RQP-DEF-0177,'sqlOpenResult' status='-28'. DPR-ERR-2082 An error has occurred

[JOELIU]

Hello everyone,

I am a new user of the Cognos 8, built one query in report studio, and the query passed the validation; however once I start to run it, the query fails with the below message:

RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'. DPR-ERR-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2009-10-22-15:24:27.526-#49

Could anyone please help with this? Thanks in advance.

[blom0344]

Report validation does not imply all queries are checked!
An SQL error will usually be displayed with more details following (open details below the first lines) . You may need to check the cognos server log for more info

[RubenvdLinden]

-28 errors are often inconsistent datatypes, e.g. a filter condition where you specify a number while the database expects a string or a mismatch of datatypes in a join condition between queries.

To track down the error in a multi-query report, I always use the 'View Tabular Data' option on each query
until I find the query with the problem.