In another case, the server was running but the JDBC driver was outdated after a database upgrade from MySQL 5.7 to 8.0. The error log revealed: java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password' . Updating the JDBC driver to version 8.0.x resolved the issue.
Add to your logging.properties :
A Cognos user reports that a dashboard fails to load, showing “XQE-JDB-0001 problem establishing connection. Please check the database server.” The dashboard worked yesterday.
: In some specific environments (like OpenPages), certain locales can trigger this connection error.
: Verify that firewall rules, security groups, or localized network policies have not suddenly blocked traffic between the Cognos Application Server tier and the database port.
Short recommended runbook (for on-call)
-- PostgreSQL SHOW max_connections; SELECT count(*) FROM pg_stat_activity;
Xqe-jdb-0001 Problem Establishing Connection. Please Check The Database Server
In another case, the server was running but the JDBC driver was outdated after a database upgrade from MySQL 5.7 to 8.0. The error log revealed: java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password' . Updating the JDBC driver to version 8.0.x resolved the issue.
Add to your logging.properties :
A Cognos user reports that a dashboard fails to load, showing “XQE-JDB-0001 problem establishing connection. Please check the database server.” The dashboard worked yesterday. In another case, the server was running but
: In some specific environments (like OpenPages), certain locales can trigger this connection error. Add to your logging
: Verify that firewall rules, security groups, or localized network policies have not suddenly blocked traffic between the Cognos Application Server tier and the database port. : Verify that firewall rules, security groups, or
Short recommended runbook (for on-call)
-- PostgreSQL SHOW max_connections; SELECT count(*) FROM pg_stat_activity;
