Record Not Getting Polled When Using Sequence Table In External Schema In SOA DB Adapter

(Doc ID 2366540.1)

Last updated on APRIL 04, 2018

Applies to:

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

Symptoms

On : 12.2.1.0.0 version, Technology Adapters

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

ERROR
-----------------------

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: a2b59b39-7eaa-4c32-ba2e-de847d14bb03-0000507d,0:2128] [APP: soa-infra] [partition-name: DOMAIN] [tenant-name: GLOBAL] [composite_name: DBPoolingUsingExternalSequenceTable] [composite_version: 1.0] [service_name: PoolDatabase] 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: [PoolDatabaseSelect], 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(DBResourceException.java:690)
at oracle.tip.adapter.db.exceptions.DBResourceException.createEISException(DBResourceException.java:656)
at oracle.tip.adapter.db.exceptions.DBResourceException.inboundReadException(DBResourceException.java:491)
at oracle.tip.adapter.db.InboundWork.handleException(InboundWork.java:1018)
at oracle.tip.adapter.db.InboundWork.run(InboundWork.java:580)
at oracle.tip.adapter.db.inbound.InboundWorkWrapper.run(InboundWorkWrapper.java:43)
at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:184)
at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:207)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:617)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:595)
at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:39)
Caused by: java.lang.ClassCastException

]]
[] [soa_server] [TRACE] [] [oracle.soa.adapter] [tid: DaemonWorkThread: '11' of WorkManager: 'default_Adapters'] [userId: weblogic] [ecid: a2b59b39-7eaa-4c32-ba2e-de847d14bb03-0000507d,0:2128] [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.
]]


STEPS
-----------------------
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

Changes

 Select External Sequencing Table on a Different Database

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms