SAP Knowledge Base Article - Public

2343609 - Length of Column exceeds Max. specified length error in Connector

Symptom

  • Error encountered when running a Connector: "Length of Column exceeds Max. specified length."
  • Exception code is 1166
  • Error is similar to the following: Length of Column exceeds Max. specified length. LMS_FIELD: "Value of field" Row ending line number: # Row starting with - "active","###","##","###"
  • 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

SAP SuccessFactors Learning Management System

Cause

  • The database has a limitation of length for each field. Please 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. 2326249 points to where the Data Dictionary can be downloaded. It can be used to cross reference total length in the database in bytes.
  • Please see 2571786 which explains field lengths.
  • Fixing the data in the file will keep the connector job to generate the exception, the fix may have to be performed in BizX if it's a Connector that utilizes data from that system.
  • Please see example below: CPNT_TITLE

Note: Not every single character is proportioned to 1 byte. There are many characters that are 3 bytes in different languages. In case if the error is still received, validate how many bytes each character is and update the value in the input file to adhere to the appropriate length.

Field Name/Header Field

Description and Rules

Data Type

LENGTH (bytes)

Item Title/
CPNT_TITLE

Item Title is a searchable field in the User library. This defaults to the system's locale.

Alpha Numeric

300

Keywords

SF, Success Factors, LMS, learning, user connector sf exception, field length, error code 1166 , KBA , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning all versions