2210025 - HANA DB table reorganization for host removal will not finish.

Symptom

You are trying to remove a host from a HANA scale-out landscape. For that purpose, you want to reorganize the tables via HANA Studio first and then remove the host via hdblcm. However, when trying to reorganize the tables via HANA Studio, the status remains on REORG PENDING and table reorganization will not finish.

Environment

You are using a HANA DB scale-out landscape. The revision of HANA DB is below revision 90.

Reproducing the Issue

Start the HANA Studio. Switch to 'Landscape' tab. Right click on the relevant host and click on 'remove host'. You will see that the host removal status remains on 'PENDING' and table reorganization will not finish.

Cause

This is a known issue. The dimension of one of the table columns used in landscape reorg to export results was too small for some of your temporary table names.

Resolution

This can be worked around by setting the following parameter:
"alter system alter configuration ('indexserver.ini','SYSTEM') set('table_redist','debug_export_detail')='0' WITH RECONFIGURE"
After that please cancel host removal and start it again.
Alternatively, upgrade your HANA DB to SP09 where the bug is fixed.

Keywords

HANA scale-out landscape, host removal, table reorganization, hdblcm

Header Data

Released On	26.08.2015 06:42:45
Release Status	Released to Customer
Component	HAN-DB SAP HANA Database
Priority	Normal
Category	Problem
Development Platform	C++/Visual C++
Database	HDB 1.0