upgrade from 4.1 to 4.2 Failed

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

https://stackoverflow.com/questions/7956620/do-statistics-referencing-a-column-prevent-that-column-from-being-dropped

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.

kakoli wrote:

I solved it by manually deleting those index tables (only ones that are stated), no problems since then.

I should delete before running the upgrade script or after, also can you share the delete command for the same please.

kakoli wrote:

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.

Cool, will try that and update

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