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 laterInformation 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
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 |
| Cause |
| Solution |