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

SQLIntegrityConstraintViolationException when editing person with delegations

    Details

    • Type: Bug Fix Bug Fix
    • Status: Open Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 2.5.5
    • Fix Version/s: None
    • Component/s: Development, JPA
    • Security Level: Public (Public: Anyone can view)
    • Similar issues:
      KULRICE-8254Editing Delegations does not work correctly
      KULRICE-14243Person Doc - not able to edit person with existing delegate
      KULRICE-6935If you access person maintenance or role maintenace and add a delegation with a future Active From Date then you cannot see that delegation exists to verify or edit after submit.
      KULRICE-8222Error when inquiring on or attempting to edit user with delegations
      KULRICE-11045Delegations throws exception when selecting role in Person Maintenance
      KULRICE-4385Multiple delegates seem to be mixed up when viewing a person
      KULRICE-12005Empty FDOC_NBR when submitting a Person document with a delegation
      KULRICE-12150Edit Person: When adding affiliation for a person, the Employment Information section is not saved
      KULRICE-4378Rule Delegation - Create new delegation - Error displaying more than one responsibility person and/or groups
      KULRICE-6559People Flow Edit: exception thrown when adding / deleting delegates to people flow members
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required
    • Code Review Status:
      Not Required
    • Contributing Institution:
      Indiana Univ
    • Include in Release Notes?:
      Yes

      Description

      When Editing a Person with delegations using the Person Maintenance Document, the document will fail upon submission with the following error:

      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-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, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
      	bind => [12 parameters bound]
      Query: InsertObjectQuery(org.kuali.rice.kim.bo.ui.RoleDocumentDelegationMember@5c015123[delegationMemberId=10934,roleMemberId=<null>,roleMemberMemberId=<null>,roleMemberMemberTypeCode=<null>,roleMemberName=<null>,roleMemberNamespaceCode=<null>,attributesHelper=org.kuali.rice.kim.impl.type.KimTypeAttributesHelper@136b98f2,delegationId=<null>,memberId=<null>,memberTypeCode=P,memberNamespaceCode=,memberName=beckyw,qualifiers={[org.kuali.rice.kim.bo.ui.RoleDocumentDelegationMemberQualifier@6f3f1b4a[delegationMemberId=10341,attrDataId=348876,kimTypId=11134,kimAttrDefnId=10085,attrVal=BL-HPSC,qualifierKey=<null>,unique=<null>,edit=false,active=true,documentNumber=61742779,versionNumber=<null>,objectId=4808b6b0-e9ae-4969-8947-f27d800c055f,newCollectionRecord=false,_persistence_fetchGroup=<null>]]},delegationTypeCode=<null>,activeFromDate=2015-10-13 00:00:00.0,activeToDate=2016-02-23 13:34:00.0,active=false,edit=true,documentNumber=61742779,versionNumber=1,objectId=b272999e-c771-46b6-9d05-5725385c6383,newCollectionRecord=false,_persistence_fetchGroup=<null>]); 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-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, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
      	bind => [12 parameters bound]
      Query: InsertObjectQuery(org.kuali.rice.kim.bo.ui.RoleDocumentDelegationMember@5c015123[delegationMemberId=10934,roleMemberId=<null>,roleMemberMemberId=<null>,roleMemberMemberTypeCode=<null>,roleMemberName=<null>,roleMemberNamespaceCode=<null>,attributesHelper=org.kuali.rice.kim.impl.type.KimTypeAttributesHelper@136b98f2,delegationId=<null>,memberId=<null>,memberTypeCode=P,memberNamespaceCode=,memberName=beckyw,qualifiers={[org.kuali.rice.kim.bo.ui.RoleDocumentDelegationMemberQualifier@6f3f1b4a[delegationMemberId=10341,attrDataId=348876,kimTypId=11134,kimAttrDefnId=10085,attrVal=BL-HPSC,qualifierKey=<null>,unique=<null>,edit=false,active=true,documentNumber=61742779,versionNumber=<null>,objectId=4808b6b0-e9ae-4969-8947-f27d800c055f,newCollectionRecord=false,_persistence_fetchGroup=<null>]]},delegationTypeCode=<null>,activeFromDate=2015-10-13 00:00:00.0,activeToDate=2016-02-23 13:34:00.0,active=false,edit=true,documentNumber=61742779,versionNumber=1,objectId=b272999e-c771-46b6-9d05-5725385c6383,newCollectionRecord=false,_persistence_fetchGroup=<null>])
      	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.GeneratedMethodAccessor460.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	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.$Proxy39.save(Unknown Source)
      	at org.kuali.rice.krad.data.provider.impl.ProviderBasedDataObjectService.save(ProviderBasedDataObjectService.java:134)
      	at org.kuali.rice.krad.service.impl.KRADLegacyDataAdapterImpl.saveDocument(KRADLegacyDataAdapterImpl.java:116)
      	at org.kuali.rice.krad.service.impl.LegacyDataAdapterImpl.saveDocument(LegacyDataAdapterImpl.java:56)
      	at org.kuali.rice.krad.service.impl.DocumentServiceImpl.validateAndPersistDocument(DocumentServiceImpl.java:855)
      	at org.kuali.rice.krad.service.impl.DocumentServiceImpl.routeDocument(DocumentServiceImpl.java:189)
      	at org.kuali.rice.kns.web.struts.action.KualiDocumentActionBase.route(KualiDocumentActionBase.java:820)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
      	at org.kuali.rice.kns.web.struts.action.KualiAction.dispatchMethod(KualiAction.java:173)
      	at org.kuali.rice.kns.web.struts.action.KualiAction.execute(KualiAction.java:131)
      	at org.kuali.rice.kns.web.struts.action.KualiDocumentActionBase.execute(KualiDocumentActionBase.java:181)
      	at org.kuali.rice.kim.web.struts.action.IdentityManagementPersonDocumentAction.execute(IdentityManagementPersonDocumentAction.java:112)
      	at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor$1.doInTransaction(KualiRequestProcessor.java:513)
      	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)
      	at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processActionPerform(KualiRequestProcessor.java:509)
      	at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processFormActionAndForward(KualiRequestProcessor.java:238)
      	at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.strutsProcess(KualiRequestProcessor.java:219)
      	at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.process(KualiRequestProcessor.java:98)
      	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
      	at org.kuali.rice.kns.web.struts.action.KualiActionServlet.process(KualiActionServlet.java:202)
      	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      	at edu.iu.uis.eden.web.IUUserAccessFilter.doFilter(IUUserAccessFilter.java:88)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      	at edu.iu.es.esi.util.AppsIuFilter.doFilter(AppsIuFilter.java:57)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      	at org.kuali.rice.kew.web.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:78)
      	at org.kuali.rice.kew.web.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:62)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      	at org.kuali.rice.krad.web.filter.UserLoginFilter.doFilter(UserLoginFilter.java:97)
      	at org.kuali.rice.krad.web.filter.UserLoginFilter.doFilter(UserLoginFilter.java:85)
      	at edu.iu.uis.rice.web.IUUserLoginFilter.doFilter(IUUserLoginFilter.java:123)
      	at edu.iu.uis.rice.web.IUUserLoginFilter.doFilter(IUUserLoginFilter.java:63)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      	at org.kuali.rice.krad.web.filter.BootstrapFilterChain.doFilter(BootstrapFilter.java:327)
      	at edu.iu.uis.cas.filter.CASFilter.redirectOrForwardChain(CASFilter.java:436)
      	at edu.iu.uis.cas.filter.CASFilter.doFilterUnsynchronized(CASFilter.java:362)
      	at edu.iu.uis.cas.filter.CASFilter.doFilter(CASFilter.java:341)
      	at org.kuali.rice.krad.web.filter.BootstrapFilterChain.doFilter(BootstrapFilter.java:320)
      	at org.kuali.rice.krad.web.filter.BootstrapFilter.doFilter(BootstrapFilter.java:199)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      	at org.kuali.rice.kns.web.filter.ParameterFilter.doFilter(ParameterFilter.java:53)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      	at edu.iu.uis.rice.web.ErrorHandlingFilter.doFilter(ErrorHandlingFilter.java:23)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      	at org.kuali.rice.core.web.Log4JContextClearingFilter.doFilterInternal(Log4JContextClearingFilter.java:37)
      	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      	at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      	at org.kuali.rice.krad.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:68)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      	at org.springframework.web.filter.AbstractRequestLoggingFilter.doFilterInternal(AbstractRequestLoggingFilter.java:213)
      	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      	at edu.iu.uis.rice.web.IUTransactionFilter.doFilter(IUTransactionFilter.java:58)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      	at edu.iu.uis.rice.web.WhitespaceFilter.doFilter(WhitespaceFilter.java:34)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      	at edu.iu.uis.rice.web.PortalPolicyFilter.doFilter(PortalPolicyFilter.java:30)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
      	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
      	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
      	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
      	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
      	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
      	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
      	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
      	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
      	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      	at java.lang.Thread.run(Thread.java:748)
      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-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, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
      	bind => [12 parameters bound]
      Query: InsertObjectQuery(org.kuali.rice.kim.bo.ui.RoleDocumentDelegationMember@5c015123[delegationMemberId=10934,roleMemberId=<null>,roleMemberMemberId=<null>,roleMemberMemberTypeCode=<null>,roleMemberName=<null>,roleMemberNamespaceCode=<null>,attributesHelper=org.kuali.rice.kim.impl.type.KimTypeAttributesHelper@136b98f2,delegationId=<null>,memberId=<null>,memberTypeCode=P,memberNamespaceCode=,memberName=beckyw,qualifiers={[org.kuali.rice.kim.bo.ui.RoleDocumentDelegationMemberQualifier@6f3f1b4a[delegationMemberId=10341,attrDataId=348876,kimTypId=11134,kimAttrDefnId=10085,attrVal=BL-HPSC,qualifierKey=<null>,unique=<null>,edit=false,active=true,documentNumber=61742779,versionNumber=<null>,objectId=4808b6b0-e9ae-4969-8947-f27d800c055f,newCollectionRecord=false,_persistence_fetchGroup=<null>]]},delegationTypeCode=<null>,activeFromDate=2015-10-13 00:00:00.0,activeToDate=2016-02-23 13:34:00.0,active=false,edit=true,documentNumber=61742779,versionNumber=1,objectId=b272999e-c771-46b6-9d05-5725385c6383,newCollectionRecord=false,_persistence_fetchGroup=<null>])
      	at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:868)
      	at sun.reflect.GeneratedMethodAccessor463.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:366)
      	at com.sun.proxy.$Proxy37.flush(Unknown Source)
      	at sun.reflect.GeneratedMethodAccessor463.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:241)
      	at com.sun.proxy.$Proxy37.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)
      	... 111 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-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, VER_NBR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
      	bind => [12 parameters bound]
      Query: InsertObjectQuery(org.kuali.rice.kim.bo.ui.RoleDocumentDelegationMember@5c015123[delegationMemberId=10934,roleMemberId=<null>,roleMemberMemberId=<null>,roleMemberMemberTypeCode=<null>,roleMemberName=<null>,roleMemberNamespaceCode=<null>,attributesHelper=org.kuali.rice.kim.impl.type.KimTypeAttributesHelper@136b98f2,delegationId=<null>,memberId=<null>,memberTypeCode=P,memberNamespaceCode=,memberName=beckyw,qualifiers={[org.kuali.rice.kim.bo.ui.RoleDocumentDelegationMemberQualifier@6f3f1b4a[delegationMemberId=10341,attrDataId=348876,kimTypId=11134,kimAttrDefnId=10085,attrVal=BL-HPSC,qualifierKey=<null>,unique=<null>,edit=false,active=true,documentNumber=61742779,versionNumber=<null>,objectId=4808b6b0-e9ae-4969-8947-f27d800c055f,newCollectionRecord=false,_persistence_fetchGroup=<null>]]},delegationTypeCode=<null>,activeFromDate=2015-10-13 00:00:00.0,activeToDate=2016-02-23 13:34:00.0,active=false,edit=true,documentNumber=61742779,versionNumber=1,objectId=b272999e-c771-46b6-9d05-5725385c6383,newCollectionRecord=false,_persistence_fetchGroup=<null>])
      	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.commitAllObjectsForClassWithChangeSet(CommitManager.java:193)
      	at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:138)
      	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)
      	... 123 more
      Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("KR"."KRIM_PND_DLGN_MBR_T"."DLGN_ID")
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530)
      	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
      	at org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102)
      	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:890)
      	... 154 more
      

        Activity

        Hide
        Francis Fernandez added a comment -
        Show
        Francis Fernandez added a comment - Pull request #272

          People

          • Assignee:
            Francis Fernandez
            Reporter:
            Francis Fernandez
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:

              Structure Helper Panel