Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
Back to discussions
Expand all | Collapse all

Strange preview delete scripts generated with Cognos Audit DB Cleanup Console (in v12.1.1)

  • 1.  Strange preview delete scripts generated with Cognos Audit DB Cleanup Console (in v12.1.1)

    Posted 18 hours ago

    Hi,

    I'm trying to use the application that is shipped (since Cognos 12.0.4 and above) that allows you to truncate the audit db.

    The original location (in my case with Cognos Analytics v12.1.1) is in:

    analytics_location\samples\Truncate_Audit_Database\war\

    Copy AuditDbCleanup.war file into the /wlpdropins/ directory.

    The default URL is: http://ip:9300/AuditDbCleanup/servlet

    When I define the cleanup timeline, with the option Delete the records older than selected date 3 months, I believe the preview SQL is wrong:

    When I try to change the date, the preview delete scripts are always the same!

    Did you experience the same issue?

    Best regards,



    ------------------------------
    Patrick Neveu
    BSL Consulting
    IBM Champion
    ------------------------------


Related Content