JDBC Receiver Error

[Former Member]

hi ,

we re getting the error described below:

MP: exception caught with 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: Cannot establish connection with the registered driver. oracle.jdbc.driver.OracleDriver returns: : the password has expired
.
: SQLException:: the password has expired

it is soap to jdbc scenario.

we have checked password it is working fine

Please do suggest something.

Thanks,

Debanjan

[azharshaikh · Accepted solution]

Hi Debanjan,

Can you check on following, if it helps:

1.Try to test the above db connection string using TOAD or SQLplus and see how that works. The exception clearly shows password issue.

2. Check your cache.

3. Try editing your channel and save and activate again.

4. Try re-entering the password.

5. Check with the DB guys whether they have any limited connections for their DB or password validity issue.

Regards,
Azhar

[Former Member · Accepted solution]

Thanks azhar, we are checking with all your steps given .  As we are new to PI we do not have any idea about  TOAD or SQLplus. Can you please share about it.

We also think its a password issue . we are consulting with the basis team.

Regards,

Debanjan das.

[azharshaikh · Accepted solution]

Hi Debanjan,

TOAD is 3rd party tool by Quest software while SQLPlus is oracle's main command line interface to run the Queries.

For more info you can chk:

SQL*Plus Quick Start

Toad - SQL Tuning, Database Development & Administration Software

Do you have either of these available in system? Your DB team member might be using this.

Regards,
Azhar

[Former Member · Accepted solution]

Hi,

No we do not have any . How can we install it

Thanks,

Debanjan

[anand_shankar10 · Accepted solution]

you may request your DB administrator to check if the credentials are working. They must have some third party tool for connection test.

Thanks

[Former Member]

Hi,

It was a password issue,

It is solved.

Thanks

Debanjan Das

[azharshaikh]

Hi,

Good to know that issue is resolved. Request you to close the thread.

Regards,

Azhar

[Former Member]

Ask your Oracle DBA to reset the account expiration and even disable that feature for your service account.

[Former Member]

Hi Debanjan,

Please follow Michal's blog post. It may solve your problem:

Pradeep

Message was edited by: Pradeep Verma