Oracle SOA Suite (MOSC)

MOSC Banner

OSB 12.2.1.4 DB adapter polling is not working

OSB version 12.2.1.4

DB adapter is polling from an Oracle databasebut polling is not working.Below is the error in logs. We can test datasource successfully.

DBActivationSpec Polling Exception.
Query name: [dbPollServiceSelect], Descriptor name: [dbPollService]. Polling the database for events failed on this iteration.
Caused by javax.resource.spi.IllegalStateException: [Connector:199176]Unable to execute allocateConnection(...) on ConnectionManager. A stale Connection Factory or Connection Handle may be used. The connection pool associated with it has already been destroyed. Try to perform another lookup of the Connection Factory eis/DB/EBS from JNDI and get a new Connection Handle..

We followed steps to RECREATE connection factory and updated DB adapter as suggested in

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center