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

Oracle Community | kokito | 6 years ago
  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 | 5 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 | 1 year 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

  1. balintn 4 times, last 2 weeks ago
  2. mellson 8 times, last 3 months ago
  3. mellson 2 times, last 3 months ago
  4. balintn 2 times, last 3 months ago
7 unregistered visitors
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