SAP Knowledge Base Article - Preview

2596218 - Error during split/merge operation;Moving data between servers is not allowed - SAP HANA DYT

Symptom

During alter table partition by clause, data cannot move between column store and extended storage. Error below can be found:

SQL =>

   Alter table m10 PARTITION BY RANGE(b)
     (USING DEFAULT STORAGE (PARTITION 00000010 <= VALUES < 00000050 , partition OTHERS)
      USING EXTENDED STORAGE (PARTITION 00000050 <= VALUES < 00000070 ));

Error =>

  column store error: fail to alter partition: [2593] Error during split/merge operation;Moving data between servers is not   allowed. Partition 1 at <host_name>:<port_number> needs to be moved to <host_name>:<port_number>.,object=<object_name>


Read more...

Environment

  • SAP HANA DYT 1.0
  • SAP HANA DYT 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

Moving data between servers is not allowed , KBA , HAN-DYT , SAP HANA Dynamic Tiering , 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.