I was unable to save a Workflow I’d recently imported. Even cloning the workflow and trying to save the completely unaltered workflow gave the same error:
Save Workflow Failure: Illegal user input query...
Image: Save Workflow Failure
It turned out that the fix was very easy (initially I thought something was wrong with the SQL Query) all I had to do was:
1) Go to Data Sources > reset scheme for OCUM
2) Re-acquire data from OCUM
As you can see from the below, the acquisition was failing with “Table ... doesn’t exist”.
Image: Table ... doesn’t exist
Error = "Table 'cm_storage.qtree_ex' doesn't exist"