Symptom
When trying to run the user connector, the connector fails with error :
ORA-02291: integrity
constraint (CUSTOMER_STAGE/PROD_TMS.FK_USR_PRF_DTE__ALOC_DTE_PTRN) violated -
parent key not found
Environment
SuccessFactors Learning
Learning Management System
Reproducing the Issue
Run the user connector in LMS, the rcords will be rejected with ORA-02291 error
Cause
No date format added for the locale for that user
Resolution
- Login as admin
- Navigate to System Admin>Connectors>User Connector/USer Connector - SF
- Click on View results to identify the records rejected by the connector.
- Click on 'Show archived input files' and download the feed file.From the feed file, check the locale for the user which is being rejected by the connector.
- Check the locale (References>Geography>Locales) in that instance, there will be no date format added to the locale as seen in below screenshot.This is the reason for this failure.Please add a date format for the locale and save the changes.This should solve the issue.
Keywords
ALOC_DTE_PTRN,rejecting user recors,connector,locale,preferences , KBA , LOD-SF-LMS , Learning Management System , 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 ; SuccessFactors Learning 1207 ; SuccessFactors Learning 1210 ; SuccessFactors Learning 1302 ; SuccessFactors Learning 1305 ; SuccessFactors Learning 1308 ; SuccessFactors Learning 1311 ; SuccessFactors Learning 1402 ; SuccessFactors Learning 1405 ; SuccessFactors Learning 1408 ; SuccessFactors Learning 1411 ; SuccessFactors Learning 1502 ; SuccessFactors Learning 1505 ; SuccessFactors Learning 1508