Skip to Content
avatar image
Former Member

Warning: No connection to Auditing Data Store from CMS

Hello everyone.

I have the folowing issue. I have my auditing repository in DB2, when I try to configure the Auditing Data Store from CMC, I get this error "Warning: No connection to Auditing Data Store from CMS sia_incop_pro.CentralManagementServer."

In my BI server I delete all .txt files that automatically are created in the path: /bobje/bobjxi/sap_bobj/data/Auditing. When  I do that, I solve the issue of No connection to Auditing Data Store, but this is only for a short time because the .txt files are created again and the error message comes again. I tried the solution that I found in the following discussion: http://scn.sap.com/thread/3395164 but still not working. Any suggestion?

pastedImage_2.png (45.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 12, 2015 at 08:29 PM

    I resolved the issue.

    The problem was that I didn´t have enough space in my tablespace, so I configured my tablespace as automatic resizing with maximum size with the following comands in my linux server:

    1. db2 connect to <database>

    2. db2 alter tablespace <name> autoresize yes

    3. db2 alter tablespace <name> maxsize none

    You use none to not specify a maximun limit to your tablespace.

    Regards and thank you for your time

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 06, 2015 at 10:37 PM

    "Warning: No connection to Auditing Data Store from CMS" It seems that your DB2 Audit database tablespace is full.  The resolution is simply increase the tablespace of the Auditing database for new data to be written. Hope this SAP KB "1645207 - No CMS was configured as Auditor on BI 4 using DB2 Audit Database" would help to resolve your Auditing problem. Hope this helps, Jin-Chong

    Add comment
    10|10000 characters needed characters exceeded

    • Run the list tablespaces with show detail to find out which tablespace free pages run out space. db2 list tablespaces show detail and add more tablespace (temp) to it.  Hope you'd fine this SAP KB 334608 - DB6: SMS tablespace ##(PSAPTEMP##) is FULL helps Hope this helps, Jin-Chong