Revenue Dynamics smart query hangs and does not complete

The Revenue Dynamics smart query does not complete, it hangs with the Loading message indefinitely without rendering any results regardless of what criteria is selected. This occurs when previewing results and saving any changes.
Download and install the latest service pack, which contains all fixes from previous service packs. If you are running an older version, download and install the latest version and then the service pack. 

Steps to Duplicate

1. Go to Analysis\Information Library
2. Click on the button to Add a smart query
3. Select the Revenue dynamics source view under Constituent
4. For Previous period select Last Fiscal year
5. For This period select This Fiscal year
6. In status check the box for Upgraded (gave more in this period than gave in previous period)
7. In Revenue filters\Revenue types select the check boxes for Gift, Pledge, Recurring gift payment, Event registration fee and aunction purchase. Leave Designation and Campaigns blank.
8. In the Set save options tab, select All sites, Create a selection\Create a static selection\Allow other users to modify this query.
9. Save changes, see hang occur
10. After changes save if they are able to be, go back into the query and click on the Results tab, and see hang occur there, results never load.  This also occurs if you click on the yellow bar that says "Click here to process the query and view the results" on the smart query without actually going into it to preview results as well.


 

Environment

 Blackbaud CRM
 4.0
 4.0
 Service Pack 8
 4.0.141.14 SP3

Was this article helpful?