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
Quotecondition tablename.ordertype_code in ='OP01' is validating correctly
Bit of a wild guess here, but try a semi-colon as your separator:
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.