BO4 - Cache clearing - impcat and best practice

[former_member272336]

Hi,

We are trying to get to bottom of a 30270 message and one of steps being asked to do by sap support is clear tomcat cache + webi proc server cache.

Have a couple of questions

1)  Are these not cleared automtically when SIA is stopped? - we have 2 nodes in cluster and stop the SIA each night on both nodes to do backup and to astop any possible contention of reports running while  ETL running.

2) What impcat would this have generally

3) Whilst will do druing downtime,  is this an activity we should regularly schedule or just something to do after a sp upgradee for example.

Any other thoughts/best practice on cache clearing generally.

Thanks

Philip

[former_member182521 · Accepted solution]

Hi Philip,

This could help you

http://scn.sap.com/community/bi-platform/blog/2012/10/22/businessobjects-monitoring-and-housekeeping...

Regards

Mani

[former_member272336 · Accepted solution]

Hi Mani,

Thanks for advice.

Philip

[former_member272336 · Accepted solution]

Hi Mani,

our install folder is in c:\bo4

Cleared down our c:\bo4\Tomcat6\work\catalina\localhost folder

ie. delete all the sub-folders 

but now although Tomcat starts

when type

http://<server_name>/BOE/BI

or http://<server_name>/BOE/CMC

get status 500.

We hva ebackup of folder localhost before clered it down,

Thoughts?

Thanks

[former_member182521 · Accepted solution]

Make sure you leave BOBJ alone for 15min span while the files are being deployed

[former_member190781 · Accepted solution]

Hi Philip,

Check if the XMLs are present under location. tomcat\conf\Catalina\localhost

Open Tomcat properties > Java tab > Java class path and check if you have following jars present in the specified locations.

C:\Program Files (x86)\SAP BusinessObjects\tomcat\bin\bootstrap.jar;C:\Program Files (x86)\SAP BusinessObjects\tomcat\bin\tomcat-juli.jar;C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\lib\tools.jar

Try to run wedeploy tool and use deployall command, it will generate all the xmls.

Hope this helps.

Regards,

Sohel

[former_member272336 · Accepted solution]

Thanks for replies.

I didn't realise took a while - was thinking this would be instant.

[former_member272336 · Accepted solution]

Can confirm all now O.K.

Took a while for the jar filles to appear in the work folder.

[former_member190781]

Hi Philip,

Clearing Tomcat cache mean to clear contents of BOinstalldir\Tomcat\work\catalina\localhost directly. There wont be any impact by clearing these files. To be on safer side you can take a bckp.

Once tomcat starts it will again create a fresh cache.

Restarting SIA wont clear this cache as both Tomcat and SIA are two different services.

Hope this helps.

Regards,

Sohel

[former_member190781]

Sorry missed regarding Webi processing server cache, here you would need to clear contents of BOinstalldir\Business objects enterprise (Environment specific)\Data and here you will a folder named as Web intelligence processing server. Again SIA restart wont delete the contents of this folder.

Regards,

Sohel

[former_member272336]

Hi Sohel,

Thanks for advice.

Any thoughts benefits of clearing these caches regularly?

Assume best to leave system to move stuff in and out of cache as required unless advised like this case to try and resolve problem.

Is it an activity we should do anytime upgrade service pack fro example?

Thanks

Philip

[former_member190781]

As per my knowledge I would suggest no, unless it is required as clearing the cache could impact the performance of the system. (I am talking about Webi cache).

Tomcat cache also doesnt required to be cleanedup on regular basis.

If its a Wondows environment then I would suggest to keep recycling the server on weekly basis.

Regards,

Sohel

[former_member272336]

Thanks for advice.