ETL Refresh Error:A duplicate attribute key has been found when processing: Table: BBDW_DIM_INTERACTION, Column: INTERACTION

 After upgrading to 4.0.158 from 4.0.157 the ETL refresh is failing with the error “Source: Analysis Services Processing Task Analysis Services Execute DDL Task
  Description: Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'BBDW_DIM_INTERACTION', Column: 'INTERACTIONSTATUSCODE', Value: '4'. The attribute is 'Interaction Status'.”

 
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

1. Navigate to the data warehouse.
2. Start the ETL refresh.
3. Note the error.

 

Environment

 Blackbaud CRM
 4.0
 4.0
 Service Pack 9
 4.0.158

Was this article helpful?