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
- Click on "Data Viewer", navigate to "Columns" tab.
- 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