Notifications

50 views

Symptoms


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

 

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

Release


All Releases

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:2019-01-30 14:54:05
Published:2019-01-30