NetApp WFA 4.2 - Save Workflow Failure: “Illegal user input query...”

Just sharing this minor issue, I encountered, and how to resolve it.

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"