XQE-GEN-0005 Found an internal error:

[highwingers]

Hello all I have this error message from a CQM to DQM report in Cognos 11
XQE-GEN-0005 Found an internal error:
Encountered "=" at line 16, column 11.
Was expecting one of:
    <EOF>
    "/*+" ...
    "[" ...
    "??(" ...
    "*" ...
    "+" ...
    "-" ...
    "." ...
    "/" ...
    "||" ...
    "and" ...
    "except" ...
    "fetch" ...
    "filter" ...
    "intersect" ...
    "limit" ...
    "or" ...
    "order" ...
    "union" ...
    "window" ...
    "order" ...


Any idea how to resolve this in report studio

[CognosPaul]

DQM is extremely strict in how queries are built when compared to CQM. The error indicates that an expression has an equal sign in an unexpected place. My gut instinct would be to check filters. Do you have an if or a case with the filter inside the then clause?

[highwingers]

Hey CognosPaul,
I tried to look for that equal sign myself but couldn't find anything. Still don't know whats causing this issue

[CognosPaul]

Any embedded filters in the model? Data security? Can you narrow down the error to a specific data container?

My usual technique is to delete half the report and rerun. If it runs, undo and delete the other half. If it still fails delete half of the remaining objects. Repeat until the only thing left is what's failing.

[highwingers]

Thank you for the suggestion!
I will try that