Reports filtered by dynamic queries hang after updating SQL Instance to Microsoft SQL Server 2008 R2

The Raiser's Edge hangs when running certain reports that are filtered using a dynamic query after updating to a Microsoft SQL Server 2008 R2 instance.
Download and install the latest version and patch, if applicable. 

OR

If you are filtering Total Summary Amounts for Gifts using a dynamic query:
  1. Convert the dynamic query to a static query
  2. Set the static query to be refreshed on a nightly basis through the Queue Module,

Environment

 7.91.5056.29
 7.93.5782

Was this article helpful?