API tools faq
paste
Advertisement
mugs

coeus rolodex ID FK exception

mugs
Feb 27th, 2015
288
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 14.88 KB | None | 0 0
raw download clone embed print report
  1. * SQLException during execution of sql-statement:
  2. * sql statement was 'INSERT INTO SPONSOR (SPONSOR_CODE,OWNED_BY_UNIT,ACRONYM,POSTAL_CODE,AUDIT_REPORT_SENT_FOR_FY,ROLODEX_ID,CAGE_NUMBER,SPONSOR_NAME,COUNTRY_CODE,SPONSOR_TYPE_CODE,CREATE_USER,STATE,DODAC_NUMBER,UPDATE_TIMESTAMP,DUN_AND_BRADSTREET_NUMBER,UPDATE_USER,DUNS_PLUS_FOUR_NUMBER,OBJ_ID,VER_NBR,ACTV_IND,DUNNING_CAMPAIGN_ID,CUSTOMER_NUMBER) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) '
  3. * Exception message is [Cannot add or update a child row: a foreign key constraint fails (`kc_600_dev`.`sponsor`, CONSTRAINT `FK_SPONSOR_ROLODEX_KRA` FOREIGN KEY (`ROLODEX_ID`) REFERENCES `rolodex` (`ROLODEX_ID`))]
  4. * Vendor error code [1452]
  5. * SQL state code [23000=INTEGRITY CONSTRAINT VIOLATION]
  6. * Target class is 'org.kuali.coeus.common.framework.sponsor.Sponsor'
  7. * PK of the target object is [sponsorCode=100001]
  8. * Source object: org.kuali.coeus.common.framework.sponsor.Sponsor@34a2e558[sponsorCode=100001,acronym=<null>,auditReportSentForFy=<null>,cageNumber=<null>,countryCode=<null>,dodacNumber=<null>,dunAndBradstreetNumber=<null>,dunsPlusFourNumber=<null>,ownedByUnit=000001,postalCode=<null>,rolodexId=100000,sponsorName=County of Nairobi,sponsorTypeCode=2,state=<null>,createUser=admin,dunningCampaignId=<null>,customerNumber=<null>,customerExists=<null>,customerTypeCode=<null>,active=true,updateUser=admin,updateUserSet=true,serialVersionUID=1451642350593233282,versionNumber=0,objectId=362fd467-3f38-44f4-9877-9208fc09630b,newCollectionRecord=false,serialVersionUID=5563310175227245001,_persistence_shouldRefreshFetchGroup=false]
  9. * The root stack trace is -->
  10. * com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`kc_600_dev`.`sponsor`, CONSTRAINT `FK_SPONSOR_ROLODEX_KRA` FOREIGN KEY (`ROLODEX_ID`) REFERENCES `rolodex` (`ROLODEX_ID`))
  11.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  12.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  13.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  14.     at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
  15.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
  16.     at com.mysql.jdbc.Util.getInstance(Util.java:383)
  17.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1049)
  18.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
  19.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
  20.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
  21.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
  22.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2840)
  23.     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
  24.     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334)
  25.     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262)
  26.     at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246)
  27.     at org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102)
  28.     at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown Source)
  29.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source)
  30.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
  31.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
  32.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
  33.     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source)
  34.     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source)
  35.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate$9.doInPersistenceBroker(PersistenceBrokerTemplate.java:246)
  36.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141)
  37.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate.store(PersistenceBrokerTemplate.java:244)
  38.     at org.kuali.rice.krad.dao.impl.BusinessObjectDaoOjb.save(BusinessObjectDaoOjb.java:236)
  39.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  40.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  41.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  42.     at java.lang.reflect.Method.invoke(Method.java:606)
  43.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  44.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  45.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  46.     at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:51)
  47.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  48.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  49.     at com.sun.proxy.$Proxy90.save(Unknown Source)
  50.     at org.kuali.rice.krad.dao.proxy.BusinessObjectDaoProxy.save(BusinessObjectDaoProxy.java:213)
  51.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  52.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  53.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  54.     at java.lang.reflect.Method.invoke(Method.java:606)
  55.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  56.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  57.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  58.     at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:51)
  59.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  60.     at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
  61.     at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
  62.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
  63.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  64.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  65.     at com.sun.proxy.$Proxy91.save(Unknown Source)
  66.     at org.kuali.rice.krad.service.impl.BusinessObjectServiceImpl.linkAndSave(BusinessObjectServiceImpl.java:91)
  67.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  68.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  69.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  70.     at java.lang.reflect.Method.invoke(Method.java:606)
  71.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  72.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  73.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  74.     at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:51)
  75.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  76.     at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
  77.     at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
  78.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
  79.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  80.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  81.     at com.sun.proxy.$Proxy96.linkAndSave(Unknown Source)
  82.     at org.kuali.rice.kns.maintenance.KualiMaintainableImpl.saveBusinessObject(KualiMaintainableImpl.java:317)
  83.     at org.kuali.rice.kns.maintenance.KualiMaintainableImpl.saveDataObject(KualiMaintainableImpl.java:326)
  84.     at org.kuali.coeus.common.impl.sponsor.SponsorMaintainableImpl.saveDataObject(SponsorMaintainableImpl.java:114)
  85.     at org.kuali.rice.krad.maintenance.MaintenanceDocumentBase.doRouteStatusChange(MaintenanceDocumentBase.java:561)
  86.     at org.kuali.rice.krad.service.impl.PostProcessorServiceImpl$1.call(PostProcessorServiceImpl.java:78)
  87.     at org.kuali.rice.krad.service.impl.PostProcessorServiceImpl$1.call(PostProcessorServiceImpl.java:60)
  88.     at org.kuali.rice.krad.util.GlobalVariables.doInNewGlobalVariables(GlobalVariables.java:228)
  89.     at org.kuali.rice.krad.util.LegacyUtils.doInLegacyContext(LegacyUtils.java:150)
  90.     at org.kuali.rice.krad.service.impl.PostProcessorServiceImpl.doRouteStatusChange(PostProcessorServiceImpl.java:60)
  91.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  92.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  93.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  94.     at java.lang.reflect.Method.invoke(Method.java:606)
  95.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  96.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  97.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  98.     at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
  99.     at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
  100.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
  101.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  102.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  103.     at com.sun.proxy.$Proxy106.doRouteStatusChange(Unknown Source)
  104.     at org.kuali.coeus.sys.impl.workflow.KcPostProcessorServiceImpl$1.call(KcPostProcessorServiceImpl.java:69)
  105.     at org.kuali.coeus.sys.impl.workflow.KcPostProcessorServiceImpl$1.call(KcPostProcessorServiceImpl.java:65)
  106.     at org.kuali.rice.krad.util.GlobalVariables.doInNewGlobalVariables(GlobalVariables.java:228)
  107.     at org.kuali.coeus.sys.impl.gv.GlobalVariableServiceImpl.doInNewGlobalVariables(GlobalVariableServiceImpl.java:88)
  108.     at org.kuali.coeus.sys.impl.workflow.KcPostProcessorServiceImpl.doRouteStatusChange(KcPostProcessorServiceImpl.java:65)
  109.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  110.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  111.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  112.     at java.lang.reflect.Method.invoke(Method.java:606)
  113.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  114.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  115.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  116.     at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
  117.     at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
  118.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
  119.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  120.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  121.     at com.sun.proxy.$Proxy106.doRouteStatusChange(Unknown Source)
  122.     at org.kuali.coeus.sys.framework.workflow.KcPostProcessor.doRouteStatusChange(KcPostProcessor.java:36)
  123.     at org.kuali.rice.kew.engine.StandardWorkflowEngine.notifyPostProcessor(StandardWorkflowEngine.java:489)
  124.     at org.kuali.rice.kew.engine.StandardWorkflowEngine.nodePostProcess(StandardWorkflowEngine.java:401)
  125.     at org.kuali.rice.kew.engine.StandardWorkflowEngine.process(StandardWorkflowEngine.java:148)
  126.     at org.kuali.rice.kew.engine.BlanketApproveEngine.process(BlanketApproveEngine.java:141)
  127.     at org.kuali.rice.kew.actions.BlanketApproveAction.performDeferredBlanketApproveWork(BlanketApproveAction.java:199)
  128.     at org.kuali.rice.kew.impl.action.DocumentOrchestrationQueueImpl.orchestrateDocument(DocumentOrchestrationQueueImpl.java:66)
  129.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  130.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  131.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  132.     at java.lang.reflect.Method.invoke(Method.java:606)
  133.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  134.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  135.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  136.     at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
  137.     at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
  138.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
  139.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  140.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  141.     at com.sun.proxy.$Proxy182.orchestrateDocument(Unknown Source)
  142.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  143.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  144.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  145.     at java.lang.reflect.Method.invoke(Method.java:606)
  146.     at org.kuali.rice.ksb.messaging.MessageServiceInvoker.invokeService(MessageServiceInvoker.java:157)
  147.     at org.kuali.rice.ksb.messaging.MessageServiceInvoker$1.doInTransaction(MessageServiceInvoker.java:72)
  148.     at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)
  149.     at org.kuali.rice.ksb.messaging.MessageServiceInvoker.run(MessageServiceInvoker.java:67)
  150.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  151.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  152.     at java.lang.Thread.run(Thread.java:745)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!