ORA-00001 B2B.SYS_C00100766 ERROR WHEN DEPLOYING TP IN CLUSTERED ENV (Doc ID 786902.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Server Integration B2B - Version: 10.1.2.0.2 to 10.1.2.3
This problem can occur on any platform.

Symptoms

When attempting to setup and deploy a new trading partner in a clustered (multiple b2b midtier), the following error occurred.

Error Message
2008.10.26 at 11:33:31:404: Thread-9: B2B - (INFORMATION)
oracle.tip.adapter.b2b.engine.Engine:processIncomingMessage Enter
2008.10.26 at 11:33:38:401: Thread-9: B2B - (ERROR) java.sql.SQLException: ORA-00001: unique
constraint (B2B.SYS_C00100766) violated

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:699)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:631)
at
oracle.jdbc.driver.T2CPreparedStatement.execute_for_describe(T2CPreparedStatement.java:851)
at
oracle.jdbc.driver.T2CPreparedStatement.execute_for_rows(T2CPreparedStatement.java:1014)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
at
oracle.jdbc.driver.OraclePreparedStatement.sendBatch(OraclePreparedStatement.java:3276)
at
oracle.jdbc.driver.OraclePreparedStatement.alwaysOnClose(OraclePreparedStatement.java:9390)
at
oracle.jdbc.driver.OraclePreparedStatement.enterImplicitCache(OraclePreparedStatement.java:2678)
at oracle.jdbc.driver.LRUStatementCache.addToImplicitCache(LRUStatementCache.java:291)
at
oracle.jdbc.driver.PhysicalConnection.cacheImplicitStatement(PhysicalConnection.java:4006)
at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1375)
at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1341)
at

oracle.tip.adapter.b2b.document.edi.EDIRepository.insertIncomingControlNumber(EDIRepository.java:349
)
at

oracle.tip.adapter.b2b.document.edi.EDIDocumentPlugin.processIncomingDocument(EDIDocumentPlugin.java
:1362)
at oracle.tip.adapter.b2b.engine.Engine.processIncomingMessage(Engine.java:1830)
at oracle.tip.adapter.b2b.engine.Engine.incomingContinueProcess(Engine.java:2516)
at oracle.tip.adapter.b2b.engine.Engine.handleMessageEvent(Engine.java:2386)
at oracle.tip.adapter.b2b.engine.Engine.processEvents(Engine.java:2341)
at oracle.tip.adapter.b2b.data.MsgListener.onMessage(MsgListener.java:527)
at oracle.tip.adapter.b2b.data.MsgListener.run(MsgListener.java:374)
at java.lang.Thread.run(Thread.java:534)

2008.10.26 at 11:33:38:401: Thread-9: B2B - (ERROR) Error -: AIP-51505: General Validation
Error: java.sql.SQLException: ORA-00001: unique constraint (B2B.SYS_C00100766) violated
at

oracle.tip.adapter.b2b.document.edi.EDIDocumentPlugin.processIncomingDocument(EDIDocumentPlugin.java
:1658)
at oracle.tip.adapter.b2b.engine.Engine.processIncomingMessage(Engine.java:1830)
at oracle.tip.adapter.b2b.engine.Engine.incomingContinueProcess(Engine.java:2516)
at oracle.tip.adapter.b2b.engine.Engine.handleMessageEvent(Engine.java:2386)
at oracle.tip.adapter.b2b.engine.Engine.processEvents(Engine.java:2341)
at oracle.tip.adapter.b2b.data.MsgListener.onMessage(MsgListener.java:527)
at oracle.tip.adapter.b2b.data.MsgListener.run(MsgListener.java:374)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: ORA-00001:

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