Data lists which pull data from the data warehouse no longer function after copying a database to another SQL Server

After copying a database to another SQL Server, data lists no longer function if their query is set to pull data from the data warehouse. The error received is: "Unable to load data list. Could not find stored procedure 'USP_DATALIST_ADHOCQUERY_...'
We are currently evaluating this issue for a fix in a future service pack.

Steps to Duplicate

1. Create a user defined data list using any of the ‘from blackbaud datawarehouse’ query views
2. Put that data list on a section on any page
3. Backup the database and move it to another SQL Server
4. Redeploy and Refresh BBDW
5. Go to the page the data list was put on and notice the error.

Environment

 Blackbaud CRM
 4.0
 4.0.170

Was this article helpful?