Symptom
- After adding a new node/host to the HANA scale out landscape, a table re-distribution fails for specific tables with the following errors in the indexserver trace :
Error allocating rows to parts:unexpected part index encountered for row position <>, target position <>
exception 71002048: fail to alter partition: [2593] Error during split/merge operation;exception 70002593: Repartitioning failed Step Split Main Fragment: Error allocating rows to parts;Unexpected part index encountered for row position 0, target partition ID
- Table definition typically looks something :
CREATE COLUMN TABLE "SAPHANADB"."/BIC/..."
. . . . . . .
PARTITION BY HASH
("/BIC/..."","/BIC/..."","/BIC/...","/BIC/..."","FISCVARNT","FISCPER","SEQ_NUMBER","TRANSTYPE") PARTITIONS 12, RANGE
("REQTSN" AS INT) (PARTITION OTHERS DYNAMIC THRESHOLD 0) WITH PARAMETERS ('PARTNAMES'=
('557','558','559','560','561','562','563','564','565','566','567','568'))
Read more...
Environment
SAP HANA Platform Edition 2.0
Product
Keywords
row position <>, target position <>, new node, new host, Error during split/merge operation, Error allocating rows to parts, exception 71002048: fail to alter partition: [2593] , KBA , HAN-DB-ENG , SAP HANA DB Engines , HAN-DB-ENG-BW , SAP HANA BW Engine , 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.