2659029 - LMS - Assignment Profile APM fails

Assignment Profile APM fails with an error

SAP SuccessFactors Learning

1. Run the Assignment Profile Synchronization APM

2. APM fails with the following error: 

Assignment Profile fails with the following error:

Caused by: java.lang.InterruptedException
at com.plateau.common.core.api.InterruptibleInvocationHandler.handleThreadInterrupted(InterruptibleInvocationHandler.java:91)
at com.plateau.common.db.api.InterruptibleJdbcObjectProxyFactory$InterruptibleJdbcObjectProxy.handleThreadInterrupted(InterruptibleJdbcObjectProxyFactory.java:183)
at com.plateau.common.core.api.InterruptibleInvocationHandler.doBeforeInvoke(InterruptibleInvocationHandler.java:98)
at com.plateau.common.core.api.InterruptibleInvocationHandler.invoke(InterruptibleInvocationHandler.java:70)
at com.plateau.common.db.api.InterruptibleJdbcObjectProxyFactory$InterruptibleJdbcObjectProxy.invoke(InterruptibleJdbcObjectProxyFactory.java:155)
... 60 more

Job timeout on: 2018-06-10 06:26:05.908639 reason: Job batch was running for longer than 360 seconds

ORA-01013: user requested cancel of current operation

The amount of data in the job run is too large, hence it cannot finish in 360 seconds and produces a timeout.

As per Operations Team:

ORA-01013: user requested cancel of current operation:

It's a common error message that after a timeout, the job is cancelled. It seems that the amount of data that the job is processing is too huge and it's not enough for 360 seconds. 

Please try to run the job in batches to avoid a huge amount of data.

Learning, Management, System, Assignment Profile Synchronization, APM, fail, timeout, error, ORA-01013, ORA-01013: user requested cancel of current operation, Job batch, 360 seconds, Assignment Profile APM , KBA , LOD-SF-LMS-ASP , Assignment Profile , Problem