DPR-ERR-2014 Unable to load balance the request because no nodes in the cluster are available

by ·0 Comments

Product:
Cognos BI 10.1.x
Microsoft Windows 2012 R2 Server

Symptom:
Random error when running reports, run GO OFFICE reports, or try to open the report in Report studio. 4 of 5 times you try it fails. It looks like it is only reports with charts that fails most.
This is a multi-server setup with 4 Cognos BI servers on Microsoft Windows machines.

Error message:
Failure RSV-SRV-0066 A soap fault has been returned.
DPR-ERR-2014 Unable to load balance the request because no nodes in the cluster are available, or no nodes are configured for the service: null
The expected response was not returned by IBM Cognos 8

Solution:
Ensure that all the Cognos BI servers are healthy.
Surf to the system tab in Cognos Connection, and check that all servers are Available.
Go to System Administration.
Click on System in left column.
In the middle all Cognos BI server should be listed.
If one is shown as UNKNOWN – you probably need to do a restart of all servers.

Perform a restart of all the Cognos BI servers in correct order;

Primary Cognos Content Manager server. (Wait until the Cognos service is up before you do the next step. It is not enough to see that the Windows server answers on ping.)
Cognos Gateway server.
Cognos Reporting server.

More information
http://www.cognoise.com/index.php?topic=13924.0