IBM Support

IMPORTANT Information for Clients that upgrade IBM Cognos Analytics after applying the no-upgrade instructions to address log4j v2 vulnerabilities

Troubleshooting


Problem

Running a DQM (Dynamic Query Mode) report or testing a database connection, the following error is returned:

XQE-CON-0007 XQE error encountered: DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit.

Creating a DQM report, the following error is returned:

XQE error encountered: DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit.

Running or creating a DQM dashboard, the following error is returned:

The metadata for '<Model Name>' did not load. Please contact your administrator for details.

After uploading external data using the 'Manage external data' option in the authoring tool the following error is returned when it attempts to create the package.
The latest package information could not be loaded. The package this report is referencing may no longer exist. Package metadata is required for proper operation of the user interface. Certain elements of the report definition may not be viewable or editable.

The cogaudit.log contains a log entry with the following strings:

QueryService failed to start with the following command-line arguments:
Also
-javaagent:../webapps/p2pd/WEB-INF/lib/log4jSafeAgent2021.jar
Affected Versions:
Equal to or newer than the following:
IBM Cognos Analytics 11.0.13 IF5 (11.0.13-2201052300)
IBM Cognos Analytics 11.1.7 IF8 (11.1.7-2201050500)
IBM Cognos Analytics 11.2.1 IF3 (11.2.1-2201060400)
Notes:

Verify the version of your installation by opening the <Cognos Install>/cmplst.txt file and looking at the kit_version=<version> entry. The number after the dash (-) in the version represents the date-time when the kit was created. For example, 2201052300 is Year:2022 Month:01 Day:05 Hour:23 Minute:00.

If upgrading to an IBM Cognos version (GA, FP or IF) older than the ones listed, refer to the security bulletin in the next section. You need to revisit the "no-upgrade" option in the bulletin to ensure the installation is properly protected.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl3yAAC","label":"Installation and Configuration"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics 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:
06 May 2025

UID

ibm16549814

Page Feedback