Error: The underlying connection was closed - when running revenue reports

When running any revenue report, users may receive the following error:

The underlying connection was closed: An unexpected error occurred on a receive. 
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
An existing connection was forcibly closed by the remote host.

We are currently evaluating this issue and will update this article when we have more information.

There may be a correlation between this error message and blocking on the SQL server.  If you host your own CRM database, contact support and provide SQL Snaps and a Fiddler trace from the time the report was ran. Instructions on capturing a Fiddler trace can be found in Blackbaud Know How article "Troubleshooting Tools: SQL Snaps, FiddlerCap, and More."  If Blackbaud host your CRM database, please contact support and provide a Fiddler trace taken while running the report, along with answers to the the following questions.

1. What time was the report run?
2. Can this error message be reproduced consistently?
3. Were there any scheduled queues or business processes running during the time you received the error?
4. Which Revenue report are you running?

Environment

 2.9.1001.128

Was this article helpful?