Kentico Upgrade 10 -> 11

Tomasz Czado asked on October 24, 2018 10:06

Hi,

I upgraded Kentico from 10 to 11 (successful). But before that I had to remove all staging tasks directly from db because there was an index conflict.

Anyway upgrade process finished with no errors. Then I updated code in App_code and runned the site. Everything without errors. But when I checked directly CMSDataVersion is still 10 for some reason.

Do you have any idea why?

Correct Answer

Tomasz Czado answered on October 24, 2018 16:46

Hi.

Thanks for all answers. It turned out that UpgradeProcedure.cs process failed because there was some incorrect code names in CMS_Class db table. When I updated them, procedure finished succesfully and updated CMSDataVersion.

0 votesVote for this answer Unmark Correct answer

Recent Answers

Dragoljub Ilic answered on October 24, 2018 10:49

Hi Tomasz,

Did you rollback DB after error occurs and started script again or you just ran script several times? In this article it's says that: If you experience an error during the SQL script, make sure that you roll back before addressing the causes of the error. Re-applying the script over a partially upgraded database will not work and is not supported.

If yes, the safest will be to revert everything and start with upgrade again, with clean solution and DB.

Best regards, Dragoljub

0 votesVote for this answer Mark as a Correct answer

Tomasz Czado answered on October 24, 2018 10:55

I started from beginning - I mean I restored db backup, removed stagin tasks and run upgrade again. So it should be good. But it's not.

0 votesVote for this answer Mark as a Correct answer

Rui Wang answered on October 24, 2018 14:40

Can you use visual studio to do a build of the site to make sure there is no errors?

If the DataVersion is still 10, it mean the /App_code/CMS/upgradeprocedure.cs was not executed correctly.

1 votesVote for this answer Mark as a Correct answer

Peter Mogilnitski answered on October 24, 2018 17:01

Any messages in the event log? You should see errors these in event log.

2 things to try:

It could be that sql upgrade script failed for some reason. I suggest you make a copy of you db. Take the sql script from [upgrade folder]\SQL\upgrade.sql and try to run in SQL Management Studio separately. See if there any errors?
The other way you may try to get [upgrade folder]CMS\CMS\CMSSiteUtils\Import\Upgrade_100_110.zip and try to import using sites import export utility.

At the end your CMSDataVersion and CMSDBVersion should be the same version. Actually make sure that Kentico UI, Database, File system - all match

0 votesVote for this answer Mark as a Correct answer

Tomasz Czado answered on October 24, 2018 17:06

Yes, I got entries in event logs so I resolved it - I marked my latest answer as correct.

Thanks again to all of you.

0 votesVote for this answer Mark as a Correct answer