SAP Knowledge Base Article - Public

2381010 - Connector rejecting records with error : ORA-02291: integrity constraint FK_USR_PRF_DTE__ALOC_DTE_PTRN violated - parent key not found

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.12.PNG

Keywords

ALOC_DTE_PTRN,rejecting user recors,connector,locale,preferences , KBA , LOD-SF-LMS , SuccessFactors Learning , 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