DB Insertion error (primary key already existed)

[crimson]

Hi,

I was doing some testing between 2 Hermes deployment. I sent out an
ebxml message from Gateway A to Gateway B. There was a DB insertion
error while storing the incoming message at Gateway B. Below is the
trace:
How can there be a same existing message id in the message DB when the
incoming first arrive??


2009-08-20 11:36:49 [elf-tuning)'] <INFO > <cecid.ebms.spa> <Incoming
ebxml message received: 20090820-1...@172.20.27.119>
2009-08-20 11:36:49 [elf-tuning)'] <INFO > <cecid.ebms.spa> <Inbound
agreement checking for interop>
2009-08-20 11:36:49 [elf-tuning)'] <INFO > <cecid.ebms.spa> <It is an
order message: 20090820-1...@172.20.27.119>
2009-08-20 11:36:49 [elf-tuning)'] <INFO > <cecid.ebms.spa> <Store the
incoming message: 20090820-1...@172.20.27.119>
2009-08-20 11:36:49 [Thread-13506] <INFO > <cecid.ebms.spa> <Ebxml
Message (20090820-1...@172.20.27.119) is stored in inbox with
order number: 30>
2009-08-20 11:36:49 [Thread-13514] <ERROR> <cecid.ebms.spa> <Error in
storing message to inbox>
hk.hku.cecid.piazza.commons.dao.DAOException: Error in executing
hk.hku.cecid.ebms.spa.dao.InboxDataSourceDAO::Process@36583658
by hk.hku.cecid.piazza.commons.dao.DAOException: Error in executing
update: INSERT INTO inbox (order_no, message_id) VALUES (?,?)
by hk.hku.cecid.piazza.commons.dao.DAOException: Error occurred when
executing update at row 0 of the specified parameter array
by java.sql.SQLIntegrityConstraintViolationException: ORA-00001:
unique constraint (OWNER.SYS_C0012698) violated

at hk.hku.cecid.piazza.commons.dao.ds.DataSourceProcess.start
(DataSourceProcess.java:97)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.executeUpdate
(DataSourceDAO.java:588)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.executeUpdate
(DataSourceDAO.java:548)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.executeUpdate
(DataSourceDAO.java:528)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.create
(DataSourceDAO.java:626)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.create
(DataSourceDAO.java:610)
at hk.hku.cecid.ebms.spa.task.InboxTask.execute(InboxTask.java:55)
at hk.hku.cecid.piazza.commons.module.ActiveThread.run
(ActiveThread.java:90)
at java.lang.Thread.run(Thread.java:735)
Caused by: hk.hku.cecid.piazza.commons.dao.DAOException: Error in
executing update: INSERT INTO inbox (order_no, message_id) VALUES
(?,?)
by hk.hku.cecid.piazza.commons.dao.DAOException: Error occurred when
executing update at row 0 of the specified parameter array
by java.sql.SQLIntegrityConstraintViolationException: ORA-00001:
unique constraint (OWNER.SYS_C0012698) violated

at hk.hku.cecid.piazza.commons.dao.ds.DataSourceUpdate.doTransaction
(DataSourceUpdate.java:110)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceProcess.start
(DataSourceProcess.java:89)
... 8 more
Caused by: hk.hku.cecid.piazza.commons.dao.DAOException: Error
occurred when executing update at row 0 of the specified parameter
array
by java.sql.SQLIntegrityConstraintViolationException: ORA-00001:
unique constraint (OWNER.SYS_C0012698) violated

at hk.hku.cecid.piazza.commons.dao.ds.DataSourceUpdate.doTransaction
(DataSourceUpdate.java:96)
... 9 more
Caused by: java.sql.SQLIntegrityConstraintViolationException:
ORA-00001: unique constraint (OWNER.SYS_C0012698) violated

at oracle.jdbc.driver.SQLStateMapping.newSQLException
(SQLStateMapping.java:85)
at oracle.jdbc.driver.DatabaseError.newSQLException
(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8
(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows
(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
(OracleStatement.java:1222)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal
(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate
(OraclePreparedStatementWrapper.java:1349)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate
(PreparedStatement.java:159)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceUpdate.doTransaction
(DataSourceUpdate.java:92)
... 9 more
2009-08-20 11:36:49 [Thread-13514] <ERROR> <cecid.ebms.spa> <Exception
when store the msg to inbox>
hk.hku.cecid.ebms.spa.task.DeliveryException: Error in storing message
to inbox
by hk.hku.cecid.piazza.commons.dao.DAOException: Error in executing
hk.hku.cecid.ebms.spa.dao.InboxDataSourceDAO::Process@36583658
by hk.hku.cecid.piazza.commons.dao.DAOException: Error in executing
update: INSERT INTO inbox (order_no, message_id) VALUES (?,?)
by hk.hku.cecid.piazza.commons.dao.DAOException: Error occurred when
executing update at row 0 of the specified parameter array
by java.sql.SQLIntegrityConstraintViolationException: ORA-00001:
unique constraint (OWNER.SYS_C0012698) violated

at hk.hku.cecid.ebms.spa.task.InboxTask.execute(InboxTask.java:63)
at hk.hku.cecid.piazza.commons.module.ActiveThread.run
(ActiveThread.java:90)
at java.lang.Thread.run(Thread.java:735)
Caused by: hk.hku.cecid.piazza.commons.dao.DAOException: Error in
executing
hk.hku.cecid.ebms.spa.dao.InboxDataSourceDAO::Process@36583658
by hk.hku.cecid.piazza.commons.dao.DAOException: Error in executing
update: INSERT INTO inbox (order_no, message_id) VALUES (?,?)
by hk.hku.cecid.piazza.commons.dao.DAOException: Error occurred when
executing update at row 0 of the specified parameter array
by java.sql.SQLIntegrityConstraintViolationException: ORA-00001:
unique constraint (OWNER.SYS_C0012698) violated

at hk.hku.cecid.piazza.commons.dao.ds.DataSourceProcess.start
(DataSourceProcess.java:97)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.executeUpdate
(DataSourceDAO.java:588)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.executeUpdate
(DataSourceDAO.java:548)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.executeUpdate
(DataSourceDAO.java:528)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.create
(DataSourceDAO.java:626)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceDAO.create
(DataSourceDAO.java:610)
at hk.hku.cecid.ebms.spa.task.InboxTask.execute(InboxTask.java:55)
... 2 more
Caused by: hk.hku.cecid.piazza.commons.dao.DAOException: Error in
executing update: INSERT INTO inbox (order_no, message_id) VALUES
(?,?)
by hk.hku.cecid.piazza.commons.dao.DAOException: Error occurred when
executing update at row 0 of the specified parameter array
by java.sql.SQLIntegrityConstraintViolationException: ORA-00001:
unique constraint (OWNER.SYS_C0012698) violated

at hk.hku.cecid.piazza.commons.dao.ds.DataSourceUpdate.doTransaction
(DataSourceUpdate.java:110)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceProcess.start
(DataSourceProcess.java:89)
... 8 more
Caused by: hk.hku.cecid.piazza.commons.dao.DAOException: Error
occurred when executing update at row 0 of the specified parameter
array
by java.sql.SQLIntegrityConstraintViolationException: ORA-00001:
unique constraint (OWNER.SYS_C0012698) violated

at hk.hku.cecid.piazza.commons.dao.ds.DataSourceUpdate.doTransaction
(DataSourceUpdate.java:96)
... 9 more
Caused by: java.sql.SQLIntegrityConstraintViolationException:
ORA-00001: unique constraint (OWNER.SYS_C0012698) violated

at oracle.jdbc.driver.SQLStateMapping.newSQLException
(SQLStateMapping.java:85)
at oracle.jdbc.driver.DatabaseError.newSQLException
(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8
(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows
(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
(OracleStatement.java:1222)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal
(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate
(OraclePreparedStatementWrapper.java:1349)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate
(PreparedStatement.java:159)
at hk.hku.cecid.piazza.commons.dao.ds.DataSourceUpdate.doTransaction
(DataSourceUpdate.java:92)
... 9 more