SAP Knowledge Base Article - Public

2561302 - Import Content Error - value too large for column

Symptom

You receive an error when trying to import a content object to an already existing item, similar to this one:

Caused by: java.sql.SQLException: ORA-12899: value too large for column "PA_CBT_OBJ_BANK"."DESCRIPTION" (actual: 772, maximum: 765)

Environment

SuccessFactors Learning Management System - Import Content

Reproducing the Issue

  1. Navigate to the Learning Administration
  2. Go to the import content tool - Content > Tools > Import Content
  3. Proceed importing a content using the steps on screen
  4. Error Message appears

Cause

The content you are trying to import contains a long description.

Resolution

Contact the content developer to shorten the description for you (up to 765 characters). As this change should be perfomed inside the content, it is something that could not be changed on the LMS UI.

See Also

2460272 - HTTP error when trying to import content

2348757 - HTTP Error when using the Import Content tool

Keywords

value too large for column, content import error, java.sql.SQLException, ORA-12899, PA_CBT_OBJ_BANK.DESCRIPTION , KBA , LOD-SF-LMS-CNT , Content , Problem

Product

SAP SuccessFactors Learning all versions