SAP Knowledge Base Article - Preview

3193423 - Activating ADSO or activating data in an ADSO fails with message "inserted value too large for column"

Symptom

When activating an ADSO or when activating a Request in an ADSO, the activation fails with below error messages:

"Could not activate in step SAP HANA optimized activation"

"Serious error occurred: inserted value too large for column: TrexColumnUpdate failed on table <table_name> with error: AttributeEngine: indexed value not within specified range;check [...]"

"[...] transaction rolled back by an internal error: failed to activate dso with persisted changelog:  [410 02] inserted value too large"

"Error during in-memory activation (see long text)"

This can occur sporadically or can be a persistent error, specially if you upgraded your system recently (either BW or HANA). There is a chance for this error to happen during DTP execution as well.


Read more...

Environment

SAP HAHA 2.0

SAP BW/4HANA 1.0

SAP BW/4HANA 2.0

Product

SAP BW/4HANA 1.0 ; SAP BW/4HANA 2.0 ; SAP HANA, platform edition 2.0

Keywords

inserted value too large for column, HANA optimized activation, indexed value not within specified range, fail ed to activate dso with persisted changelog, inserted value too lar, Error during in-memory activation, [410 02] , KBA , BW4-ME-ADSO , DataStore Object (Advanced) , BW4-DM-ADSO , DataStore Object (Advanced) , HAN-DB , SAP HANA Database , 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.