2659029 - LMS - Assignment Profile APM fails

Symptom

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

Environment

SAP Successfactors Learning Management System

Reproducing the Issue

1. Run the Assignment Profile Synchronization APM

2. APM fails with the error on the Symptom section of this KBA

Cause

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

Resolution

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.

Keywords

LMS, Learning, Management, System, Assignment Profile Synchronization, APM, fail, timeout, error, ORA-01013, ORA-01013: user requested cancel of current operation, Job batch was running for longer than 360 seconds, Assignment Profile APM , KBA , LOD-SF-LMS-BCJ , Assign (bulk), Add/ Delete Sub/ Cur, Revise, Import , Problem

Product

SAP SuccessFactors Learning 1611 ; SAP SuccessFactors Learning 1702 ; SAP SuccessFactors Learning 1705 ; SAP SuccessFactors Learning 1708 ; SAP SuccessFactors Learning 1711 ; SAP SuccessFactors Learning 1802 ; SAP SuccessFactors Learning 1805 ; SAP SuccessFactors Learning 1808