QE-DEF-0030 Expression parsing in cognos 10.2

[84gopi]

Hi,

I am using overriding SQL in my report studio and does not any filter or anything in the report.

When I run the report i am getting below error

QE-DEF-0030 Expression parsing.

Can you please advise ASAP.

Thanks
Gopi

[BigChris]

The problem is that you got something wrong in your SQL.

[Michael75]

The second problem is that you shouldn't really be using SQL in your report.

[bdbits]

Actually, that's backwards. The first problem is using SQL in the report.   ;D

Was there a reason you used SQL? Is there something you did not know how to do with a package? I have found very, very few reasons to drop down to coding SQL for Cognos, and even then I normally encapsulate it into a database view and use that as a query subject in FM. Perhaps we can solve your original problem and skip the SQL altogether.

The error is generic but means the SQL was not seen as valid SQL. Copy and paste it into your native database query tool and see if that provides more information. If you insist on using the SQL and want help with that, you'll need to specify what database and version you are using. Then post the SQL here and hope someone can see the error.

[cognostechie]

The third problem is that you are not trying to understand what's going in the report and simply posting it here hoping somebody would magically help you out  ;D

[BigChris]

I think magically is the operative word there - take a look at point 1 in the forum etiquette and I think you'll see that it pretty much describes your question...