3541943 - ADSO remodeling fails post reduction of field length

Symptom

A reduction of a field length in an ADSO was performed while the ADSO contains data, remodeling is requested but the remodeling rule is failing.

Error similar to the one below can be seen in the WP trace:
SQLCODE : 274
SQLERRTEXT : inserted value too large for column: TrexColumnUpdate failed on table 'SAPHANADB:/BIC/A<ADSO_TECH_NAME>' with error: AttributeEngine: indexed value not within specified range;checkCesu8StringColumn(): max length (10) violated on pos 5, value='<XYZ>';column '<COLUMN_NAME>', table 'SAPHANADB:/BIC/A<ADSO_TECH_NAME>', rc=6959

Environment

SAP BW
SAP BW/4HANA

Product

SAP BW/4HANA 2021 ; SAP NetWeaver all versions

Keywords

Remodeling, ADSO, Error, Truncate , KBA , BW4-DM-ADSO , DataStore Object (Advanced) , BW4-DM-RMT , Remodeling Toolbox , BW-WHM-DBA-RMT , Remodelling Toolbox , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.