An error occurred while performing operation 'sqlPrepareWithOptions'status='-120

[Sarayucog]

Hi Gurus,

I am using Cognos 8.4 Version. I have a report with 5 prompts. In that first 3 prompts are Cascading pormpts. Report is running fine, but when I am selecting the value in 2nd prompt I am getting the below error.

An error occurred while performing operation 'sqlPrepareWithOptions' status='-120'.

Could you please tell me the solution for this.


Thanks in advance
Sarayu

[PRIT AMRIT]

Looks like this error due unsupported SQL... are using any SQL function like Distinct or something else not supported by COGNOS?

Can you try enabling Query Procession to 'limited Local' for the Prompt Query?

Thanks
P