Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 13, 2015 at 01:26 PM

    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


    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Jun 14, 2015 at 09:03 AM

    Hello Daya Sir,

    Thanks for the information 😊 😊

    Regards,

    Tulika

    Add comment
    10|10000 characters needed characters exceeded