The ETL refresh is taking several hours to complete the BBDW.FACT_FINANCIALTRANSACTIONLINEITEM step

After deploying the data warehouse you may notice the step that transmits all of the Financial Transaction line item information during the incremental refresh information into the data warehouse database takes several hours to complete.
We're currently evaluating this issue for a fix in a future patch or service pack.  

Steps to Duplicate

1. Log into the database
2. Go to Adminstration > Data Warehouse
3. Start the ETL refresh
4. The BBDW.FACT_FINANCIALTRANSACTIONLINEITEM takes over 4 hours to run

Environment

 Blackbaud CRM
 3.0

Was this article helpful?