Issue with JDBC receiver

[Chandra_Hota]

Hello All,

We have SAP ECC (proxy sender) -> XPI 7.0 -> Oracle (jdbc receiver).

We are querying data in some oracle tables. This is the error we see in communiation channel monitoring for JDBC receiver adapter:

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@xxxxx.abc.def.com:1521:rdwT1': SQLException: ORA-28000: the account is locked

But, we were told that login credentials (user/password) are working fine and account (user name give in the communication channel) is not locked.

So, is there anything i need to check?

In XI's SXMB_MONI, we see the following error:

<SAP:Category>XIAdapterFramework</SAP:Category>

<SAP:Code area="MESSAGE">GENERAL</SAP:Code>

<SAP:P1 />

<SAP:P2 />

<SAP:P3 />

<SAP:P4 />

<SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: Exception in method process.</SAP:AdditionalText>

Another question is, why is the error in communication channel monitoring not getting propogated to SXMB_MONI?

Anything obvious missing here?

Thanks,

Chandra

[former_member192238]

Shekar,

In SXMB_MONI you can can view messages processed in Integartion engine As JDBC adopter is in java stock u wont be able to see those errors.

Ask u r DB team to to unlock the SCOTT account

Regards

Praveen

[baskar_gopalakrishnan2]

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@xxxxx.abc.def.com:1521:rdwT1': SQLException: ORA-28000: the account is locked

Please check the following..

a) Test the above db connection string using TOAD or sQLplus and see how that works. The exception clearly shows account is locked. If you repeatedly use invalid credentials for three times using the jdbc channel there is a possibility that account gets locked.

b) Also check the port, hostname and database name are right and valid one. Also check with BASIS team whether one more time account is locked or not.

Since you configured the receiver channel as JDBC and you will see this error log only at Java Stack.. that is in the communication channel monitoring. This you wont see it in the Integration engine.

Hope that helps.

[markangelo_dihiansan]

Hello,

Adding to what the user above posted:

Another question is, why is the error in communication channel monitoring not getting propogated to SXMB_MONI?
Anything obvious missing here?

This is expected because you are using a JDBC receiver which resides on the Java Stack, so after the Integration Engine, the message gets passed to the Adapter Engine. Hence you can only see the error if you use RWB message monitoring (Adapter Engine) or CC monitoring.

Hope this helps,

Mark

[Former Member]

Hi Chandra,

This is common error with respect to JDBC drivers and might occur due to the following.

1. Check your cache.

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

3. Try reentering the password.

4. Check with the Oracle guys whether they have any limited connections for their DB.

In most of the cases, it might be erroneous driver or problem in number of connections limited.

Also check with your basis guys on this.

Regards

Krish

[Former Member]

Hi Chandra,

can u check what are jdbc conection and drivers in receiver communication channel and user name and password.

regards,

ganesh