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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.