Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Bounce the Server?
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Bounce the Server?
 Login/Join
 
Expert
posted
What's the current recommendation on Bouncing the Servers? Should that be done periodically, I'm thinking: Yes? Or, what better way is there to maintain the clean functionality of the environments?

Case in point: We just had an issue where things were so slow that AppStudio timed out while accessing the environments. We restarted the associated services and things are working fine now.

This message has been edited. Last edited by: Doug,




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Currently with Fidelity Investments
 
Posts: 3052 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Guru
posted Hide Post
Ideally never, there is a reason for something not responding anymore, that should be fixed first.

Negative effect of server restart: OS cache is gone and you have a new maintainance window.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 414 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
I'd first check the agents running on the reporting server - there could be a runaway task slowing everything down. If there is, kill the agent.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Doug

When I was an SE a lot of my customers would recycle the reporting server on a weekly basis. The edatemp directory is re-created every time the server is recycled and it would also clear up any excess memory usage as well.

Francis post is also very valid for cleaning up an agent that may be causing an immediate issue and the server can't be bounced.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1735 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
depends on your usage volume and your tomcat, if you use it. if your edaprint logs get gigantic, recycle more often. if you use tomcat, that sucker needs a recycle as well, renaming the current localhost and starting over with a fresh one when you restart.
I learned from techsupport to rename my tomcat localhosts as a.localhost, b.localhost, etc, after stopping the service and before restarting.
and as francis says, look for hung agents. I use an includable fex in every report that grabs the name of the fex, the user, some parms, and puts it into a .txt file in the agent, so when something crashes or hangs , I can always tell what broke and who ran it.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Virtuoso
posted Hide Post
quote:
Originally posted by susannah:
If your edaprint logs get gigantic, recycle more often.


Just as a side note, you can minimize this by configuring a max line limit and edaprint history file count. You don't have to keep the default edaprint config. For example, you can max the size to 10k lines and 5 history files. It will rollover the edaprints and delete older history files automatically.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
Expert
posted Hide Post
Thanks All,

I'll check the size of the edaprint logs. Do the restart delete those logs, I'm thinking: No?

There were no hung agents this time.

We'll look into this deeper (I don't have full admin rights here, yet)
 
Posts: 3052 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Doug

There is a setting that keeps a number of edaprint logs by default it is 5 logs. They are saved in the \ibi\srv81\wfs directory.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1735 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Before you bounce the server, turn it off and disconnect all wires. Depending on the weight, you may require a second person doing the lifting.

On a more serious note, we recently had some serious slowness on both our DEV and production servers. Turned out there was a Windows Update going on...

Microsoft is getting more and more aggressive about pushing updates through our throats recently (is Trump's behaviour rubbing off perhaps?). I'll celebrate the day we get rid of it.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1654 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
And just a little after posting that we ran into slowness on our DEV server caused by a new version of McCoffee anti-virus, that did not copy the excluded binaries (tscom3, jscom3, edapsomething, tomcat7) nor the excluded directories (not possible anymore?) from the previous version. As a result, it was interfering with the WebFOCUS binaries, severely degrading performance.

And OMG, what kind of user interface is THAT?!? They clearly focused more on pretty pictures than on usability...


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1654 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport This Post
Silver Member
posted Hide Post
On Linux, we rarely reboot the server(s). Slowness can be caused by any of the aforementioned issues plus several others. Temporary files (for example, using Excel output) are written to a specific directory which is designated in the Admin Console. We’ve had run-ins with Java memory issues. Just make sure to check your application server log files and you WF log files (client and reporting server) before restarting anything if you want to get to the root problem. I’ve had times where the log files showed nothing suspicious and a recycling of Tomcat fixed the slowness, so, there’s that, too.


8.8.09 - z/Linux (WF, Report Caster, Report Library).
Iway FFS on MVS (HFS)
 
Posts: 36 | Location: Oklahoma City | Registered: December 05, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
Thanks again Everyone...

That's a lot to chew on for a relatively new installation of WebFOCUS and other IBI Items like DataMigrator.

I'll keep this open for a while...

Doug

This message has been edited. Last edited by: Doug,
 
Posts: 3052 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
Hey Doug

I finally decided to look into the forums for the first time in forever. Lo and behold - a post from Doug Lee Smiler

Here's the thing nobody's mentioned, the hanging behavior is very likely actually occurring at the WF client level. It's not necessarily the reporting server.

If you bounced both Tomcat and the WFRS services and things started working, it might have been a client issue.

Here's how to tell - next time it occurs, use something like Fiddler or turn on the AS communication layer trace. (essentially they both watch HTTP traffic which AS uses to connect to the environment)

I can help you with that if you need a hand. A hint when using the communication layer trace - leave the utility running and just toggle on or off. The tracing will start or stop instantly. No need to close that utility between starting and stopping tracing. Notice the path it shows for where the trace will land on your machine (wfscom.trc).

For more info see the user manual and or call me.

WebFOCUS App Studio User’s Manual
Release 8.2 Version 01
September 22, 2016

Page 760- App Studio Trace Utility


Good luck!
Toby
 
Posts: 62 | Registered: October 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
Toby,

Thanks for the great information and our phone conversation. This, along with all the other inputs, will help us resolve this issue and prevent it from any re-occurrences.

I'm going to dive into this deeply next week and update this post accordingly.




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Currently with Fidelity Investments
 
Posts: 3052 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Bounce the Server?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.