Cognos Analytics

Cognos Analytics

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


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

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

    Posted 12/09/25 09:17 AM

    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
    ------------------------------


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

    Posted 06/10/26 11:32 AM

    Hi ,

     Hope you are doing well. I've installed 12.1.2 Interim Fix and setup analytics_location\samples\Truncate_Audit_Database\war\. 

    Our audit DB sits in Oracle. The weird thing is it's not accepting my db credentials. its comes up with unanble to connect to db!



    ------------------------------
    Mayur Madoo
    ------------------------------



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

    Posted 06/11/26 04:59 AM

    Hi Mayur,

    Do you have any specific error message? Would you be able to share a screenshot? How to you connect to your audit DB in Oracle?

    Best regards,



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

    Original Message


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

    Posted 06/11/26 05:08 AM

    Make a copy of any file before using it.

    You can also add/modify a dbcleanup.properties file located in AuditDbCleanup.war. In the folder \WEB-INF\classes, you might create a file with the following entries:

    # Configuration file for com.cognos.dbcleanup
    # $Id: dbcleanup.properties$
    # JDBC connection details:
    jdbc.url=jdbc:oracle:thin:@//database_name:1521/name.domaine
    jdbc.user=AUDIT
    jdbc.password=YourPassword
    If you edit AuditDbCleanup.war, you need to drop it again in wlpdropins folder.
    Best regards,


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

    Original Message


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

    Posted 06/12/26 03:37 AM
    Edited by Mayur Madoo 06/12/26 03:49 AM

    Hi thanks for this.

    I updated accordingly but still get this error:



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

    Posted 06/12/26 05:06 AM

    In the dbcleanup.properties file, you need to copy the same information available from your connection to your Audit database.

    For instance in jdbc.url=jdbc:oracle:thin:@//db01:1521/ORCLPDB1.company.com
    where db01 is the Oracle server, 1521 is the port, and the service is ORCLPDB1.company.com (the service is NOT the SID).

    You can check the service_name in the tnsnames.ora file.

    Best regards,



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

    Original Message


Related Content