SAP Knowledge Base Article - Public

2508134 - Learning Management System(LMS) Item rejected because of blank revision date

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

  1. Goto Learning Administration
  2. Check for an item and update any field
  3. Make sure that REV_DTE field is blank for these records in the item connector feed file.
  4. 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

Product

SAP SuccessFactors Learning all versions