If you are unable to create a new account, please email bspsoftware@techdata.com

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

Offline Samrat

  • Full Member
  • ***
  • Join Date: May 2014
  • Posts: 27
  • Forum Citizenship: +0/-0

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??


Offline bus_pass_man

  • Statesman
  • ******
  • Join Date: May 2008
  • Posts: 541
  • Forum Citizenship: +48/-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,822
  • Forum Citizenship: +106/-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.