Performance Issues in Export When Filtering On A Specific Campaign

When exporting from Raiser's Edge, if filtering gift information on a specific Campaign, the export takes numerous hours to process.
This is resolved in 7.96, patch 12, released in July-August 2018 and applied to databases in Blackbaud Hosting Services. If your database is installed locally, download and install the latest version and patch, if applicable.

Steps to Duplicate

  1. Login to RE
  2. Click On Export from the left side toolbar
  3. Click on the REMINDERS folder
  4. Open the "REMINDER Monthly" parameter file
  5. Highlight the Gifts option on the Outputs tab and click Criteria down at the bottom of the screen
  6. On the Filters tab, notice that the gift fields are filtered by the Campaign "17 Moved by Faith"
  7. Follow Steps 5-6 for the Last Gift set of fields as well and notice the same campaign is filtered.
  8. Click Export Now
  9. Notice the process will take over 5 hours
  10. Repeat Steps 5-6 for both the Gifts and Last Gifts fields and change the campaign to any other campaign
  11.  Run the export again and it will take 5-10 minutes

Environment

 Raiser's Edge
 7.96
 7.96
 12

Was this article helpful?