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.