In SOA Cluster, Inbound File Adapter Fails with '[ORA-00001: unique constraint violated Error' after Reading the First File

(Doc ID 1420516.1)

Last updated on OCTOBER 13, 2017

Applies to:

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

Symptoms

On SOA cluster environment, file adapter is able to process the first file, however, when picking up a 2nd file or subsequent file with the same name, the following error occurs:

[2012-02-13T15:32:13.776-08:00] [soa_server1] [TRACE] [] [oracle.soa.adapter] [tid: weblogic.work.j2ee.J2EEWorkManager$WorkWithListener@bb165c5] [userId: <anonymous>] [ecid: 0000J,0] [SRC_CLASS: oracle.integration.platform.blocks.adapter.fw.log.LogManagerImpl] [APP: soa-infra] [SRC_METHOD: log] File Adapter EBillingBillLoader FileListDAO::tryLock failed due to [ORA-00001: unique constraint (FMW_SOAINFRA.SYS_C007970) violated[[]]]


The adapter will only work after restarting the SOA server or redeploying the project.

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