SAP Knowledge Base Article - Public

3019749 - Competency Connector error messages - LMS


The Competency Description (CPTY_EXPLANATION) is giving an error that the Length of Column Exceeds the Max specified length when running the Competency Connector


SAP SuccessFactors Learning

Reproducing the Issue

  1. Run the Provisioning job to export the Competency file
  2. Run the Competency Connector in LMS
  3. Error "Length of Column Exceeds the Max specified length" after running the connector


This KBA applies to customers who are using a legacy competency module (JDM) which does not have max length fields defined for competency name, description, teaser name and description.

As a result, the connector is failing with the length of column exceeds max error.


Add the following properties to the connector configuration file (System Administration > Configuration > System Configuration > Connector):


Please note that these do not apply to teaser names. If the you are exporting the competency data and the connector is failing with such errors eventhough the configuration is enabled, you must verify the teaser data to ensure it is not over the limit.


You may refer to the data dictionary for the character limit in LMS: KBA 2326249


NOTE: any CLOB data in LMS is maxed at 4000 bytes


Length of Column Exceeds the Max specified length, competency connector error , KBA , LOD-SF-LMS-CON , Connectors , Problem


SAP SuccessFactors Learning 1902 ; SAP SuccessFactors Learning 1905 ; SAP SuccessFactors Learning 1908 ; SAP SuccessFactors Learning 1911 ; SAP SuccessFactors Learning 2005 ; SAP SuccessFactors Learning 2011