2543989 - User Connector SF failing with : Error Entity Invalid. No transformation data configured. NOTACTIVE: active

Symptom

When trying to run the User Connector SF, the connector is failing with below error :

Entity Invalid. No transformation data configured. NOTACTIVE: active

In the connector configurations(System Admin>Configurations>CONNECTORS), the below transformation rule have been added:

sfuser.field.transform.data.NOTACTIVE.N=active,active_external,ACTIVE,ACTIVE_EXTERNAL

Environment

SAP Successfactors Learning

Learning Management System (LMS)

Reproducing the Issue

1.Login as admin

2.Upload the feed file to SFTP

3.Schedule the connector to run

4.Connector fails with error ' Error Entity Invalid. No transformation data configured. NOTACTIVE: active'

Cause

The Connector Configurations (System Admin>Configurations>CONNECTORS), has the below transformation rule :

sfuser.field.transform.data.NOTACTIVE.N=active,active_external,ACTIVE,ACTIVE_EXTERNAL

The feed file has data like :

STATUS	USERID	USERNAME	FIRSTNAME	LASTNAME	MI	GENDER
STATUS	USERID	USERNAME	FIRSTNAME	LASTNAME	Middle Name	GENDER
active	123456789	abcdefgh	ABCD	EFGH		M

If you check the value for 'NOTACTIVE' column, you will see that the value for the field is 'active '.There is leading space in the value.Whereas, in the connector configurations we did not create a transformation rule for value 'active '.The transformation rule is valid for 'active' and NOT 'active '.

This is causing the rule to fail and the record to be rejected by the connector.

Resolution

In order to fix the issue, please correct the values for the 'NOTACTIVE' column.Please ensure that it contains exactly the same values as you have defined in your transformation rule.

In the example above, the correct feed file should have the value for NOTACTIVE column as 'active'.

Correct the feed file and then execute Replication Steps 1-3.

NOTE: This applies for all the values in the feed file and for all the columns of the feed file.Please ensure that the data is absolutely correct before it is being sent to SFTP for the connector to process it.

Keywords

User Connector SF, Error Entity Invalid,No transformation data configured,sfuser.field.transform.data.NOTACTIVE.N , KBA , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning all versions