SAP Knowledge Base Article - Public

2343609 - Max. specified length - Exceptions in SFUserConnector

Symptom

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.

Environment

SuccessFactors Learning Management System (LMS)

Cause

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.

Resolution

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.

N/A

CURRENCY_CODE

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.

Alpha Numeric

3

See Also

2404463 - LMS Connectors - Connector Workbooks FAQ

Keywords

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

Product

SAP SuccessFactors Learning all versions