Skip to Content

How to reset host entry in HANA

Hi Gurus,

I was creating a data backup of a SAP HANA database but it failed with “Topology contains invalid host, please remove host: <hostname> from topology, so I followed 2340161 note to remove an empty host entry from the topology.

I verified that the host entry in the topology is actually empty. Therefore, please run the following query:

SELECT * FROM "SYS"."M_TOPOLOGY_TREE" WHERE PATH = '/host' AND NAME not in (select distinct host from M_HOST_INFORMATION);

Then, removed the “empty” host entry, provided you found one in step 1. Execute the following statement, replacing the <hostname> with the value returned by the first query in step 1:

ALTER SYSTEM ALTER CONFIGURATION ('topology.ini', 'system') UNSET ('/host', '<hostname>') WITH RECONFIGURE;

the issue is that I have removed by mistake the actual host name of the HDB!!!

So, my question is, is there any way to set it back???

I tried to use the following command:

ALTER SYSTEM ALTER CONFIGURATION ('topology.ini', 'system') SET ('/host', '<hostname>') WITH RECONFIGURE;

but got the following error:

Could not execute 'ALTER SYSTEM ALTER CONFIGURATION ('topology.ini', 'system') SET ...' SAP DBTech JDBC: [2]: general error: only ('section', 'key') = 'value' format is allowed

Does the above command need to be modified some how?

Is there any other way to set host entry of my system back?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 30, 2018 at 07:01 AM

    the solution done by SAP Support by recovery of the topology file from a backup

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 29, 2018 at 10:48 AM


    Deleting the hostname was a silly mistake.

    Best option here is a point in time recovery, i'm guessing since this is an important system to you, you have made sure to have a recent backup?

    Add comment
    10|10000 characters needed characters exceeded