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.