Troubleshooting
Problem
The database user credentials provided in the JDBC stage configuration or Control Hub Connection configuration are incorrect.
The database user does not have permission to login to the database.
Example: in PostgreSQL, the role does not have the LOGIN attribute
Symptom
Pipeline validation fails
When you select the Validation Error in the UI, it will display the following error: “
JDBC_INIT_48 - User authentication failed"The logs will contain the following message:
ERROR User authentication failed [JDBC_INIT_48]The SDC logs will contain further detail about this error, such as one of the following messages:
User authentication failed: Access denied for user 'test'@'%' (using password: YES)User authentication failed: FATAL: password authentication failed for user "test1"User authentication failed: FATAL: role "test2" is not permitted to log in
Resolving The Problem
Verify that the user credentials provided in the JDBC stage configuration or Control Hub Connection configuration are correct.
The database user credentials may be in the JDBC Connection String, or they may be in the Credentials tab if the “Use Credentials” box is checked.
Verify that the database user has the correct permissions to login to the database.
Document Location
Worldwide
Was this topic helpful?
Document Information
Modified date:
15 March 2025
UID
ibm17186211