When creating or editing any ad-hoc query, all users are kicked out of the application

When creating or editing any type of ad-hoc query, the w3wp.exe process (application pool) is recycled and all users are kicked out of the application.  This only occurs when using MS .NET Framework 4.0 on the servers while selecting to include selections for the BBDW refresh process. 
Download and install the latest patch which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.

Alternative Solution:
  • Update Microsoft .NET Framework to v4.5 on the servers. 
  • Temporarily disable the BBDW process from including selections.
  1. Browse to the following location from your database server: \\WEBSERVERNAME\Blackbaud\INSTALLNAME\bbappfx\MSBuild\Datamarts\bin
  2. Select the Blackbaud.AppFx.ReportDB.Installer application
  3. Click 'Edit Advanced Settings' and change the Include Selections option from True to False
  4. Redeploy the BBDW

The .NET upgrade solution will resolve the issue with the application pool recycling and kicking users out although you may still encounter errors when saving queries. 
Using both of the above solutions should resolve all issues.

Steps to Duplicate

  1. Go to the Analysis functional area
  2. Select Information Library
  3. Select Create ad-hoc query
  4. Select Constituents (but can be any)
  5. Add filter Age>30
  6. Output Name
  7. Preview results
  8. Observe error

Environment

 Blackbaud CRM
 4.0
 4.0
 Service Pack 4

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.