Problem
When clicking the re-prompt button in a set of cascading prompts, the re-prompt fails with an error for some users
Symptom
RQP-DEF-0177 An error occurred while performing operation ‘sqlPrepareWithOptions’ status=’-205’.
UDA-SQL-0191 The column “CUST_ID” was not found in the table or view “CUSTOMER”.
Cause
The framework manager object level security is too restrictive.
Solution
Ensure that all the users have sufficient object level security on the relevant query subjects in Framework Manager model.