2412591 - Avoid issues with exceeding CPNT_DESC max column length in Skillsoft Item Catalog

SAP Knowledge Base Article - Public

2412591 - Avoid issues with exceeding CPNT_DESC max column length in Skillsoft Item Catalog

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

  1. Run Skillsoft Connector
  2. 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 , SuccessFactors Learning , How To

Product

SAP SuccessFactors Learning all versions