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])

Solutions on the web476

  • via Kuali JIRA by Arun Ramaiah, 1 year ago
    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
  • via Kuali JIRA by Arun Ramaiah, 1 year ago
    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
  • via Kuali JIRA by Francis Fernandez, 1 month ago
    ORA-01400: cannot insert NULL into ("KR"."KRIM_PND_DLGN_MBR_T"."DLGN_ID") Error Code: 1400 Call: INSERT INTO KRIM_PND_DLGN_MBR_T (FDOC_NBR, DLGN_MBR_ID, ACTV_IND, ACTV_FRM_DT, ACTV_TO_DT, DLGN_ID, MBR_ID, MBR_NM, MBR_TYP_CD, OBJ_ID, ROLE_MBR_ID
  • Stack trace

    • 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You are the first who have seen this exception. Write a tip to help other users and build your expert profile.