Clone from Live, run site, choose restore, and get: No differences found, but checksums differ.

[lcichanowicz]

Issue description

This sure seems like https://github.com/umbraco/Umbraco.Cloud.Issues/issues/290

I just cloned my site, locally, from Live, into VS 2022. I don't even open any files. I run the site in IIS. I get the Umbraco launch page. I choose Restore. It gets to 25%, then:

Schema mismatch
While trying to restore, we found schema mismatches between your environments. To be able to restore content, first make sure you have pulled and applied all pending schema changes via git before trying to restore.

If you are still experiencing problems, please refer to the documentation on how to [troubleshoot schema errors on Umbraco Cloud](https://our.umbraco.org/documentation/Umbraco-Cloud/Troubleshooting/Content-Deploy-Schema/Local/).

The following items are causing problems:

Document type Home with alias 'home'
umb://document-type/577b209eca2344f1ab40abb86a4efb45
No differences found, but checksums differ.
Source checksum json: {"Name":"Home","Alias":"home","DefaultTemplate":"umb://template/cb3b398c09f3432eae1517b495bbc2ac","AllowedTemplates":["umb://template/8275bc35e57d4173b3983c416290e16d","umb://template/cb3b398c09f3432eae1517b495bbc2ac"],"Icon":"icon-home color-deep-purple","Thumbnail":"folder.png","Description":null,"IsContainer":false,"Permissions":{"AllowVaryingByCulture":false,"AllowVaryingBySegment":false,"AllowedAtRoot":true,"IsElementType":false,"AllowedChildContentTypes":["umb://document-type/66b6ff3615ae46c581d5550ac3143183","umb://document-type/e2de3fb120af468ab15381d634b8b4e7","umb://document-type/743dbe6fc9314150809c99a20b3d5428","umb://document-type/c55871615c6949a298c770a54265e19c"]},"Parent":null,"CompositionContentTypes":[],"PropertyGroups":[],"PropertyTypes":[],"Udi":"umb://document-type/577b209eca2344f1ab40abb86a4efb45","Dependencies":[{"Udi":"umb://document-type/66b6ff3615ae46c581d5550ac3143183","Ordering":false,"Mode":0},{"Udi":"umb://document-type/743dbe6fc9314150809c99a20b3d5428","Ordering":false,"Mode":0},{"Udi":"umb://document-type/c55871615c6949a298c770a54265e19c","Ordering":false,"Mode":0},{"Udi":"umb://document-type/e2de3fb120af468ab15381d634b8b4e7","Ordering":false,"Mode":0},{"Udi":"umb://template/8275bc35e57d4173b3983c416290e16d","Ordering":true,"Mode":0},{"Udi":"umb://template/cb3b398c09f3432eae1517b495bbc2ac","Ordering":true,"Mode":0}],"__type":"Umbraco.Deploy,Umbraco.Deploy.Artifacts.ContentType.DocumentTypeArtifact"}
Target checksum json: {"Name":"Home","Alias":"home","DefaultTemplate":"umb://template/cb3b398c09f3432eae1517b495bbc2ac","AllowedTemplates":["umb://template/8275bc35e57d4173b3983c416290e16d","umb://template/cb3b398c09f3432eae1517b495bbc2ac"],"Icon":"icon-home color-deep-purple","Thumbnail":"folder.png","Description":null,"IsContainer":false,"Permissions":{"AllowVaryingByCulture":false,"AllowVaryingBySegment":false,"AllowedAtRoot":true,"IsElementType":false,"AllowedChildContentTypes":["umb://document-type/66b6ff3615ae46c581d5550ac3143183","umb://document-type/743dbe6fc9314150809c99a20b3d5428","umb://document-type/c55871615c6949a298c770a54265e19c","umb://document-type/e2de3fb120af468ab15381d634b8b4e7"]},"Parent":null,"CompositionContentTypes":[],"PropertyGroups":[],"PropertyTypes":[],"Udi":"umb://document-type/577b209eca2344f1ab40abb86a4efb45","Dependencies":[{"Udi":"umb://document-type/66b6ff3615ae46c581d5550ac3143183","Ordering":false,"Mode":0},{"Udi":"umb://document-type/743dbe6fc9314150809c99a20b3d5428","Ordering":false,"Mode":0},{"Udi":"umb://document-type/c55871615c6949a298c770a54265e19c","Ordering":false,"Mode":0},{"Udi":"umb://document-type/e2de3fb120af468ab15381d634b8b4e7","Ordering":false,"Mode":0},{"Udi":"umb://template/8275bc35e57d4173b3983c416290e16d","Ordering":true,"Mode":0},{"Udi":"umb://template/cb3b398c09f3432eae1517b495bbc2ac","Ordering":true,"Mode":0}],"__type":"Umbraco.Deploy,Umbraco.Deploy.Artifacts.ContentType.DocumentTypeArtifact"}
Document type State with alias 'state'
umb://document-type/a177987172d44b728faf219df7156ec4
No differences found, but checksums differ.
Source checksum json: {"Name":"State","Alias":"state","DefaultTemplate":"umb://template/b5535c555839446e9e7d185ab22ad827","AllowedTemplates":["umb://template/b5535c555839446e9e7d185ab22ad827"],"Icon":"icon-map color-brown","Thumbnail":"folder.png","Description":null,"IsContainer":false,"Permissions":{"AllowVaryingByCulture":false,"AllowVaryingBySegment":false,"AllowedAtRoot":false,"IsElementType":false,"AllowedChildContentTypes":["umb://document-type/bc8843ab525b429cae724193dcb59d1b","umb://document-type/13a3d99cd630457f9017df3028416e73","umb://document-type/9dc8b3a7b60944d9945fd4d18563b5c0","umb://document-type/8a437f7fbd2d445e83af227be6827ed7"]},"Parent":"umb://document-type/66b6ff3615ae46c581d5550ac3143183","CompositionContentTypes":["umb://document-type/66b6ff3615ae46c581d5550ac3143183"],"PropertyGroups":[{"Key":"a7a77e37-1f81-4c50-85db-9c5e2e819c3d","Name":"Main","SortOrder":1,"Type":0,"Alias":"","PropertyTypes":[{"Key":"01ef620b-7155-4fac-92aa-3d10c45e5e71","Alias":"stateName","DataType":"umb://data-type/0cc0eba1996042c9bf9b60e150b429ae","Description":null,"Mandatory":true,"Name":"State Name","SortOrder":0,"Validation":null,"VariesByCulture":false,"VariesBySegment":false,"LabelOnTop":false,"MemberCanEdit":false,"ViewOnProfile":false,"IsSensitive":false},{"Key":"d727750b-9e52-41aa-9db4-b6825266109f","Alias":"borderingStates","DataType":"umb://data-type/96819435d1764f28a51605a80a4686bd","Description":null,"Mandatory":false,"Name":"Bordering States","SortOrder":1,"Validation":null,"VariesByCulture":false,"VariesBySegment":false,"LabelOnTop":false,"MemberCanEdit":false,"ViewOnProfile":false,"IsSensitive":false}]}],"PropertyTypes":[],"Udi":"umb://document-type/a177987172d44b728faf219df7156ec4","Dependencies":[{"Udi":"umb://data-type/0cc0eba1996042c9bf9b60e150b429ae","Ordering":true,"Mode":0},{"Udi":"umb://data-type/96819435d1764f28a51605a80a4686bd","Ordering":true,"Mode":0},{"Udi":"umb://document-type/13a3d99cd630457f9017df3028416e73","Ordering":false,"Mode":0},{"Udi":"umb://document-type/66b6ff3615ae46c581d5550ac3143183","Ordering":true,"Mode":0},{"Udi":"umb://document-type/8a437f7fbd2d445e83af227be6827ed7","Ordering":false,"Mode":0},{"Udi":"umb://document-type/9dc8b3a7b60944d9945fd4d18563b5c0","Ordering":false,"Mode":0},{"Udi":"umb://document-type/bc8843ab525b429cae724193dcb59d1b","Ordering":false,"Mode":0},{"Udi":"umb://template/b5535c555839446e9e7d185ab22ad827","Ordering":true,"Mode":0}],"__type":"Umbraco.Deploy,Umbraco.Deploy.Artifacts.ContentType.DocumentTypeArtifact"}
Target checksum json: {"Name":"State","Alias":"state","DefaultTemplate":"umb://template/b5535c555839446e9e7d185ab22ad827","AllowedTemplates":["umb://template/b5535c555839446e9e7d185ab22ad827"],"Icon":"icon-map color-brown","Thumbnail":"folder.png","Description":null,"IsContainer":false,"Permissions":{"AllowVaryingByCulture":false,"AllowVaryingBySegment":false,"AllowedAtRoot":false,"IsElementType":false,"AllowedChildContentTypes":["umb://document-type/13a3d99cd630457f9017df3028416e73","umb://document-type/8a437f7fbd2d445e83af227be6827ed7","umb://document-type/9dc8b3a7b60944d9945fd4d18563b5c0","umb://document-type/bc8843ab525b429cae724193dcb59d1b"]},"Parent":"umb://document-type/66b6ff3615ae46c581d5550ac3143183","CompositionContentTypes":["umb://document-type/66b6ff3615ae46c581d5550ac3143183"],"PropertyGroups":[{"Key":"a7a77e37-1f81-4c50-85db-9c5e2e819c3d","Name":"Main","SortOrder":1,"Type":0,"Alias":"","PropertyTypes":[{"Key":"01ef620b-7155-4fac-92aa-3d10c45e5e71","Alias":"stateName","DataType":"umb://data-type/0cc0eba1996042c9bf9b60e150b429ae","Description":null,"Mandatory":true,"Name":"State Name","SortOrder":0,"Validation":null,"VariesByCulture":false,"VariesBySegment":false,"LabelOnTop":false,"MemberCanEdit":false,"ViewOnProfile":false,"IsSensitive":false},{"Key":"d727750b-9e52-41aa-9db4-b6825266109f","Alias":"borderingStates","DataType":"umb://data-type/96819435d1764f28a51605a80a4686bd","Description":null,"Mandatory":false,"Name":"Bordering States","SortOrder":1,"Validation":null,"VariesByCulture":false,"VariesBySegment":false,"LabelOnTop":false,"MemberCanEdit":false,"ViewOnProfile":false,"IsSensitive":false}]}],"PropertyTypes":[],"Udi":"umb://document-type/a177987172d44b728faf219df7156ec4","Dependencies":[{"Udi":"umb://data-type/0cc0eba1996042c9bf9b60e150b429ae","Ordering":true,"Mode":0},{"Udi":"umb://data-type/96819435d1764f28a51605a80a4686bd","Ordering":true,"Mode":0},{"Udi":"umb://document-type/13a3d99cd630457f9017df3028416e73","Ordering":false,"Mode":0},{"Udi":"umb://document-type/66b6ff3615ae46c581d5550ac3143183","Ordering":true,"Mode":0},{"Udi":"umb://document-type/8a437f7fbd2d445e83af227be6827ed7","Ordering":false,"Mode":0},{"Udi":"umb://document-type/9dc8b3a7b60944d9945fd4d18563b5c0","Ordering":false,"Mode":0},{"Udi":"umb://document-type/bc8843ab525b429cae724193dcb59d1b","Ordering":false,"Mode":0},{"Udi":"umb://template/b5535c555839446e9e7d185ab22ad827","Ordering":true,"Mode":0}],"__type":"Umbraco.Deploy,Umbraco.Deploy.Artifacts.ContentType.DocumentTypeArtifact"}
Time: Sat Aug 27 2022 16:55:07 GMT-0400 (Eastern Daylight Time)

[lcichanowicz]

I found mention of a "partial restore" work around. Yeah, that bombs, too.

[AndyButland]

Hi @lcichanowicz - am just looking at what you've reported here, it does look to be either a regression or some other cause of the #290 issue you've referenced. Would you mind reaching out to Umbraco support? With your permission they can then give me access to your project to try to replicate what you've found and see if we can see why this issue is re-occurring.

[lcichanowicz]

Thanks, @AndyButland. I already contacted Umbraco Cloud support about this issue. How can I help get you what you need to assist?

[AndyButland]

If you could just update on your ticket please with reference to this conversation, and let them know that I'd like to have access to the project to test the clone myself and hopefully replicate the issue/dig into what the cause is.

[lcichanowicz]

Thanks, @AndyButland. I notified Dennis, at Umbraco Cloud that you want to help.

[AndyButland]

Hi @lcichanowicz - I tried this today, and not sure if good or bad news, but I could clone the project just fine (I repeated the clone, and it worked a second time without problems too).

I dug a little into the history of #290 - and can see the fix there was to ensure that when we generate the artifact for document types, the sort order of the list of AllowedChildContentTypes is respected. So I wondered if maybe there was an issue in your database, that perhaps somehow your content types had duplicate sort orders, that might mean you get a different order in different environments. But having had a look via the following query, that isn't the case (at least for content types "Home" and "State", which for you were reporting problems).

SELECT alias,id,AllowedId,SortOrder
FROM cmsContentTypeAllowedContentType ctact
INNER JOIN cmsContentType ct ON ct.nodeId = ctact.Id
ORDER BY Id,SortOrder

It's possible that was the case when you first tried this, but have since saved your doc types on live which cleared this issue. That's only a theory though.

All I can suggest at the moment is to please try again... perhaps it's now sorted for you. And if not, let us know and we'll try to investigate some more. Unfortunately this looked like an easy one to at least replicate, but that hasn't proved to be the case.

[Musealali]

Hey @lcichanowicz hope you're doing well!

We noticed that we haven't heard from you in a while regarding this issue. It appears that this issue is not related to our current product. For further assistance and to ensure your concern is addressed promptly, please refer to the appropriate tracker at https://github.com/umbraco/Umbraco.Deploy.Issues/issues

Best Regards.