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?


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.