java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699])

Kuali JIRA | Arun Ramaiah | 2 years ago
  1. 0

    Steps to reproduce: # Login as Fred/Alice # Navigate to CM Home # Create a Course # Hit Continue or Select Cur Review and Continue Expected: Create a Proposal Course Information tab is dispayed Actual: Stack trace is encountered {code} org.springframework.orm.jpa.JpaSystemException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699]); nested exception is javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699]) at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:321) at org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:121) at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:403) at org.kuali.rice.krad.data.jpa.KradEntityManagerFactoryBean.translateExceptionIfPossible(KradEntityManagerFactoryBean.java:533) at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58) at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213) at org.kuali.rice.krad.data.jpa.JpaPersistenceProvider.doWithExceptionTranslation(JpaPersistenceProvider.java:324) at org.kuali.rice.krad.data.jpa.JpaPersistenceProvider.save(JpaPersistenceProvider.java:167) at sun.reflect.GeneratedMethodAccessor802.invoke(Unknown Source) 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:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy87.save(Unknown Source) at org.kuali.rice.krad.data.provider.impl.ProviderBasedDataObjectService.save(ProviderBasedDataObjectService.java:134) at org.kuali.rice.kew.routeheader.service.impl.RouteHeaderServiceImpl.saveRouteHeader(RouteHeaderServiceImpl.java:110) at sun.reflect.GeneratedMethodAccessor2345.invoke(Unknown Source) 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:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy215.saveRouteHeader(Unknown Source) at org.kuali.rice.kew.routeheader.service.impl.WorkflowDocumentServiceImpl.createDocument(WorkflowDocumentServiceImpl.java:274) at sun.reflect.GeneratedMethodAccessor2349.invoke(Unknown Source) 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:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy487.createDocument(Unknown Source) at org.kuali.rice.kew.impl.action.WorkflowDocumentActionsServiceImpl.create(WorkflowDocumentActionsServiceImpl.java:318) at sun.reflect.GeneratedMethodAccessor2348.invoke(Unknown Source) 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:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy206.create(Unknown Source) at org.kuali.rice.kew.impl.document.DefaultWorkflowDocumentProvider.createDocument(DefaultWorkflowDocumentProvider.java:35) at sun.reflect.GeneratedMethodAccessor2347.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.kuali.rice.kew.api.WorkflowDocumentFactory.createDocument(WorkflowDocumentFactory.java:130) at org.kuali.rice.kew.api.WorkflowDocumentFactory.createDocument(WorkflowDocumentFactory.java:82) at org.kuali.rice.krad.workflow.service.impl.WorkflowDocumentServiceImpl.createWorkflowDocument(WorkflowDocumentServiceImpl.java:100) at sun.reflect.GeneratedMethodAccessor2346.invoke(Unknown Source) 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:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy142.createWorkflowDocument(Unknown Source) at org.kuali.rice.krad.service.impl.DocumentServiceImpl.getNewDocument(DocumentServiceImpl.java:586) at org.kuali.rice.krad.service.impl.DocumentServiceImpl.getNewDocument(DocumentServiceImpl.java:643) at org.kuali.rice.krad.web.controller.DocumentControllerBase.createDocument(DocumentControllerBase.java:199) at org.kuali.student.cm.course.controller.CourseController.createDocument(CourseController.java:161) at org.kuali.rice.krad.web.controller.MaintenanceDocumentController.docHandler(MaintenanceDocumentController.java:110) at org.kuali.student.cm.course.controller.CourseController.docHandler(CourseController.java:205) at org.kuali.student.cm.course.controller.CourseController$$FastClassByCGLIB$$ebcb3f03.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:698) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:631) at org.kuali.student.cm.course.controller.CourseController$$EnhancerByCGLIB$$562330cf.docHandler(<generated>) 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.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.kuali.student.ap.framework.context.support.DefaultKsapContext$Filter.doFilter(DefaultKsapContext.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.kuali.rice.krad.web.filter.UserLoginFilter.doFilter(UserLoginFilter.java:89) at org.kuali.rice.krad.web.filter.UserLoginFilter.doFilter(UserLoginFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.kuali.rice.krad.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:68) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.kuali.student.security.filter.AuthenticationGwtRpcFilter.doFilterHttp(AuthenticationGwtRpcFilter.java:54) at org.kuali.student.security.filter.AuthenticationGwtRpcFilter.doFilter(AuthenticationGwtRpcFilter.java:38) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) 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:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:722) Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699]) at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:868) at sun.reflect.GeneratedMethodAccessor1040.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:366) at com.sun.proxy.$Proxy85.flush(Unknown Source) at sun.reflect.GeneratedMethodAccessor1040.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:241) at com.sun.proxy.$Proxy85.flush(Unknown Source) at org.kuali.rice.krad.data.jpa.JpaPersistenceProvider$1.call(JpaPersistenceProvider.java:184) at org.kuali.rice.krad.data.jpa.JpaPersistenceProvider.doWithExceptionTranslation(JpaPersistenceProvider.java:321) ... 161 more Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699]) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:900) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:962) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:631) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1991) at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:298) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:377) at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:165) at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:180) at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:489) at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80) at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90) at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:301) at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899) at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:798) at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108) at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1793) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1775) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1726) at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:226) at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:125) at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:4196) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1441) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithPreBuiltChangeSet(UnitOfWorkImpl.java:1587) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:452) at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:863) ... 173 more Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:452) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:400) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:884) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:471) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:199) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:535) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:238) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1385) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1709) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4364) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4531) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:5575) at org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:890) ... 203 more {code}

    Kuali JIRA | 2 years ago | Arun Ramaiah
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699])
  2. 0

    Steps to reproduce: # Login as Fred/Alice # Navigate to CM Home # Create a Course # Hit Continue or Select Cur Review and Continue Expected: Create a Proposal Course Information tab is dispayed Actual: Stack trace is encountered {code} org.springframework.orm.jpa.JpaSystemException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699]); nested exception is javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699]) at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:321) at org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:121) at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:403) at org.kuali.rice.krad.data.jpa.KradEntityManagerFactoryBean.translateExceptionIfPossible(KradEntityManagerFactoryBean.java:533) at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58) at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213) at org.kuali.rice.krad.data.jpa.JpaPersistenceProvider.doWithExceptionTranslation(JpaPersistenceProvider.java:324) at org.kuali.rice.krad.data.jpa.JpaPersistenceProvider.save(JpaPersistenceProvider.java:167) at sun.reflect.GeneratedMethodAccessor802.invoke(Unknown Source) 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:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy87.save(Unknown Source) at org.kuali.rice.krad.data.provider.impl.ProviderBasedDataObjectService.save(ProviderBasedDataObjectService.java:134) at org.kuali.rice.kew.routeheader.service.impl.RouteHeaderServiceImpl.saveRouteHeader(RouteHeaderServiceImpl.java:110) at sun.reflect.GeneratedMethodAccessor2345.invoke(Unknown Source) 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:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy215.saveRouteHeader(Unknown Source) at org.kuali.rice.kew.routeheader.service.impl.WorkflowDocumentServiceImpl.createDocument(WorkflowDocumentServiceImpl.java:274) at sun.reflect.GeneratedMethodAccessor2349.invoke(Unknown Source) 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:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy487.createDocument(Unknown Source) at org.kuali.rice.kew.impl.action.WorkflowDocumentActionsServiceImpl.create(WorkflowDocumentActionsServiceImpl.java:318) at sun.reflect.GeneratedMethodAccessor2348.invoke(Unknown Source) 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:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy206.create(Unknown Source) at org.kuali.rice.kew.impl.document.DefaultWorkflowDocumentProvider.createDocument(DefaultWorkflowDocumentProvider.java:35) at sun.reflect.GeneratedMethodAccessor2347.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.kuali.rice.kew.api.WorkflowDocumentFactory.createDocument(WorkflowDocumentFactory.java:130) at org.kuali.rice.kew.api.WorkflowDocumentFactory.createDocument(WorkflowDocumentFactory.java:82) at org.kuali.rice.krad.workflow.service.impl.WorkflowDocumentServiceImpl.createWorkflowDocument(WorkflowDocumentServiceImpl.java:100) at sun.reflect.GeneratedMethodAccessor2346.invoke(Unknown Source) 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:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy142.createWorkflowDocument(Unknown Source) at org.kuali.rice.krad.service.impl.DocumentServiceImpl.getNewDocument(DocumentServiceImpl.java:586) at org.kuali.rice.krad.service.impl.DocumentServiceImpl.getNewDocument(DocumentServiceImpl.java:643) at org.kuali.rice.krad.web.controller.DocumentControllerBase.createDocument(DocumentControllerBase.java:199) at org.kuali.student.cm.course.controller.CourseController.createDocument(CourseController.java:161) at org.kuali.rice.krad.web.controller.MaintenanceDocumentController.docHandler(MaintenanceDocumentController.java:110) at org.kuali.student.cm.course.controller.CourseController.docHandler(CourseController.java:205) at org.kuali.student.cm.course.controller.CourseController$$FastClassByCGLIB$$ebcb3f03.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:698) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:631) at org.kuali.student.cm.course.controller.CourseController$$EnhancerByCGLIB$$562330cf.docHandler(<generated>) 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.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.kuali.student.ap.framework.context.support.DefaultKsapContext$Filter.doFilter(DefaultKsapContext.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.kuali.rice.krad.web.filter.UserLoginFilter.doFilter(UserLoginFilter.java:89) at org.kuali.rice.krad.web.filter.UserLoginFilter.doFilter(UserLoginFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.kuali.rice.krad.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:68) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.kuali.student.security.filter.AuthenticationGwtRpcFilter.doFilterHttp(AuthenticationGwtRpcFilter.java:54) at org.kuali.student.security.filter.AuthenticationGwtRpcFilter.doFilter(AuthenticationGwtRpcFilter.java:38) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) 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:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:722) Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699]) at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:868) at sun.reflect.GeneratedMethodAccessor1040.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:366) at com.sun.proxy.$Proxy85.flush(Unknown Source) at sun.reflect.GeneratedMethodAccessor1040.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:241) at com.sun.proxy.$Proxy85.flush(Unknown Source) at org.kuali.rice.krad.data.jpa.JpaPersistenceProvider$1.call(JpaPersistenceProvider.java:184) at org.kuali.rice.krad.data.jpa.JpaPersistenceProvider.doWithExceptionTranslation(JpaPersistenceProvider.java:321) ... 161 more Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699]) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:900) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:962) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:631) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1991) at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:298) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:377) at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:165) at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:180) at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:489) at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80) at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90) at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:301) at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899) at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:798) at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108) at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1793) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1775) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1726) at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:226) at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:125) at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:4196) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1441) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithPreBuiltChangeSet(UnitOfWorkImpl.java:1587) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:452) at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:863) ... 173 more Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:452) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:400) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:884) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:471) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:199) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:535) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:238) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1385) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1709) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4364) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4531) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:5575) at org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:890) ... 203 more {code}

    Kuali JIRA | 2 years ago | Arun Ramaiah
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699])
  3. 0

    Oracle BPM: Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ABC_SOAINFRA.BPM_AUDIT_QUERY_PK) violated

    Oracle Community | 1 year ago | 1572922
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (IPS_SOAINFRA.BPM_AUDIT_QUERY_PK) violated Error Code: 1 Call: INSERT INTO BPM_AUDIT_QUERY (QUERY_ID, ECID, ACTIVITY_ID, ACTIVITY_NAME, ACTIVITY_TYPE, AUDIT_INSTANCE_TYPE, AUDIT_LEVEL, AUDIT_LOG, AUDIT_NUMBER1, AUDIT_STRING1, AUDIT_COMMENT, COMPONENT_INSTANCE_ID, COMPONENT_NAME, COMPONENT_TYPE, COMPOSITE_DN, COMPOSITE_INSTANCE_ID, COMPOSITE_NAME, CREATE_TIME, DUE_DATE, FAULT_ISRECOVERABLE, FAULT_TYPE, FLOW_ELEMENT_TYPE, INSTANCE_COUNT, INVOKED_COMPONENT_NAME, LABEL, LOOP_COUNT, OPERATION, PARENT_THREAD_ID, PARTICIPANT, CI_PARTITION_DATE, PRIORITY, PROCESS_DUE_DATE, PROCESS_NAME, REFERENCE_ID, ROLE_ID, SCOPE_ID, SOURCE_ACTIVITY, STEP, TARGET_ACTIVITY, THREAD_ID, TITLE, V_VALUEDATE1, V_VALUEDATE10, V_VALUEDATE2, V_VALUEDATE3, V_VALUEDATE4, V_VALUEDATE5, V_VALUEDATE6, V_VALUEDATE7, V_VALUEDATE8, V_VALUEDATE9, V_VALUENUMBER1, V_VALUENUMBER10, V_VALUENUMBER11, V_VALUENUMBER12, V_VALUENUMBER13, V_VALUENUMBER14, V_VALUENUMBER15, V_VALUENUMBER16, V_VALUENUMBER17, V_VALUENUMBER18, V_VALUENUMBER19, V_VALUENUMBER2, V_VALUENUMBER20, V_VALUENUMBER21, V_VALUENUMBER22, V_VALUENUMBER23, V_VALUENUMBER24, V_VALUENUMBER25, V_VALUENUMBER26, V_VALUENUMBER27, V_VALUENUMBER28, V_VALUENUMBER29, V_VALUENUMBER3, V_VALUENUMBER30, V_VALUENUMBER4, V_VALUENUMBER5, V_VALUENUMBER6, V_VALUENUMBER7, V_VALUENUMBER8, V_VALUENUMBER9, V_VALUESTRING1, V_VALUESTRING10, V_VALUESTRING11, V_VALUESTRING12, V_VALUESTRING13, V_VALUESTRING14, V_VALUESTRING15, V_VALUESTRING16, V_VALUESTRING17, V_VALUESTRING18, V_VALUESTRING19, V_VALUESTRING2, V_VALUESTRING20, V_VALUESTRING3, V_VALUESTRING4, V_VALUESTRING5, V_VALUESTRING6, V_VALUESTRING7, V_VALUESTRING8, V_VALUESTRING9) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [101 parameters bound] Query: InsertObjectQuery(oracle.bpm.bpmn.engine.service.audit.persistence.model.AuditQuery@3c4e1e09)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Oracle SOA / Java blog: april 2012

    blogspot.com | 4 months ago
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SOA_SOAINFRA.AT_PK) violated Error Code: 1 Call: INSERT INTO AUDIT_TRAIL (CIKEY, COUNT_ID, NUM_OF_EVENTS, BLOCK_USIZE, CI_PARTITION_DATE, BLOCK_CSIZE, BLOCK, LOG) VALUES (?, ?, ?, ?, ?, ?, ?, ?) bind => [851450, 5, 0, 118110, 2012-01-12 16:08:04.063, 5048, 3, [B@69157b01] Query: InsertObjectQuery(com.collaxa.cube.persistence.dto.AuditTrail@494ca627)
  6. 0

    Steps to reproduce: # Login as Fred/Alice # Navigate to CM Home # Create a Course # Hit Continue or Select Cur Review and Continue Expected: Create a Proposal Course Information tab is dispayed Actual: Stack trace is encountered {code} org.springframework.orm.jpa.JpaSystemException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699]); nested exception is javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699]) at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:321) at org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:121) at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:403) at org.kuali.rice.krad.data.jpa.KradEntityManagerFactoryBean.translateExceptionIfPossible(KradEntityManagerFactoryBean.java:533) at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58) at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213) at org.kuali.rice.krad.data.jpa.JpaPersistenceProvider.doWithExceptionTranslation(JpaPersistenceProvider.java:324) at org.kuali.rice.krad.data.jpa.JpaPersistenceProvider.save(JpaPersistenceProvider.java:167) at sun.reflect.GeneratedMethodAccessor802.invoke(Unknown Source) 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:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy87.save(Unknown Source) at org.kuali.rice.krad.data.provider.impl.ProviderBasedDataObjectService.save(ProviderBasedDataObjectService.java:134) at org.kuali.rice.kew.routeheader.service.impl.RouteHeaderServiceImpl.saveRouteHeader(RouteHeaderServiceImpl.java:110) at sun.reflect.GeneratedMethodAccessor2345.invoke(Unknown Source) 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:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy215.saveRouteHeader(Unknown Source) at org.kuali.rice.kew.routeheader.service.impl.WorkflowDocumentServiceImpl.createDocument(WorkflowDocumentServiceImpl.java:274) at sun.reflect.GeneratedMethodAccessor2349.invoke(Unknown Source) 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:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy487.createDocument(Unknown Source) at org.kuali.rice.kew.impl.action.WorkflowDocumentActionsServiceImpl.create(WorkflowDocumentActionsServiceImpl.java:318) at sun.reflect.GeneratedMethodAccessor2348.invoke(Unknown Source) 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:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy206.create(Unknown Source) at org.kuali.rice.kew.impl.document.DefaultWorkflowDocumentProvider.createDocument(DefaultWorkflowDocumentProvider.java:35) at sun.reflect.GeneratedMethodAccessor2347.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.kuali.rice.kew.api.WorkflowDocumentFactory.createDocument(WorkflowDocumentFactory.java:130) at org.kuali.rice.kew.api.WorkflowDocumentFactory.createDocument(WorkflowDocumentFactory.java:82) at org.kuali.rice.krad.workflow.service.impl.WorkflowDocumentServiceImpl.createWorkflowDocument(WorkflowDocumentServiceImpl.java:100) at sun.reflect.GeneratedMethodAccessor2346.invoke(Unknown Source) 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:317) 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$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy142.createWorkflowDocument(Unknown Source) at org.kuali.rice.krad.service.impl.DocumentServiceImpl.getNewDocument(DocumentServiceImpl.java:586) at org.kuali.rice.krad.service.impl.DocumentServiceImpl.getNewDocument(DocumentServiceImpl.java:643) at org.kuali.rice.krad.web.controller.DocumentControllerBase.createDocument(DocumentControllerBase.java:199) at org.kuali.student.cm.course.controller.CourseController.createDocument(CourseController.java:161) at org.kuali.rice.krad.web.controller.MaintenanceDocumentController.docHandler(MaintenanceDocumentController.java:110) at org.kuali.student.cm.course.controller.CourseController.docHandler(CourseController.java:205) at org.kuali.student.cm.course.controller.CourseController$$FastClassByCGLIB$$ebcb3f03.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:698) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:631) at org.kuali.student.cm.course.controller.CourseController$$EnhancerByCGLIB$$562330cf.docHandler(<generated>) 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.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.kuali.student.ap.framework.context.support.DefaultKsapContext$Filter.doFilter(DefaultKsapContext.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.kuali.rice.krad.web.filter.UserLoginFilter.doFilter(UserLoginFilter.java:89) at org.kuali.rice.krad.web.filter.UserLoginFilter.doFilter(UserLoginFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.kuali.rice.krad.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:68) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.kuali.student.security.filter.AuthenticationGwtRpcFilter.doFilterHttp(AuthenticationGwtRpcFilter.java:54) at org.kuali.student.security.filter.AuthenticationGwtRpcFilter.doFilter(AuthenticationGwtRpcFilter.java:38) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) 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:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:722) Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699]) at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:868) at sun.reflect.GeneratedMethodAccessor1040.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:366) at com.sun.proxy.$Proxy85.flush(Unknown Source) at sun.reflect.GeneratedMethodAccessor1040.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:241) at com.sun.proxy.$Proxy85.flush(Unknown Source) at org.kuali.rice.krad.data.jpa.JpaPersistenceProvider$1.call(JpaPersistenceProvider.java:184) at org.kuali.rice.krad.data.jpa.JpaPersistenceProvider.doWithExceptionTranslation(JpaPersistenceProvider.java:321) ... 161 more Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699]) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:900) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:962) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:631) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1991) at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:298) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:377) at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:165) at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:180) at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:489) at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80) at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90) at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:301) at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899) at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:798) at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108) at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1793) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1775) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1726) at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:226) at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:125) at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:4196) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1441) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithPreBuiltChangeSet(UnitOfWorkImpl.java:1587) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:452) at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:863) ... 173 more Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:452) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:400) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:884) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:471) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:199) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:535) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:238) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1385) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1709) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4364) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4531) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:5575) at org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:890) ... 203 more {code}

    Kuali JIRA | 2 years ago | Arun Ramaiah
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699])

    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-00001: unique constraint (KSENV2.KREW_DOC_HDR_TP1) violated Error Code: 1 Call: INSERT INTO KREW_DOC_HDR_T (DOC_HDR_ID, APP_DOC_ID, APP_DOC_STAT, APP_DOC_STAT_MDFN_DT, APRV_DT, CRTE_DT, STAT_MDFN_DT, RTE_LVL, DOC_HDR_STAT_CD, TTL, DOC_VER_NBR, DOC_TYP_ID, FNL_DT, INITR_PRNCPL_ID, OBJ_ID, RTE_STAT_MDFN_DT, RTE_PRNCPL_ID, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [18 parameters bound] Query: InsertObjectQuery(org.kuali.rice.kew.routeheader.DocumentRouteHeaderValue@31c43386[documentId=3043,documentTypeId=KS-1028,docRouteStatus=I,docRouteLevel=0,docTitle=<null>,appDocId=<null>,docVersion=1,initiatorWorkflowId=alice,routedByUserWorkflowId=<null>,appDocStatus=<null>,initialRouteNodeInstances={[]},appDocStatusHistory={[]},notes={[]},routingReport=false,simulatedActionRequests=<null>,versionNumber=1,objectId=cf717c09-4590-4369-b080-eb99bc8eb699])

      at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush()
    2. EclipseLink (non-OSGi)
      EntityManagerImpl.flush
      1. org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:868)
      1 frame
    3. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor1040.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:601)
      3 frames
    4. Spring ORM
      ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke
      1. org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:366)
      1 frame
    5. com.sun.proxy
      $Proxy85.flush
      1. com.sun.proxy.$Proxy85.flush(Unknown Source)
      1 frame
    6. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor1040.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:601)
      3 frames
    7. Spring ORM
      SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke
      1. org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:241)
      1 frame
    8. com.sun.proxy
      $Proxy85.flush
      1. com.sun.proxy.$Proxy85.flush(Unknown Source)
      1 frame
    9. org.kuali.rice
      JpaPersistenceProvider.doWithExceptionTranslation
      1. org.kuali.rice.krad.data.jpa.JpaPersistenceProvider$1.call(JpaPersistenceProvider.java:184)
      2. org.kuali.rice.krad.data.jpa.JpaPersistenceProvider.doWithExceptionTranslation(JpaPersistenceProvider.java:321)
      2 frames