When trying to run the user connector, the connector fails with error :
constraint (CUSTOMER_STAGE/PROD_TMS.FK_USR_PRF_DTE__ALOC_DTE_PTRN) violated -
parent key not found
Learning Management System
Reproducing the Issue
Run the user connector in LMS, the rcords will be rejected with ORA-02291 error
No date format added for the locale for that user
- 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.
ALOC_DTE_PTRN,rejecting user recors,connector,locale,preferences , KBA , LOD-SF-LMS , Learning Management System , Problem