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.
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
-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.