2144720 - HANA: How to remove the coordinator/master host in a Multi-host system

Symptom

You could see the following error message when trying to remove the coordinator* host with HANA studio directly:

SAP DBTech JDBC: [293]: argument type mismatch: remove not allowed;cannot remove coordinator* host <hostname>

Even through you failover it to the standby host, the error still appears when delete the original coordinator* host:

SAP DBTech JDBC: [293]: argument type mismatch: remove not allowed;cannot remove worker host while not assigned 
to a storage partition. 
You have to switch role with a standby host and then remove this host. <hostname>

Environment

SAP HANA, platform edition

Product

SAP HANA, platform edition all versions

Keywords

HDBLCM, hdblcmgui, hdbaddhost, hdbremovehost, hdbreg, Scale-out, coordinator, worker, distributed, Configure Hosts for Failover Situation, configured role, actual role, nameserver, indexserver, failover, standby , KBA , master , slave , HAN-LM-PLT , SAP HANA Platform Lifecycle Management , HAN-STD-ADM-DBA , SAP HANA Studio (Eclipse) Admin Tooling , How To

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.