Cognos Analytics

 View Only
  • 1.  Audit reports not updating after upgrade to 11.2.4

    Posted Tue June 04, 2024 02:15 AM

    We upgraded from Cognos Analytics 11.1.7 to 11.2.4 (new installation and not over the top).

    The audit reports are not updating in the new instance. Would like to mention that after the new instance was up and running, I had migrated the content store from the older version to the new version and this seems to have overwritten the Audit datasource connection & signon properties. We corrected this but the problem with audit not updating persists. Would like to know possible causes and suggestions. The next step I can think of is restart of services which may or may not get the audit working.

    Best Regards,



    ------------------------------
    Mack L
    ------------------------------


  • 2.  RE: Audit reports not updating after upgrade to 11.2.4

    IBM Champion
    Posted 30 days ago

    Hi Mack,

    I've seen this article from IBM support and it looks like your issue:

    Audit database gives error on startup after upgrading from 11.1.x to 11.2.x or 12.x

    Best regards,



    ------------------------------
    Patrick Neveu
    Collaboration Betters The World (CBTW)
    IBM Champion
    ------------------------------



  • 3.  RE: Audit reports not updating after upgrade to 11.2.4

    Posted 30 days ago

    Hi Patrick,

    I checked the article. In my case, there is no error thrown when I run existing audit reports but there is blank output (no data). When I create a new audit report, it simply keeps running. I think the audit DB is not getting updated.



    ------------------------------
    Mack L
    ------------------------------



  • 4.  RE: Audit reports not updating after upgrade to 11.2.4
    Best Answer

    IBM Champion
    Posted 30 days ago

    Hi,

    Did you check that the Audit database is still configured correctly within Cognos Configuration? Does it test ok from in there? If it's a multi-server install, have you also checked the other machines are configured in the same way?

    What logging levels are set for each dispatcher? Are they all at least Basic?

    Cheers!

    MF.



    ------------------------------
    Mark Fry
    Technical Consultant
    ------------------------------



  • 5.  RE: Audit reports not updating after upgrade to 11.2.4

    Posted 23 days ago

    Thank you Mark. I changed the Audit logging level for the dispatcher from minimum to Basic.

    Now the audit reports are updating.

    Best Regards,



    ------------------------------
    Mack L
    ------------------------------