SAP Knowledge Base Article - Public

2642533 - LMS: Cannot specify a NULL Key value for reference entity REV_DTE in Item Connector

Symptom

Item Connector error message: "Cannot specify a NULL Key value for reference entity REV_DTE"

Environment

SAP SuccessFactors Learning Management System (LMS)

Reproducing the Issue

  1. Run item connector with a file having REV_DTE field blank.
  2. Error will be encountered.

Cause

Following is the setting in CONNECTOR configuration file.

item.connector.defaultRevDate.currentTimestamp=N

  • Setting this to 'N' makes REV_DTE field mandatory.
  • Setting this to 'Y' uses the current timestamp as REV_DTE.

Resolution

You have two options:

  1. Set 'item.connector.defaultRevDate.currentTimestamp' to 'Y'; or
  2. Populate the REV_DTE field.

See Also

2286589 - Avoiding Date/Time Issues with Connectors

2529731 - Cannot specify NULL exception for a referenced field which doesn't have any data - SuccessFactors LMS

2769270 - Item Connector: Not nullable "CPNT_ID" column

Keywords

REV_DTE, NULL, key, Cannot specify a NULL Key, revision date, item connector, connector , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , Learning Management System , Problem

Product

SAP SuccessFactors Learning all versions