Cognos reprompt issue

[Avi]

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.