Symptom
How to increase column length of an Item's Description (CPNT_DESC) in Item Catalog import file imported by the Skillsoft Connector when polling Skillsoft Servers via Web Services.
Increasing the Item Descritpion column length will help avoid Skillsoft Connector errors such as "Exceeding the MAX column length" for CPNT_DESC column.
Environment
SuccessFactors Learning Management System (LMS) - All Supported Versions
Reproducing the Issue
- Run Skillsoft Connector
- Connector fails due to "Exceeding the MAX column length" for CPNT_DESC" Error
Cause
This is when your Item Descrition length exceeds the default 400 bytes allowed for CPNT_DESC field in LMS.
Resolution
This can be avoided by adding the following property to your connector config:
skillsoft.item.field.transform.trim.data.length.CPNT_DESC=4000 (Again, try increasing to this value or a higher value if needed)
Keywords
LMS; Connectors; Skillsoft Connector; Web Services; CPNT_DESC, Exceeding MAX CPNT_DESC length error; , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , Learning Management System , How To