Symptom
Item Connector throwing below error when trying to run without having REV_DTE
Error : Cannot specify the NULL key value for reference entity REV_DTE.
Environment
LMS - Learning Management System
SuccessFactors LMS
Reproducing the Issue
Try updating courses in LMS system through Item connector.
Make sure that REV_DTE field is blank for these records in the item connector feed file.
Cause
As per item connector work book , Revision date field is optional which is why the customer did not provide the value in the feed file.
Resolution
For the item connector following value is maintained in LMS Admin>>System Admin>>Configuration>>System Configuration>>Connectors.
"item.connector.defaultRevDate.currentTimestamp=N"
The connector throws the same error, when there is no value passed for REV_DTE and the above configuration is blank or if its set to "N" for default timestamp.
You have to make sure that you either pass the value in the feed file for REV_DTE (or) enable the configuration by setting it to "Y" if you are not passing the value in the feed file.
Keywords
REV_DTE Revision Date Item Connector defaultRevDate currentTimestamp , KBA , LOD-SF-LMS-CON , Connectors , Problem