JDBC messages processed even though connection was down

[Former Member]

Hi,

We have an XI to JDBC flow.

A couple of days ago the database to which the JDBC connection goes was down, but all messages that the system tried to send to this database appear as processed in SXMB_MONI. Only the acknowledgement contains following error:

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:as400://192.168.197.10:446/WMSLIB': SQLException: The application requester cannot establish the connection. (connect timed out)

This is very annoying since we can't reprocess the messages with status "processed", even though they are not processed at all.

Any ideas?

[Former Member · Accepted solution]

Hi,

The message status will sucess in SXMB_MONI. Because the integration will process the message to integration server. Here the integration engine will not look for the connection to the data base. When ever the integration server is processing message adapter enigne then the adapter will look for the connection. If the database is down then the message will be failed in message monitoring in RWB. You can reprocess the message from message monitoring in RWB.

Regards,

Raju.

[rajasekhar_reddy14]

> 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:as400://192.168.197.10:446/WMSLIB': SQLException: The application requester cannot establish the connection. (connect timed out)

>

Above error message comes when your JDBC channel trying to connect to Data base,but connection not established ,because Connection was down.

in this case none of the messages will be processed.

Regards,

Raj