java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("JKL"."USERS"."USER_ID")

Oracle Community | kokito | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    How to configure automatic  provisioning...?

    Oracle Community | 6 years ago | kokito
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("JKL"."USERS"."USER_ID")
  2. 0

    Table without primary key

    symmetricds | 5 years ago | aleksandy
    java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (DEST.FK_TABLEB_A_ID) violated - parent key not found
  3. 0

    Web8 Update Preview error

    Tridion | 10 months ago | Jose Honorato
    java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (TRIDIONSESSIONPREVIEWUSER.FK_VARIANTS_BINARY) violated - parent key not found
  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 | 2 years ago
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ETRIAL.SYS_C006672) violated
  6. 0

    Session Id Issue in weblogic 10 using jdbc persistence

    Oracle Community | 7 years ago | 747758
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ETRIAL.SYS_C006672) 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 ("JKL"."USERS"."USER_ID")

    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. Commons DBCP
    DelegatingPreparedStatement.executeUpdate
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
    1 frame
  4. com.thortech.xl
    GCAdapterLibrary.executeFunctionality
    1. com.thortech.xl.gc.impl.common.DBFacade.createParentRecord(Unknown Source)
    2. com.thortech.xl.gc.impl.prov.DBProvisioningTransportProvider.sendData(Unknown Source)
    3. com.thortech.xl.gc.runtime.GCAdapterLibrary.executeFunctionality(Unknown Source)
    3 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. com.thortech.xl
    tcUserOperationsSession.createUser
    1. com.thortech.xl.adapterGlue.ScheduleItemEvents.adpCGP2011_GTC.GENERICADAPTER(adpCGP2011_GTC.java:125)
    2. com.thortech.xl.adapterGlue.ScheduleItemEvents.adpCGP2011_GTC.implementation(adpCGP2011_GTC.java:70)
    3. com.thortech.xl.client.events.tcBaseEvent.run(Unknown Source)
    4. com.thortech.xl.dataobj.tcDataObj.runEvent(Unknown Source)
    5. com.thortech.xl.dataobj.tcScheduleItem.runMilestoneEvent(Unknown Source)
    6. com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(Unknown Source)
    7. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    8. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    9. com.thortech.xl.dataobj.tcORC.insertNonConditionalMilestones(Unknown Source)
    10. com.thortech.xl.dataobj.tcORC.completeSystemValidationMilestone(Unknown Source)
    11. com.thortech.xl.dataobj.tcOrderItemInfo.completeCarrierBaseMilestone(Unknown Source)
    12. com.thortech.xl.dataobj.tcOrderItemInfo.eventPostInsert(Unknown Source)
    13. com.thortech.xl.dataobj.tcUDProcess.eventPostInsert(Unknown Source)
    14. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    15. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    16. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
    17. com.thortech.xl.dataobj.tcORC.autoDOBSave(Unknown Source)
    18. com.thortech.xl.dataobj.util.tcOrderPackages.createOrder(Unknown Source)
    19. com.thortech.xl.dataobj.util.tcOrderPackages.orderPackageForUser(Unknown Source)
    20. com.thortech.xl.dataobj.tcOIU.provision(Unknown Source)
    21. com.thortech.xl.dataobj.tcOIU.eventPostInsert(Unknown Source)
    22. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    23. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    24. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
    25. com.thortech.xl.dataobj.tcUserProvisionObject.insertImplementation(Unknown Source)
    26. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    27. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    28. com.thortech.xl.dataobj.util.tcProvPolicyUtils.provisionObject(Unknown Source)
    29. com.thortech.xl.dataobj.util.tcProvPolicyUtils.provisionObjects(Unknown Source)
    30. com.thortech.xl.dataobj.util.tcProvPolicyUtils.doProvisioning(Unknown Source)
    31. com.thortech.xl.dataobj.util.tcProvPolicyUtils.evaluatePolicies(Unknown Source)
    32. com.thortech.xl.dataobj.util.tcProvPolicyUtils.evaluatePolicies_All(Unknown Source)
    33. com.thortech.xl.client.events.tcUSRevaluatePolicies.evaluatePolicies(Unknown Source)
    34. com.thortech.xl.client.events.tcUSRevaluatePolicies.implementation(Unknown Source)
    35. com.thortech.xl.client.events.tcBaseEvent.run(Unknown Source)
    36. com.thortech.xl.dataobj.tcDataObj.runEvent(Unknown Source)
    37. com.thortech.xl.dataobj.tcDataObj.eventPostUpdate(Unknown Source)
    38. com.thortech.xl.dataobj.tcUSR.eventPostUpdate(Unknown Source)
    39. com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)
    40. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    41. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
    42. com.thortech.xl.dataobj.tcUSR.orderUserProcess(Unknown Source)
    43. com.thortech.xl.dataobj.tcUSR.eventPostInsert(Unknown Source)
    44. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    45. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    46. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
    47. com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.createUser(Unknown Source)
    48. com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.createUser(Unknown Source)
    49. com.thortech.xl.ejb.beans.tcUserOperationsSession.createUser(Unknown Source)
    49 frames
  7. 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
  8. JBoss Application Server Server
    StatelessSessionContainer$ContainerInterceptor.invoke
    1. org.jboss.invocation.Invocation.performCall(Invocation.java:359)
    2. org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
    2 frames
  9. JBoss Application Server Connector
    CachedConnectionInterceptor.invoke
    1. org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
    1 frame
  10. JBoss Application Server Server
    Container.invoke
    1. org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
    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.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
    7. org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
    8. org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
    9. org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
    10. org.jboss.ejb.Container.invoke(Container.java:960)
    10 frames
  11. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor127.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  12. org.jboss.mx
    ReflectedDispatcher.invoke
    1. org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
    1 frame
  13. JBoss Application Server J2SE
    MBeanServerImpl.invoke
    1. org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
    2. org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
    3. org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
    4. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
    4 frames
  14. JBoss Application Server Server
    ClientContainer.invoke
    1. org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
    2. org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
    3. org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
    4. org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
    5. org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
    6. org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
    7. org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
    8. org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
    8 frames
  15. Unknown
    $Proxy745.createUser
    1. $Proxy745.createUser(Unknown Source)
    1 frame
  16. Thor.API.Operations
    tcUserOperationsClient.createUser
    1. Thor.API.Operations.tcUserOperationsClient.createUser(Unknown Source)
    1 frame
  17. 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
  18. Thor.API.Base
    SecurityInvocationHandler$1.run
    1. Thor.API.Base.SecurityInvocationHandler$1.run(Unknown Source)
    1 frame
  19. Thor.API.Security
    jbossLoginSession.runAs
    1. Thor.API.Security.LoginHandler.jbossLoginSession.runAs(Unknown Source)
    1 frame
  20. Thor.API.Base
    SecurityInvocationHandler.invoke
    1. Thor.API.Base.SecurityInvocationHandler.invoke(Unknown Source)
    1 frame
  21. Unknown
    $Proxy800.createUser
    1. $Proxy800.createUser(Unknown Source)
    1 frame
  22. com.thortech.xl
    tcManageUserAction.createUser
    1. com.thortech.xl.webclient.actions.tcManageUserAction.createUser(Unknown Source)
    1 frame
  23. 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
  24. struts
    DispatchAction.dispatchMethod
    1. org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
    1 frame
  25. com.thortech.xl
    tcAction.execute
    1. com.thortech.xl.webclient.actions.tcLookupDispatchAction.execute(Unknown Source)
    2. com.thortech.xl.webclient.actions.tcActionBase.execute(Unknown Source)
    3. com.thortech.xl.webclient.actions.tcAction.execute(Unknown Source)
    3 frames
  26. struts
    ActionServlet.doPost
    1. org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
    2. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
    3. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
    4. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
    4 frames
  27. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    2 frames
  28. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  29. com.thortech.xl
    SecurityFilter.doFilter
    1. com.thortech.xl.webclient.security.SecurityFilter.doFilter(Unknown Source)
    1 frame
  30. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  31. JBoss Application Server Tomcat
    ReplyHeaderFilter.doFilter
    1. org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
    1 frame
  32. Glassfish Core
    StandardContextValve.invoke
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    4 frames
  33. JBoss Application Server Tomcat
    JaccContextValve.invoke
    1. org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
    2. org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
    2 frames
  34. Glassfish Core
    ErrorReportValve.invoke
    1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    2. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    2 frames
  35. JBoss Application Server Tomcat
    CachedConnectionValve.invoke
    1. org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
    1 frame
  36. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    2. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
    2 frames
  37. Grizzly HTTP
    JIoEndpoint$Worker.run
    1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
    3 frames
  38. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:619)
    1 frame