Pledge Status Report Hangs (Freezes, Stops, Locks) in The Raiser's Edge

When running the Pledge Status Report, The Raiser's Edge freezes on me. Why does the Pledge Status Report hang? Are there special steps to take to run the Pledge Status Report? 
The Pledge Status Report is one of the most complex reports that The Raiser's Edge produces. Due to the many calculations this report does, it can take longer to run than other reports based the report settings, number of records in the report, and/or available network resources. 

Try each of the following steps to resolve the issue:
  1. Allow the process time to complete:
    • Try running the report after hours, overnight, or when few users are logged in. 
    • If Blackbaud does not host your Raiser's Edge, try running the report directly on the Raiser's Edge server.** 
    • If Blackbaud hosts your Raiser's Edge, run the report under a non-supervisor user. (Note: If the report hangs, be sure to manually log off to end the session.)
  2. Consider the number of records being included and how much data is calculated per record. Users reporting unexpected changes in processing time can test potential record corruption or database issues by re-running the same report and only including 1-10 records. If the report completes in a reasonable timeframe attempt to re-run the full report parameters over a longer period of time.
  3. If your Pledge Status report is set to output all constituent records, split it into multiple smaller reports.  For example, create one report that only pulls constituent last names A through M and a second that pulls constituent last names N through Z.
  4. When filtering on one specific campaign, some users report the process hangs significantly. However, other campaigns and other groups of gifts run with no delay.
  5.  Run SQL Server database maintenance.**
  6. If using a full version of SQL Server 2008. 2008 R2, 2012. or 2014, make sure it has been prepared for use with Blackbaud databases.**
  7. Upgrade to the latest patch and version.**

**NOTE: Some troubleshooting steps, such as database maintenance, are specific to customers whose Raiser's Edge is not hosted by Blackbaud. 


 Raiser's Edge

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.