2425588 - WebSocket: error with sql subscription option - SAP Event Stream Processor 5.1 SP11

• 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":[]}

• SAP Event Stream Processor (ESP) 5.1 SP 11
• Microsoft Windows 10

streaming, processing,esp , KBA , BC-SYB-ESP , Sybase ESP (Event Stream Processor) , Problem