Receiving error when running Scheduled Offering Connector or Registration Connector. Legacy ID is a mandatory field in the connector
SuccessFactors Learning Management System (LMS)
Reproducing the Issue
- Prepare the Scheduled Offering Connector feed file;
- Place it in the SFTP;
- Schedule the schedule offering connector;
- Receiving the error in the connector log, as "Error Creating Scheduled Offering; ORA-02291: integrity constraint violated - parent key not found".
The reason for the error is, custom column number 99 (Legacy ID) was not created which was causing the connector to fail.
Create Custom Column 99(Label as "Legacy ID" & un-referenced), under LMS Admin->System Admin->Custom Column->Scheduled Offering and then run the connector which will resolve the issue.
Please note that the Custom Column 99 is used as an unique identifier for the scheduled offering and it is mandatory. It means that if you use the same value for this custom column twice, LMS will understand that you are trying to update an existing scheduled offering.
If you are updating a Scheduled Offering, you should check its custom column 99 to match, otherwise it will create a new scheduled offering.
Note: If possible, use an alpha numeric ID for the legacy scheduled offering ID. There is a possible connector processing problem if the legacy ID matches an existing schedule offering ID.
Error Creating Scheduled Offering, SQLIntegrityConstraintViolationException, ORA-02291, integrity constraint, violated - parent key not found, Custom Column 99, COL_NUM_99 , KBA , LOD-SF-LMS-CON , Connectors , Problem