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

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 12, 2015 at 08:28 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

  • avatar image
    Former Member
    Jan 07, 2015 at 03:59 PM

    Hi Victor,

    Here some steps that may help you pin point the exact cause.

    1. With the help of the BO tracing mechanism, enable high level trace on the CMS.

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

    2. Keep the tracing enabled for 15 minutes.

    3. After 15 minutes stop the tracing.

    View and analyse the tracing for any auditing traces/DB2 connectivity error.

    Provide your observations in snippet.

    -Guru

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 06, 2015 at 10:29 PM

    Hi Victor,

    Check the connection to your DB2 database from the server machine.

    You can use commands from this link.

    Use the same user name and password that you have provided On Auditing page.

    Regards,

    Onkar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Onkar

      I used the following comand:
      db2 connect to database

      And the result was

      I have connection from my server, so I think that's not the problem.

      Thank you for your response

      Regards