Error deploying the Data Warehouse when deploying against an existing Data Warehouse from SP16 on SQL Server 2012.

An error occurred while executing a service revisions. ALTER TABLE statement failed because the definition of a column cannot be changed if the column is part of a columnstore index. Consider dropping the columnstore index, altering the column, then creating a new columnstore index. Revision text: alter table [BBDW].[FACT_SOLICITCODECHANNELOPTOUT] alter column [SOLICITCODECHANNELOPTOUTCONSENT] [nvarchar](16) null; when deploying the data warehouse against an existing data warehouse from SP16 on SQL Server 2012
We're currently evaluating this issue for a fix in a future patch or service pack.

*****************************************************
Primary Workaround:
Delete the existing BBDW database and deploy a new BBDW.

Secondary Workaround:
Drop the columnstore index, deploy against the existing BBDW database, and re-add the columstore index once the deploy is complete. 
 

Steps to Duplicate

Steps to duplicate:
1. Attach a 4.0 SP15, patch 63 database on SQL 2012.
2. Deploy the BBDW.
3. Run an ETL refresh.
4. Upgrade the CRM database to 4.0 SP16, HF 1604 (or SP16 without the HF would work as well).
5. Redeploy the BBDW against the existing BBDW.
6. Receive the error: An error occurred while executing a service revisions. ALTER TABLE statement failed because the definition of a column cannot be changed if the column is part of a columnstore index. Consider dropping the columnstore index, altering the column, then creating a new columnstore index. Revision text: alter table [BBDW].[FACT_SOLICITCODECHANNELOPTOUT] alter column [SOLICITCODECHANNELOPTOUTCONSENT] [nvarchar](16) null;
 

Environment

 Blackbaud CRM
 4.0
 4.0.180.1605

Was this article helpful?