COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: Desperado on 27 Jul 2007 11:36:14 AM

Title: strange error using value prompt
Post by: Desperado on 27 Jul 2007 11:36:14 AM
Hi , i'm creating  a  value prompt . but i'm getting a strange error ....
the prompt was created on receivable type column which is a char field ...
I just seleccted the column , from the list and built the prompt page . when i run the report , i got this error.

RQP-DEF-0177

An error occurred while performing operation 'sqlOpenResult' status='-28'.

it's working for every other query item ....
I'm getting this error for this item only.

Can anyone tell me y i'm getting this error and how to solve it ....

Thanks in advance

Title: Re: strange error using value prompt
Post by: Desperado on 30 Jul 2007 07:48:56 AM
Okay , i fuigure it out ... it's some oracle error .. I'm in hte process of solving it .