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.

[Former Member]

Need some more details to answer your question.

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

Also when you say 'Data Cleanup', what exactly you are trying to achieve here?

Yes when the Server Intelligence Agent(SIA) stops, it stops in the sequence : all servers->CMS-> and then stops itself. Are there any schedule job already running when you try to stop the SIA. Any stuck/stale(taking no CPU usage) process seen in the Task Manager(Windows) or top/topas in *nix

Please elaborate the issue so that we can answer in a better way

Thanks,

Megh