Error: An error occurred while executing a service revision. Revision text: alter table BBDW.[DIM_EVENT] alter column [EVENTSTATRTTIME] dbo.[UDT_HOURMINUTE] - when upgrading a data warehouse

When attempting to upgrade an existing data warehouse, users may receive the error:

An error occurred while executing a service revision. Revision text: alter table BBDW.[DIM_EVENT] alter column [EVENTSTATRTTIME] dbo.[UDT_HOURMINUTE].
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. 

Workaround: Rather than attempt to upgrade the existing data warehouse, deploy a new one and refresh it.

Environment

 3.0.516, patch 8
 3.0.516, patch 14

Was this article helpful?