3567462 - Error "274, "message":inserted value too large for column" when performing Data Persistency of the view in SAP Datasphere

When running data persistency of the View in Datasphere, the following error appears:

• "code":274, "message":"inserted value too large for column"
• error: AttributeEngine: indexed value not within specified range;checkCesu8StringColumn(): max length (4) violated on pos 0, value='01047649',column '*****'; $table$=****:****_$PT1AttributeEngine: indexed value not within specified range;checkCesu8StringColumn(): max length (2) violated on pos 0, value='1000',column '*****', rc=6959", "insertingData":true}  )

SAP Datasphere

1. Login to Datasphere tenant
2. Navigate to Data Builder, space *** 
3. Search for view ***
4. Perform Data Persistency of the view and get the error message. 

View persistency could be failing due to inconsistent datatype length between application and database. 

It is recommend to align the data type length using the Cast function.

For more information, see CAST Function (Data Type Conversion).

datasphere, ds, dws, data persistency, 274, data length , KBA , DS-DI-VIW , View Persistency and Runtime , Problem