SAP Knowledge Base Article - Public

3213809 - Deny Expired Approval Processes Automatic Process - Fails with foreign key constraint error

Symptom

The Deny Expired Approval Processes Automatic Process (APM) fails with any of the following errors:

  • Caused by: 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.process.ElmsProcessException: com.plateausystems.elms.util.helper.ElmsCreateException: SQLException - Could not create com.plateausystems.elms.bo.businessprocess.impl.BusinessProcessServiceImpl record!
  • 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: com.plateausystems.elms.util.helper.ElmsCreateException: SQLException - Could not create com.plateausystems.elms.bo.businessprocess.impl.BusinessProcessServiceImpl record!
  • Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [461]: foreign key constraint violation: TrexUpdate failed on table '[Your Company Schema]_PROD_TMS:PA_TAP_ACTION' with error: Only found 0 of 1 rows from [Your Company Schema]_PROD_TMS:PA_TAP_ACTION(USER_ID) in [Your Company Schema]_PROD_TMS:PA_USER_PRFL(USER_NAME)

Environment

SAP SuccessFactors Learning

Cause

The admin that originally scheduled the automatic process is deleted from the system or has been inactivated.

Resolution

  1. Go to System Administration > Automatic Processes > Deny Expired Approval Processes
  2. Select the "Schedule This Process" to disable and Apply Changes
  3. Select again the "Schedule This Process" to enable it and Apply Changes
  4. Let the automatic process run

Keywords

error, apm, automatic, process, fails, failure, PA_TAP_ACTION, deny, approval, process, processes, PA_USER_PROFL, PA_USER_PRFL(USER_NAME), foreign, key, constraint, could, not, create , KBA , LOD-SF-LMS-APM , Automatic Processes , Problem

Product

SAP SuccessFactors Learning all versions