Skip to Content (Press Enter)
2013-01-31 21-55-49
André Alho
55Views
4Comments
[SQL Sandbox] Execution Plan not working
Question
SQL
Forge
Traditional Web
sql-sandbox
Web icon
SQL Sandbox (O11)
Forge asset by Leonardo Fernandes
Application Type
Traditional Web

After asking OS support to create a new user with SHOWPLAN permission

We are still getting errors while using the connection with the configured user

Any clue?

Thanks

0
0
27 Sep 2024
Copy Link
2023-01-25 05-43-21
Murugan S S

Hi Andre, 

I faced this issue, I just disconnected and restarted the SQLMS, and I tried connecting again it works for me, Access perspective show plan access enough to get the execution plan.


Thanks

Murugan S S 

0
0
24 Feb 2025
Copy Link
2020-10-27 09-20-27
John Salamat
 
MVP

Hi Andre,

Did you do the steps required to define a new connection string with the user that has permission and use that as DB connection.

https://johnalvinsalamat.medium.com/viewing-sql-execution-plans-in-outsystems-using-sql-sandbox-8117a59ce9fd


Regards,

John

0
0
24 Feb 2025
Copy Link
2022-12-30 07-28-09
Navneet Garg

Please check the module settings

0
0
25 Feb 2025
Copy Link
2023-02-09 12-36-42
Damian Fonville

Could you try it with this query? 

SELECT TOP 10 * FROM OSSYS_User

In our environment when the entity syntax is used the internal database connection is used, but with SQL tables it uses the correct connection that you have selected

0
0
06 Mar 2025
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.