COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Framework Manager => Topic started by: Samrat on 01 Sep 2016 02:28:59 pm

Title: Error while validating Multi value prompt macro in cognos Framework manager
Post by: Samrat on 01 Sep 2016 02:28:59 pm
Hi,

I am trying to validate below condition in cognos FM 11 againist DB2 datasource.

[table name].[Filed name] in  (#Promptmany('Enter Premise Nbr(s) or % for All:','string','[table name].[Filed name]')#)

I am getting below error

"XQE-DAT-0001 Data source adapter error: com.ibm.db2.jcc.am.SqlSyntaxErrorException: ILLEGAL SYMBOL "(". SOME SYMBOLS THAT MIGHT BE LEGAL ARE:"

any help??

Thanks,
SM
Title: Re: Error while validating Multi value prompt macro in cognos Framework manager
Post by: bus_pass_man on 27 Sep 2016 06:55:28 pm
That error is coming from DB2.  It doesn't like one of the ( symbols in your expression.

Just eyeballing the expression doesn't have anything that leaps out and shouts boo.   The ( in Nbr(s) in the title might be clearing its throat, though.

If you replaced Nbr(s) with some string without the brackets do you get the error?
Title: Re: Error while validating Multi value prompt macro in cognos Framework manager
Post by: bdbits on 28 Sep 2016 10:37:15 am
Another idea - Prompt macros can sometimes generate odd/misleading error messages if a problem occurs during prompt resolution. So, I would suggest renaming the prompt title to something a bit more ordinary, just a simple string, and see if the error goes away. If it does, add your punctuation back in one at a time until the error show up again.