BO Server Data Cleanup

[baijuma]

Hi,

While doing the weekly data clearing jobs..

1. Do we need to stop all scheduled jobs?
2. Do we need to stop Tomcat Service and Server Intelligence Agent? (using CCM)
3. Once the data cleanup process completed, after how much time gap users can access BO?

I have experienced below mentioned issues:

1. Once we try to stop, Server Intelligence Agent stops after a long time (more than 1 hour)
2. BO reports / scheduled jobs etc not working for 48 hours or more.

Requesting your help. Thanks in advance.

[baijuma]

Thanks. More details:

BI Version used - 4.1 SP3
Standalone/Clustered - Clustered
CMS DB - Microsoft Sql
OS(Windows/*nix flavor) - Windows
Type of reports scheduled (Webi/Crystal) - Webi only

Data Cleanup is done manually, to improve the performance. Data Cleanup is done as mentioned below:

1. Delete the contents under the Local host folder in order to clear Tomcat Cache
2. Delete contents under the Logging Folder to clear log files generated

If the cleanup is not done periodically BO becomes too slow. So we need to do the cleanup. I would like to know the exact steps to follow to do the data cleanup.

1. Do I need to stop Tomcat Service before deleting the files (using CCM) ?
2. Do I need to stop Server Intelligent Agent (using CCM)?

There can be scheduled jobs running while doing this, Do I need to stop all before starting the steps? Please reply.

[denis_konovalov]

1. Why would you clear tomcat cache ?
2. You can set trace log settings for each service in CMC to none, this way you do not need to clear logging directory.

On a properly configured system you do not need to do any of this steps.
There is no Data Cleanup. Unless your BOE processes (webi) is crashing and leaving session and other stuff behind.
But then you need to fix that part first.

[Former Member]

Thank you for the information provided.

Firstly to answer your questions:

1. Yes, you need to stop Tomcat service from CCM before you clean/delete the localhost folder to clear the cache of Tomcat

2. Yes, you need to stop Server Intelligence Agent(SIA) from CCM before you clear logging folder completely. Even if you do not stop the SIA, the logs in the logging folder can be deleted, however some may not as they may be in use by particular server.

3. Yes, you need to make sure that the scheduled jobs are completed and no jobs are remaining in running status. Then you can stop the SIA and go for deletion of the contents.

Having said the above, it is also important to identify what makes your environment slow periodically that you eventually end up cleaning the contents to improve the performance

Make sure there is sufficient disk space on the BI installation drive.

Below are couple of performance related KBAs that I would like to share.

P.S.: Not all below KBAs may be relevant to your environment. Reason being the cause of the decrease in performance may be different for different environments depending upon the way it is used. You first need to identify what is causing the performance to degrade and then can proceed for below KBAs.

However if you wish to continue the manual way, please do so as suggested above.

1867416 - *** Master KBA *** - Troubleshooting performance issues in SAP BO Business Intelligence Pl...

2161908 - BI 4.x: Overall navigation in BI Launchpad and the performance of opening WebI reports is ...

1609661 - Periodical performance issue on BusinessObjects (BO) Server

1879431 - How to clear the Tomcat cache?

Hope the above explanation helps

Thanks,

Megh

[Joe_Peters1]

Tomcat cache -- you mean the work folder? There is a rarely a need to clear it in normal circumstances. If you do, it will just cause a very long startup time then next time Tomcat is started.

[baijuma]

Thank You very much.

[baijuma]

Thanks a lot

[baijuma]

Thank You !