SAP Knowledge Base Article - Public

2561586 - Issue while Uploading References - Completion Status via Import Tool - [LMS]

Symptom

1) Error while uploading References -> Completion Status

2) The system could not add the record for one or more reasons: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (FK_CMPL_STAT__TAP_DEF) violated - parent key not found

Environment

SuccessFactors Learning Management System

Reproducing the Issue

Login as a LMS Admin->System Admin->Tools->Import Data-> 'Action:Import Data' and 'Record Type:References'->With values under Completion Status tab of the excel sheet

Cause

If the "approval process" field in the 'Completion Status' tab of the filled 'Reference' template has a value.

Resolution

Please remove value in "approval process" fields and import the file which will fix the issue, since approval process is a reference field it should be available in the LMS before you use the reference values and in here, it is better if you remove the value at all (not 'yes' or 'no' but an empty value).

Keywords

FK_CMPL_STAT__TAP_DEF, ORA-02291, Completion Status Upload, Completion Status error , KBA , LOD-SF-LMS-COR , LMS Core - Items, Catalog, Curricula , Problem

Product

SAP SuccessFactors Learning 1511 ; SAP SuccessFactors Learning 1602 ; SAP SuccessFactors Learning 1605 ; SAP SuccessFactors Learning 1608 ; SAP SuccessFactors Learning 1611 ; SAP SuccessFactors Learning 1702 ; SAP SuccessFactors Learning 1705 ; SAP SuccessFactors Learning 1708 ; SAP SuccessFactors Learning 1711 ; SAP SuccessFactors Learning 1802 ; SuccessFactors Learning 1502 ; SuccessFactors Learning 1505 ; SuccessFactors Learning 1508