Skip to Content

Remove wrong index server HDB Multi tenant

Hello Gurus,

Please help me with below case.


  • -HANA Database : HANA 1.0 SP12 SPS122 deployment MultiTenant Database
  • OS : Linux SLES 11 SP 3
  • -HANA Studio : 2.2.12
  • -Browser : Firefox 51.0.1 (32-bit)

Issue :

Invalid indexserver in hana multitenant database.

When I try to reset password for SYSTEM user, I run command below in OS:

/hana/shared/<SID>/exe/linuxx86_64/HDB_1. –port 31003 –resetUserSystem

The problem is, port 31003 is not right and it causing the service is error like below

Is there any way for me to remove the wrong indexserver service?

I try to delete via DB cockpit but unfortunately it’s not possible due to disabled button.

Also i tried to use below query but no luck.

- ALTER DATABASE xxx REMOVE 'indexserver' AT LOCATION 'HOST_A:31003'


- call REORG_GENERATE(2,'')


Thanks Gurus,


upload-1.png (42.7 kB)
upload-2.png (55.7 kB)
upload-firefox.png (77.1 kB)
upload-3.png (36.4 kB)
upload-4.png (78.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 13, 2017 at 10:57 AM

    Hello Guys,

    anyone have the solution?

    Thanks before!

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 14, 2017 at 12:40 PM

    Hi Freddy how did you come to know that this is the Invalid indexserver, and did you converted single to MDC, if yes invalid indexserver should not come, You must have to check with SAP, i guess BUG Thanks Sadiq

    Add comment
    10|10000 characters needed characters exceeded