Notifications

6 views

Symptoms


Create a new custom JDBC workflow activity, in the sql command field enter ‘alter’ then the error will show up:

 

Given SQL statement is not allowed to be executed at this time.
The query: alter group xxx add user xxxxx

Release


Any

Cause


There is a mid server property called mid.property.jdbc_operations that tells the JDBCOrchestrationProbe what JDBC operations are allowed to execute, alter operation is not included by default.

Resolution


Edit the mid server property mid.property.jdbc_operations and include the alter keyword

Additional Information


MID Server property

Article Information

Last Updated:2018-11-25 17:04:27
Published:2018-11-26