when you say sql menu. are they from ar system database or any external db?
If external db then is it accessible from ar system and arsystem DB user have read access to external table?
It's querying the ARSystem DB only, not the external DB
Just to narrow it down..
are you able to run sql query directly and getting expected results?
is it only with a specific menu or with all sql menus?
Yes, directly running through SQL client works fine and only this SQL menu has the issue