Upgrade from 9.x to 10 failing

Marty Abrahams asked on August 17, 2017 09:32

I'm trying to upgrade a site from 9.0.36 to 10.0 using the Kentico Upgrade Utility. It's failing during the database upgrade.

Log Extract:

Query: 

ALTER TABLE [OM_Contact] 
     ALTER COLUMN [ContactLastName] [nvarchar](100) NULL;


Caused exception: 
The index 'IX_OM_Contact_ContactPersonaID_ContactLastName' is dependent on column 'ContactLastName'.
The index 'IX_OM_Contact_ContactLastName' is dependent on column 'ContactLastName'.
ALTER TABLE ALTER COLUMN ContactLastName failed because one or more objects access this column.

Note: I haven't played around with the original indexes and we don't use this feature for this site.

One thing that isn't clear in the upgrade instructions is whether I need to be on the latest hotfix patch of K9 before running this upgrade. It makes sense if this is the case, but I couldn't find anything that says this. My plan was to try this anyway, but for the life of me I can't find the download for the KIM tool. ¯\_(ツ)_/¯

Thanks Marty

Recent Answers

Trevor Fayas answered on August 17, 2017 14:03

shouldn't need to go to latest hotfix, however I've noted before if upgrading a site that was built originally on an older version, sometimes this stuff occurred. I'll have to check when I get into the office if Kentico 10 has this index, if not you can drop the index then try again.

0 votesVote for this answer Mark as a Correct answer

Suneel Jhangiani answered on August 17, 2017 14:12

I've just checked a v10 database and that Index does exist. What I would suggest is dropping the index, performing the upgrade and then re-creating the index - I've copied the create script from a v10 database below.

/****** Object:  Index [IX_OM_Contact_ContactPersonaID_ContactLastName]    Script Date: 17/08/2017 13:07:56 ******/
CREATE NONCLUSTERED INDEX [IX_OM_Contact_ContactPersonaID_ContactLastName] ON [dbo].[OM_Contact]
(
    [ContactPersonaID] ASC,
    [ContactLastName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO
0 votesVote for this answer Mark as a Correct answer

Marty Abrahams answered on August 18, 2017 09:10

Thanks, I did try dropping that one index but then was hit with another index issue which was why I thought it looked like a slippery slope to go down. I will try upgrading and see what happens.

0 votesVote for this answer Mark as a Correct answer

Marty Abrahams answered on August 21, 2017 01:37

Can someone please point me to where I can download the KIM tool? I can't find a download anywhere..

0 votesVote for this answer Mark as a Correct answer

Trevor Fayas answered on August 21, 2017 14:19

when you install Kentico, it's part of the install, often though it doesn't show up on the search, just expand your programs in the start menu and find your Kentico x.0 and you will see it there.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.