Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hi All,


In the database available via http there is a web service that calls my procedure. During the procedure, it may cause an error (tried raiserror and signal).

If the web service has TYPE set to 'XML', then the error text will be visible in this XML.

If the web service has TYPE set to 'JSON', then the error text is not visible, and the response body is generally empty.

Question: Is this error SA or does something need to be configured on the server ?

asked 06 Dec '18, 07:42

Stalker's gravatar image

accept rate: 11%

edited 09 Dec '18, 14:43

Volker%20Barth's gravatar image

Volker Barth

Maybe that note from the v12.0.1.4484 readme is of help (or any other fix after build no. 4134 which is really old ...):

    ================(Build #4166  - Engineering Case #771444)================

    JSON services would have returned an empty document if an SQL error occurred. 
    This has been fixed so that an object containing one row with two keys, status: 
    “error”, and message: “<text of="" the="" sql="" error="" message="">”, is now returned.
permanent link

answered 06 Dec '18, 08:55

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

edited 06 Dec '18, 08:56

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 06 Dec '18, 07:42

question was seen: 1,388 times

last updated: 09 Dec '18, 14:43