My Oracle Support Banner

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

Last updated on APRIL 23, 2019

Applies to:

Oracle B2B 10g (Business to Business) - Version 10.1.2.0.2 and later
Information in this document applies to any platform.
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

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
References


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