Sense we have upgraded from 11.1 to 11.2 we are unable to run any reports. The error message is saying DPR-ERR-2072 Unable to load balance a request with absolute affinity, most likely due to a failure to connect to the remote dispatcher. The error message is misleading because there is nothing wrong with the dispatchers. We are on a single install for Analytics. The problem seems to be with the SSO. Has anyone had any problems with going to 11.2?
Quote from: ewent@rwu.edu on 07 Mar 2022 01:03:03 PM
Sense we have upgraded from 11.1 to 11.2 we are unable to run any reports. The error message is saying DPR-ERR-2072 Unable to load balance a request with absolute affinity, most likely due to a failure to connect to the remote dispatcher. The error message is misleading because there is nothing wrong with the dispatchers. We are on a single install for Analytics. The problem seems to be with the SSO. Has anyone had any problems with going to 11.2?
Hi,
This sounds similar to another poster's issue that came up recently in this forum. In that case, it turned out the Query Service was failing to start, and they were using Dynamic Query Mode, so none of their reports would run. This is the first thing I'd check - look in cognosserver.log to see if there are any errors being returned about the Query Service. In the case of the other poster, it looked like their security team had tried to implement a manual fix for the Log4J vulnerability and messed up an XML file the Query Service needs - so it wouldn't start.
Here's a link to the other post: https://www.cognoise.com/index.php/topic,37496
Cheers!
MF.