2542276 - APM Deny Expired Approval Process job failed consistently

SAP Knowledge Base Article - Public

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

Environment

SuccessFactors Learning Management System (LMS)

Cause

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

Resolution

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

See Also

1773689 - How to add logon credentials securely to an incident - SAP ONE Support Launchpad 

Keywords

APM, Automatic Process, Expired Approval, failing, failed, Deny Approval, Background Job , KBA , LOD-SF-LMS-BCJ , LMS Background Jobs , Problem

Product

SAP SuccessFactors Learning 1608