Hi community,
Since today, we can no longer execute delete or update statements in SQL sandbox. This used to work without problems. We are using the latest version 3.3.3 and did not update/change anything.
We get the following error message with every query we are trying to execute:
Any ideas of why this occuring? The user executing has the Select (SQL) and DML (SQL) role.
If more information is needed, please feel free to ask them!
Best regards,
Bart Nooijens
Hi @Bart Nooijens ,
I'm having the same issue this time with the version 3.3.4 but only in DEV environment (QA is working just fine).
Suddenly I started to have the exact same error message as you and I haven't updated the component.
Were you able to find a solution?
Thanks,
Jorge
Hi Jorge,
Unfortunately we did not find the issue. As you bumped this forum post, maybe somebody who reads this has any idea on how to solve this issue.
Bart
I have exactly the same issue in just one of our environments. All other environments handle UPDATEs just fine. So I also bumping this up for visibility.
Found my issue. I had the Execution Plan selected in Options. Deselecting it resolved the issue.
@Thabo Sibeko I just deselected the Include Execution Plan option and it works like a charm!
Thanks for sharing the solution!