While executing SQL Script file getting 'Given SQL statement is not allowed to be executed at this time.'

[sanket14]

While executing SQL Script file getting 'Given SQL statement is not allowed to be executed at this time.' 

Direct Queries such as select,create,update,etc. works fine. But if I pass a script file getting above error. 

I'm using JDBC Credential to query the database via MID server.

[Kranthi Kumar3]

Hello Sanket,

Did above question has resolved, I had a similar issue while executing the sql statement from JDBC step in flow designer. Could you please let me know the solution if this has been resolved.

Thanks in Advance

Thanks,

Kranthi

[Mark Cheek]

I had a similar issue when I was trying to execute a stored procedure using the exec command. It is not allowed by default, but you just have to update a mid server property to allow it. That is covered in this KB article

[P-Rudenko-SN]

@Mark Cheek unfortunately this did not fix the problem for me.

@Kranthi Kumar @sanket did you guys solve this issue? as I'm having the similar one

[martinschoenfel]

I had a simular issue.

I have an input variable string in my Flow with the SQL statement. When i try to use this input value as SQL Statement in the JDBC step it throws me the error "Given SQL statement is not allowed to be executed at this time"

Writing the SQL statement directly into the SQL Statement field is working fine. 

Any ideas or solution?