
Hello Experts,
We have been facing issue with the Auditing application in our BOBJ prd system since a very long time. Below are the issues faced and the options tried non of which worked permanently:
Issues faced:
1. ADS last updated on shows old date.
2. The connection is lost to the data store from the CMS
Solutions tried:
1. Raised multiple OSS messages to SAP but no permanent solution provided yet.
Collected logs and traces to SAP but no resolution worked permanently.
2. Created a new Audit Database
3.Renamed the Auditing folder multiple times but this works for few hours and the connection is lost or the last updated data does not gets updated.
4. Upgraded from 4.1SP5 to 4.1SP10
5.Restarted multiple times but this works for few hours and the connection is lost or the last updated data does not gets updated.
Please note that the daily growth of the Audit DB was high in our PRD systems .
Additionally we don't see this issue in the dev/qa .
==Environment Details==
1. BOBJ version : SAP BusinessObjects BI Platform 4.1 Support Pack 10
2. Server OS version?SLES 11.3 (x86_64) Kernel
3. Standalone environment (There are 2 databases in this server, BOP and ADS <auditing>). Both on same server running on SAP ASE.
4. Total physical RAM Mem total 64 GB
Any help would be really appreciated.
Thanks
Saurav Sagar