SAP Knowledge Base Article - Preview

3428866 - Error allocating rows to parts unexpected part index encountered for row position <>, target position <>

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

SAP HANA, platform edition 2.0

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.