SAP Knowledge Base Article - Preview

2542276 - APM Deny Expired Approval Process job failed consistently

Symptom

Upon checking the Automatic Process of Deny Expired Process the User can see that it is failing consistently. The error is similar to:

com.plateausystems.elms.util.helper.ElmsUncheckedException: Error occurred in Deny Expired Business Process APM Job
at com.plateausystems.elms.framework.jobscheduling.impl.ElmsRecurringJobServiceImpl.denyExpiredBusinessProcess(ElmsRecurringJobServiceImpl.java:1533)
at sun.reflect.GeneratedMethodAccessor3535.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at com.plateausystems.elms.framework.perfmonitor.impl.ServicePerformanceMonitorInterceptor.invoke(ServicePerformanceMonitorInterceptor.java:41)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.plateausystems.elms.framework.usagestatistics.impl.UsageStatisticsInterceptor.invoke(UsageStatisticsInterceptor.java:66)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.plateausystems.elms.framework.authorization.impl.ServiceAuthorizationInterceptor.invoke(ServiceAuthorizationInterceptor.java:127)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.plateausystems.elms.util.helper.LastUpdateUserInterceptor.invoke(LastUpdateUserInterceptor.java:49)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.plateausystems.elms.framework.localization.DataLocalizationInterceptor.invoke(DataLocalizationInterceptor.java:72)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
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 com.sun.proxy.$Proxy1245.denyExpiredBusinessProcess(Unknown Source)
at com.plateausystems.elms.framework.jobscheduling.impl.DenyExpiredBusinessProcessApmJob.execute(DenyExpiredBusinessProcessApmJob.java:16)
at com.plateau.common.jobscheduling.impl.simple.SimpleJobRunnable.run(SimpleJobRunnable.java:95)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:812)
Caused by: com.plateausystems.elms.util.process.ElmsProcessException: com.plateausystems.elms.util.helper.ElmsCreateException: SQLException - Could not create com.plateausystems.elms.bo.businessprocess.impl.BusinessProcessServiceImpl record!
at com.plateausystems.elms.bo.businessprocess.impl.BusinessProcessServiceImpl.advanceBusinessProcess(BusinessProcessServiceImpl.java:773)
at com.plateausystems.elms.bo.businessprocess.impl.BusinessProcessServiceImpl.advanceBusinessProcess(BusinessProcessServiceImpl.java:688)
at com.plateausystems.elms.bo.businessprocess.impl.BusinessProcessServiceImpl.denyExpiredBusinessProcess(BusinessProcessServiceImpl.java:1067)
at sun.reflect.GeneratedMethodAccessor3536.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at com.plateausystems.elms.framework.perfmonitor.impl.ServicePerformanceMonitorInterceptor.invoke(ServicePerformanceMonitorInterceptor.java:41)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.plateausystems.elms.framework.usagestatistics.impl.UsageStatisticsInterceptor.invoke(UsageStatisticsInterceptor.java:66)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.plateausystems.elms.framework.authorization.impl.ServiceAuthorizationInterceptor.invoke(ServiceAuthorizationInterceptor.java:127)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.plateausystems.elms.util.helper.LastUpdateUserInterceptor.invoke(LastUpdateUserInterceptor.java:49)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.plateausystems.elms.framework.localization.DataLocalizationInterceptor.invoke(DataLocalizationInterceptor.java:72)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
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 com.sun.proxy.$Proxy796.denyExpiredBusinessProcess(Unknown Source)
at com.plateausystems.elms.framework.jobscheduling.impl.ElmsRecurringJobServiceImpl.denyExpiredBusinessProcess(ElmsRecurringJobServiceImpl.java:1530)
... 25 more
Caused by: com.plateausystems.elms.util.helper.ElmsCreateException: SQLException - Could not create com.plateausystems.elms.bo.businessprocess.impl.BusinessProcessServiceImpl record!
at com.plateausystems.elms.bo.businessprocess.impl.BusinessProcessServiceImpl.addBusinessProcessAction(BusinessProcessServiceImpl.java:1360)
at com.plateausystems.elms.bo.businessprocess.impl.BusinessProcessServiceImpl.advanceBusinessProcess(BusinessProcessServiceImpl.java:755)
... 48 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (XXXXX.FK_TAP_ACTION__TAP_ACTION_STAT) violated - parent key not found

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
at oracle.jdbc.driver.T4CPreparedStatement.executeUpdate(T4CPreparedStatement.java)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:230)
at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:124)
at com.sun.proxy.$Proxy125.executeUpdate(Unknown Source)
at com.plateau.common.db.api.AbstractPreparedStatementWrapper.executeUpdate(AbstractPreparedStatementWrapper.java:81)
at com.plateau.common.db.oracle.impl.AbstractOraclePreparedStatementWrapper.executeUpdate(AbstractOraclePreparedStatementWrapper.java)
at com.plateau.common.db.oracle.impl.PlateauOraclePreparedStatement.executeUpdate(PlateauOraclePreparedStatement.java)
at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.plateau.foundation.jdbc.StatementPerfMonitorInvocationHandler.invoke(StatementPerfMonitorInvocationHandler.java:146)
at com.sun.proxy.$Proxy126.executeUpdate(Unknown Source)
at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.plateau.common.core.api.InterruptibleInvocationHandler.invoke(InterruptibleInvocationHandler.java:71)
at com.plateau.common.db.api.InterruptibleJdbcObjectProxyFactory$InterruptibleJdbcObjectProxy.invoke(InterruptibleJdbcObjectProxyFactory.java:155)
at com.sun.proxy.$Proxy127.executeUpdate(Unknown Source)
at com.plateausystems.elms.util.helper.DBUtil.executeUpdateSQL(DBUtil.java:1027)
at com.plateausystems.elms.util.helper.DBUtil.executeUpdateSQL(DBUtil.java:955)
at com.plateausystems.elms.bo.businessprocess.helper.BusinessProcessDAOImpl.addBusinessProcessAction(BusinessProcessDAOImpl.java:2165)
at com.plateausystems.elms.bo.businessprocess.impl.BusinessProcessServiceImpl.addBusinessProcessAction(BusinessProcessServiceImpl.java:1354)
... 49 more


Read more...

Environment

SuccessFactors Learning Management System (LMS)

Product

SAP SuccessFactors Learning 1608

Keywords

APM, Automatic Process, Expired Approval, failing, failed, Deny Approval, Background Job , KBA , LOD-SF-LMS-BCJ , Assign (bulk), Add/ Delete Sub/ Cur, Revise, Import , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.