Remove wrong index server HDB Multi tenant

[former_member293200]

Hello Gurus,

Please help me with below case.

Environtment:

• -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.00.122.05.1481577062_3382751/hdbindexserver –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 SYS.UPDATE_LANDSCAPE_CONFIGURATION('SET REMOVE','<hostname:31003>');

- call REORG_GENERATE(2,'')

- call REORG_EXECUTE(?)

Thanks Gurus,

Freddy

[former_member182505]

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

[former_member293200]

Hello Guys,

anyone have the solution?

Thanks before!