API tools faq
paste
mugs

integrity constraint (KULDEV.CM_AST_PAYMENT_TR5) violated -

mugs
Jul 6th, 2017
82
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 11.95 KB | None | 0 0
raw download clone embed print report
  1. * SQLException during execution of sql-statement:
  2. * sql statement was 'UPDATE CM_AST_PAYMENT_T SET OBJ_ID=?,VER_NBR=?,FIN_COA_CD=?,ACCOUNT_NBR=?,SUB_ACCT_NBR=?,FIN_OBJECT_CD=?,FIN_SUB_OBJ_CD=?,FS_ORIGIN_CD=?,FDOC_TYP_CD=?,FDOC_NBR=?,FDOC_POST_YR=?,FDOC_POST_PRD_CD=?,FDOC_POST_DT=?,PROJECT_CD=?,ORG_REFERENCE_ID=?,ACCT_CHARGE_AMT=?,PO_NUMBER=?,REQUISITION_NBR=?,AST_DEPR1_BASE_AMT=?,AST_ACUM_DEPR1_AMT=?,AST_PRVYRDEPR1_AMT=?,AST_PRD1_DEPR1_AMT=?,AST_PRD2_DEPR1_AMT=?,AST_PRD3_DEPR1_AMT=?,AST_PRD4_DEPR1_AMT=?,AST_PRD5_DEPR1_AMT=?,AST_PRD6_DEPR1_AMT=?,AST_PRD7_DEPR1_AMT=?,AST_PRD8_DEPR1_AMT=?,AST_PRD9_DEPR1_AMT=?,AST_PRD10DEPR1_AMT=?,AST_PRD11DEPR1_AMT=?,AST_PRD12DEPR1_AMT=?,AST_TRNFR_PMT_CD=? WHERE CPTLAST_NBR = ?  AND AST_PMT_SEQ_NBR = ?  AND VER_NBR = ? '
  3. * Exception message is [ORA-02291: integrity constraint (KULDEV.CM_AST_PAYMENT_TR5) violated - parent key not found
  4. ]
  5. * Vendor error code [2291]
  6. * SQL state code [23000=INTEGRITY CONSTRAINT VIOLATION]
  7. * Target class is 'org.kuali.kfs.module.cam.businessobject.AssetPayment'
  8. * PK of the target object is [capitalAssetNumber=502436, paymentSequenceNumber=3]
  9. * Source object: org.kuali.kfs.module.cam.businessobject.AssetPayment@63676cdf[capitalAssetNumber=502436,paymentSequenceNumber=3,chartOfAccountsCode=I,accountNumber=1G00275,subAccountNumber=<null>,financialObjectCode=4210,financialSubObjectCode=F1,financialSystemOriginationCode=01,financialDocumentTypeCode=ARD,documentNumber=1918314,financialDocumentPostingYear=2015,financialDocumentPostingPeriodCode=07,financialDocumentPostingDate=2015-07-30,projectCode=<null>,organizationReferenceId=<null>,accountChargeAmount=19273.32,purchaseOrderNumber=<null>,requisitionNumber=<null>,primaryDepreciationBaseAmount=19273.32,accumulatedPrimaryDepreciationAmount=5506.66,previousYearPrimaryDepreciationAmount=2753.33,period1Depreciation1Amount=229.44,period2Depreciation1Amount=229.45,period3Depreciation1Amount=229.44,period4Depreciation1Amount=229.44,period5Depreciation1Amount=229.45,period6Depreciation1Amount=229.44,period7Depreciation1Amount=0.00,period8Depreciation1Amount=0.00,period9Depreciation1Amount=0.00,period10Depreciation1Amount=0.00,period11Depreciation1Amount=0.00,period12Depreciation1Amount=0.00,transferPaymentCode=N,yearToDate=<null>,versionNumber=5,objectId=04b2b7a1-3c02-43e3-b627-ce08c9cf94a8,newCollectionRecord=false]
  10. * The root stack trace is -->
  11. * java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (KULDEV.CM_AST_PAYMENT_TR5) violated - parent key not found
  12.  
  13.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  14.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  15.     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
  16.     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
  17.     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
  18.     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  19.     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
  20.     at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
  21.     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
  22.     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
  23.     at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
  24.     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
  25.     at org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102)
  26.     at sun.reflect.GeneratedMethodAccessor211.invoke(Unknown Source)
  27.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  28.     at java.lang.reflect.Method.invoke(Method.java:606)
  29.     at net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:393)
  30.     at net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:175)
  31.     at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:277)
  32.     at com.sun.proxy.$Proxy69.executeUpdate(Unknown Source)
  33.     at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeUpdate(Unknown Source)
  34.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source)
  35.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
  36.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
  37.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
  38.     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source)
  39.     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source)
  40.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate$9.doInPersistenceBroker(PersistenceBrokerTemplate.java:246)
  41.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141)
  42.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate.store(PersistenceBrokerTemplate.java:244)
  43.     at org.kuali.rice.krad.dao.impl.BusinessObjectDaoOjb.save(BusinessObjectDaoOjb.java:258)
  44.     at org.kuali.rice.krad.dao.proxy.BusinessObjectDaoProxy.save(BusinessObjectDaoProxy.java:254)
  45.     at sun.reflect.GeneratedMethodAccessor821.invoke(Unknown Source)
  46.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  47.     at java.lang.reflect.Method.invoke(Method.java:606)
  48.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  49.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  50.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  51.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  52.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  53.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  54.     at com.sun.proxy.$Proxy75.save(Unknown Source)
  55.     at org.kuali.rice.krad.service.impl.BusinessObjectServiceImpl.save(BusinessObjectServiceImpl.java:77)
  56.     at sun.reflect.GeneratedMethodAccessor820.invoke(Unknown Source)
  57.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  58.     at java.lang.reflect.Method.invoke(Method.java:606)
  59.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  60.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  61.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  62.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  63.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  64.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  65.     at com.sun.proxy.$Proxy76.save(Unknown Source)
  66.     at za.org.kuali.kfs.module.cam.document.service.impl.AssetReclassificationServiceImpl.saveApprovedChanges(AssetReclassificationServiceImpl.java:107)
  67.     at za.org.kuali.kfs.module.cam.document.AssetReclassificationDocument.doRouteStatusChange(AssetReclassificationDocument.java:303)
  68.     at org.kuali.rice.krad.service.impl.PostProcessorServiceImpl$1.call(PostProcessorServiceImpl.java:81)
  69.     at org.kuali.rice.krad.service.impl.PostProcessorServiceImpl$1.call(PostProcessorServiceImpl.java:61)
  70.     at org.kuali.rice.krad.util.GlobalVariables.doInNewGlobalVariables(GlobalVariables.java:191)
  71.     at org.kuali.rice.krad.service.impl.PostProcessorServiceImpl.doRouteStatusChange(PostProcessorServiceImpl.java:60)
  72.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  73.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  74.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  75.     at java.lang.reflect.Method.invoke(Method.java:606)
  76.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  77.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  78.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  79.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  80.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  81.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  82.     at com.sun.proxy.$Proxy88.doRouteStatusChange(Unknown Source)
  83.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  84.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  85.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  86.     at java.lang.reflect.Method.invoke(Method.java:606)
  87.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  88.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  89.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  90.     at org.kuali.rice.core.framework.persistence.jpa.NoResultExceptionInterceptor.invoke(NoResultExceptionInterceptor.java:33)
  91.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  92.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  93.     at com.sun.proxy.$Proxy89.doRouteStatusChange(Unknown Source)
  94.     at org.kuali.kfs.sys.document.workflow.PostProcessor.doRouteStatusChange(PostProcessor.java:53)
  95.     at org.kuali.rice.kew.engine.StandardWorkflowEngine.notifyPostProcessor(StandardWorkflowEngine.java:513)
  96.     at org.kuali.rice.kew.engine.StandardWorkflowEngine.nodePostProcess(StandardWorkflowEngine.java:423)
  97.     at org.kuali.rice.kew.engine.StandardWorkflowEngine.process(StandardWorkflowEngine.java:151)
  98.     at org.kuali.rice.kew.impl.document.DocumentProcessingQueueImpl.processWithOptions(DocumentProcessingQueueImpl.java:66)
  99.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  100.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  101.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  102.     at java.lang.reflect.Method.invoke(Method.java:606)
  103.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  104.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  105.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  106.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  107.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  108.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  109.     at com.sun.proxy.$Proxy175.processWithOptions(Unknown Source)
  110.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  111.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  112.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  113.     at java.lang.reflect.Method.invoke(Method.java:606)
  114.     at org.kuali.rice.ksb.messaging.MessageServiceInvoker.invokeService(MessageServiceInvoker.java:157)
  115.     at org.kuali.rice.ksb.messaging.MessageServiceInvoker$1.doInTransaction(MessageServiceInvoker.java:72)
  116.     at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
  117.     at org.kuali.rice.ksb.messaging.MessageServiceInvoker.run(MessageServiceInvoker.java:67)
  118.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  119.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  120.     at java.lang.Thread.run(Thread.java:744)
Add Comment
Please, Sign In to add comment
Public Pastes
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!