My Oracle Support Banner

Record Not Getting Polled When Using Sequence Table In External Schema In SOA DB Adapter (Doc ID 2366540.1)

Last updated on JANUARY 20, 2022

Applies to:

Oracle SOA Suite - Version and later
Information in this document applies to any platform.


On : version, Technology Adapters

Record not Getting Polled when using "Update an External Sequencing Table on a Different Database"


No errors generated when deploying the composite

The following error message appears in the logs :

[] [soa_server] [ERROR] [] [oracle.soa.adapter.db.inbound] [tid: DaemonWorkThread: '11' of WorkManager: 'default_Adapters'] [userId: weblogic] [ecid: ] [APP: soa-infra] [partition-name: DOMAIN] [tenant-name: GLOBAL] [composite_name:name] [composite_version: 1.0] [service_name: name] Encountered a fatal exception while polling. Will continue polling but with minimal logging. Please investigate the fault and manually stop polling from the console if in development and this appears to be a modeling mistake. BINDING.JCA-11624[[
DBActivationSpec Polling Exception.
Query name: [<name>], Descriptor name: [PoolDatabase.XxgSoaStgHdr]. Polling the database for events failed on this iteration.
Caused by java.lang.ClassCastException.
This exception is considered not retriable, likely due to a modelling mistake. This polling process will shut down, unless the fault is related to processing a particular row, in which case polling will continue but the row will be rejected (faulted).

at oracle.tip.adapter.db.exceptions.DBResourceException.createNonRetriableException(
at oracle.tip.adapter.db.exceptions.DBResourceException.createEISException(
at oracle.tip.adapter.db.exceptions.DBResourceException.inboundReadException(
at oracle.tip.adapter.db.InboundWork.handleException(
at oracle.integration.platform.blocks.executor.WorkManagerExecutor$
at weblogic.invocation.ComponentInvocationContextManager._runAs(
at weblogic.invocation.ComponentInvocationContextManager.runAs(
Caused by: java.lang.ClassCastException

[] [soa_server] [TRACE] [] [oracle.soa.adapter] [tid: DaemonWorkThread: '11' of WorkManager: 'default_Adapters'] [userId: <user>] [ecid: ] [APP: soa-infra] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl] [SRC_METHOD: log] JCABinding=> PoolDatabase onAlert: sent alert <<[[
DBActivationSpec Polling Exception
Caused by {2}.

>> to the JCA Binding Component.

The issue can be reproduced at will with the following steps:
1. Create composite and add Database Adapter to poll records in a database
2. Select "Update an External Sequencing Table on a Different Database"
3. Records are not updated in the External Sequencing Table on a Different Database

If "Update a Sequencing Table" is selected, then the sequencing table is updated. The issue is only with External Sequencing Table on a Different Database


 Select External Sequencing Table on a Different Database


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.