SA 12.0.1.4134: Return an error from a web service with TYPE "JSON"

[former_SQLA_member1694881]

Hi All,

SA 12.0.1.4134.

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 12.0.1.4134 or does something need to be configured on the server ?

[VolkerBarth]

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.