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

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):

 

competency.sfcompetency.field.transform.trim.data.enable=True

competency.sfcompetency.field.transform.trim.data.length.CPTY_DESC=4000

competency.sfcompetency.field.transform.trim.data.length.CPTY_EXPLANATION=4000

competency.sfratingcriteria.field.transform.trim.data.length.CPTY_DESC=4000

 

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