BBDW_FACT_FINANCIALTRANSACTIONLINEITEMSITE.dtsx package can take a long time to complete

For databases with a large number of SITE records (n=100 or more), the 4.0 delivered BBDW_FACT_FINANCIALTRANSACTIONLINEITEMSITE.dtsx can take a very long time to complete when performing a Blackbaud Data Warehouse ETL refresh.
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.

Steps to Duplicate

You can see if you are impacted by running the following query against your CRM (OLTP) database:
select count(*) from SITE

Environment

 Blackbaud CRM
 4.0
 4.0
 Patch 9
 4.0.138.2

Was this article helpful?