Inbound Database Adapter Polling not Working - SQLSyntaxErrorException and ORA-00942 Errors
(Doc ID 1313685.1)
Last updated on MARCH 24, 2021
Applies to:
Oracle SOA Suite - Version 11.1.1.1.0 and laterInformation in this document applies to any platform.
Symptoms
You have a Mediator process that uses an inbound DB Adapter to poll records from a table. However the adapter never starts polling and the following error occurs:
[2011-03-28T10:42:53.174-05:00] [soa_server1] .. Database Adapter StageEmpPrj <oracle.tip.adapter.db.InboundWork handleException> BINDING.JCA-11624[[
DBActivationSpec Polling Exception.
Query name: [GetEmpDASelect], Descriptor name: [GetEmpDA.StageEmp]. Polling the database for events failed on this iteration.
Caused by java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
.
This exception is considered retriable, likely due to a communication failure. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "942" to your deployment descriptor (i.e. weblogic-ra.xml). Polling will be attempted again next polling interval.
DBActivationSpec Polling Exception.
Query name: [GetEmpDASelect], Descriptor name: [GetEmpDA.StageEmp]. Polling the database for events failed on this iteration.
Caused by java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
.
This exception is considered retriable, likely due to a communication failure. To classify it as non-retriable instead add property nonRetriableErrorCodes with value "942" to your deployment descriptor (i.e. weblogic-ra.xml). Polling will be attempted again next polling interval.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |