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.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors Learning
Reproducing the Issue
- Goto Learning Administration
- Check for an item and update any field
- Make sure that REV_DTE field is blank for these records in the item connector feed file.
- Run the item connector and observe the above error
Cause
The Connector throws the same error, when there is no value passed for REV_DTE and The Connector configuration "item.connector.defaultRevDate.currentTimestamp" is set to "N" Or blank" for default timestamp.
Resolution
Even though in the item Connector Workbook, the Revision date field is optional, you need to provide a value in the feed file when the item Connector configuration "item.connector.defaultRevDate.currentTimestamp" is set to "N" Or blank"
However, 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.
- Goto Learning Admin
- System Admin >Configuration>System Configuration>Connectors.
- Set "item.connector.defaultRevDate.currentTimestamp=Y" and Apply changes.
Keywords
Learning Admin, REV_DTE, Revision Date, Item Connector, defaultRevDate, currentTimestamp, Connectors, System Configuration, feed file, Connector Work Book, Cannot specify the NULL key, reference entity, , KBA , LOD-SF-LMS-CON , Connectors , Problem
SAP Knowledge Base Article - Public