BBDW PackageList dependencies

Mitchell Gibbs

We're trying to use the parallel processing capabilities that Blackbaud built into the ETL process for OOB packages by adjusting the number of lanes it can use, changing olapdatasource.etlmaxparallelism.


However, we're running into occasional deadlocks. Since troubleshooting deadlocks is dependent on the deadlocks first happening and they don't happen every time, it's a pretty frustrating thing. Has anyone else worked through this and, if so, do you have any recommendations?


So far we've identified that we needed to add a line to Blackbaud's BBDW_PackageList.txt file to make BBDW_FACT_RECURRINGGIFTINSTALLMENT dependent on BBDW_FACT_FINANCIALTRANSACTIONLINEITEMSITE. Those ETLs are not trying to change the same tables, but they both have merge statements joining to FACT_FINANCIALTRANSACTIONLINEITEM, which seems to be the source of the deadlocks.


Thanks!


Mitch