Getting the error "Given SQL statement is not allowed to be executed at this time."

andrewdevadhas
Kilo Contributor

‎12-13-2017 03:38 AM

Getting the error message when trying to run a query

Given SQL statement is not allowed to be executed at this time.

find_real_file.png

Preview file
38 KB
0 Helpfuls
  • 2,431 Views
3 REPLIES 3

vignathareddy
Kilo Contributor

‎01-04-2018 01:22 AM

Hi Andrew,



I had similar issue, but is resolved now. You should have copy pasted Query or did any changes in the alignment of query like hitting enter button for new lines.


Try to take the same query as you execute in teradata or dbeaver etc and try out. Try to avoid enter buttons in Query after you paste in servicenow activity.


Try to check once. In my case it is resolved.



Thanks.


0 Helpfuls

Revathi1
Tera Contributor

‎03-15-2021 11:13 PM

HI all , i am also getting same error ,'the given SQL statement cannot run at this time

did anyone able to resolve this issue ?

 

Thanks .

0 Helpfuls

Mark Cheek
Tera Contributor

‎03-23-2021 12:13 PM

My problem was I was trying to run a stored procedure using the exec command, and that was not allowed by default. I had to change a mid server property to allow it. That is covered in this KB article