Kuali Rice Development
  1. Kuali Rice Development
  2. KULRICE-6892

Constraint violation on OBJ_ID upon submission of copied document

    Details

    • Type: Bug Fix Bug Fix
    • Status: Closed Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0.1
    • Component/s: Development
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • Similar issues:
      KULRICE-14042Agenda Rule - Copy Rule causes PK violation
      KULRICE-4317Rule Lookup - When a rule search is done, Name field in returned values is incorrect -- looks like it might be OBJ_ID
      KULRICE-4501Entities with multiple Principals causes unique constraint violations on the KRIM_ENTITY_CACHE_T table
      KULRICE-2371Drop SH_NTE_TC1 constraint on Notes table
      KULRICE-3242Unique constraint violated on insert into KREW_USR_OPTN_T
      KULRICE-2067Copying without changing the name (or other Unique Constraint fields) seems to allow for submission but actually throws a unique constraint
      KULRICE-4098KRNS_SESN_DOC_T table does not have OBJ_ID and VER_NBR columns to work with PersistableBusinessObjectBase
      KULRICE-2605Add missing OBJ_ID column to KEW tables
      KULRICE-8588RoleRouteModuleTests failing in Oracle with ORA-00001: unique constraint (RICEUNT.KRIM_ROLE_TC1) violated
      KULRICE-1207integrity constraint violation when trying to inactivate a workgroup
    • Rice Module:
      KNS
    • Application Requirement:
      KFS
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required

      Description

      When copying a document, the OBJ_ID's seem to be copied over from one document to another resulting in a constraint violation. I'm attaching the stack trace and also linking a similar Rice issue I found while looking through Jira. I hope this helps.

      Stack Trace:
      org.springframework.dao.DataIntegrityViolationException: OJB operation; SQL []; Duplicate entry 'b2c11d9c-2e30-4ea1-968d-32bffc304e9d' for key 'FP_FND_TRNFR_DOC_TC0'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'b2c11d9c-2e30-4ea1-968d-32bffc304e9d' for key 'FP_FND_TRNFR_DOC_TC0'
      at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
      at org.springmodules.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107)
      at org.springmodules.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89)
      at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:144)
      at org.springmodules.orm.ojb.PersistenceBrokerTemplate.store(PersistenceBrokerTemplate.java:244)
      at org.kuali.rice.krad.dao.impl.DocumentDaoOjb.save(DocumentDaoOjb.java:60)
      at org.kuali.rice.krad.dao.proxy.DocumentDaoProxy.save(DocumentDaoProxy.java:98)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      at $Proxy65.save(Unknown Source)
      at org.kuali.rice.krad.service.impl.DocumentServiceImpl.validateAndPersistDocument(DocumentServiceImpl.java:770)
      at org.kuali.rice.krad.service.impl.DocumentServiceImpl.routeDocument(DocumentServiceImpl.java:189)
      at org.kuali.rice.kns.web.struts.action.KualiDocumentActionBase.route(KualiDocumentActionBase.java:785)
      at org.kuali.kfs.sys.web.struts.KualiAccountingDocumentActionBase.route(KualiAccountingDocumentActionBase.java:759)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)

        Issue Links

          Activity

          There are no comments yet on this issue.

            People

            • Assignee:
              Jeremy Hanson
              Reporter:
              Dan Lemus (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Structure Helper Panel