Forum Discussion

Greeb's avatar
Greeb
Occasional Contributor
9 years ago

Queries randomly give error message

Both of these generate table data. Test Complete gives "Unable to display the table data. The following error occurred: The query was executed but it produced no table data." I get this a ton for no apparent reason.

 

2 Replies

  • NisHera's avatar
    NisHera
    Valued Contributor

    How did you write it in test compelete?

    without looking at you code it's not possible to comment

    • Colin_McCrae's avatar
      Colin_McCrae
      Community Hero

      You're running those directly in SQL Mgmt Studio?

       

      And these are Stored Procedures you're trying to call?

       

      Does the second one work if you run it directly in SQL like you've shown in your screen capture? If it won't run directly, no way it'll run in TestComplete.

       

      Can't say I know much about SQL SP's, but I do notice the first one has an owner (the "[dbo]." part) but the second one doesn't? Not sure if these are required for SQL SP's ....