java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (KMS.KREN_NTFCTN_FK3) violated - parent key not found

Kuali JIRA | Mike Riley | 4 years ago
  1. 0

    I noticed this error when browsing the SND log4j output: (makes me wonder if KREN configuration was not completed on SND) 2012-11-05 16:14:52,155 [ajp-bio-192.168.220.241-8039-exec-5:] ERROR org.apache.ojb.broker.accesslayer.JdbcAccessImpl.generateException() :: * SQLException during execution of sql-statement: * sql statement was 'INSERT INTO KREN_NTFCTN_T (NTFCTN_ID,DELIV_TYP,CRTE_DTTM,SND_DTTM,AUTO_RMV_DTTM,TTL,CNTNT,PROCESSING_FLAG,LOCKD_DTTM,VER_NBR,PRODCR_ID,CNTNT_TYP_ID,CHNL_ID,PRIO_ID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?) ' * Exception message is [ORA-02291: integrity constraint (KMS.KREN_NTFCTN_FK3) violated - parent key not found ] * Vendor error code [2291] * SQL state code [23000=INTEGRITY CONSTRAINT VIOLATION] * Target class is 'org.kuali.rice.ken.bo.Notification' * PK of the target object is [id=1022] * Source object: org.kuali.rice.ken.bo.Notification@2d06fee3[id=1022,deliveryType=FYI,sendDateTime=2012-11-05 16:14:52.142,autoRemoveDateTime=<null>,content=<content><message>This is a notification of item changes made to the indicated worklist</message>...,processingFlag=UNRESOLVED,lockedDate=<null>,lockVerNbr=1,priority=org.kuali.rice.ken.bo.NotificationPriority@703e50e8,contentType=org.kuali.rice.ken.bo.NotificationContentType@b31e8ea[id=100,name=KMS WorkList Change Notification,namespace=notification/ContentTypeWorkListChange,version=0,current=true],channel=org.kuali.rice.ken.bo.NotificationChannel@79b26063,producer=org.kuali.rice.ken.bo.NotificationProducer@2dd64200[id=100,name=KITSKMS Events Manager,description=This producter will be used to trigger KITSKMS event notifications,contactInfo=kits.dev@kuali.org],recipients=0,senders=1] * The root stack trace is --> * java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (KMS.KREN_NTFCTN_FK3) violated - parent key not found at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) at org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.springmodules.orm.ojb.PersistenceBrokerTemplate$9.doInPersistenceBroker(PersistenceBrokerTemplate.java:246) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.store(PersistenceBrokerTemplate.java:244) at org.kuali.rice.core.dao.impl.GenericDaoOjb.save(GenericDaoOjb.java:155) 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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy68.save(Unknown Source) at org.kuali.rice.ken.service.impl.NotificationServiceImpl.sendNotification(NotificationServiceImpl.java:159) 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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy100.sendNotification(Unknown Source) at org.kuali.kits.kms.notification.KmsNotificationService.sendKmsNotification(KmsNotificationService.java:54) at org.kuali.kits.kms.worklist.WorkListAction.sendChangeNotification(WorkListAction.java:823) at org.kuali.kits.kms.worklist.WorkListAction.save(WorkListAction.java:797) at sun.reflect.GeneratedMethodAccessor1474.invoke(Unknown Source) 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:270) at org.kuali.rice.kns.web.struts.action.KualiAction.dispatchMethod(KualiAction.java:172) at org.kuali.rice.kns.web.struts.action.KualiAction.execute(KualiAction.java:123) at org.kuali.rice.kns.web.struts.action.KualiDocumentActionBase.execute(KualiDocumentActionBase.java:118) at org.kuali.kits.kms.worklist.WorkListAction.execute(WorkListAction.java:133) at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor$1.doInTransaction(KualiRequestProcessor.java:503) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processActionPerform(KualiRequestProcessor.java:499) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.process(KualiRequestProcessor.java:101) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.kuali.rice.kew.web.UserLoginFilter.doFilter(UserLoginFilter.java:92) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.kuali.rice.kew.web.BootstrapFilterChain.doFilter(BootstrapFilter.java:273) at edu.iu.uis.cas.filter.CASFilter.redirectOrForwardChain(CASFilter.java:410) at edu.iu.uis.cas.filter.CASFilter.doFilterUnsynchronized(CASFilter.java:336) at edu.iu.uis.cas.filter.CASFilter.doFilter(CASFilter.java:315) at org.kuali.rice.kew.web.BootstrapFilterChain.doFilter(BootstrapFilter.java:266) at org.kuali.rice.kew.web.BootstrapFilter.doFilter(BootstrapFilter.java:164) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.kuali.rice.kns.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:69) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.ha.session.JvmRouteBinderValve.invoke(JvmRouteBinderValve.java:219) at org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:333) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) ** 2012-11-05 16:14:52,156 [ajp-bio-192.168.220.241-8039-exec-5:] FATAL org.kuali.rice.core.database.KualiTransactionInterceptor.completeTransactionAfterThrowing() :: Exception caught by Transaction Interceptor, this will cause a rollback at the end of the transaction. org.springframework.dao.DataIntegrityViolationException: OJB operation; SQL []; ORA-02291: integrity constraint (KMS.KREN_NTFCTN_FK3) violated - parent key not found ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (KMS.KREN_NTFCTN_FK3) violated - parent key not found at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springmodules.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107) at org.springmodules.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:144) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.store(PersistenceBrokerTemplate.java:244) at org.kuali.rice.core.dao.impl.GenericDaoOjb.save(GenericDaoOjb.java:155) 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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy68.save(Unknown Source) at org.kuali.rice.ken.service.impl.NotificationServiceImpl.sendNotification(NotificationServiceImpl.java:159) 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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

    Kuali JIRA | 4 years ago | Mike Riley
    java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (KMS.KREN_NTFCTN_FK3) violated - parent key not found
  2. 0

    I noticed this error when browsing the SND log4j output: (makes me wonder if KREN configuration was not completed on SND) 2012-11-05 16:14:52,155 [ajp-bio-192.168.220.241-8039-exec-5:] ERROR org.apache.ojb.broker.accesslayer.JdbcAccessImpl.generateException() :: * SQLException during execution of sql-statement: * sql statement was 'INSERT INTO KREN_NTFCTN_T (NTFCTN_ID,DELIV_TYP,CRTE_DTTM,SND_DTTM,AUTO_RMV_DTTM,TTL,CNTNT,PROCESSING_FLAG,LOCKD_DTTM,VER_NBR,PRODCR_ID,CNTNT_TYP_ID,CHNL_ID,PRIO_ID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?) ' * Exception message is [ORA-02291: integrity constraint (KMS.KREN_NTFCTN_FK3) violated - parent key not found ] * Vendor error code [2291] * SQL state code [23000=INTEGRITY CONSTRAINT VIOLATION] * Target class is 'org.kuali.rice.ken.bo.Notification' * PK of the target object is [id=1022] * Source object: org.kuali.rice.ken.bo.Notification@2d06fee3[id=1022,deliveryType=FYI,sendDateTime=2012-11-05 16:14:52.142,autoRemoveDateTime=<null>,content=<content><message>This is a notification of item changes made to the indicated worklist</message>...,processingFlag=UNRESOLVED,lockedDate=<null>,lockVerNbr=1,priority=org.kuali.rice.ken.bo.NotificationPriority@703e50e8,contentType=org.kuali.rice.ken.bo.NotificationContentType@b31e8ea[id=100,name=KMS WorkList Change Notification,namespace=notification/ContentTypeWorkListChange,version=0,current=true],channel=org.kuali.rice.ken.bo.NotificationChannel@79b26063,producer=org.kuali.rice.ken.bo.NotificationProducer@2dd64200[id=100,name=KITSKMS Events Manager,description=This producter will be used to trigger KITSKMS event notifications,contactInfo=kits.dev@kuali.org],recipients=0,senders=1] * The root stack trace is --> * java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (KMS.KREN_NTFCTN_FK3) violated - parent key not found at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) at org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.springmodules.orm.ojb.PersistenceBrokerTemplate$9.doInPersistenceBroker(PersistenceBrokerTemplate.java:246) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.store(PersistenceBrokerTemplate.java:244) at org.kuali.rice.core.dao.impl.GenericDaoOjb.save(GenericDaoOjb.java:155) 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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy68.save(Unknown Source) at org.kuali.rice.ken.service.impl.NotificationServiceImpl.sendNotification(NotificationServiceImpl.java:159) 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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy100.sendNotification(Unknown Source) at org.kuali.kits.kms.notification.KmsNotificationService.sendKmsNotification(KmsNotificationService.java:54) at org.kuali.kits.kms.worklist.WorkListAction.sendChangeNotification(WorkListAction.java:823) at org.kuali.kits.kms.worklist.WorkListAction.save(WorkListAction.java:797) at sun.reflect.GeneratedMethodAccessor1474.invoke(Unknown Source) 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:270) at org.kuali.rice.kns.web.struts.action.KualiAction.dispatchMethod(KualiAction.java:172) at org.kuali.rice.kns.web.struts.action.KualiAction.execute(KualiAction.java:123) at org.kuali.rice.kns.web.struts.action.KualiDocumentActionBase.execute(KualiDocumentActionBase.java:118) at org.kuali.kits.kms.worklist.WorkListAction.execute(WorkListAction.java:133) at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor$1.doInTransaction(KualiRequestProcessor.java:503) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processActionPerform(KualiRequestProcessor.java:499) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.process(KualiRequestProcessor.java:101) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.kuali.rice.kew.web.UserLoginFilter.doFilter(UserLoginFilter.java:92) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.kuali.rice.kew.web.BootstrapFilterChain.doFilter(BootstrapFilter.java:273) at edu.iu.uis.cas.filter.CASFilter.redirectOrForwardChain(CASFilter.java:410) at edu.iu.uis.cas.filter.CASFilter.doFilterUnsynchronized(CASFilter.java:336) at edu.iu.uis.cas.filter.CASFilter.doFilter(CASFilter.java:315) at org.kuali.rice.kew.web.BootstrapFilterChain.doFilter(BootstrapFilter.java:266) at org.kuali.rice.kew.web.BootstrapFilter.doFilter(BootstrapFilter.java:164) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.kuali.rice.kns.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:69) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.ha.session.JvmRouteBinderValve.invoke(JvmRouteBinderValve.java:219) at org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:333) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) ** 2012-11-05 16:14:52,156 [ajp-bio-192.168.220.241-8039-exec-5:] FATAL org.kuali.rice.core.database.KualiTransactionInterceptor.completeTransactionAfterThrowing() :: Exception caught by Transaction Interceptor, this will cause a rollback at the end of the transaction. org.springframework.dao.DataIntegrityViolationException: OJB operation; SQL []; ORA-02291: integrity constraint (KMS.KREN_NTFCTN_FK3) violated - parent key not found ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (KMS.KREN_NTFCTN_FK3) violated - parent key not found at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springmodules.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107) at org.springmodules.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:144) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.store(PersistenceBrokerTemplate.java:244) at org.kuali.rice.core.dao.impl.GenericDaoOjb.save(GenericDaoOjb.java:155) 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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy68.save(Unknown Source) at org.kuali.rice.ken.service.impl.NotificationServiceImpl.sendNotification(NotificationServiceImpl.java:159) 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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

    Kuali JIRA | 4 years ago | Mike Riley
    java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (KMS.KREN_NTFCTN_FK3) violated - parent key not found
  3. 0

    At IU we have a handful of users who have an entity record but no principal (they're an employee but they don't have an IT account). When the IdentityArchiveServiceImpl tries to save the user into the cache it throws an exception like the following: {noformat} [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: * SQLException during execution of sql-statement: * sql statement was 'INSERT INTO KRIM_ENTITY_CACHE_T (PRNCPL_ID,PRNCPL_NM,ENTITY_ID,ENTITY_TYP_CD,FIRST_NM,MIDDLE_NM,LAST_NM,PRSN_NM,CAMPUS_CD,PRMRY_DEPT_CD,EMP_ID,LAST_UPDT_TS,OBJ_ID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?) ' * Exception message is [ORA-01400: cannot insert NULL into ("KR"."KRIM_ENTITY_CACHE_T"."PRNCPL_ID") ] * Vendor error code [1400] * SQL state code [23000=INTEGRITY CONSTRAINT VIOLATION] * Target class is 'org.kuali.rice.kim.impl.identity.EntityDefaultInfoCacheBo' * PK of the target object is [principalId=null] * Source object: org.kuali.rice.kim.impl.identity.EntityDefaultInfoCacheBo@561338c6[versionNumber=<null>,principalId=<null>,principalName=<null>,entityId=0003072212,entityTypeCode=PERSON,firstName=Danny,middleName=L.,lastName=Senn,name=Senn, Danny L.,campusCode=EA,primaryDepartmentCode=EA-GRAF,employeeId=0003072212,lastUpdateTimestamp=2013-07-11 05:12:23.686,versionNumber=<null>,objectId=504370a9-00b5-442d-81b6-8f7d81263c79,newCollectionRecord=false] * The root stack trace is --> * java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("KR"."KRIM_ENTITY_CACHE_T"."PRNCPL_ID") at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352) at org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.springmodules.orm.ojb.PersistenceBrokerTemplate$9.doInPersistenceBroker(PersistenceBrokerTemplate.java:246) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.store(PersistenceBrokerTemplate.java:244) at org.kuali.rice.krad.dao.impl.BusinessObjectDaoOjb.save(BusinessObjectDaoOjb.java:258) at org.kuali.rice.krad.dao.proxy.BusinessObjectDaoProxy.save(BusinessObjectDaoProxy.java:254) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy37.save(Unknown Source) at org.kuali.rice.krad.service.impl.BusinessObjectServiceImpl.save(BusinessObjectServiceImpl.java:77) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy38.save(Unknown Source) at org.kuali.rice.kim.service.impl.IdentityArchiveServiceImpl$EntityArchiveWriter$3.doInTransaction(IdentityArchiveServiceImpl.java:380) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) at org.kuali.rice.kim.service.impl.IdentityArchiveServiceImpl$EntityArchiveWriter.call(IdentityArchiveServiceImpl.java:353) at org.kuali.rice.kim.service.impl.IdentityArchiveServiceImpl$PreLogCallableWrapper.call(IdentityArchiveServiceImpl.java:449) at org.kuali.rice.kim.service.impl.IdentityArchiveServiceImpl$CallableAdapter.run(IdentityArchiveServiceImpl.java:470) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) {noformat} This problem appears to be coming from the EntityArchiveWriter private class inside of the IdentityArchiveServiceImpl class. That class has a call method which inserts information into the entity cache table but it doesn't handle the case when an entity doesn't have a principal. I believe that we need to modify the code so it doesn't try to insert the information for the user into the cache if they don't have any principals associated with the entity.

    Kuali JIRA | 3 years ago | James Bennett
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("KR"."KRIM_ENTITY_CACHE_T"."PRNCPL_ID")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    At IU we have a handful of users who have an entity record but no principal (they're an employee but they don't have an IT account). When the IdentityArchiveServiceImpl tries to save the user into the cache it throws an exception like the following: {noformat} [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: * SQLException during execution of sql-statement: * sql statement was 'INSERT INTO KRIM_ENTITY_CACHE_T (PRNCPL_ID,PRNCPL_NM,ENTITY_ID,ENTITY_TYP_CD,FIRST_NM,MIDDLE_NM,LAST_NM,PRSN_NM,CAMPUS_CD,PRMRY_DEPT_CD,EMP_ID,LAST_UPDT_TS,OBJ_ID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?) ' * Exception message is [ORA-01400: cannot insert NULL into ("KR"."KRIM_ENTITY_CACHE_T"."PRNCPL_ID") ] * Vendor error code [1400] * SQL state code [23000=INTEGRITY CONSTRAINT VIOLATION] * Target class is 'org.kuali.rice.kim.impl.identity.EntityDefaultInfoCacheBo' * PK of the target object is [principalId=null] * Source object: org.kuali.rice.kim.impl.identity.EntityDefaultInfoCacheBo@561338c6[versionNumber=<null>,principalId=<null>,principalName=<null>,entityId=0003072212,entityTypeCode=PERSON,firstName=Danny,middleName=L.,lastName=Senn,name=Senn, Danny L.,campusCode=EA,primaryDepartmentCode=EA-GRAF,employeeId=0003072212,lastUpdateTimestamp=2013-07-11 05:12:23.686,versionNumber=<null>,objectId=504370a9-00b5-442d-81b6-8f7d81263c79,newCollectionRecord=false] * The root stack trace is --> * java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("KR"."KRIM_ENTITY_CACHE_T"."PRNCPL_ID") at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352) at org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.springmodules.orm.ojb.PersistenceBrokerTemplate$9.doInPersistenceBroker(PersistenceBrokerTemplate.java:246) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.store(PersistenceBrokerTemplate.java:244) at org.kuali.rice.krad.dao.impl.BusinessObjectDaoOjb.save(BusinessObjectDaoOjb.java:258) at org.kuali.rice.krad.dao.proxy.BusinessObjectDaoProxy.save(BusinessObjectDaoProxy.java:254) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy37.save(Unknown Source) at org.kuali.rice.krad.service.impl.BusinessObjectServiceImpl.save(BusinessObjectServiceImpl.java:77) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy38.save(Unknown Source) at org.kuali.rice.kim.service.impl.IdentityArchiveServiceImpl$EntityArchiveWriter$3.doInTransaction(IdentityArchiveServiceImpl.java:380) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) at org.kuali.rice.kim.service.impl.IdentityArchiveServiceImpl$EntityArchiveWriter.call(IdentityArchiveServiceImpl.java:353) at org.kuali.rice.kim.service.impl.IdentityArchiveServiceImpl$PreLogCallableWrapper.call(IdentityArchiveServiceImpl.java:449) at org.kuali.rice.kim.service.impl.IdentityArchiveServiceImpl$CallableAdapter.run(IdentityArchiveServiceImpl.java:470) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) {noformat} This problem appears to be coming from the EntityArchiveWriter private class inside of the IdentityArchiveServiceImpl class. That class has a call method which inserts information into the entity cache table but it doesn't handle the case when an entity doesn't have a principal. I believe that we need to modify the code so it doesn't try to insert the information for the user into the cache if they don't have any principals associated with the entity.

    Kuali JIRA | 3 years ago | James Bennett
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("KR"."KRIM_ENTITY_CACHE_T"."PRNCPL_ID")
  6. 0

    When processing a collector xml with detail lines, the job fails with the following stack trace in the log. java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("KFS"."GL_ID_BILL_T"."FIN_OBJ_TYP_CD") at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) at org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source)

    Kuali JIRA | 3 years ago | Juancho Baino
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("KFS"."GL_ID_BILL_T"."FIN_OBJ_TYP_CD")
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-02291: integrity constraint (KMS.KREN_NTFCTN_FK3) violated - parent key not found

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeUpdate
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
    12 frames
  3. XAPool
    CorePreparedStatement.executeUpdate
    1. org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102)
    1 frame
  4. ObJectRelationalBridge
    DelegatingPersistenceBroker.store
    1. org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source)
    2. org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source)
    3. org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
    4. org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
    5. org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
    6. org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source)
    7. org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source)
    7 frames
  5. org.springmodules.orm
    PersistenceBrokerTemplate.store
    1. org.springmodules.orm.ojb.PersistenceBrokerTemplate$9.doInPersistenceBroker(PersistenceBrokerTemplate.java:246)
    2. org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141)
    3. org.springmodules.orm.ojb.PersistenceBrokerTemplate.store(PersistenceBrokerTemplate.java:244)
    3 frames
  6. org.kuali.rice
    GenericDaoOjb.save
    1. org.kuali.rice.core.dao.impl.GenericDaoOjb.save(GenericDaoOjb.java:155)
    1 frame
  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. 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
  9. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
    1 frame
  10. 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
  11. Unknown
    $Proxy68.save
    1. $Proxy68.save(Unknown Source)
    1 frame
  12. org.kuali.rice
    NotificationServiceImpl.sendNotification
    1. org.kuali.rice.ken.service.impl.NotificationServiceImpl.sendNotification(NotificationServiceImpl.java:159)
    1 frame
  13. 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
  14. 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
  15. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
    1 frame
  16. 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
  17. Unknown
    $Proxy100.sendNotification
    1. $Proxy100.sendNotification(Unknown Source)
    1 frame
  18. org.kuali.kits
    WorkListAction.save
    1. org.kuali.kits.kms.notification.KmsNotificationService.sendKmsNotification(KmsNotificationService.java:54)
    2. org.kuali.kits.kms.worklist.WorkListAction.sendChangeNotification(WorkListAction.java:823)
    3. org.kuali.kits.kms.worklist.WorkListAction.save(WorkListAction.java:797)
    3 frames
  19. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor1474.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  20. struts
    DispatchAction.dispatchMethod
    1. org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
    1 frame
  21. org.kuali.rice
    KualiDocumentActionBase.execute
    1. org.kuali.rice.kns.web.struts.action.KualiAction.dispatchMethod(KualiAction.java:172)
    2. org.kuali.rice.kns.web.struts.action.KualiAction.execute(KualiAction.java:123)
    3. org.kuali.rice.kns.web.struts.action.KualiDocumentActionBase.execute(KualiDocumentActionBase.java:118)
    3 frames
  22. org.kuali.kits
    WorkListAction.execute
    1. org.kuali.kits.kms.worklist.WorkListAction.execute(WorkListAction.java:133)
    1 frame
  23. org.kuali.rice
    KualiRequestProcessor$1.doInTransaction
    1. org.kuali.rice.kns.web.struts.action.KualiRequestProcessor$1.doInTransaction(KualiRequestProcessor.java:503)
    1 frame
  24. Spring Tx
    TransactionTemplate.execute
    1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
    1 frame
  25. org.kuali.rice
    KualiRequestProcessor.processActionPerform
    1. org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processActionPerform(KualiRequestProcessor.java:499)
    1 frame
  26. struts
    RequestProcessor.process
    1. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
    1 frame
  27. org.kuali.rice
    KualiRequestProcessor.process
    1. org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.process(KualiRequestProcessor.java:101)
    1 frame
  28. struts
    ActionServlet.doPost
    1. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
    2. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
    2 frames
  29. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    2 frames
  30. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    2 frames
  31. org.kuali.rice
    UserLoginFilter.doFilter
    1. org.kuali.rice.kew.web.UserLoginFilter.doFilter(UserLoginFilter.java:92)
    1 frame
  32. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    2 frames
  33. org.kuali.rice
    BootstrapFilterChain.doFilter
    1. org.kuali.rice.kew.web.BootstrapFilterChain.doFilter(BootstrapFilter.java:273)
    1 frame
  34. edu.iu.uis
    CASFilter.doFilter
    1. edu.iu.uis.cas.filter.CASFilter.redirectOrForwardChain(CASFilter.java:410)
    2. edu.iu.uis.cas.filter.CASFilter.doFilterUnsynchronized(CASFilter.java:336)
    3. edu.iu.uis.cas.filter.CASFilter.doFilter(CASFilter.java:315)
    3 frames
  35. org.kuali.rice
    BootstrapFilter.doFilter
    1. org.kuali.rice.kew.web.BootstrapFilterChain.doFilter(BootstrapFilter.java:266)
    2. org.kuali.rice.kew.web.BootstrapFilter.doFilter(BootstrapFilter.java:164)
    2 frames
  36. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    2 frames
  37. Display tag library
    ResponseOverrideFilter.doFilter
    1. org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
    1 frame
  38. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    2 frames
  39. org.kuali.rice
    HideWebInfFilter.doFilter
    1. org.kuali.rice.kns.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:69)
    1 frame
  40. Glassfish Core
    StandardEngineValve.invoke
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
    5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
    7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
    8. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
    9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    9 frames
  41. org.apache.catalina
    ReplicationValve.invoke
    1. org.apache.catalina.ha.session.JvmRouteBinderValve.invoke(JvmRouteBinderValve.java:219)
    2. org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:333)
    2 frames
  42. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    1 frame
  43. org.apache.coyote
    AjpProcessor.process
    1. org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200)
    1 frame
  44. Grizzly HTTP
    JIoEndpoint$SocketProcessor.run
    1. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
    2. org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)
    2 frames
  45. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    3. java.lang.Thread.run(Thread.java:662)
    3 frames