Author Topic: Error while validating Multi value prompt macro in cognos Framework manager  (Read 543 times)

Offline Samrat

  • Full Member
  • ***
  • Join Date: May 2014
  • Posts: 26
  • Forum Citizenship: +0/-0
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

Offline bus_pass_man

  • Community Leader
  • *****
  • Join Date: May 2008
  • Posts: 239
  • Forum Citizenship: +30/-0
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?

Offline bdbits

  • Super Moderator
  • Statesman
  • ******
  • Join Date: Feb 2010
  • Posts: 1,781
  • Forum Citizenship: +104/-0
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.

 


       
Twittear