java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("PRD_SOAINFRA"."DLV_MESSAGE"."COMPONENT_TYPE") Error Code: 1400 Call: INSERT INTO DLV_MESSAGE (MESSAGE_GUID, RECEIVE_DATE, COMPOSITE_NAME, OPERATION_NAME, COMPOSITE_LABEL, CONV_ID, STATE, EXT_STRING1, DOMAIN_NAME, PARTNER_LINK, EXT_INT1, CIKEY, COMPONENT_NAME, EXT_STRING2, PRIORITY, COMPOSITE_REVISION, EVENT_NAME, MASTER_CONV_ID, DLV_TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [5200C9D0BEE011E0BF99ABEF4F8A8306, 2011-08-04 17:25:47.877, XPD2_POLLER, Read, soa_f7332b37-c795-4939-a399-9d3fd3cacd2c, Haw_Jl1AltujLx7lN-wzXNr-82ij6qF-Vd3N24cFylE., 0, null, EnterpriseDomain, XPD2_Poller, 0, 0, entsyspoller, null, 5, 1.1, null, null, 1] Query: InsertObjectQuery(com.collaxa.cube.persistence.dto.InvokeMessage@227429ec)

Oracle Community | 727045 | 5 years ago
  1. 0

    ORA-01400: cannot insert NULL into ("PRD_SOAINFRA"."DLV_MESSAGE"."COMPONENT

    Oracle Community | 5 years ago | 727045
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("PRD_SOAINFRA"."DLV_MESSAGE"."COMPONENT_TYPE") Error Code: 1400 Call: INSERT INTO DLV_MESSAGE (MESSAGE_GUID, RECEIVE_DATE, COMPOSITE_NAME, OPERATION_NAME, COMPOSITE_LABEL, CONV_ID, STATE, EXT_STRING1, DOMAIN_NAME, PARTNER_LINK, EXT_INT1, CIKEY, COMPONENT_NAME, EXT_STRING2, PRIORITY, COMPOSITE_REVISION, EVENT_NAME, MASTER_CONV_ID, DLV_TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [5200C9D0BEE011E0BF99ABEF4F8A8306, 2011-08-04 17:25:47.877, XPD2_POLLER, Read, soa_f7332b37-c795-4939-a399-9d3fd3cacd2c, Haw_Jl1AltujLx7lN-wzXNr-82ij6qF-Vd3N24cFylE., 0, null, EnterpriseDomain, XPD2_Poller, 0, 0, entsyspoller, null, 5, 1.1, null, null, 1] Query: InsertObjectQuery(com.collaxa.cube.persistence.dto.InvokeMessage@227429ec)
  2. 0

    Oracle Access Manager default installation issue: ORA-00001: unique constraint (DEV_OAM.PK_ENTITIES) violated

    Oracle Community | 2 years ago | Bram van Pelt
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_OAM.PK_ENTITIES) violated
  3. 0

    Java mon amour: June 2012

    javamonamour.org | 1 year ago
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (PP1_SOAINFRA.SYS_C0013550) violated
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Jdbc Data Source-0' Due To Error Weblogic.Application.Moduleexception

    wpthm.com | 1 year ago
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ETRIAL.SYS_C006672) violated
  6. 0

    Java mon amour: SQLIntegrityConstraintViolationException while the LeaseManager updates the ACTIVE table

    javamonamour.org | 1 year ago
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (PP1_SOAINFRA.SYS_C0013550) violated
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLIntegrityConstraintViolationException

    ORA-01400: cannot insert NULL into ("PRD_SOAINFRA"."DLV_MESSAGE"."COMPONENT_TYPE")

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeUpdate
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:89)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:135)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:210)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:473)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:423)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1095)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1040)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1379)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3568)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1508)
    12 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.executeUpdate
    1. weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
    1 frame
  4. EclipseLink (non-OSGi)
    JTASynchronizationListener.beforeCompletion
    1. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:792)
    2. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:867)
    3. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:587)
    4. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:530)
    5. org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:914)
    6. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
    7. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192)
    8. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:335)
    9. org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:162)
    10. org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:177)
    11. org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:462)
    12. org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80)
    13. org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90)
    14. org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:287)
    15. org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)
    16. org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:675)
    17. org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:589)
    18. org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:109)
    19. org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:86)
    20. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2898)
    21. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1225)
    22. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1207)
    23. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1167)
    24. org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:197)
    25. org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:164)
    26. org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:116)
    27. org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3260)
    28. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1413)
    29. org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:547)
    30. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1518)
    31. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3171)
    32. org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:268)
    33. org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:157)
    34. org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68)
    34 frames
  5. weblogic.transaction.internal
    ServerTransactionImpl.commit
    1. weblogic.transaction.internal.ServerSCInfo.doBeforeCompletion(ServerSCInfo.java:1214)
    2. weblogic.transaction.internal.ServerSCInfo.callBeforeCompletions(ServerSCInfo.java:1189)
    3. weblogic.transaction.internal.ServerSCInfo.startPrePrepareAndChain(ServerSCInfo.java:109)
    4. weblogic.transaction.internal.ServerTransactionImpl.localPrePrepareAndChain(ServerTransactionImpl.java:1301)
    5. weblogic.transaction.internal.ServerTransactionImpl.globalPrePrepare(ServerTransactionImpl.java:2117)
    6. weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:257)
    7. weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:224)
    7 frames
  6. weblogic.ejb.container
    BaseLocalObject.__WL_postInvokeTxRetry
    1. weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:594)
    2. weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:427)
    2 frames
  7. com.collaxa.cube
    BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.post
    1. com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.post(BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.java:408)
    1 frame
  8. oracle.fabric
    CubeServiceEngine.post
    1. oracle.fabric.CubeServiceEngine.post(CubeServiceEngine.java:560)
    1 frame
  9. oracle.integration.platform
    MeshImpl.post
    1. oracle.integration.platform.blocks.mesh.AsynchronousMessageHandler.doPost(AsynchronousMessageHandler.java:142)
    2. oracle.integration.platform.blocks.mesh.MessageRouter.post(MessageRouter.java:194)
    3. oracle.integration.platform.blocks.mesh.MeshImpl.post(MeshImpl.java:215)
    3 frames
  10. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor1167.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  11. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    3 frames
  12. oracle.integration.platform
    PhaseEventAspect.invoke
    1. oracle.integration.platform.metrics.PhaseEventAspect.invoke(PhaseEventAspect.java:59)
    1 frame
  13. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  14. Unknown
    $Proxy245.post
    1. $Proxy245.post(Unknown Source)
    1 frame
  15. oracle.integration.platform
    AdapterServiceMDB.onMessage
    1. oracle.integration.platform.blocks.adapter.fw.jca.mdb.AdapterServiceMDB.onMessage(AdapterServiceMDB.java:606)
    1 frame
  16. oracle.tip.adapter
    ProcessWork.run
    1. oracle.tip.adapter.fw.jca.messageinflow.MessageEndpointImpl.onMessage(MessageEndpointImpl.java:462)
    2. oracle.tip.adapter.file.inbound.Publisher.onMessageDelegate(Publisher.java:460)
    3. oracle.tip.adapter.file.inbound.Publisher.publishMessage(Publisher.java:397)
    4. oracle.tip.adapter.file.inbound.Publisher.publishAttachment(Publisher.java:151)
    5. oracle.tip.adapter.file.inbound.ProcessorDelegate.process(ProcessorDelegate.java:149)
    6. oracle.tip.adapter.file.inbound.ProcessWork.run(ProcessWork.java:349)
    6 frames
  17. oracle.integration.platform
    WorkManagerExecutor$1.run
    1. oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:105)
    1 frame
  18. weblogic.work.j2ee
    J2EEWorkManager$WorkWithListener.run
    1. weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:183)
    1 frame
  19. weblogic.work
    DaemonWorkThread.run
    1. weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)
    1 frame