Question

0

Upgrading to 4.0 Failing

Andrew Lee posted 8 Years Ago

When upgrading from 3.5 to 4.0 the update seems to run successful. We are given an all green with the option to restart. Once we restart the Rock never comes back. We are given this error when launching the website.

The index 'idx_DCh_14853_14852_PageView' is dependent on column 'UserAgent'.
ALTER TABLE DROP COLUMN UserAgent failed because one or more objects access this column.

Thank you!

Andrew

0
- David Turner replied 8 Years Ago
Andrew, When you restart, Rock is attempting to run all the migrations to convert your database to be in sync with the version of software just installed. One of the migrations for v4.0 is to consolidate the UserAgent value on the PageView table into its own table and then remove that column from the DateView table (to save db space). It looks like you have an index on that table that was not added by Rock and that is preventing Rock from removing that column. Are you able to drop that index manually using SQL Server Management Studio
Edit Answer

Andrew, When you restart, Rock is attempting to run all the migrations to convert your database to be in sync with the version of software just installed. One of the migrations for v4.0 is to consolidate the UserAgent value on the PageView table into its own table and then remove that column from the DateView table (to save db space). It looks like you have an index on that table that was not added by Rock and that is preventing Rock from removing that column. Are you able to drop that index manually using SQL Server Management Studio
Andrew, When you restart, Rock is attempting to run all the migrations to convert your database to be in sync with the version of software just installed. One of the migrations for v4.0 is to consolidate the UserAgent value on the PageView table into its own table and then remove that column from the DateView table (to save db space). It looks like you have an index on that table that was not added by Rock and that is preventing Rock from removing that column. Are you able to drop that index manually using SQL Server Management Studio
Andrew, When you restart, Rock is attempting to run all the migrations to convert your database to be in sync with the version of software just installed. One of the migrations for v4.0 is to consolidate the UserAgent value on the PageView table into its own table and then remove that column from the DateView table (to save db space). It looks like you have an index on that table that was not added by Rock and that is preventing Rock from removing that column. Are you able to drop that index manually using SQL Server Management Studio
Save Cancel