Error: An error occurred before executing the process: 'Data Warehouse Start ETL Refresh Job Business Process': After Successful ETL refresh

After taking steps to redeploy the Blackblaud Data Warehouse, reset the ETL and an ETL refresh for the CRM environment. The ETL is successful but an Error occurs. 

Error: An error occurred before executing the process 'Data Warehouse Start ETL Refresh Job Business Process': Unable to generate attribute query views after the ETL completed: A .NET Framework error occurred during execution of user-defined routine or aggregate "USP_LOADSPEC": System.Exception: The MartKey for BOA - Main Line does not match the MartKey for related view V_QUERY_BBDW_DATE. Related views must have the same MartKey. System.Exception: at Blackbaud.AppFx.Platform.SqlClr.QueryViewSpecProcessor.ProcessRelationships(QueryViewSpec spec, Nullable'1 changeAgentID) at Blackbaud.AppFx.Platform.SqlBoolean processPageAlterations) at Blackbaud.AppFx.Platform.SqlClr.LoadSpec.LoadSpecInternal(String specTypeName, String specXmlText, SqlString itemName, Nullable'1 changeAgentID, SqlString sourceName, SqlString itemName, SqlBoolean loadAsDependency, SqlBoolean forceReload,SqlBoolean processPageAlterations, SqlBoolean skipValidation, SqlBoolean compareToExistingSpecXml) at Blackbaud.AppFx.Platform.SqlClr.LoadSpec.LoadSpec (SqlXml specXml, Nullable'1 changeAgentID, SqlString sourceName, SqlString itemName, SqlBoolean loadAsDependency, SqlBoolean forceReload, SqlBoolean processPageAlterations, SqlBoolean skipValidation, SqlBoolean compareToExistingSpecXml). LOADSPEC ERROR: The MartKey for BOA - Main Line does not match the MartKey for related view V_QUERY_BBDW_DATE. Related views must have the same MartKey. 
 
We are currently evaluating this issue for a fix in a future service pack.

Steps to Duplicate

1. Redeploy BBDW
2. Go into CRM Environment
3. Click the Administration tab
4. Click Data Warehouses
5. Click Blackbaud Data Warehouse
6. Click Reset ETL
7. Click Start ETL Refresh
8. ETL refresh Successful
9. Error: An error occurred before executing the process: 'Data Warehouse Start ETL Refresh Job Business Process':

Environment

 Blackbaud CRM
 4.0
 4.0.168.0

Was this article helpful?