2542276 - APM Deny Expired Approval Process job failed consistently

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

SuccessFactors Learning Management System (LMS)

This is a known system behavior than can occur and need to be reported to SAP Cloud Support for further investigation.

Contact SAP SF Cloud Support providing the following information:

• The complete error log
• Since when did the job start failing
• The URL for the instance in which the job is failing
• Provide login credentials for the Support, either by Support Access or by Secure Login

1773689 - How to add logon credentials securely to an case - SAP for Me 

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