Error while validating filter in FM

[Samrat]

Hi folks,
I am getting following error: "XQE-DAT-0001 Data source adapter error: java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected"


while validating Framework manager filter condition :  tablename.ordertype_code in ('OP01', 'OP02', 'OP03', 'OP09')

I don't see any syntax error in condition but expression is failing to validate.

condition tablename.ordertype_code in ='OP01' is validating correctly..

Any help??


Thanks
SM

[Michael75]

condition tablename.ordertype_code in ='OP01' is validating correctly

Bit of a wild guess here, but try a semi-colon as your separator:

Code Select Expand

tablename.ordertype_code in ('OP01'; 'OP02'; 'OP03'; 'OP09')

On a handful of occasions, and at different sites, I got syntax errors because the comma that I usually used as separator was no longer accepted. No changes to PC locale or whatever had been made, it was just what Cognos chose to accept on those particular occasions.