BAQ error in 10.2.500.14

We tested a migration from Epicor 9 to 10.2.500.14. All BAQs are “pass” in the conversion workbench. However, when we are trying to open any existing BAQ, we got the error: **Unsupported SQL type: ‘character’ **. We can still click on OK button to open the BAQ and make some changes but give the same error when trying to save.

image

I am not sure what we are missing or have done something not right. Hope someone can give us some ideas.

When you open up the BAQ
Review the pseudo code - maybe find something there?
If not - comment out /* */ the formulas on the calculated fields and replace with fixed value one by one?