2425588 - WebSocket: error with sql subscription option - SAP Event Stream Processor 5.1 SP11 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

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

SAP Event Stream Processor 5.1 ; SAP Sybase Event Stream Processor 5.0

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.