Before attempting fixes, diagnose the underlying cause. The error is generic, but the roots fall into six categories:
To prevent connection drops from happening again, follow these maintenance strategies:
nc -zv [database_host_ip] [port] # or via PowerShell Test-NetConnection -ComputerName [database_host_ip] -Port [port] Use code with caution.
Confirm that the database server is online and accepting connections on the correct port from the application server's IP address. Before attempting fixes, diagnose the underlying cause
: An incompatible or bug-ridden version of a JDBC driver is placed in the Cognos directory. For instance, IBM JCC JDBC driver version 4.33.31 breaks Db2 Trusted Context connections, throwing the exact XQE-JDB-0001 string.
psql -U your_user -d your_db -h localhost mysql -u your_user -p -h 127.0.0.1
: The required .jar driver for your specific database (e.g., SQL Server, Db2, Snowflake) is either missing from the \drivers directory or is an incompatible version. : An incompatible or bug-ridden version of a
Navigate to -> Configuration -> Data Source Connections .
: In some environments like IBM OpenPages , users with non-English locale settings may trigger this error.
For specific platform issues, refer to the following official IBM support guides: Troubleshooting DB2 Trusted Context Failures Handling XQE-JDB-0001 in IBM OpenPages data server connections fails Navigate to -> Configuration -> Data Source Connections
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.
Before diving into fixes, it helps to recognise where the error most frequently appears: