Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  Message "The logging database schema will be upgraded" (with Cognos Analytics v12.1.0-2507241412)

    Posted Thu September 11, 2025 09:40 AM

    Hi,

    I'm using Cognos Analytics v12.1.0-2507241412.

    When I start Cognos from Cognos Configuration (GUI), I receive the following message:

    When I click on details, I have this message:

    "The logging database schema will be upgraded. The upgrade may take a substantial amount of time based on the number of logging databases and database entries."

    Each time I restart, I have this message. It seems no upgrade is happening.

    Any idea?

    Best regards,



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


  • 2.  RE: Message "The logging database schema will be upgraded" (with Cognos Analytics v12.1.0-2507241412)

    Posted Fri September 12, 2025 02:23 AM
    1. Stop Cognos Analytics services.
    2. Backup your logging database. If you don't know the logging database, you can find its details in IBM Cognos Configuration.
    3. Start IBM Cognos services. This step will trigger the databse upgrade process automatically.


    ------------------------------
    Ahmed Abdel-Baky
    - IBM Egypt
    ------------------------------

    Original Message


  • 3.  RE: Message "The logging database schema will be upgraded" (with Cognos Analytics v12.1.0-2507241412)

    Posted Fri September 12, 2025 09:50 AM

    Hi,

    I'm using DB_VERSION 10.32 which is the latest available script in<cognos_location>\configuration\schemas\delivery\sqlserver.

    I've restarted again and again with the same result each time.

    Best regards,



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

    Original Message


  • 4.  RE: Message "The logging database schema will be upgraded" (with Cognos Analytics v12.1.0-2507241412)

    Posted Fri September 12, 2025 12:07 PM

    Patrick, I'm not sure if it's a server you can try it on, but maybe try renaming the existing audit database and create a new empty one from scratch and let Cognos create the schema.  Then see if subsequent restarts give you that message.

    When I upgraded from 11.1.7 to 11.2.4 I got that message.  My audit database was 65GB.  I googled on that message and also read that the upgrade will continue to run in the background once the server starts - the length of time required obviously dependent on the size of the audit database.  So it's possible the upgrade is failing or not completing before the next restart in your case.

    I decided with my upgrade to start with a brand new audit database instead of the hassle/risk of the auto upgrade.  Sure I lost the history but if needed I could always restore it to my dev server and let it try the upgrade there OR restore it to a different database name and manually query it.

    Best regards,

    Wayne



    ------------------------------
    Wayne Westlake
    ------------------------------

    Original Message


  • 5.  RE: Message "The logging database schema will be upgraded" (with Cognos Analytics v12.1.0-2507241412)
    Best Answer

    Posted Wed September 17, 2025 08:31 AM

    Patrick,

    I had the same exact issue.  I entered a ticket with IBM and the solution was to update the PROPVALUE field in the COGIPF_SYSPROPS table of the audit database.  After the upgrade my value was 102.008 and they had me update it to 102.009 and then restart Cognos.  This solved the issue.  I'm running 12.1.0 IF2.



    ------------------------------
    Cliff Stewart
    ------------------------------

    Original Message


  • 6.  RE: Message "The logging database schema will be upgraded" (with Cognos Analytics v12.1.0-2507241412)

    Posted Fri September 19, 2025 04:31 AM

    Hi Cliff,

    Thank you for your solution, I was the solution for me.

    I'm also running 12.1.0 IF2 (AKA 12.1.0-2507241412).

    Best regards,



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

    Original Message


Related Content