WebDispatcher Issue in SP09 Multi DB and Solution
In SP09 MultiDB system, Webdispatcher processes inbound HTTP and HTTPS connections to XS services.
In SP09 System, Multiple Tenant databases will be there. Each Tenant database will have unique xs engine and Single Webdispatcher is available for one HANA Instance So Webdispatcher is common for all the Tenant databases.
Webdispatcher receives the user http request and It will point to corresponding XS Engine port using [wdisp/system_1] Parameter.
I have tried the following options, I could not bring out the system to Normal Condition.
1. Setting Webdispatcher Instances to 0 and change the Instances to 1.
2. HANA System Restart
3 Start and Stop Tenant DB Index servers.
Nothing is working and Finally I found the work around for this problem.
Solution:
1. In daemon.ini, Set Instance value for Webdispatcher is 0
2. Then We have to remove the webdispatcher from Name Server Topology
ALTER SYSTEM ALTER CONFIGURATION (‘topology.ini’, ‘system’) UNSET (‘/host/<hostname>’, ‘webdispatcher’) WITH RECONFIGURE
3. Remove the Parameter [wdisp/system_1] from Profile Section under Webdispatcher.ini
4. Now, In daemon.ini, Set Instance value for Webdispatcher is 1
5. After Setting the parameter value is 1, Webdispatcher service will be started now. Now the service will be green.
Now The Webdispatcher Issue in SP09 Problem is solved 🙂
Sorry, but why not simply restart the WebDispatcher service via right click in Landscape Overview -> Services and "Restart missing services"?
Removing, Re-adding the service to the system configuration and restarting the system is a pretty extreme approach.
Also, it seems a little optimistic to state the problem is solved without knowing the reason for the WebDispatcher service downtime. There must have been some kind of error messages in the trace/alert files.
Hi Lars,
I have tried first that option only: simply restart the WebDispatcher service via right click in Landscape Overview -> Services and "Restart missing services"? But this is not working.
and I have tried simply removing and re adding the service But This is also not working.
So I have found this work around.
1. Stop the service completely by removing it from topology
2. Removing the parameter [wdisp] from webdispatcher
3. start the Service by setting Instance Parameter - 1
4. Finally Set the [wdisp] parameter again.
Then I only I can make system up and webdispatcher is working.
The interesting part now is: why were these actions not working?
Did you get a chance to check the trace files for error messages?
Hi Lars,
I don't know Whether it is limitation or Issue?, I have to check the trace files for error.
Regards,
Muthu
after step 5 it doesn't turn green on my sp9 what else could i do?
Hello Muthuram,
for this workaround. I had the same issue and it worked your fix. But I do not feel comfortable with not knowing what was the reason for this behaviour in a multitenant environment ...