SAP Knowledge Base Article - Public

2185921 - Data getting nullified through connectors


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.


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


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


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


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


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


SAP SuccessFactors Learning all versions