If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report Studio: rqp-def-0177 'sqlpreparewithoptions' status '-9'

Started by kiran_cognoise, 10 Dec 2011 07:54:41 AM

Previous topic - Next topic

kiran_cognoise

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.

HalfBloodPrince