Skip to Content

BO Server Data Cleanup


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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Aug 23, 2017 at 11:59 AM

    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



    Add comment
    10|10000 characters needed characters exceeded

  • Aug 23, 2017 at 07:52 PM

    You mean, you are running RDT to cleanup

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 24, 2017 at 03:57 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 25, 2017 at 09:24 AM

    Hi Baiju,

    As per the best practises, Stop the Tomcat before clearing localhost files to remove completely as there is no usage of localhost files by any user. Similarly if you are clearing the BO logs files then stop the SIA.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Baiju,

      First start the SIA, it will start all the BO Services (CMS+other services). It might take 5 to 10 mins as all the services to come into running state.

      Once you started the Tomcat service it will load all the webapps(BOE,Admintools,....) into work directory. Once the BOE application loaded you can run the reports. BOE webapp will be around 1.5GB so it will take sometime around 10 to 15mins mins based on the Tomcat (java size, standalone tomcat installation/tomcat+CMS installation).