Customer gets exception while running UserConnector - SF. Exception code is 1166, "Length of Column exceeds Max. specified length."
Error is similar to the following: Length of Column exceeds Max. specified length. LMS_FIELD: "Value of field" Row ending line number: XXXXXX Row starting with - "active","XXXXXXX","XXXXXXXX","XXXXX","XXXXX","","XXXXXXX","X","XXXXXXX","XXXXX","XXXX","XX"
Note that LMS_FIELD may be any field, including CURRENCY_CODE, ORG_ID, among others. The Xs assist in determining the affected row inside the file and will have data specific for your input file.
SuccessFactors Learning Management System (LMS)
The database has a limitation of length for each field, note that this limit may differ among different fields. The limit is set in the database and any change on it needs to be submitted as an enhancement request.
Check the Connector Workbook for the length limitation of each field. Below you can find as an example, the CURRENCY_CODE line. Kindly pay attention for the unit of the length specified in the Connector Workbook as it is standardly displayed with the Unit of bytes and not characters. Fixing the data in the file will keep the connector job to generate the exception, the fix may have to be performed in BizX as the file is generated from its export.
This field is referenced in the database.
Default Currency Preference for the user. Connector will not update Currency for existing records as the user may modify the preference via the UI.
If null defaults to configuration value. If the value is invalid then the record is rejected.
2404463 - LMS Connectors - Connector Workbooks FAQ
Max. specified length exception, User connector exceptions, sfuser connector exceptions, sf user connector exceptions, Lenght, Limit, Exception, 1166 , KBA , LOD-SF-LMS-CON , Connectors , Problem