Symptom
- Class Connector Not Updating Fields or Values;
- Class Connector creating a new Class instead of updating an existing one;
- Class Connector failing as "Cannot specify a NULL Key value for reference entity COL_NUM99_VAL";
- Class Connector creating multiple segments instead of classes.
- Only some of the classes in the input file are created after running Class Connector.
"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
- Run Class Connector to create Class, with no value in the Legacy ID;
OR
- Run Class Connector to populate the Legacy ID in a manually created Class;
OR
-
Fill mutiple entries in the input file and some of the 'COL_NUM99_VAL' columns have the same value.
Cause
Custom Column 99 is not using a unique Value or is not present on the connector input file.
Resolution
- The first time the connector creates the class the system creates the SCHED_ID based on the item id, rev_date and item type.
- To update the same class via connector, it uses its unique Legacy_ID (COL_NUM99_VAL) to identify which class to update.
- System Admin
- Configuration
- Entity configuration
- Select a record to configure 'Class'
- See Legacy ID and add as seen in below image.
- You should now see this custom column under Classes
- Custom Column 99 is used as an unique identifier for the class and it is mandatory when running the connector by any means (update and/or create)
- If you are updating a Class, you should ensure you have custom column 99 to match input file value, otherwise it will create a new class.
- If you want to create multiple classes for one item, ensure you set different legacy ID(COL_NUM99_VAL) for each classes. If same value is used repeatedly, multiple segments will be created instead of multiple classes.
- You will update input file for COL_NUM99_VAL with recommended alpha-numeric characters instead of numbers. This is to avoid it being similar to Class IDs e.g. "XCW-123"
IMPORTANT:
- If you have created the Class via the UI, it is not possible to use the Class Connector to populate the legacy ID/ COL_NUM99_VAL.
- The Legacy ID cannot match any Class IDs or it will not work.
Keywords
Class Connector, Class, Offering, Connector, Class Update, Connectors, Connector, Custom Columns, COL_NUM99_VAL, Custom Column 99 , KBA , LOD-SF-LMS-CON , Connectors , Problem