My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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