SAP Knowledge Base Article - Public

3471932 - Error message "code:274, message:inserted value too large for column" when persisting view with exceeding max length limit in SAP Datasphere

Symptom

When persist the view in SAP Datasphere, it fails with following error message:

  • Error: "{"code":274, "message":"inserted value too large for column: \"**\".\"***\": line ** col ** (at pos ***): TrexColumnUpdate failed on table ****' with error: AttributeEngine: indexed value not within specified range;checkCesu8StringColumn(): max length (5000) violated on pos ..." 

Environment

SAP Datasphere

Cause

Length number of the Data Type "String" is less than a column name characters.

Resolution

  1. Click on "Data Viewer", navigate to "Columns" tab.
  2. Under "Data Type", increase the substring limit to higher number of characters for a needed column.

Keywords

datasphere, view, character limit, code 274, persist , KBA , DS-DI-VIW , View Persistency and Runtime , Problem

Product

SAP Datasphere all versions