For OpenPages or similar integrated environments, ensure the system locales are supported and that the temporary file locations have sufficient permissions and space.
Select and locate your target database asset.
: Check if the database instance (e.g., IBM Db2, Microsoft SQL Server, Oracle , or Snowflake) is online and accepting incoming connection pools. For OpenPages or similar integrated environments, ensure the
If you are in a production outage situation, run this checklist (5 minutes or less):
Ensure your application host can reach the database host. If you are in a production outage situation,
A frequent driver-level conflict occurs when connecting Cognos Analytics to IBM Db2 instances using specific versions of the IBM JCC JDBC driver (such as version 4.33.31) alongside DB2 Trusted Context features. The security handshake fails silently or causes a hard drop at the driver boundary, resulting in an explicit XQE-JDB-0001 diagnostic fault. Navigate to the ../drivers directory on your Cognos server.
Download the supported JDBC driver directly from your database vendor (e.g., mssql-jdbc.jar or db2jcc4.jar ). Navigate to the
If you are connecting to IBM Db2 and recently updated the JDBC driver, check if you are using version 4.33.31. According to IBM support,Trusted Context connections to DB2 might fail with XQE-JDB-0001 when using this driver 1.2.2. Reverting to a previous driver version may resolve the issue. 6. Review Cogserver.log
: Most frequently encountered on environments using IBM JCC (for Db2) , Microsoft JDBC Driver for SQL Server , or specialized data adapters like Snowflake or Hive .