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
Read more...
Environment
SAP BW
SAP BW/4HANA
Product
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.