3471932 - Inserted value too large for column error when persisting view in SAP Datasphere

View persisting in SAP Datasphere failed with the 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 ..." 

SAP Datasphere

View persisting

This issue occurs when the length of type definition of a column is insufficient to hold the actual data at runtime. Typical causes:

1. Column length too small. The column definition in the view is smaller than the incoming values.
2. Type/length mismatch between layers. Calculated or concatenated columns result in implicit conversion where application-layer definition and database-layer definition do not match.

There are several ways to adjust column definitions depending on the situation.

Option A: Increase column length in the UI.

1. Open the View
2. Increase the length of the column
3. Save and re-run the persistency

Option B: Use CAST to align types

• CAST Function (Data Type Conversion) | SAP Help Portal

• KBA 3627941 - AttributeEngine: indexed value not within specified range;checkCesu8StringColumn(): max length () violated on pos
• CAST Function (Data Type Conversion) | SAP Help Portal

Datasphere, Persist View, Error 274, inserted value too large for column, length exceeded, CAST, substring limit , KBA , DS-DI-VIW , View Persistency and Runtime , Problem