SAP Knowledge Base Article - Public

2216839 - Parent key not found error when running Deny Expired Approval Processes APM

Symptom

When running Deny Expired Approval Processes APM the following error is generated:

com.plateausystems.elms.util.helper.ElmsUncheckedException: Error occurred in Deny Expired Business Process APM Job
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!
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (BCBSNC_STAGE_TMS.FK_TAP_ACTION__TAP_ACTION_STAT) violated - parent key not found

Environment

SAP SuccessFactors Learning - All Supported Versions

Cause

The error is genearted as the is an issue with the database

Resolution

Please create a new incident with the support team so that the Operations can make a correction that will allow this APM to function normally.

Keywords

Deny Expired Business Process APM Job, ElmsCreateException, ORA-02291, integrity constraint, BCBSNC_STAGE_TMS.FK_TAP_ACTION__TAP_ACTION_STAT , KBA , LOD-SF-LMS , Learning Management System , Problem

Product

SAP SuccessFactors Learning all versions