Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-14740

fix constraint error in picture views generation on cmis tests oracle

    XMLWordPrintable

    Details

      Description

      2014-07-07 20:54:33,703 ERROR [Nuxeo-Work-pictureViewsGeneration-1] [org.nuxeo.ecm.core.storage.sql.SessionImpl] Exception during transaction commit
      org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO "DC_CONTRIBUTORS" ("ID", "POS", "ITEM") VALUES (?, ?, ?)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertCollectionRows(JDBCRowMapper.java:631)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.updateCollectionRows(JDBCRowMapper.java:718)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeUpdates(JDBCRowMapper.java:523)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:475)
      	at org.nuxeo.ecm.core.storage.sql.SoftRefCachingRowMapper.write(SoftRefCachingRowMapper.java:427)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.doFlush(SessionImpl.java:401)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:375)
      	at org.nuxeo.ecm.core.storage.sql.SessionImpl.end(SessionImpl.java:1521)
      	at org.apache.geronimo.transaction.manager.WrapperNamedXAResource.end(WrapperNamedXAResource.java:61)
      	at org.apache.geronimo.transaction.manager.TransactionImpl.endResources(TransactionImpl.java:569)
      	at org.apache.geronimo.transaction.manager.TransactionImpl.endResources(TransactionImpl.java:548)
      	at org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(TransactionImpl.java:408)
      	at org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:255)
      	at org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252)
      	at org.nuxeo.runtime.jtajca.NuxeoContainer$TransactionManagerWrapper.commit(NuxeoContainer.java:775)
      	at org.nuxeo.runtime.jtajca.NuxeoContainer$UserTransactionImpl.commit(NuxeoContainer.java:653)
      	at org.nuxeo.runtime.transaction.TransactionHelper.commitOrRollbackTransaction(TransactionHelper.java:312)
      	at org.nuxeo.ecm.core.work.AbstractWork.runWorkWithTransaction(AbstractWork.java:379)
      	at org.nuxeo.ecm.core.work.AbstractWork.runWorkWithTransactionAndCheckExceptions(AbstractWork.java:316)
      	at org.nuxeo.ecm.core.work.AbstractWork.run(AbstractWork.java:284)
      	at org.nuxeo.ecm.core.work.WorkHolder.run(WorkHolder.java:52)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      	at java.lang.Thread.run(Thread.java:744)
      Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (MADHATTER.DC_C_4015E4A8_FK) violated - parent key not found
      
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
      	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
      	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
      	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
      	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.ScalarCollectionIO.executeInserts(ScalarCollectionIO.java:105)
      	at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertCollectionRows(JDBCRowMapper.java:624)
      	... 23 more
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              slacoin Stéphane Lacoin
              Participants:
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: