Removing host role "streaming" not possible

[Former Member]

Hi guys,

I'm currently trying to remove the host role "streaming" from a same host deployment (using for testing purposes).

For the background:

We installed an old version of SDS (SP9) and tried to update it to SP12 recently. This failed because "the password could not be encrypted" (I guess it was the password in the cluster.cfg).

I would like to make a fresh install of SDS by uninstalling the SDS components. In order to do that I have to remove the role first.

The error while trying to remove the host role via hdblcm is:

Output line 1: com.sybase.esp.cluster.config.ConfigException: com.sybase.esp.cluster.impl.DatabaseException: com.sybase.esp.cluster.config
.ConfigException: Cannot get size for column SEGMENT in table ESP_CLUSTER_CONFIG_ENTRY

I also tried to remove the role by using the hdbmodify (and using script strrremovehost.sh) program which leads to the same error.

Any ideas? It seems like the installation is corrupt in some way...

Thanks in advance!

[RobertWaywell]

Unfortunately HANA does not provide the ability to remove a local role once it is granted.

In your situation I would suggest opening a Support case to figure out the issue you are running into with the upgrade.