Skip to Content
0

Remove wrong index server HDB Multi tenant

Jul 11, 2017 at 04:40 AM

157

avatar image

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

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Freddy Januardo Jul 13, 2017 at 10:57 AM
0

Hello Guys,

anyone have the solution?

Thanks before!

Share
10 |10000 characters needed characters left characters exceeded
Sadiq Iqbal Jul 14, 2017 at 12:40 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded