IBM Support

"CM-CFG-5024 Content Manager is unable to update the content store database schema from version "7.002" to "7.0027" because it cannot access the upgrade file(s) "dbupgrade7*-to-*_mssqlserver.sql"." trying to upgrade Controller

Troubleshooting


Problem

Customer is trying to upgrade Controller to a later version. As part of this, the administrator has just finished installing the Controller server software. Afterwards, the administrator launches 'Cognos Configuration' and clicks 'Start'. The IBM Cognos service does not start. An error appears.

Symptom

English:

[Start Service]
11:31:29, 'LogService', 'StartService', 'Success'.
11:31:30, CAF-WRN-0010 CAF input validation enabled.
11:31:30, CAF-WRN-0021 CAF Third Party XSS checking disabled.
11:32:57, CM-SYS-2211 The Content Manager internal consistency check is complete.
11:32:56, CM-SYS-2210 The Content Manager internal consistency check started.
11:32:57, CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. CM-CFG-5024 Content Manager is unable to update the content store database schema from version "7.002" to "7.0027" because it cannot access the upgrade file(s) "dbupgrade7*-to-*_mssqlserver.sql".
11:32:57, 'ContentManagerService', 'StartService', 'Failure'.

11:32:57, 'ContentManager', 'getActiveContentManager', 'Failure'.
DPR-CMI-4006 Unable to determine the active Content Manager. Will retry periodically.


German:

[Start Service]
16:28:51, 'LogService', 'StartService', 'Success'.
16:28:51, CAF-WRN-0010 CAF-Eingabeprüfung ist aktiviert.
16:28:51, CAF-WRN-0021 CAF-Prüfung für XSS anderer Anbieter ist inaktiviert.
16:30:10, 'ContentManagerService', 'StartService', 'Failure'.

16:30:10, CM-SYS-2210 Die interne Konsistenzüberprüfung des Content Managers wurde gestartet.
16:30:10, CM-CFG-5063 Beim Herstellen einer Verbindung zum Content Store wurde ein Content Manager-Konfigurationsfehler gefunden. CM-CFG-5024 Content Manager kann das Content Store-Datenbankschema nicht von Version '7.002' auf '7.0027' aktualisieren, weil kein Zugriff auf die Aktualisierungsdatei(en) 'dbupgrade7*-to-*_mssqlserver.sql' besteht.
16:30:10, CM-SYS-2211 Die interne Konsistenzüberprüfung des Content Managers ist abgeschlossen.
16:30:11, 'ContentManager', 'getActiveContentManager', 'Failure'.DPR-CMI-4006 Der aktive Content Manager kann nicht festgestellt werden. Es werden regelmäßige Neuversuche durchgeführt.
<.....>
16:30:46, 'SACamSrvc', 'StopService', 'Success'.
16:30:46, 'LogService', 'StopService', 'Success'.

[Start Service]
[ ERROR ] CFG-ERR-0103 Unable to start IBM Cognos service.
Execution of the external process returns an error code value of '-1'."

English:
CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. CM-CFG-5024 Content Manager is unable to update the content store database schema
from version "7.002" to "7.0026" because it cannot access the upgrade file(s) "dbupgrade7*-to-*_db2.sql".

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
08 May 2025

UID

swg21985447