java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("XELADM"."UPA_USR"."ACT_KEY")

Oracle Community | 808915 | 6 years ago
  1. 0

    Event Handler not found -OIM 9102

    Oracle Community | 6 years ago | 808915
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("XELADM"."UPA_USR"."ACT_KEY")
  2. 0

    AD Group members

    Oracle Community | 7 years ago | 740620
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("XLSYSADM"."UD_GRPMAIL"."UD_DOMDL_KEY")
  3. 0

    Error during AD target recon.

    Oracle Community | 7 years ago | user00009
    java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (OIM_USER.FK_RCM_ORF) violated - parent key not found
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Unique Constraint violation during staging deployment in BCC

    Google Groups | 3 years ago | loka
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (VM_STAGING.DCS_CAT_CHLDCAT_P) violated
  6. 0

    Unable to deploy category from BCC ATG Oracle Web Commerce

    Stack Overflow | 2 years ago | Aazim
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("ATGCATALOGA"."DCS_CAT_CHLDCAT"."SEQUENCE_NUM")
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 ("XELADM"."UPA_USR"."ACT_KEY")

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeUpdate
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
    12 frames
  3. JBoss Application Server Connector
    WrappedPreparedStatement.executeUpdate
    1. org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
    1 frame
  4. com.thortech.xl
    AuditMessageHandlerMDB.onMessage
    1. com.thortech.xl.dataaccess.tcDataBase.writePreparedStatement(Unknown Source)
    2. com.thortech.xl.dataobj.PreparedStatementUtil.executeUpdate(Unknown Source)
    3. com.thortech.xl.audit.auditdataprocessors.UserProfileRDGenerator.insertUserProfile(Unknown Source)
    4. com.thortech.xl.audit.auditdataprocessors.UserProfileRDGenerator.processUserProfileChanges(Unknown Source)
    5. com.thortech.xl.audit.auditdataprocessors.UserProfileRDGenerator.processAuditData(Unknown Source)
    6. com.thortech.xl.audit.genericauditor.GenericAuditor.processAuditMessage(Unknown Source)
    7. com.thortech.xl.audit.engine.AuditEngine.processSingleAudJmsEntry(Unknown Source)
    8. com.thortech.xl.audit.engine.AuditEngine.processOfflineNew(Unknown Source)
    9. com.thortech.xl.audit.engine.jms.XLAuditMessageHandler.execute(Unknown Source)
    10. com.thortech.xl.schedule.jms.messagehandler.MessageProcessUtil.processMessage(Unknown Source)
    11. com.thortech.xl.schedule.jms.messagehandler.AuditMessageHandlerMDB.onMessage(Unknown Source)
    11 frames
  5. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  6. JBoss Application Server Server
    MessageDrivenContainer$ContainerInterceptor.invoke
    1. org.jboss.invocation.Invocation.performCall(Invocation.java:359)
    2. org.jboss.ejb.MessageDrivenContainer$ContainerInterceptor.invoke(MessageDrivenContainer.java:495)
    2 frames
  7. JBoss Application Server Connector
    CachedConnectionInterceptor.invoke
    1. org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
    1 frame
  8. JBoss Application Server Server
    JMSContainerInvoker$MessageListenerImpl.onMessage
    1. org.jboss.ejb.plugins.MessageDrivenInstanceInterceptor.invoke(MessageDrivenInstanceInterceptor.java:116)
    2. org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
    3. org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
    4. org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
    5. org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
    6. org.jboss.ejb.plugins.RunAsSecurityInterceptor.invoke(RunAsSecurityInterceptor.java:109)
    7. org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
    8. org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
    9. org.jboss.ejb.MessageDrivenContainer.internalInvoke(MessageDrivenContainer.java:402)
    10. org.jboss.ejb.Container.invoke(Container.java:960)
    11. org.jboss.ejb.plugins.jms.JMSContainerInvoker.invoke(JMSContainerInvoker.java:1092)
    12. org.jboss.ejb.plugins.jms.JMSContainerInvoker$MessageListenerImpl.onMessage(JMSContainerInvoker.java:1392)
    12 frames
  9. org.jboss.jms
    StdServerSession.onMessage
    1. org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:266)
    1 frame
  10. JBossMQ
    SpySession.run
    1. org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:906)
    2. org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:170)
    3. org.jboss.mq.SpySession.run(SpySession.java:323)
    3 frames
  11. org.jboss.jms
    StdServerSession.run
    1. org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194)
    1 frame
  12. Dough Lea's util.concurrent package
    PooledExecutor$Worker.run
    1. EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:761)
    1 frame
  13. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:619)
    1 frame