Problem

--If you are using B2Bi configured with Oracle database and if you have a problems with the MessagePurge:

ERROR [MessagePurge] (ConnectionHandle) - Database access problem. Killing off this connection and all remaining connections in the connection pool. SQL State = 08006

ERROR [MessagePurge] (MessagePurge) - Error in retrieving Messages to purge
org.apache.openjpa.lib.jdbc.ReportingSQLException: IO Error: Socket read timed out {prepstmnt 1883760377 SELECT DISTINCT msgs.OID FROM Messages msgs WHERE msgs.CurrentStateType IN (?, ?, ?, ?, ?, ?, ?, ?) AND msgs.EXPIRATIONTIME < ?} [code=17002, state=08006]

Possible Resolution

*You can try to increase the ConnectionTimeoutInMs from datastoreconfig.xml file

*Or you can try to rebuild the database index for the Messages table from Oracle database