SAP Knowledge Base Article - Public

2185921 - Data getting nullified through connectors

Symptom

Data is getting nullified through connectors even if the relevant column is not present in the feed file.

Eg: When the connector runs all the email addresses are getting erased for the users. However, when checking the feed file the column name EMAIL is not present.

Environment

SuccessFactors LMS

Learning Management System

Reproducing the Issue

Create a feed file with the mandatory fields as mentioned in the workbook but do not use the field EMAIL

Now upload the file on sftp in the required location

Login to LMS as an Admin and navigate

--> System Admin--> Connectors and run the User Connector

Once the connector runs all the values in the field Email gets nullified

Cause

We CAN nullify the values by using the following property:
sfuser.connector.updateOnNull=Column value that you want to nullify.

eg:
user.connector.updateOnNull=EMAIL

In this case if we do not use the column EMAIL then system considers it to be coming to connectors as empty and it executes the configuration.

This results in the column being nullified even though it is not present in the feed file

Resolution

Once the nullification is done ,remove the property to avoid any unwanted nullifications for the mentioned column in the property

Keywords

KBA , LOD-SF-LMS , SuccessFactors Learning , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning all versions