COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Avi on 08 Jul 2020 06:06:21 AM

Title: Cognos reprompt issue
Post by: Avi on 08 Jul 2020 06:06:21 AM
Hi Everyone,

We have been facing an issue with one of our prompts.
The prompt selections are like this

org status: active/inactive
type: prod/test
org : List of orgs

The organization prompt (List) which will be populated with thousands of records with default selection (ALL) for status and type prompts.
The prompt page loads fine when the report is run. But when the user makes any selection from above 2 and clicks Reprompt the below error occurs
RQP-DEF-0177  An error occurred while performing operation 'sqlOpenResult' status='-237'.

Attached screen for details.
Thanks in advance.