cancel
Showing results for 
Search instead for 
Did you mean: 

Warning:Client Auditing is unavailable' & There is no connection to the Auditing Data Store from the CMS error in SAP Business Objects 4.1 SP2

DayaJha
Active Contributor
0 Kudos

Hi All,

I am facing issue intermittently in Audit tab, Please refer the below screenshot and platform details for your reference.

Error in Audit Tab of SAP Business Objects Application.

Error 01:  'Warning:Client Auditing is unavailable'.

Error 02: There is no connection to the Auditing Data Store from the CMS

Below is the environment details.:

SAP Business Objects Version: 4.1 SP2

Operating System: Windows Server 2008 Enterprise

Database: SQL SERVER 2008 R2

Status in Audit Folder:

Thanks,

Daya

Accepted Solutions (1)

Accepted Solutions (1)

DayaJha
Active Contributor
0 Kudos

Hi Team,

Finally Issue resolve


Error 01:  'Warning:Client Auditing is unavailable'.


Solution: Check APS status, Please refer below KBA for more details

1694890 - 'Warning: Client auditing is unavailable' in Auditing section of CMC in BI 4.0

https://service.sap.com/sap/support/notes/1694890


Error 02: There is no connection to the Auditing Data Store from the CMS

For this issue it was bug from SAP Business Objects 4.x Side.

After changing the password of SQL Server from 8 character to 7 character issue resolved, Please refer the below screenshot of Audit tab for your reference

Audit Folder Status after Audit configured properly.

Please configure 64 bit ODBC for CMS & AUDIT database.

This issue occur in below cases:

  • If you delete the ODBC configuration, After deleting ODBC below is the status of ODBC (64) Tab in Operating System & Audit Tab in Central Management Console

ODBC Status:

Audit Tab Status in Central Management Console:

Then recreate 64 bit ODBC again, Please refer the below screenshot for your reference.

ODBC Status:

Audit Tab Status in Central Management Console:


So going forward please beware please don't delete Audit ODBC configured at Server level.


Please refer below thread & KBA for same issue.

KBA:

1694890 - 'Warning: Client auditing is unavailable' in Auditing section of CMC in BI 4.0

SCN Thread:

http://scn.sap.com/thread/3534085

http://scn.sap.com/thread/3395164

http://scn.sap.com/thread/2127820

Thanks,

Daya

Former Member
0 Kudos

Hiii ,daya,

it is very useful for audit configuration...

Thanks a lot ...

DayaJha
Active Contributor
0 Kudos

Once you mapped new schema for Audit below is the table & view status.

Table Status:

View Status:


Steps for Mapping New Audit Blank Schema:

- Create blank schema and assign appropriate rights & security at database level

- If it was SQL Server then create ODBC as per your version like 64 bit or 32 bit, If you are using oracle then TNSNAME.ORA details must me there for this new connection

- Go to Audit Tab in Central Management Console and update the details, please be aware take the screenshot of last configuration and update the same in new configuration of ADS

Hope this will help!!!

Thanks,

Daya

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Daya Sir,

Thanks for the information

Regards,

Tulika