U4-9993 - Errors upgrading to 7.6.3

Created by Stephan 06 Jun 2017, 09:36:03 Updated by Sebastiaan Janssen 25 Aug 2017, 20:05:38

Relates to: U4-10358

Relates to: U4-9927

Subtask of: U4-9609

There was an issue upgrading from old versions to 7.6.1 (U4-9927) which has been fixed in 7.6.3 and we have reports of several sites that could not be upgraded to 7.6.1 and have been upgraded successfully to 7.6.3, so that issue is considered fixed.

However, some people reported that they still had problems upgrading, to 7.6.3 this time. See U4-9927 for details, and this new issue will be tracked here.

7 Attachments

Download UmbracoTraceLog.txt

Download UmbracoTraceLog.txt

Download SchemaCompare.sql

Download Umbraco Upgrade Issue.docx

Comments

Stephan 06 Jun 2017, 09:45:07

Copied from other issue: happened when upgrading from 7.0.1 and from 7.1.6. In both cases with error message:

The database failed to upgrade. ERROR: The database configuration failed with the following message: The index 'IX_umbracoNodeUniqueID' is dependent on column 'uniqueID'. ALTER TABLE ALTER COLUMN uniqueID failed because one or more objects access this column. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')


Stephan 06 Jun 2017, 10:28:36

Installed 7.0.1 / SqlCE then upgraded to latest dev-v7 (7.6.4) without problem.

Anyone got a site that consistently fail, that they could zip and share?


Sebastiaan Janssen 06 Jun 2017, 11:34:00

Maybe @Fuggle or @bmcnally or @jaandrews can share a problematic database?


Racheal Smith 06 Jun 2017, 21:20:09

I tried the upgrade twice yesterday and it failed in the same way both times. I'm not able to share the site or database as this is client work, sorry.

Here are steps I also took: #Attempted upgrade to 7.6.0, failed with a different database issue, I think it was this one: http://issues.umbraco.org/issue/U4-9842 #Upgraded to 7.5.14 successfully.


Brendan Davidson 06 Jun 2017, 22:18:02

I am having the same issues upgrading a client website. I was trying to dig around and hope I could modify a script and have this run. I found nothing I could edit, but I believe I have found what might cause this. I am by far no expert and am a complete novice. Take this with a grain of salt the size of Manhattan.

in the file:

(Umbraco-CMS/src/Umbraco.Core/Persistence/Migrations/Upgrades/TargetVersionSevenThreeZero/UpdateUniqueIdToHaveCorrectIndexType.cs) on github

line 32: //must be non-nullable Alter.Table("umbracoNode").AlterColumn("uniqueID").AsGuid().NotNullable();

The others are contained within checks to make sure the value is not already what its trying to change it to, but this one does not? Could this possibly be it?

This is a line from the error block I was receiving: ALTER TABLE ALTER COLUMN uniqueID failed because one or more objects access this column.

I hope I am able to help dig to the bottom of this, but I cannot share any files as they're client data =\

Edit: I should mention, I did try to manually make the changes to the DB hoping it would skip this step where it errors out. But without the check to make sure, it still fails anyway. Microsoft SQL server Management Studio was able to make the changes to the DB but it still fails because "one or more objects access this column."


Jesse Andrews 06 Jun 2017, 23:18:06

@sebastiaan @zpqrtbnk I'm not able to share my database unfortunately, as the database is for a client's internal website. I'll try pulling down the dev-v7 branch and test it locally to see if it works for me. I will post an update on how that goes tomorrow.


Toby Dimmick 07 Jun 2017, 11:51:22

I'm experiencing this issue upgrading 7.2.5 -> 7.6.3 through NuGet. Log attached.

I may try and build the head of dev-v7 and see if I have any success.


Jesse Andrews 07 Jun 2017, 17:33:51

@sebastiaan @zpqrtbnk I tried updating to the latest dev-v7, but that did not resolve the issue for me. I did find a work around for my case though. I just upgraded the site to 7.5.14 and then upgraded it to 7.6.3. That did work.

Also, just a bit more background on the umbraco version history of the project. It started on 7.2.1 and was later upgraded to 7.2.8. I doubt that had any impact on the issue I ran into though.


Martin Griffiths 08 Jun 2017, 15:32:32

@zpqrtbnk I can supply a db v7.2.1 being troublesome.


Paul Hawkridge 08 Jun 2017, 23:51:56

Just got this issue - I have attached the file so you can see what I mean - here is the error returned to upgrade dialogue The database failed to upgrade. ERROR: The database configuration failed with the following message: The index 'IX_umbracoNodeUniqueID' is dependent on column 'uniqueID'. ALTER TABLE ALTER COLUMN uniqueID failed because one or more objects access this column. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')


Paul Hawkridge 12 Jun 2017, 23:40:27

I did a visual studio sql compare schema between a 7.6.3 version and the 7.2.4 I run and attached the resulting deploy scrip file - don't know if that is of any use or not. File is schema compare


Simon Justesen 14 Jun 2017, 00:19:48

Tried compiling v7-dev, which identifies itself as 7.6.4 (it seems?) - unfortunately there's still an issue with the ALTER TABLE ALTER COLUMN uniqueID error (the project I'm working with, was upgraded from v7.1)


Stephan 14 Jun 2017, 13:05:24

Captured from the logs posted here:

2017-06-07 12:31:33,863 [P5000/D2/T10] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 16: ALTER TABLE [umbracoNode] ALTER COLUMN [uniqueID] UniqueIdentifier NOT NULL 2017-06-07 12:31:33,876 [P5000/D2/T10] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (83890d93). System.Data.SqlClient.SqlException (0x80131904): The index 'IX_umbracoNodeUniqueID' is dependent on column 'uniqueID'. ALTER TABLE ALTER COLUMN uniqueID failed because one or more objects access this column.

So, we're trying to execute sql: ALTER TABLE [umbracoNode] ALTER COLUMN [uniqueID] UniqueIdentifier NOT NULL

Which comes from migration TargetVersionSevenThreeZero/UpdateUniqueIdToHaveCorrectIndexType, and this fails because index IX_umbracoNodeUniqueID actually depends on the uniqueID column


Stephan 14 Jun 2017, 13:06:10

PR https://github.com/umbraco/Umbraco-CMS/pull/2001

Works by first removing the index, then altering the column, then re-creating the index.

@Simon.Justesen any chance you can test the code in this PR and confirm it works?


Sebastiaan Janssen 14 Jun 2017, 13:15:35

To test, there should be artifacts here in a few minutes: https://ci.appveyor.com/project/Umbraco/umbraco-cms-hs8dx/build/7831/artifacts

Using the UmbracoCms.7.6.4-build7831.zip file should help you trying to upgrade, just copying in the bin folder is enough.


Simon Justesen 14 Jun 2017, 13:28:42

@zpqrtbnk @sebastiaan Thanks! Yes, I'll try to test right away :)


Simon Justesen 14 Jun 2017, 14:12:38

@zpqrtbnk @sebastiaan I get an UrlRewritingNet.UrlRewriter FileNotFoundException, when trying to upgrade - copied over /bin from build.7831 first .. tested. Copied the new web.config to the new folder then replaced /config, /umbraco and /umbraco_client Exception still shows up.

If I "fix" the rewriter exception by temporarily copying over the old file, the compiler moves on to complain about Newtonsoft.Json 6.0 not being present, if I "fix" that as well I get a general exception - compiler error - saying that System.Web.Http is trying to reference Newtonsoft.Json 6.0 that was newer than the expected version 4.5


Sebastiaan Janssen 14 Jun 2017, 17:02:00

Simon: you still need to follow the upgrade instructions for 7.6 mate. Look at version specific instructions too.


Paul Hawkridge 14 Jun 2017, 21:17:07

I had this index problem and did something similar to fix it...also got a duplicate uniqueid error where there were 30 or so rows in the umbraconode table that ended up with duplicate unique ids in them...the fix i did for that was generating newid () where there were duplicates ...that made the upgrade work but am unsure what if any effect it will have down the line.


Simon Justesen 20 Jun 2017, 09:07:34

@zpqrtbnk @sebastiaan I'm having huge difficulties getting the patch to work, can't login after I applied the artifact build. Looked at the version specific instructions too


Sebastiaan Janssen 20 Jun 2017, 17:38:54

Did you lock yourself out? Did you change from legacy password encoding to non-legacy? Did you change the password length requirements to something longer than your current password?


Søren Kottal 26 Jun 2017, 11:27:32

@zpqrtbnk @sebastiaan I have problems upgrading a solution from 7.2.6 to 7.6.3. Applying the patch (copying the files from bin) didn't help.

I get this error on the installer:

The database failed to upgrade. ERROR: The database configuration failed with the following message: The index 'IX_umbracoNodeUniqueID' is dependent on column 'uniqueID'. ALTER TABLE ALTER COLUMN uniqueID failed because one or more objects access this column. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')


Søren Kottal 29 Jun 2017, 08:49:48

An update:

Upgrading to 7.5.14 before upgrading to 7.6.3 works.


Stephan 30 Jun 2017, 09:15:30

Right, trying again: installing 7.2.6 and trying to upgrade to latest 7.6.x with PR...


Brian McNally 30 Jun 2017, 15:40:40

@Søren.Kottal I also ended up doing an interim update to 7.5.14 and then on to 7.6.3 and that did the trick.


Stephan 30 Jun 2017, 17:29:27

Ok, what I did: download stock 7.2.from Our and install, replace files with 7.6.x with PR, upgrade Umbraco, and it works for me. @sebastiaan any chance you can try that same operation and see if you can repro? Else... I just cannot repro. Anyone else?


Daniel 03 Jul 2017, 23:14:45

Hi all,

I've uploaded a document detailing the issues we have also had while performing an Umbraco upgrade. Doc name is "Umbraco Upgrade Issue" which includes screenshots, logs and other detail about our issue, in particular.

Any help is much appreciated.

Regards, Daniel


Daniel 03 Jul 2017, 23:16:11

Hi all,

I've uploaded a document detailing the issues we have also had while performing an Umbraco upgrade. Doc name is "Umbraco Upgrade Issue" which includes screenshots, logs and other detail about our issue, in particular.

Any help is much appreciated.

Regards, Daniel


Daniel 03 Jul 2017, 23:16:56

Hi all,

I've uploaded a document detailing the issues we have also had while performing an Umbraco upgrade. Doc name is "Umbraco Upgrade Issue" which includes screenshots, logs and other detail about our issue, in particular.

Any help is much appreciated.

Regards, Daniel


Sebastiaan Janssen 04 Jul 2017, 12:17:21

@DT-NV See the comment from Claus here, you need to run an update query before you upgrade. This is a different problem: http://issues.umbraco.org/issue/U4-7222#comment=67-23690


David Sheiles 06 Jul 2017, 16:07:20

@sebastiaan I had the same issues upgrading from 7.2.8 to 7.6.3. Applying the patch (copying the files from bin) didn't help for me either. The I then upgraded from 7.2.8 to 7.5.14 and it went smoothly. Haven't tried going further with then upgrading to 7.6.3 as yet


Stephan 07 Jul 2017, 13:56:16

This is all very weird. What would ''really'' help is: if you have a site that fails the update and you can share with HQ? Even under some sort of NDA if that may help. But... at the moment I'm kinda deadlocked as I cannot repro ;(


Søren Kottal 08 Jul 2017, 10:00:09

@zpqrtbnk I might have some, need to check with my manager though.


David Sheiles 08 Jul 2017, 10:27:20

@zpqrtbnk I'll see if I can grab a copy of it before I upgraded.


Stephan 10 Jul 2017, 13:45:38

@DT-NV Finally had time to review your Word document. I see two errors there:

  1. an error trying to insert a duplicate row - when trying to assign a uniqueID to content types with ID 1468 and 1671 - 7.6 tries to assign uniqueID to many existing things, and to be consistent it derives these IDs from unique properties of these things.

For content types, the corresponding migration would be TargetVersionSevenFourZero.EnsureContentTypeUniqueIdsAreConsistent which derives the uniqueID from the alias of the content type, which can be found in the cmsContentType table. Looking at the umbracoNode table records you pasted in the document... node id 1468 and 1471 seem to have the same "text" value - if would be interesting to check whether they have the same content type alias (in cmsContentType) as that would explain the collision.

Having duplicate content type aliases is an anomaly - not sure how you would have ended up in that state, but it would have to be fixed before upgrading.

Any chance you have a copy of the original DB and can check?

  1. the "''index 'IX_umbracoNodeUniqueID' is dependent on column 'uniqueID'. ALTER TABLE ALTER COLUMN uniqueID failed''" error that has been reported by others, and is supposed to be fixed by the patch.

As mentionned already, I'm really looking for a site (database) that fails the update (even under NDA, anything) since I cannot seem to be able to repro that issue.

Any chance you have a copy of your original DB you could share?


Daniel 11 Jul 2017, 04:24:38

@zpqrtbnk - Hi! Thanks for the reply. My colleagues found a workaround for it (I was away ill). If anyone is interested, the following is what they did:

  • Manually clear duplicate Document Types from the back office (not sure how Umbraco 6.1.5 allowed them).
  • Create a new, empty, web project.
  • Add UmbracoCMS 7.0 NuGet Package.
  • Run the site against the existing Umbraco 6.1.5 database to prompt the Umbraco database upgrade.
  • Upgrade UmbracoCMS NuGet Package from 7.0 to 7.3 and run against the database again to prompt the upgrade.
  • Upgrade UmbracoCMS NuGet Package from 7.3 to 7.6.3 and run against the database again to prompt the upgrade.

The reason for the specific Umbraco version jumps is that the Umbraco upgrades do not appear to be database-cumulative, and upgrading straight from 6.1.5 to 7.6.3 for instance will miss out several important/required database changes (we experienced issues with "umbracoUser" and "umbracoServer" tables before giving up trying to patch the database based on upgrade failure log messages).


Ben Palmer 11 Jul 2017, 12:26:58

@zpqrtbnk I've just run in to the same issue and can send you my files and database, any chance you could let me know an email to send it to?

Thanks,

Ben


Stephan 11 Jul 2017, 12:31:02

@0Neji fantastic, email: stephane@umbraco.com


Ben Palmer 11 Jul 2017, 12:38:02

@zpqrtbnk Thanks, on it's way via WeTransfer :)


Stephan 11 Jul 2017, 12:46:58

got the files, thnks, now trying to repro


Stephan 11 Jul 2017, 12:55:12

yes! reproduced, now debugging


Stephan 11 Jul 2017, 13:03:20

ah well, the site you sent me does indeed fail to upgrade, but simply replacing ~/bin/Umbraco.Core.dll with a fresh one built from branch dev-u4-9993 ie the PR branch mentioned above, is enough to fix the issue and upgrade without a glitch.

so... again, from what I'm seeing the PR / patch is fixing the issue. Would love to get a site from ppl who reported that their upgrade failed, even though they were running the PR / patch.


Ben Palmer 11 Jul 2017, 13:47:27

Ah, apologies, I glanced over the patch. I'll give that a try - thanks for the super quick response!


Stephan 11 Jul 2017, 17:01:24

So, someone has been able to share a 7.2.8 site that was failing to upgrade, and I have been able to upgrade it with the patch applied. Still discussing this site with its owner, but I ''really'' want to consider this issue fixed so it can go in 7.6.5.


David Sheiles 12 Jul 2017, 01:03:27

Hey @zpqrtbnk , unfortunately the upgrade to the latest build didn't work for me with the same DB that I sent you. I have emailed you further details and logs. Not sure what I'm doing differently from you!


David Sheiles 12 Jul 2017, 10:41:49

Success @zpqrtbnk ! It took a while and eventually timed out, but as discussed it was a large DB over a remote connection. After a refresh, I ended up in the backoffice without any problems. I think its all good to go for 7.6.5


Stephan 12 Jul 2017, 10:50:04

yay! many thanks for your precious help!

moving this issue to review - reviewer just need to merge PR https://github.com/umbraco/Umbraco-CMS/pull/2001

no need for more testing I guess


Santhoshkumar N 13 Jul 2017, 10:17:55

Hi All, I have the similar problem when I upgrade DB from 6.1.6 to 7.6.0. I have upgraded in my DEV instance the website and DB successfully (from 6.1.6 to 7.0.0, then 7.0.0 to 7.2.0 and finally 7.2.0 to 7.6.0). Now I have my website deployed in QA instance were the umbraco code is latest (7.6.0), but QA DB is 6.1.6. I read a blog that got to know that I can run the website by setting the UmbracoConfigurationStatus as 6.1.6 and run the website. Everything seems to be good until now. Website opened with umbraco installer, but failed initially for missing typeUniqueID column, I found in google a script that I executed. Then when I proceed I see now the following error:

The database failed to upgrade. ERROR: The database configuration failed with the following message: The index 'IX_umbracoNodeUniqueID' is dependent on column 'uniqueID'. ALTER TABLE ALTER COLUMN uniqueID failed because one or more objects access this column. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')

I do not know how to proceed here, Can someone tell me how can I upgrade my QA umbraco DB from 6.1.6 to 7.6.0?

+From Stephan's comments I'm trying to download the DEV code from https://github.com/umbraco/Umbraco-CMS and build to get the ~/bin/Umbraco.Core.dll and use them to succeed+

Any help is much appreciated, as I have very less time to complete the upgradation! - Santhosh


Stephan 13 Jul 2017, 10:44:30

There is no current released version that will work - you will have to wait for 7.6.5 or manually build code from the dev-v7 branch (as the PR has been merged now). Alternatively you may want to do some steps ie some ppl seem to say (see above) that first upgrading to 7.5.14 and then to 7.6.4 works.


Santhoshkumar N 13 Jul 2017, 10:52:09

Hi Stephan, Many Thanks for your quick reply! I don't mind building manually the umbraco dev code to fix the issue. I have just now tried once to get the code and build by running the "build.bat" and deploy the Umbraco.Core.dll, but didn't succeed. Do you know why?

The problem for me is the website is already upgraded to 7.6.0 in my DEV and when I tried deploying the code in QA I realised I can't change the website version, but only to upgrade the DB with installer.

I seem to have only 2 options, either expect a new release or patch DLL that can solve this issue (or) manually take the code of umbraco dev, build, and deploy

  • Santhosh


David Sheiles 13 Jul 2017, 11:40:59

Hi @isna@eurofins.com , I had a similar problem with build.bat due to nuget.exe missing in the build folder (It should say in the build.bat output). I just opened the solution in visual studio and built it form there and then grabbed the DLL from the Umbraco.core/bin/debug folder. Hope that helps you!


Santhoshkumar N 13 Jul 2017, 12:42:28

Hi All, I was able to +Fix+ my problem I did the following:

  1. Downloaded the code base from gitHub
  2. commented following lines from src\Umbraco.Core\Persistence\Migrations\Upgrades\TargetVersionSevenTwoZero\AddIndexToUmbracoNodeTable.cs

Create.Index("IX_umbracoNodeUniqueID").OnTable("umbracoNode").OnColumn("uniqueID").Ascending().WithOptions().NonClustered();

  • Delete.Index("IX_umbracoNodeUniqueID").OnTable("umbracoNode");
  1. run the build.bat
  2. Used the Umbraco.core.dll in my website for DB upgradation All went successful! Then I created the index manually :)
  3. I will remove the umbraco.core.dll (manually build one) from my website and replace with v7.6.0 umbraco.core.dll

My only concern is: As I wanted to upgrade to v7.6.0 for now, but I have run the installer using umbraco.core.dll v7.6.4 (that includes the fix) and got my db upgraded. I fear for future upgrades if there will be any problem at all.

@Stephan : Can you comment on this?

Thanks all for your response. I'm happy

  • Santhosh


Santhoshkumar N 13 Jul 2017, 12:46:33

@David.Sheiles: I was able to build successfully with build.bat. But the code fix U4-9993 (Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.UpdateUniqueIdToHaveCorrectIndexType changes to delete the IX_umbracoNodeUniqueID) didnt work for me. I faced the same situation again. But now I was able to solve the problem as I mentioned above. Thanks for your timely reply!


Sebastiaan Janssen 13 Jul 2017, 14:27:23

@isna@eurofins.com This blog post explains how migrations work: https://cultiv.nl/blog/using-umbraco-migrations-to-deploy-changes/

In short: the migration for 7.6.0 will not run any more when you upgrade to 7.6.4 - only the ones that have never ran will run. So any migrations for 7.6.1,7.6.2,7.6.3 or 7.6.4 will run. So you won't run into this specific error any more.


Santhoshkumar N 18 Jul 2017, 15:17:32

Is anyone aware about "WebForms" not supported with v7.6.0? I see my webforms master pages throwing error when I try to view in backend. I see the following error: There is already an open DataReader associated with this Command which must be closed first.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.

Source Error:

Line 153: Line 154: <div class="macro" rel="<%# DataBinder.Eval(Container, "DataItem.macroAlias")%>" Line 155: params="<%# DoesMacroHaveSettings(DataBinder.Eval(Container, "DataItem.id").ToString()) %>"> Line 156: <%# DataBinder.Eval(Container, "DataItem.macroName")%> Line 157:

Source File: c:\ISNA\CorporateTfs\Genomics\Ecom\Ecom.B2C\Core\Eurofins.Genomics.Ecom.Web\umbraco\Settings\editTemplate.aspx Line: 155

Can anyone let me know which version of umbraco supports Webforms completely with master pages?

Santhosh


Sebastiaan Janssen 19 Jul 2017, 07:58:56

@isna@eurofins.com Yes, webforms/masterpages is still supported. I guess you didn't close a connection properly. Make sure to head to Google/the forums (https://our.umbraco.org) for help.


Santhoshkumar N 19 Jul 2017, 08:03:42

Hi Sebastiaan, Thanks for your prompt reply. I have not done any code change after upgrading from 6.1.6 to 7.6.0. The problem is discussed here http://issues.umbraco.org/issue/U4-9930. If I understand the issue, webforms master pages are no more supported from 7.6.0. Is this true? Does this mean only way for us is to upgrade to MVC? What if my business has no plans to upgrade to MVC in the near future? will I get license support if we are continuing with webforms? I will write the same on the issue 9930.


Sebastiaan Janssen 19 Jul 2017, 09:27:27

@isna@eurofins.com Make sure to read carefully: editing webforms templates from the backoffice of Umbraco is no longer supported. That's all.

WebForms still work for everything. You've done a major upgrade, you can expect to have to make some code adjustments to make your current code work again. In the 4 years between 6.1.6 and 7.6.0 a lot has happened. Also make sure to go to 7.6.4 as there's numerous bugs fixed since 7.6.0.


Santhoshkumar N 19 Jul 2017, 11:56:00

Hi Sebastiaan, Thanks for your quick reply! Thanks for explaining that only the problem is view/edit templates from the back office. Also the umbraco license support mentioned I can move to views from master pages to solve this issue. Does this mean ONLY upgrading my master pages to views with usercontrols developed in webforms will work? I see the below options for me at the moment:

  1. Downgrade to 7.5.14 to have everything working as expected without any disruptions
  2. Accept the disabled edit feature from back office and manage via VS
  3. Move to MVC (This could be a larger task) Thanks Santhosh


Sebastiaan Janssen 19 Jul 2017, 12:30:37

@isna@eurofins.com

This is really beyond the scope of the issue but..

Also the umbraco license support mentioned I can move to views from master pages to solve this issue. I don't know what the umbraco license support thing is

Does this mean ONLY upgrading my master pages to views with usercontrols developed in webforms will work? You don't have to upgrade anything, all masterpages will still work, provided you fix the errors being caused by your custom code

Downgrade to 7.5.14 to have everything working as expected without any disruptions I would recommend you don't use older versions, does the same site work on 7.5.14? I doubt you'll have more success. If you only want to downgrade because you then can edit masterpages from the backoffice, see the solution available here: http://issues.umbraco.org/issue/U4-9930#comment=67-37073 There's a masterpage editor attached


Santhoshkumar N 19 Jul 2017, 13:06:04

@sebastiaan : The error comes from the "editTemplate.aspx" which is umbraco back office page, what should be changed from our custom code? Master pages were working as part of v6.1.6, I understand there could be some changes required to make templates work in the back office with v7.6.0, but what are those, I can change them if someone can mention what will not work.

If I understand correctly, v7.6.0 has stopped supporting webforms master pages view/edit/create from the umbraco back office. This can be managed with a plugin as you have attached (AceUmbraco). This could be someting that I can think of possibly a solution

Downgrade options seems not right for you, then I have only following options to by business,

  1. Change master pages to views - Dev effort
  2. Accept that master pages cannot be changed from umbraco back end and can only be modified/added in VS
  3. Use the AceUmbraco plugin with the disadvantage that no tree structures

What would you suggest?

Thanks for your answers Santhosh


mark firth 28 Jul 2017, 10:12:44

Hi, I've just used downloaded the latest version and built it 7.6.5 and dropped the umbraco.core into my solution and i'm still getting the same error when trying to upgrade 6.1.6 > 7.6.5 Has this not been fixed in 7.6.5?

============================= 2017-07-28 10:36:29,748 [P19304/D4/T20] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 155: ALTER TABLE [umbracoNode] ALTER COLUMN [uniqueID] UniqueIdentifier NOT NULL

2017-07-28 10:36:29,851 [P19304/D4/T20] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (80e1922f). System.Data.SqlClient.SqlException (0x80131904): The index 'IX_umbracoNodeUniqueID' is dependent on column 'uniqueID'. ALTER TABLE ALTER COLUMN uniqueID failed because one or more objects access this column. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 266 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy) at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy retryPolicy) at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command) at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) ClientConnectionId:dad3960d-301c-41c7-b43f-ee42d6a4dc25 Error Number:5074,State:1,Class:16 2017-07-28 10:36:29,862 [P19304/D4/T20] ERROR Umbraco.Core.DatabaseContext - Database configuration failed System.Data.SqlClient.SqlException (0x80131904): The index 'IX_umbracoNodeUniqueID' is dependent on column 'uniqueID'. ALTER TABLE ALTER COLUMN uniqueID failed because one or more objects access this column. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 266 at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass2_0.<ExecuteNonQueryWithRetry>b__0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy) at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy retryPolicy) at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command) at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) at Umbraco.Core.Persistence.Migrations.MigrationRunner.ExecuteMigrations(IMigrationContext context, Database database) at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade) at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, Boolean isUpgrade) at Umbraco.Core.DatabaseContext.UpgradeSchemaAndData(IMigrationEntryService migrationEntryService) ClientConnectionId:dad3960d-301c-41c7-b43f-ee42d6a4dc25 Error Number:5074,State:1,Class:16 2017-07-28 10:36:29,867 [P19304/D4/T20] INFO Umbraco.Core.DatabaseContext - The database schema validation produced the following summary: The following tables were found in the database, but are not in the current schema: ContactFormLogs,tracking,ToImport,ToImportFlat,cmsMember_bak,cmsMacroPropertyType,cmsStylesheet,cmsStylesheetProperty,umbracoUserLogins,umbracoAccess,umbracoAccessRule,umbracoCacheInstruction,umbracoExternalLogin,umbracoMigration,umbracoRedirectUrl,umbracoLock

The following columns were found in the database, but are not in the current schema: cmsTemplate,master,cmsContentVersion,LanguageLocale,cmsDocument,alias,cmsDataType,controlId,ContactFormLogs,id,ContactFormLogs,Date,ContactFormLogs,Name,ContactFormLogs,Email,ContactFormLogs,Message,tracking,Id,tracking,DateAdded,tracking,FabricId,tracking,MemberId,tracking,ActionId,ToImport,nodeId,ToImport,Email,ToImport,LoginName,ToImport,Password,ToImport,MemberFieldAlias,ToImport,MemberData,ToImportFlat,nodeId,ToImportFlat,Email,ToImportFlat,LoginName,ToImportFlat,Password,ToImportFlat,approvedByCarrington,ToImportFlat,approvedEmailSent,ToImportFlat,companyName,ToImportFlat,telephone,ToImportFlat,country,ToImportFlat,resetGUID,ToImportFlat,emailVerifyGUID,ToImportFlat,numberOfLogins,ToImportFlat,lastLoggedIn,ToImportFlat,numberOfProfileViews,ToImportFlat,hostNameOfLastLogin,ToImportFlat,IPofLastLogin,ToImportFlat,profileURL,ToImportFlat,hasVerifiedEmail,ToImportFlat,joinedDate,ToImportFlat,description,ToImportFlat,twitter,ToImportFlat,linkedIn,ToImportFlat,skype,cmsMember_bak,nodeId,cmsMember_bak,Email,cmsMember_bak,LoginName,cmsMember_bak,Password,cmsMacroPropertyType,id,cmsMacroPropertyType,macroPropertyTypeAlias,cmsMacroPropertyType,macroPropertyTypeRenderAssembly,cmsMacroPropertyType,macroPropertyTypeRenderType,cmsMacroPropertyType,macroPropertyTypeBaseType,cmsMacroProperty,macroPropertyHidden,cmsMacroProperty,macroPropertyType,cmsPropertyTypeGroup,parentGroupId,cmsPropertyType,helpText,cmsStylesheet,nodeId,cmsStylesheet,filename,cmsStylesheet,content,cmsStylesheetProperty,nodeId,cmsStylesheetProperty,stylesheetPropertyEditor,cmsStylesheetProperty,stylesheetPropertyAlias,cmsStylesheetProperty,stylesheetPropertyValue,umbracoUserLogins,contextID,umbracoUserLogins,userID,umbracoUserLogins,timeout,umbracoUser,userDefaultPermissions,umbracoUser,defaultToLiveEditing,cmsDataType,propertyEditorAlias,cmsMacro,uniqueId,cmsMacroProperty,uniquePropertyId,cmsMacroProperty,editorAlias,cmsPropertyTypeGroup,uniqueID,cmsPropertyType,UniqueID,cmsPropertyData,dataDecimal,umbracoRelationType,typeUniqueId,cmsTagRelationship,propertyTypeId,umbracoUser,securityStampToken,umbracoUser,failedLoginAttempts,umbracoUser,lastLockoutDate,umbracoUser,lastPasswordChangeDate,umbracoUser,lastLoginDate,umbracoServer,isMaster,umbracoAccess,id,umbracoAccess,nodeId,umbracoAccess,loginNodeId,umbracoAccess,noAccessNodeId,umbracoAccess,createDate,umbracoAccess,updateDate,umbracoAccessRule,id,umbracoAccessRule,accessId,umbracoAccessRule,ruleValue,umbracoAccessRule,ruleType,umbracoAccessRule,createDate,umbracoAccessRule,updateDate,umbracoCacheInstruction,id,umbracoCacheInstruction,utcStamp,umbracoCacheInstruction,jsonInstruction,umbracoCacheInstruction,originated,umbracoExternalLogin,id,umbracoExternalLogin,userId,umbracoExternalLogin,loginProvider,umbracoExternalLogin,providerKey,umbracoExternalLogin,createDate,umbracoMigration,id,umbracoMigration,name,umbracoMigration,createDate,umbracoMigration,version,umbracoRedirectUrl,id,umbracoRedirectUrl,contentKey,umbracoRedirectUrl,createDateUtc,umbracoRedirectUrl,url,umbracoRedirectUrl,urlHash,umbracoLock,id,umbracoLock,value,umbracoLock,name

The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema: FK_cmsMacroProperty_cmsMacroPropertyType_id,FK_cmsPropertyTypeGroup_cmsPropertyTypeGroup_id,FK_cmsStylesheet_umbracoNode_id,FK_cmsTagRelationship_umbracoNode_id,FK_cmsTemplate_cmsTemplate,FK_cmsContent_cmsContentType_nodeId,FK_cmsDictionary_cmsDictionary_id,FK_cmsLanguageText_umbracoLanguage_id,FK_cmsTags_cmsTags,FK_cmsTagRelationship_cmsContent,FK_cmsTagRelationship_cmsPropertyType,FK_umbracoAccess_umbracoNode_id,FK_umbracoAccess_umbracoNode_id1,FK_umbracoAccess_umbracoNode_id2,FK_umbracoAccessRule_umbracoAccess_id,FK_umbracoRedirectUrl_umbracoNode_uniqueID,PK_cmsMacroPropertyType,PK_cmsPreviewXml,PK_cmsStylesheet,PK_cmsStylesheetProperty,PK_ContactFormLogs,PK_cmsContentPreviewXml,PK_umbracoAccess,PK_umbracoAccessRule,PK_umbracoCacheInstruction,PK_umbracoExternalLogin,PK_umbracoMigration,PK_umbracoRedirectUrl,PK_umbracoLock,IX_umbracoNodeTrashed,IX_umbracoNodeParentId,IX_umbracoNodePath,IX_umbracoNodeUniqueID,IX_umbracoNodeObjectType,IX_cmsContentType,IX_cmsContentType_icon,IX_cmsTemplate_nodeId,IX_cmsContent,IX_cmsContentVersion_ContentId,IX_cmsContentVersion_VersionId,IX_cmsDocument,IX_cmsDocument_published,IX_cmsDocument_newest,IX_cmsDataType_nodeId,IX_cmsDictionary_id,IX_umbracoLanguage_languageISOCode,IX_umbracoLog,IX_cmsMacro_UniqueId,IX_cmsMacroPropertyAlias,IX_cmsMacroProperty_UniquePropertyId,IX_cmsMacroProperty_Alias,IX_cmsMember_LoginName,IX_cmsPropertyTypeGroupUniqueID,IX_cmsPropertyTypeUniqueID,IX_cmsPropertyData_1,IX_cmsPropertyData_2,IX_cmsPropertyData_3,IX_umbracoRelationType_UniqueId,IX_umbracoRelationType_name,IX_umbracoRelationType_alias,IX_umbracoRelation_parentChildType,IX_cmsTags,IX_umbracoUser_userLogin,IX_cmsTaskType_alias,IX_umbracoUser2NodePermission_nodeId,IX_computerName,IX_umbracoServer_isActive,IX_umbracoAccess_nodeId,IX_umbracoAccessRule,IX_umbracoMigration,IX_umbracoRedirectUrl

The following indexes were found in the database, but are not in the current schema: IX_cmsPropertyData,umbracoUserLogins_Index,IX_umbracoNodeTrashed,IX_umbracoNodePath,IX_umbracoNodeUniqueID,IX_cmsContentVersion_ContentId,IX_cmsDocument_published,IX_cmsDocument_newest,IX_cmsMacro_UniqueId,IX_cmsMacroPropertyAlias,IX_cmsMacroProperty_UniquePropertyId,IX_cmsMacroProperty_Alias,IX_cmsMember_LoginName,IX_cmsPropertyTypeGroupUniqueID,IX_cmsPropertyTypeUniqueID,IX_umbracoRelationType_UniqueId,IX_umbracoRelationType_name,IX_umbracoRelationType_alias,IX_umbracoRelation_parentChildType,IX_cmsTags,IX_umbracoUser2NodePermission_nodeId,IX_umbracoAccess_nodeId,IX_umbracoAccessRule,IX_umbracoMigration,IX_umbracoRedirectUrl

2017-07-28 10:36:29,869 [P19304/D4/T20] ERROR Umbraco.Web.Install.Controllers.InstallApiController - Installation step DatabaseUpgrade failed. System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: The index 'IX_umbracoNodeUniqueID' is dependent on column 'uniqueID'. ALTER TABLE ALTER COLUMN uniqueID failed because one or more objects access this column. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt') at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction) 2017-07-28 10:36:29,871 [P19304/D4/T20] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 24567ms) 2017-07-28 10:36:29,871 [P19304/D4/T20] ERROR Umbraco.Web.Install.Controllers.InstallApiController - An error occurred during installation step DatabaseUpgrade System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: The index 'IX_umbracoNodeUniqueID' is dependent on column 'uniqueID'. ALTER TABLE ALTER COLUMN uniqueID failed because one or more objects access this column. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt') at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction) at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)


Stephan 28 Jul 2017, 10:22:50

oh no... it ''has'' been fixed - what code are you using exactly (branch/latest commit)?


mark firth 28 Jul 2017, 10:28:18

Hi, dev-v7 https://github.com/umbraco/Umbraco-CMS/tree/dev-v7

and looking at the Up() function i have:

    public override void Up()
    {
        var indexes = SqlSyntax.GetDefinedIndexes(Context.Database)
            .Select(x => new DbIndexDefinition()
            {
                TableName = x.Item1,
                IndexName = x.Item2,
                ColumnName = x.Item3,
                IsUnique = x.Item4
            }).ToArray();

        // drop the index if it exists
        if (indexes.Any(x => x.IndexName.InvariantEquals("IX_umbracoNodeUniqueID")))
            Delete.Index("IX_umbracoNodeUniqueID").OnTable("umbracoNode");

        // set uniqueID to be non-nullable
        // the index *must* be dropped else 'one or more objects access this column' exception
        Alter.Table("umbracoNode").AlterColumn("uniqueID").AsGuid().NotNullable();

        // create the index
        Create.Index("IX_umbracoNode_uniqueID").OnTable("umbracoNode").OnColumn("uniqueID").Unique();
    }

==========================


mark firth 29 Jul 2017, 08:34:54

Update. I got this to work by commenting out the line:

Alter.Table("umbracoNode").AlterColumn("uniqueID").AsGuid().NotNullable();

Then prior to the upgrade i executed

ALTER TABLE [umbracoNode] ALTER COLUMN [uniqueID] UniqueIdentifier NOT NULL

against the the database. then ran the upgrade and it worked OK bizarrely.

My 6.1.6 database does not have the IX_umbracoNodeUniqueID index so it baffling to see why the error occurs as it suggests that the column has the dependent index..

anyway i've got a work around.

cheers,

mark


Pieter van Uhm 09 Aug 2017, 08:15:14

Upgrading from 7.1.4 to 7.6.3. gives sames error as people mentioned here.

The database failed to upgrade. ERROR: The database configuration failed with the following message: The index 'IX_umbracoNodeUniqueID' is dependent on column 'uniqueID'. ALTER TABLE ALTER COLUMN uniqueID failed because one or more objects access this column. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')

Any fix for this version?


Sebastiaan Janssen 09 Aug 2017, 08:28:17

@pietervanuhm No fix for 7.6.3, you can upgrade to 7.6.5 where this problem is fixed.


Pieter van Uhm 09 Aug 2017, 08:35:02

@sebastiaan Is it possible to update by Nuget to this version?


Sebastiaan Janssen 09 Aug 2017, 08:51:42

Yes, of course Update-Package UmbracoCms should do the trick.

Make sure you have backups of your site and database before doing that.

Note that the release page lists links to upgrade guides, etc: https://our.umbraco.org/contribute/releases/765/


Pieter van Uhm 09 Aug 2017, 09:25:50

@sebastiaan Nope, i get this:

PM> Update-Package UmbracoCms Attempting to gather dependency information for multiple packages with respect to project 'X', targeting '.NETFramework,Version=v4.5.1' Attempting to resolve dependencies for multiple packages. Resolving actions install multiple packages Resolution was successful but resulted in no action There are no new updates available. No package updates are available from the current package source for project 'X'.

and with this: PM> Update-Package UmbracoCms -Version 7.6.5. i get the same.

Edit: Sorry i think i already had 7.6.5. but i still have the error..


Pieter van Uhm 10 Aug 2017, 14:38:43

@sebastiaan do you have any idea to the issue above?


Martin Affolter 10 Aug 2017, 16:23:26

Same here, update via NuGet, from 7.1.8 to 7.6.5:

2017-08-10 18:11:23,688 [P4644/D4/T5] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 20: ALTER TABLE [umbracoNode] ALTER COLUMN [uniqueID] UniqueIdentifier NOT NULL

2017-08-10 18:11:23,709 [P4644/D4/T5] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Exception (8acbe854). System.Data.SqlClient.SqlException (0x80131904): The index 'IX_umbracoNodeUniqueID' is dependent on column 'uniqueID'. ALTER TABLE ALTER COLUMN uniqueID failed because one or more objects access this column. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.b__0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) ClientConnectionId:76403621-9545-4f9c-97de-2b1c6e9c7620 Error Number:5074,State:1,Class:16


Martin Affolter 11 Aug 2017, 08:46:34

Got it working by executing the command manually via ssms:

ALTER TABLE [umbracoNode] ALTER COLUMN [uniqueID] UniqueIdentifier NOT NULL


Pieter van Uhm 11 Aug 2017, 10:25:53

@martin@affolter.net Thanks this fixed my upgrade issue, now i have another issue:

backoffice is working perfectly. Only in front-end i have this.

================================ Server Error in '/' Application.

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0234: The type or namespace name 'Helpers' does not exist in the namespace 'Microsoft.Web' (are you missing an assembly reference?)

Source Error:

Line 29: using Umbraco.Core.Models; Line 30: using Umbraco.Web.Mvc; Line 31: using Microsoft.Web.Helpers; Line 32: using umbraco; Line 33: using Examine;

=============================

I added the old Microsoft.Web.Helpers that i had in a backup, then i get this.

============================= Server Error in '/' Application.

Attempt by security transparent method 'Microsoft.Web.Helpers.PreApplicationStartCode.Start()' to access security critical method 'System.Web.WebPages.Razor.WebPageRazorHost.AddGlobalImport(System.String)' failed.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.MethodAccessException: Attempt by security transparent method 'Microsoft.Web.Helpers.PreApplicationStartCode.Start()' to access security critical method 'System.Web.WebPages.Razor.WebPageRazorHost.AddGlobalImport(System.String)' failed.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[MethodAccessException: Attempt by security transparent method 'Microsoft.Web.Helpers.PreApplicationStartCode.Start()' to access security critical method 'System.Web.WebPages.Razor.WebPageRazorHost.AddGlobalImport(System.String)' failed.] Microsoft.Web.Helpers.PreApplicationStartCode.Start() +35

[InvalidOperationException: The pre-application start initialization method Start on type Microsoft.Web.Helpers.PreApplicationStartCode threw an exception with the following error message: Attempt by security transparent method 'Microsoft.Web.Helpers.PreApplicationStartCode.Start()' to access security critical method 'System.Web.WebPages.Razor.WebPageRazorHost.AddGlobalImport(System.String)' failed..] System.Web.Compilation.BuildManager.InvokePreStartInitMethodsCore(ICollection1 methods, Func1 setHostingEnvironmentCultures) +622 System.Web.Compilation.BuildManager.InvokePreStartInitMethods(ICollection`1 methods) +141 System.Web.Compilation.BuildManager.CallPreStartInitMethods(String preStartInitListPath, Boolean& isRefAssemblyLoaded) +102 System.Web.Compilation.BuildManager.ExecutePreAppStart() +157 System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters, PolicyLevel policyLevel, Exception appDomainCreationException) +531

[HttpException (0x80004005): The pre-application start initialization method Start on type Microsoft.Web.Helpers.PreApplicationStartCode threw an exception with the following error message: Attempt by security transparent method 'Microsoft.Web.Helpers.PreApplicationStartCode.Start()' to access security critical method 'System.Web.WebPages.Razor.WebPageRazorHost.AddGlobalImport(System.String)' failed..] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +9947380 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +101 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +261

=============================


Trevor Loader 22 Aug 2017, 05:01:36

I tried upgrading from 7.1.6 directly to 7.6.5 and it failed with the same index problem. So this has NOT been fixed with 7.6.5.

@martin@affolter.net suggestion above of running ALTER TABLE [umbracoNode] ALTER COLUMN [uniqueID] UniqueIdentifier NOT NULL on the database when the upgrade fails does work!

Thanks Martin!


Tomasz Kowalski 23 Aug 2017, 08:20:09

I'd like to confirm what @trevorloader says. I've just tried tu update 7.1.8 to fresh downloaded 7.6.5, and experienced error with IX_umbracoNodeUniqueID index. Fortunately "Alter table..." fix works


Asbjørn Riis-Knudsen 24 Aug 2017, 13:39:35

This is not fixed. I just tried upgrading a 7.1.8 site as well. The exact same error occurs.


Sebastiaan Janssen 24 Aug 2017, 13:59:55

Is anybody can send us a database where this fails we'd be very grateful, then we can see if we can fix it.. again! :-)

  1. Zip up the database with a LONG zip password
  2. Upload to Wetransfer.com
  3. As the receiver email set sj@umbraco.dk
  4. Leave a comment Visible to HQ with the zip password (see screenshot)


Asbjørn Riis-Knudsen 24 Aug 2017, 15:22:38

@sebastiaan I should be able to get you a database tomorrow.


Sebastiaan Janssen 25 Aug 2017, 08:20:45

Thanks @arknu - I can confirm with your db this is still an issue. Looking into it now.


Sebastiaan Janssen 25 Aug 2017, 08:22:13

--This is a different error though: The database configuration failed with the following message: Invalid object name 'umbracoMigration'. - did you get that one?--

Ignore me, that was my fault for having 7.6.5 in the web.config instead of 7.1.8. :-)


Asbjørn Riis-Knudsen 25 Aug 2017, 08:23:42

Nope, the error message is the same (in the UI at least), but the cause is slightly different. Last time I had this issue, I had to delete the index in question manually. In this case, I had to run the ALTER TABLE SQL mentioned above to make the upgrade proceed (and the index does not appear to exist).


Sebastiaan Janssen 25 Aug 2017, 08:25:51

Yeah, that was my bad, tracking this in http://issues.umbraco.org/issue/U4-10358 now.


Sebastiaan Janssen 25 Aug 2017, 20:05:38

Update: thanks @arknu - very useful to have a DB to test against! For everyone trying to upgrade from a version LOWER than 7.2.0, you can do a straight upgrade as of the upcoming 7.6.6 - for the root cause, see: http://issues.umbraco.org/issue/U4-10358


Priority: Normal

Type: Bug

State: Fixed

Assignee:

Difficulty: Normal

Category:

Backwards Compatible: True

Fix Submitted:

Affected versions: 7.6.3

Due in version: 7.6.5

Sprint: Sprint 63

Story Points: 3

Cycle: