BBDW_RPT_GIVINGLISTDETAIL ETL package takes a long time to complete

When running an ETL refresh, the package 'BBDW_RPT_GIVINGLISTDETAIL' may take a long time to complete.
We are currently evaluating this issue for a fix in a future service pack.


 

Steps to Duplicate

1. Navigate to Administration>Data warehouses>Blackbaud Data Warehouse.
2. Under 'Refresh data' select 'Start ETL refresh'.
3. Notice that it may take 20 hours to complete the 'BBDW_RPT_GIVINGLISTDETAIL' package.

Environment

 SQL Server 2014
 Blackbaud CRM
 4.0
 4.0.166.0

Was this article helpful?