IBM Cognos: Error message RQP-DEF-0177 when run Cognos report
Error message RQP-DEF-0177 happens if a dataset is not available for report. This dataset can be a database or a web service.
In details we have:
UDA-SQL-0528 The XML parser returned the following message: "General XMLParser Error!".UDA-SQL-0196 The table or view "XXXXXX_XXX" was not found in the dictionary.RQP-DEF-0149 The query specification is incorrect.RQP-DEF-0457 Referenced Query 'Q_XXXXXX' is not defined or its query items contain unresolved references
In my customer, these happened 3 times because Cognos cannot connect to the web service, in the following situations:
- one of the Cognos server was using a wrong load balancer defined at /etc/hosts.
- one of the Cognos server don't have a route to backend service
- Customer changes the TLS certificate of web service and signed with a private CA, that was not available on trusted CA of file carcerts.
Checking connection on Cognos Administration -> Configuration tab -> Data Source Connections -> <conection> -> Test Connection. I received the following error:
DPR-ERR-2072 Unable to load balance a request with absolute affinity, most likely due to failure to connect to the remote dispatcher. See remote dispatcher detailed logs for more information. Check the health status of the installed system by using the dispatcher diagnostics URIs.