Today I`m here to present some options of solutions to handle an error for Item Connector - "Cannot specify a NULL Key value for reference entity REV_DTE in Item Connector"- used to upload massive courses into SAP SuccessFactors LMS.
Before to start, go understand the whole import process.
The import or upload process in LMS is used for inputting some kind of data (information) in the system and can be executed manually or massively (our focus).
Manual is a single process that you can execute using the ADMIN interface, and in another hand, the massive is a routine that uses archives called CONNECTORS. The connectors are basically a TXT or CSV files that you can use to import massive data.
Once the file (using some specific columns, attributes and rules) is created you drop it into a SFTP folder and schedule the LMS to consume it and the magic happens.
But in some cases the connector doesn`t load correctly the data caused by some malformation in the file, fields, attributes and so on. To check what is happen you need to check the error log.
For our particular case, the connector used to upload courses is called Item Connector and when is consumed show the specific error in the log (Admin side >> System Administration >> Connectors >> Item Connector >> View Results):
"...LMS: Cannot specify a NULL Key value for reference entity REV_DTE in Item Connector..."
To understand this error is important to know that the unique item identifier (Item Key) is formed by:
Item Type | Item ID | Creation or Revision Date/Time Stamp
Here an example: COURSE LOGISTIC001 (Rev 2 - Jan/25/2021 05:00 PM America/New York)