I am working on a report where Employee ID is used as a filter. The query is running fine when few employees are selected while viewing tabular data. When I select more employees (>100) or all employees it is returning error rqp-def-0177 'sqlpreparewithoptions' status '-9'. This is happening with all queries in the report which has employee ID as filter. I don't have access to FM as it is owned by business. Request you to please comment on the probable cause. Its very annoying as it is happening only with employee id. The unique count of employee id is 90,000. Kindly respond.
Please add the complete error message.