java.sql.SQLIntegrityConstraintViolationException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Table without primary key
    via symmetricds by aleksandy
    ,
  • Web8 Update Preview error
    via Tridion by Jose Honorato
    ,
  • AD Group members
    via by 740620,
  • Error during AD target recon.
    via by user00009,
    • java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("JKL"."USERS"."USER_ID") at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at com.thortech.xl.gc.impl.common.DBFacade.createParentRecord(Unknown Source) at com.thortech.xl.gc.impl.prov.DBProvisioningTransportProvider.sendData(Unknown Source) at com.thortech.xl.gc.runtime.GCAdapterLibrary.executeFunctionality(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.thortech.xl.adapterGlue.ScheduleItemEvents.adpCGP2011_GTC.GENERICADAPTER(adpCGP2011_GTC.java:125) at com.thortech.xl.adapterGlue.ScheduleItemEvents.adpCGP2011_GTC.implementation(adpCGP2011_GTC.java:70) at com.thortech.xl.client.events.tcBaseEvent.run(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.runEvent(Unknown Source) at com.thortech.xl.dataobj.tcScheduleItem.runMilestoneEvent(Unknown Source) at com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source) at com.thortech.xl.dataobj.tcORC.insertNonConditionalMilestones(Unknown Source) at com.thortech.xl.dataobj.tcORC.completeSystemValidationMilestone(Unknown Source) at com.thortech.xl.dataobj.tcOrderItemInfo.completeCarrierBaseMilestone(Unknown Source) at com.thortech.xl.dataobj.tcOrderItemInfo.eventPostInsert(Unknown Source) at com.thortech.xl.dataobj.tcUDProcess.eventPostInsert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source) at com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source) at com.thortech.xl.dataobj.tcORC.autoDOBSave(Unknown Source) at com.thortech.xl.dataobj.util.tcOrderPackages.createOrder(Unknown Source) at com.thortech.xl.dataobj.util.tcOrderPackages.orderPackageForUser(Unknown Source) at com.thortech.xl.dataobj.tcOIU.provision(Unknown Source) at com.thortech.xl.dataobj.tcOIU.eventPostInsert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source) at com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source) at com.thortech.xl.dataobj.tcUserProvisionObject.insertImplementation(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source) at com.thortech.xl.dataobj.util.tcProvPolicyUtils.provisionObject(Unknown Source) at com.thortech.xl.dataobj.util.tcProvPolicyUtils.provisionObjects(Unknown Source) at com.thortech.xl.dataobj.util.tcProvPolicyUtils.doProvisioning(Unknown Source) at com.thortech.xl.dataobj.util.tcProvPolicyUtils.evaluatePolicies(Unknown Source) at com.thortech.xl.dataobj.util.tcProvPolicyUtils.evaluatePolicies_All(Unknown Source) at com.thortech.xl.client.events.tcUSRevaluatePolicies.evaluatePolicies(Unknown Source) at com.thortech.xl.client.events.tcUSRevaluatePolicies.implementation(Unknown Source) at com.thortech.xl.client.events.tcBaseEvent.run(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.runEvent(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.eventPostUpdate(Unknown Source) at com.thortech.xl.dataobj.tcUSR.eventPostUpdate(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.update(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source) at com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source) at com.thortech.xl.dataobj.tcUSR.orderUserProcess(Unknown Source) at com.thortech.xl.dataobj.tcUSR.eventPostInsert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source) at com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source) at com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.createUser(Unknown Source) at com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.createUser(Unknown Source) at com.thortech.xl.ejb.beans.tcUserOperationsSession.createUser(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.invocation.Invocation.performCall(Invocation.java:359) at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158) at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169) at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181) at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138) at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648) at org.jboss.ejb.Container.invoke(Container.java:960) at sun.reflect.GeneratedMethodAccessor127.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169) at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118) at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209) at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195) at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61) at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70) at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112) at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100) at $Proxy745.createUser(Unknown Source) at Thor.API.Operations.tcUserOperationsClient.createUser(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at Thor.API.Base.SecurityInvocationHandler$1.run(Unknown Source) at Thor.API.Security.LoginHandler.jbossLoginSession.runAs(Unknown Source) at Thor.API.Base.SecurityInvocationHandler.invoke(Unknown Source) at $Proxy800.createUser(Unknown Source) at com.thortech.xl.webclient.actions.tcManageUserAction.createUser(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280) at com.thortech.xl.webclient.actions.tcLookupDispatchAction.execute(Unknown Source) at com.thortech.xl.webclient.actions.tcActionBase.execute(Unknown Source) at com.thortech.xl.webclient.actions.tcAction.execute(Unknown Source) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.thortech.xl.webclient.security.SecurityFilter.doFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:619)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    31 more bugmates