Symptom
-
The Web Services Provider has been installed and configured for use with the SAP Event Stream Processor (ESP) cluster.
-
The Jetty server has been started using wsp.bat.
-
The ESP project has been configured to be exposed as a Web service.
-
A connection request was sent from a WebSocket client to subscribe to data from the ESP project using the 'sql' subscription option.
- For example:
ws://localhost:9092/subscribe/default/a_window?basic-authorization=c3R1ZGlvOnM=&sql=’select * from Window1’ -
The connection request fails with the following error:
-
The wsp.bat reports the following errors:
WARN301501[/subscribe/<myespworkspace>/<mywindow--1] - com.sybase.esp.wsp.socket2.RemoteConnection.sendError(RemoteConnection.java:98) - Closing session (/0:0:0:0:0:0:0:1:60628) :
{"version":0,"type":"ERROR","source":"message\u003d\u0027\u0027: exception\u003d\u0027com.sybase.esp.sdk.exception.ProjectErrorException: SQL parsing error\u0027: event\u003d\u0027SUBSCRIBED\u0027","rows":[]}
- The WebSocket client receives the following error message:
{"version":0,"type":"ERROR","source":"message\u003d\u0027\u0027: exception\u003d\u0027com.sybase.esp.sdk.exception.ProjectErrorException: SQL parsing error\u0027: event\u003d\u0027SUBSCRIBED\u0027","rows":[]}
Read more...
Environment
- SAP Event Stream Processor (ESP) 5.1 SP 11
- Microsoft Windows 10
Product
Keywords
streaming, processing,esp , KBA , BC-SYB-ESP , Sybase ESP (Event Stream Processor) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.