XS - 500 Dispatching Error - SAP HANA

[former_member184871]

Hi all,

I am having "500 Dispatching Error" whenever I access anything using HANA XS but When I ping my server I always get "XS Engine Up and Running".

I have imported all the additional content Delivery Unit, configured the required work-space, saved and activated the projects but during access via web browser I get the following.

Please guide how to resolve the issue.

Awaiting response.

Regards

Kumar.

[former_member186082 · Accepted solution]

Hi Kumar,

Have you enabled developer mode on XSJS? This might help in getting more details on error

http://www.youtube.com/watch?v=cnSQhrxnWNs&feature=c4-overview&list=UUVLSTvSR7UAd87o_0qoIR4Q

Regards

Chandu

[former_member184871 · Accepted solution]

Hi Chandra

I checked the video, but its nothing related "500 dispatching error" - In video its clearly explained that "With Developer mode = true" it will throw back lot more detailed messages, also if developer mode is not configured on any server it will throw back error message but in more Generalized graphical way.

My question still remains same - when i ping the server its Says "XS engine is up and running" but when I try to use any of the feature say IDE or web based Editor - I am getting a dispatching error.

PS : I have already imported all the required Delivery Units - which is required for IDE, LM or WEB Editor.

Please help in resolving the issue.

Regards

Kumar.

[AtulKumarJain · Accepted solution]

Hi Mayuresh,

Please check

http://scn.sap.com/thread/3284203

check SAP note 1665602

You need to check web dispatcher parameter , also from hana studio xsengine services should running .

Please check below doc

http://help.sap.com/hana/SAP_HANA_Direct_Extractor_Connection%20_Implementation_Guide_en.pdf

If you still facing any issue please update issue  / error log.

BR

Atul

[former_member184871 · Accepted solution]

Hi Atul,

Thanks for your reply. I cross checked with the XS engine configuration and its configured properly.

When I Ping my server it says "XS ENGINE IS UP AND RUNNING" .

But my point is - when I open any other XS Engine based application - for example IDE, LM, WEB EDITOR I get "500 Dispatching Error"

I have also imported the respective Delivery Unit - related to IDE or LM.

Awaiting your feedback.

Regards

Kumar.

[AtulKumarJain · Accepted solution]

Hi Mayuresh,

Could you please provide webdispatcher profile .

I want to check profile parameter for webdispatcher.

BR

Atul

[former_member184871 · Accepted solution]

Hi Atul,

As asked - here is the SAPWEBDISP.pfl

# Profile generated by sapwebdisp bootstrap

# unique instance number

SAPSYSTEM = 00

SAPSYSTEMNAME = HDB

_HTTP_PORT = 80$

(SAPSYSTEM)

_HTTPS_PORT = 43$

(SAPSYSTEM)

_LOCAL_HOST_NAME = imdbhdb

# add default directory settings

DIR_EXECUTABLE = exe

DIR_INSTANCE = $(_LOCAL_HOST_NAME)

icm/security_log = LOGFILE=$(DIR_INSTANCE)/trace/dev_icm_sec,MAXSIZEKB=500

# Accessibility of Message Serversr

disp/mshost =

ms/http_port =

# SAP Web Dispatcher Parameter

wdisp/auto_refresh = 25

wdisp/max_servers = 100

wdisp/shm_attach_mode = 6

# configuration for default scenario

(medium size)

icm/max_conn      = 500

icm/max_sockets   = 1024

icm/req_queue_len = 500

icm/min_threads   = 10

icm/max_threads   = 100

mpi/total_size_MB = 80

#maximum number of concurrent connections to one server

wdisp/HTTP/max_pooled_con = 200

wdisp/HTTP/min_pooled_con = 0

wdisp/HTTPS/max_pooled_con = 200

wdisp/HTTPS/min_pooled_con = 0

wdisp/HTTP/use_pool_for_new_conn = 1

# SAP Web Dispatcher Ports

icm/server_port_0 = PROT=HTTP,PORT=$(_HTTP_PORT),PROCTIMEOUT=600

icm/server_port_1 = PROT=HTTPS,PORT=$(_HTTPS_PORT),PROCTIMEOUT=600

icm/server_port_2 = PORT=0, PROT=WEBSOCKET, TIMEOUT=-1

icm/server_port_3 = PORT=0, PROT=WEBSOCKETS, TIMEOUT=-1

# SAP Web Dispatcher Web Administration

icm/HTTP/admin_0 = PREFIX=/sap/wdisp/admin,DOCROOT=$(DIR_INSTANCE)/wdisp/admin,AUTHFILE=$(DIR_INSTANCE)/wdisp/icmauth.txt

icm/HTTP/hdb_0=TRUE

wdisp/add_client_protocol_header = 1

wdisp/system_0 = SID=$(SAPSYSTEMNAME), EXTSRV=http://localhost:3$(SAPSYSTEM)08, SRCURL=/

#icm/sleep_after_startup = 1

#icm/HTTP/server_cache_0 = PREFIX=/, CACHEDIR=$(DIR_INSTANCE)/wdisp/cache

Awaiting your inputs.

Regards

Kumar.

[AtulKumarJain · Accepted solution]

Hi Kumar,

Please check SAP Note No. 1888522.

can you please update error message from xsengine log and webdispatcher log.

Please also provide the version of HANA DB.

BR

Atul

[former_member184871 · Accepted solution]

Hi Atul,

Thank you for your help.

SAP NOTE: 1888522 worked.

As per the SAP NOTE I somehow lost the SELECT privileges from _SYS_XS - schema.

Regards

Kumar