Error 5132 with Web Platform

[Former Member]

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.

[michael_loop]

The help file says,

"5132 AE_INVALID_OBJECT_NAME

The specified database object name is not valid.

If you are getting this error when attempting to use the Advantage Web Administrator utility to view database and server information, it could be because the dictionary that you are connecting to is not a root dictionary. The web administrator utility uses system procedure requests to retrieve information from the server, and system procedures through the Advantage Web Platform can only be run when connected to the root dictionary. If it is not a root dictionary, the web platform attempts to treat the system procedure name as a table object in the dictionary, which results in a 5132 error."

Is your production database a root dictionary?

Mike Loop
Senior Product Support Engineer
SAP Product Support

[Former Member]

Thank you for the response Michael. I actually wasn't aware of root DDs, but upon investigation I found that we don't have a data path specified for the root DD in the configuration utility. We'll set one up and see what happens.

That said, the problem is specifically when trying to execute user-created stored procedures through the Advantage Web Platform, not when using the WAU.

I forgot to mention that we can execute some other SPs with no problems on the production server using the same connection string (but with different SP/arguments of course). The problem seems a bit arbitrary.

I suspect now that it may be some kind of memory/runtime problem with the ADS service on the live server. I'm not able to restart the service mid-day, whereas I can restart the test machine (which works). I'll restart the service tonight and see if there's any change.