Modify the profile parameter in webdispatcher.ini

[marouane19]

Dear experts,

I hope you are doing well and safe

We try to modify or delete a profile parameter (wdisp/system_11) in webdispatcher.ini manually and using the request below:

"ALTER SYSTEM ALTER CONFIGURATION('webdispatcher.ini','system') SET('profile', 'wdisp/system_11')= 'GENERATED, SID=HDB, NAME=HDB, EXTSRV=localhost:30008, SRCVHOST=dbhanaprod.consosystem' WITH RECONFIGURE"

But the parameter doesn't change and it still the same (see screen shots)

Could you please help?

Thank you

Best Regards,

Marouane

[Kai_Mueller]

Hello,

It seems like there is a host specific value which will be used over the system value. Can you please check this with the following query?

SELECT * FROM SYS.M_INIFILE_CONTENTS WHERE FILE_NAME = 'webdispatcher.ini' AND lower(SECTION) = 'profile' AND lower(KEY) = 'wdisp/system_11';

If you see another layer than SYSTEM and DEFAULT, you should earse or adapt them

Best regards, Kai

[marouane19]

Hello Kai,

Thank you for your answer

I executed the request above, and that what i get as a result below (please see the screen shot)

Please, can you tell me what do you mean by "earse or adapt them"?

Thank you again !

Best Regards, Marouane

[Kai_Mueller]

Hi,

can you please share were you executed the first command? The SYSTEMDB or the tenant? However, you have specified the same key on multiple layers. HANA supports SYSTEM, DATABASE and HOST. So you say, that the SYSTEM layer should have value X, but in the same time you specify value Y on HOST level.

You can now either change the value on HOST level or you remove the one on HOST level, so that the SYSTEM level works.

Please note, that if you use SYSTEM on the SYSTEMDB it affects all tenants, but if you specify it on a tenant it just affects the tenant. Therefore I guess you don't see a second row on the SYSTEMDB. Therefore it depends to which tenant the host belongs.

Please get more familiar with the configuration:

• Configuring SAP HANA System Properties (INI Files)
• ALTER SYSTEM ALTER CONFIGURATION Statement

Best regards,

Kai

[marouane19]

Hi Kai,

I executed the first command in SYSTEMDB

When i try to delete one of the HOST, it's not deleted, i cannot even modify the parameter of the systemdb or host

What exactly i need, is to modify the SRVCHOST of SYSTEM DB from dbhanaprod to dbhanaprod.consosystem.com (see the screen shot)

I unable to add the domain consosystem.com, i tried it manually and by the sql command, and it's not working

Thank you again

Marouane

[Kai_Mueller]

Hi,

so I can recommend to unset all values and then set teh one you finally want to see. Maybe this issue is somehow related to your HANA or HANA Studio version? I guess this scope beyond this portal, therefore I recommend you to open a support ticket if the above steps don't work.

Best regards, Kai

[marouane19]

Hello Kai,

Thank you for you help

I resolved the problem following the steps below:

1) I set the paramater "wdisp/system_auto_configuration" from true to false,

2) I created a new parameter "wdisp/system_11= SID=SYS....."

Thank you

Marouane