Error: The Lookup Marketing Source Code encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.

When refreshing the ETL Blackbaud Data Warehouse, it fails and produces this Error: The Lookup Marketing Source Code encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
We are currently evaluating this issue for a fix in a future service pack. 

Steps to Duplicate

1. Click Administration tab
2. Click Data Warehouses
3. Click Start ETL refresh
4. ETL refresh failed
5. Download Status Log
6. Error in Status Log - Description: The Lookup Marketing Source Code encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.

Environment

 Blackbaud CRM
 4.0
 4.0.168.0

Was this article helpful?