Skip to Content
0
Former Member
Jun 09, 2011 at 06:41 AM

JDBC messages processed even though connection was down

38 Views

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?