Skip to Content
0
Jun 22, 2018 at 07:46 PM

Error 5132 with Web Platform

170 Views

Hello-

We're seeing weird behavior with executing stored procedures via URL string in ADS 11. As part of troubleshooting this we created a simple stored procedure in our production environment and in a test environment. The SP has three arguments: myInt, myDate, and myChar. It just returns all three as output.

In the production environment we get back a 5132 error that the database object cannot be found. Here's a sample string:

http://localhost:6272/adsweb/testData/v1/SP_Test?MyInt=1&MyDate=2018-06-22&MyChar=A&$format=json

From the production server:

  "error": {
    "code": "5132",
    "message": {
      "lang": "en-US",
      "value": "Error 5132:  The specified database object name is not valid.  \"SP_Test\" is not a table or view in the data dictionary."

From the test environment:

   "__metadata": {
          "uri": "http://localhost:6272/adsweb/testData/v1/SP_Test",
          "key_fields": "",
          "rows_affected": 1,
          "last_autoinc": 0
        },
        "_MyInt": 1,
        "_MyDate": "2018-06-22T00:00:00",
        "_MyChar": "A"

Any idea as to what could be the difference, or any general advice on troubleshooting this error?

The test data is a clone of the production data and the SPs are identical. The conf files for AWP are identical except for the local file paths to the databases.