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.
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
This is when your Item Descrition length exceeds the default 400 bytes allowed for CPNT_DESC field in LMS.
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)
LMS; Connectors; Skillsoft Connector; Web Services; CPNT_DESC, Exceeding MAX CPNT_DESC length error; , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , SuccessFactors Learning , How To