issue in JDBC

[Former Member]

HI All,

My scenario is Idoc to jdbc and getting bellow error in RWB for Jdbc Receiver Communication channel .

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Can not establish connection:: com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][2016][11252][3.61.65] Connection authorization failure occurred.  Reason: User ID invalid. ERRORCODE=-4214, SQLSTATE=28000

Thanks,

[rajasekhar_reddy14]

Check USER ID exists or not in DB, it looks user id enetered might me wrong..

[zameerf]

Hi,

Were you able to directly connect the database with that user from outside PI?

You may want to check with DB team on the user authorization.

-Zameer

[former_member184681]

Hi,

Your error description gives you a lot of information about the reason for your problem:

Connection authorization failure occurred.  Reason: User ID invalid

Review the user credentials provided in the receiver CC and confirm with the party responsible for the receiver DB what username and password you should be using.

Regards,

Greg