upgrade from 4.1 to 4.2 Failed

6 months ago
So, as title states i get there following error when trying to upgrade from 4.1 - 4.2:

EDIT: site is working, it seems without any errors, still i wouldn't really want to let it go live if there was an error during upgrade

Msg 5074, Level 16, State 1, Line 2272
The statistics '_dta_stat_821577965_15_18' is dependent on column 'CreatedOnUtc'.
Msg 5074, Level 16, State 1, Line 2272
The statistics '_dta_stat_821577965_1_18' is dependent on column 'CreatedOnUtc'.
Msg 5074, Level 16, State 1, Line 2272
The statistics '_dta_stat_821577965_18_14_1' is dependent on column 'CreatedOnUtc'.
Msg 5074, Level 16, State 1, Line 2272
The statistics '_dta_stat_821577965_1_15_18' is dependent on column 'CreatedOnUtc'.
Msg 4922, Level 16, State 9, Line 2272
ALTER TABLE ALTER COLUMN CreatedOnUtc failed because one or more objects access this column.
Msg 5074, Level 16, State 1, Line 2382
The index '_dta_index_Product_7_178099675__K11_K98_K99_K1_K97_K5_2_3_4_6_7_8_9_10_12_13_14_15_16_17_18_19_20_21_22_23_24_25_26_27_28_29_' is dependent on column 'CreatedOnUtc'.
Msg 4922, Level 16, State 9, Line 2382
ALTER TABLE ALTER COLUMN CreatedOnUtc failed because one or more objects access this column.
Msg 5074, Level 16, State 1, Line 2393
The index '_dta_index_QueuedEmail_7_658101385__K17_K18_K2_K16_1_3_4_5_6_7_8_9_10_11_12_13_14_15_19' is dependent on column 'CreatedOnUtc'.
Msg 5074, Level 16, State 1, Line 2393
The statistics '_dta_stat_658101385_2_16_17' is dependent on column 'CreatedOnUtc'.
Msg 4922, Level 16, State 9, Line 2393
ALTER TABLE ALTER COLUMN CreatedOnUtc failed because one or more objects access this column.
Msg 5074, Level 16, State 1, Line 2489
The index '_dta_index_Product_7_178099675__K11_K98_K99_K1_K97_K5_2_3_4_6_7_8_9_10_12_13_14_15_16_17_18_19_20_21_22_23_24_25_26_27_28_29_' is dependent on column 'UpdatedOnUtc'.
Msg 4922, Level 16, State 9, Line 2489
ALTER TABLE ALTER COLUMN UpdatedOnUtc failed because one or more objects access this column.
Msg 5074, Level 16, State 1, Line 2574
The index '_dta_index_Product_7_178099675__K11_K98_K99_K1_K97_K5_2_3_4_6_7_8_9_10_12_13_14_15_16_17_18_19_20_21_22_23_24_25_26_27_28_29_' is dependent on column 'PreOrderAvailabilityStartDateTimeUtc'.
Msg 4922, Level 16, State 9, Line 2574
ALTER TABLE ALTER COLUMN PreOrderAvailabilityStartDateTimeUtc failed because one or more objects access this column.
Msg 5074, Level 16, State 1, Line 2591
The index '_dta_index_Product_7_178099675__K11_K98_K99_K1_K97_K5_2_3_4_6_7_8_9_10_12_13_14_15_16_17_18_19_20_21_22_23_24_25_26_27_28_29_' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The index '_dta_index_Product_7_178099675__K98_K2_K99_K78_K95_K96_K20_K21_K1_75' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The index '_dta_index_Product_7_178099675__K98_K99_K78_K95_K96_K20_K21_K1_75' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The index '_dta_index_Product_7_178099675__K98_K2_K99_K95_K96_K20_K21_K1_78' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The index '_dta_index_Product_7_178099675__K98_K99_K95_K96_K20_K21_K1_78' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The index '_dta_index_Product_7_178099675__K96_K1_K99_K98_K3_K4_K95_K20_K21' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The index '_dta_index_Product_7_178099675__K1_K95_K99_K96_K98_K20_K21' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_95_96_98_20' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_95_99_96_98' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_95_96_20_99_2' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_1_2_99_95_96' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_1_95_96_98_20' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_1_99_78_95_96' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_99_95_96_20_21' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_3_1_99_98_95' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_20_1_98_99_95' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_4_1_99_98_95_96' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_1_2_99_78_95_96' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_99_98_1_95_96_20' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_20_1_98_2_99_95' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_20_1_98_99_78_95' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_95_3_4_96_98_20' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_99_78_95_96_20_21' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_2_99_95_96_20_21' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_21_1_98_99_78_95_96' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_1_98_2_99_95_96_20' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_99_1_98_78_95_96_20' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_2_99_78_95_96_20_21' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_20_1_99_98_3_4_95' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_21_1_98_2_99_95_96' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_1_95_96_78_20_99_21' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_1_95_3_4_96_98_20' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_20_1_99_98_95_96_3' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_21_1_98_99_95_96_20' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_20_1_98_2_99_78_95' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_95_96_78_20_99_2_1_21' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_99_98_3_4_95_96_20_21' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_21_1_98_2_99_78_95_96' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_1_95_96_20_99_2_21_98' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_21_1_99_98_3_4_95_96' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_98_1_99_3_4_95_96_20_21' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2591
The statistics '_dta_stat_178099675_98_1_2_99_78_95_96_20_21' is dependent on column 'AvailableStartDateTimeUtc'.
Msg 4922, Level 16, State 9, Line 2591
ALTER TABLE ALTER COLUMN AvailableStartDateTimeUtc failed because one or more objects access this column.
Msg 3701, Level 11, State 7, Line 2598
Cannot drop the index 'Product.IX_Product_PriceDatesEtc', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 2599
Cannot drop the index 'Product.IX_Product_VisibleIndividually_Published_Deleted_Extended', because it does not exist or you do not have permission.
Msg 5074, Level 16, State 1, Line 2600
The index '_dta_index_Product_7_178099675__K11_K98_K99_K1_K97_K5_2_3_4_6_7_8_9_10_12_13_14_15_16_17_18_19_20_21_22_23_24_25_26_27_28_29_' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The index '_dta_index_Product_7_178099675__K98_K2_K99_K78_K95_K96_K20_K21_K1_75' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The index '_dta_index_Product_7_178099675__K98_K99_K78_K95_K96_K20_K21_K1_75' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The index '_dta_index_Product_7_178099675__K98_K2_K99_K95_K96_K20_K21_K1_78' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The index '_dta_index_Product_7_178099675__K98_K99_K95_K96_K20_K21_K1_78' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The index '_dta_index_Product_7_178099675__K96_K1_K99_K98_K3_K4_K95_K20_K21' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The index '_dta_index_Product_7_178099675__K1_K95_K99_K96_K98_K20_K21' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_95_96_98_20' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_95_99_96_98' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_95_96_20_99_2' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_1_2_99_95_96' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_1_95_96_98_20' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_1_99_78_95_96' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_99_95_96_20_21' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_96_1_98_99_78' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_4_1_99_98_95_96' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_1_2_99_78_95_96' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_99_98_1_95_96_20' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_96_1_98_2_99_78' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_95_3_4_96_98_20' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_99_78_95_96_20_21' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_2_99_95_96_20_21' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_21_1_98_99_78_95_96' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_1_98_2_99_95_96_20' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_99_1_98_78_95_96_20' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_2_99_78_95_96_20_21' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_21_1_98_2_99_95_96' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_1_95_96_78_20_99_21' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_1_95_3_4_96_98_20' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_20_1_99_98_95_96_3' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_21_1_98_99_95_96_20' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_95_96_78_20_99_2_1_21' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_99_98_3_4_95_96_20_21' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_21_1_98_2_99_78_95_96' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_1_95_96_20_99_2_21_98' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_21_1_99_98_3_4_95_96' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_98_1_99_3_4_95_96_20_21' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 5074, Level 16, State 1, Line 2600
The statistics '_dta_stat_178099675_98_1_2_99_78_95_96_20_21' is dependent on column 'AvailableEndDateTimeUtc'.
Msg 4922, Level 16, State 9, Line 2600
ALTER TABLE ALTER COLUMN AvailableEndDateTimeUtc failed because one or more objects access this column.
Msg 5074, Level 16, State 1, Line 2615
The index '_dta_index_QueuedEmail_7_658101385__K17_K18_K2_K16_1_3_4_5_6_7_8_9_10_11_12_13_14_15_19' is dependent on column 'SentOnUtc'.
Msg 5074, Level 16, State 1, Line 2615
The index '_dta_index_QueuedEmail_7_658101385__K17_K18' is dependent on column 'SentOnUtc'.
Msg 4922, Level 16, State 9, Line 2615
ALTER TABLE ALTER COLUMN SentOnUtc failed because one or more objects access this column.

If anyone has dealt with this before, please advise, thanks in advance
6 months ago
https://stackoverflow.com/questions/7956620/do-statistics-referencing-a-column-prevent-that-column-from-being-dropped
2 months ago
I am getting following error while updating from 4.1 to 4.2, the solution provided above I couldnt understand as I am novice to SQL, please help in being more specific to solving issue on nop4.2

(1 row affected)
Msg 3701, Level 11, State 7, Line 2313
Cannot drop the index 'Customer.IX_Customer_CreatedOnUtc', because it does not exist or you do not have permission.
Msg 5074, Level 16, State 1, Line 2314
The index 'idx_DCh_93751_93750_Customer' is dependent on column 'CreatedOnUtc'.
Msg 5074, Level 16, State 1, Line 2314
The index 'idx_DCh_504987_504986_Customer' is dependent on column 'CreatedOnUtc'.
Msg 4922, Level 16, State 9, Line 2314
ALTER TABLE ALTER COLUMN CreatedOnUtc failed because one or more objects access this column.
Msg 3701, Level 11, State 7, Line 2407
Cannot drop the index 'Order.IX_Order_CreatedOnUtc', because it does not exist or you do not have permission.
Msg 5074, Level 16, State 1, Line 2408
The index 'idx_DCh_271_270_Order' is dependent on column 'CreatedOnUtc'.
Msg 5074, Level 16, State 1, Line 2408
The index 'idx_DCh_166_165_Order' is dependent on column 'CreatedOnUtc'.
Msg 4922, Level 16, State 9, Line 2408
ALTER TABLE ALTER COLUMN CreatedOnUtc failed because one or more objects access this column.
Msg 3701, Level 11, State 7, Line 2656
Cannot drop the index 'QueuedEmail.IX_QueuedEmail_SentOnUtc_DontSendBeforeDateUtc_Extended', because it does not exist or you do not have permission.
Msg 5074, Level 16, State 1, Line 2657
The index 'idx_DCh_501189_501188_QueuedEmail' is dependent on column 'SentOnUtc'.
Msg 4922, Level 16, State 9, Line 2657
ALTER TABLE ALTER COLUMN SentOnUtc failed because one or more objects access this column.
2 months ago
kakoli wrote:
I am getting following error while updating from 4.1 to 4.2, the solution provided above I couldnt understand as I am novice to SQL, please help in being more specific to solving issue on nop4.2

(1 row affected)
Msg 3701, Level 11, State 7, Line 2313
Cannot drop the index 'Customer.IX_Customer_CreatedOnUtc', because it does not exist or you do not have permission.
Msg 5074, Level 16, State 1, Line 2314
The index 'idx_DCh_93751_93750_Customer' is dependent on column 'CreatedOnUtc'.
Msg 5074, Level 16, State 1, Line 2314
The index 'idx_DCh_504987_504986_Customer' is dependent on column 'CreatedOnUtc'.
Msg 4922, Level 16, State 9, Line 2314
ALTER TABLE ALTER COLUMN CreatedOnUtc failed because one or more objects access this column.
Msg 3701, Level 11, State 7, Line 2407
Cannot drop the index 'Order.IX_Order_CreatedOnUtc', because it does not exist or you do not have permission.
Msg 5074, Level 16, State 1, Line 2408
The index 'idx_DCh_271_270_Order' is dependent on column 'CreatedOnUtc'.
Msg 5074, Level 16, State 1, Line 2408
The index 'idx_DCh_166_165_Order' is dependent on column 'CreatedOnUtc'.
Msg 4922, Level 16, State 9, Line 2408
ALTER TABLE ALTER COLUMN CreatedOnUtc failed because one or more objects access this column.
Msg 3701, Level 11, State 7, Line 2656
Cannot drop the index 'QueuedEmail.IX_QueuedEmail_SentOnUtc_DontSendBeforeDateUtc_Extended', because it does not exist or you do not have permission.
Msg 5074, Level 16, State 1, Line 2657
The index 'idx_DCh_501189_501188_QueuedEmail' is dependent on column 'SentOnUtc'.
Msg 4922, Level 16, State 9, Line 2657
ALTER TABLE ALTER COLUMN SentOnUtc failed because one or more objects access this column.


I solved it by manually deleting those index tables (only ones that are stated), no problems since then.
2 months ago
I should delete before running the upgrade script or after, also can you share the delete command for the same please.
2 months ago
kakoli wrote:
I should delete before running the upgrade script or after, also can you share the delete command for the same please.


Before you run upgrade. I don't know delete command, i do it by browsing through sql management studio.
You just go to your database, select table that reports error and clear those index tables that are listed in log.
1 month ago
Cool, will try that and update
1 month ago
I deleted those stated in the error, now when I run the upgrade script of 4.2 still getting the following error

Msg 3701, Level 11, State 7, Line 2271
Cannot drop the index 'Customer.IX_Customer_CreatedOnUtc', because it does not exist or you do not have permission.
Msg 5074, Level 16, State 1, Line 2272
The index 'idx_DCh_93751_93750_Customer' is dependent on column 'CreatedOnUtc'.
Msg 5074, Level 16, State 1, Line 2272
The index 'idx_DCh_504987_504986_Customer' is dependent on column 'CreatedOnUtc'.
Msg 4922, Level 16, State 9, Line 2272
ALTER TABLE ALTER COLUMN CreatedOnUtc failed because one or more objects access this column.
Msg 3701, Level 11, State 7, Line 2365
Cannot drop the index 'Order.IX_Order_CreatedOnUtc', because it does not exist or you do not have permission.
Msg 5074, Level 16, State 1, Line 2366
The index 'idx_DCh_271_270_Order' is dependent on column 'CreatedOnUtc'.
Msg 5074, Level 16, State 1, Line 2366
The index 'idx_DCh_166_165_Order' is dependent on column 'CreatedOnUtc'.
Msg 4922, Level 16, State 9, Line 2366
ALTER TABLE ALTER COLUMN CreatedOnUtc failed because one or more objects access this column.
Msg 3701, Level 11, State 7, Line 2614
Cannot drop the index 'QueuedEmail.IX_QueuedEmail_SentOnUtc_DontSendBeforeDateUtc_Extended', because it does not exist or you do not have permission.
Msg 5074, Level 16, State 1, Line 2615
The index 'idx_DCh_501189_501188_QueuedEmail' is dependent on column 'SentOnUtc'.
Msg 4922, Level 16, State 9, Line 2615
ALTER TABLE ALTER COLUMN SentOnUtc failed because one or more objects access this column.

Thanks
Kakoli