November Happy Hour will be moved to Thursday December 5th.
November Happy Hour will be moved to Thursday December 5th.
Do you have any custom routes setup. Are you using the DefaultHierarchialRouter for catalogcontent. Can you show the debug log for when you make the request?
I suspect it is failing trying to build the catalog tree in the content selector becuase it can only map one of three catalogs. Do you need to select catalog content. can you try adding
[AllowedTypes(new [] { typeof(PageData) })]
to the ContentReference?
It is hard to say what is going wrong. The method where it is choking on has protection before getting there to make sure it is of catalog content. The actual method is trying to cast the contentprovider for the contentLink to CatalogContentProvider. Maybe there is a is a block somewhere that has a reference to a non existant entry or node or one in draft state that was not migrated. Could you try to enable Draft store migration job and rerun and see if the problem still exists
Running that job crashes IIS, no logs at all.
Setting logs to All, running that job generates logfile with about 9000 lines
but one of thouse lines are ~65MB long and starts with:
2016-02-04 11:19:40,916 DEBUG [33] EPiServer.Logging.Compatibility.LogManager+CompatibilityWrapper.Debug - 10.5.1 Export/import progress: Initializing 2016-02-04 11:19:40,917 WARN [33] EPiServer.Logging.Compatibility.LogManager+CompatibilityWrapper.Warn - 10.5.2 Export/import warning: Unexpected format of PropertyContentReference: 41353__CatalogContent 2016-02-04 11:19:40,917 DEBUG [33] EPiServer.Logging.Compatibility.LogManager+CompatibilityWrapper.Debug - Importing property PageReference name='ContentLink' value='41353__CatalogContent' = '41353__CatalogContent' 2016-02-04 11:19:40,918 WARN [33] EPiServer.Logging.Compatibility.LogManager+CompatibilityWrapper.Warn - 10.5.2 Export/import warning: Unexpected format of PropertyContentReference: 41353__CatalogContent 2016-02-04 11:19:40,919 DEBUG [33] EPiServer.Logging.Compatibility.LogManager+CompatibilityWrapper.Debug - Importing property PageReference name='ContentLink' value='41353__CatalogContent' = '41353__CatalogContent' 2016-02-04 11:19:40,919 WARN [33] EPiServer.Logging.Compatibility.LogManager+CompatibilityWrapper.Warn - 10.5.2 Export/import warning: Unexpected format of PropertyContentReference: 41353__CatalogContent 2016-02-04 11:19:40,920 DEBUG [33] EPiServer.Logging.Compatibility.LogManager+CompatibilityWrapper.Debug - Importing property PageReference name='PriceReference' value='41353__CatalogContent' = '41353__CatalogContent' 2016-02-04 11:19:40,920 WARN [33] EPiServer.Logging.Compatibility.LogManager+CompatibilityWrapper.Warn - 10.5.2 Export/import warning: Unexpected format of PropertyContentReference: 41353__CatalogContent 2016-02-04 11:19:40,921 DEBUG [33] EPiServer.Logging.Compatibility.LogManager+CompatibilityWrapper.Debug - Importing property PageReference name='InventoryReference' value='41353__CatalogContent' = '41353__CatalogContent' 2016-02-04 11:19:40,922 WARN [33] EPiServer.Logging.Compatibility.LogManager+CompatibilityWrapper.Warn - 10.5.2 Export/import warning: Property 'Prices' does not exist on destination content type 2016-02-04 11:19:40,923 WARN [33] EPiServer.Logging.Compatibility.LogManager+CompatibilityWrapper.Warn - 10.5.2 Export/import warning: Property 'Price' does not exist on destination content type 2016-02-04 11:19:40,923 WARN [33] EPiServer.Logging.Compatibility.LogManager+CompatibilityWrapper.Warn - 10.5.2 Export/import warning: Property 'CategoryCodes' does not exist on destination content type 2016-02-04 11:19:40,924 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'LoadProperties' with parameter values: Castle.Proxies.BaseVariationProxy, EPiServer.Core.RawContent 2016-02-04 11:19:40,924 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetReferenceProperties' with parameter values: Castle.Proxies.BaseVariationProxy, 41353__CatalogContent 2016-02-04 11:19:40,992 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: , Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:40,994 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: Product name A, Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,010 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: , Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,011 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: , Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,011 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: , Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,012 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: , Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,013 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: 77777777, Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,014 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: Generell, Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,015 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: 25, Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,062 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: , Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,063 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: Product name B, Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,064 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: , Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,064 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: , Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,065 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: , Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,066 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: 15 cm, Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,066 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: 66666666, Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,067 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: Generell, Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,067 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: 25, Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,069 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: , Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,070 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: TS, Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,071 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: , Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,071 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: Sben, Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,071 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: https://url.to.image.no/image.jpg, Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,072 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: True, Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,073 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: , Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,073 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: , Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,077 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: Product description, Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,078 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: Product name C, Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:41,410 DEBUG [33] Mediachase.Commerce.Extensions.LogExtensions.DebugBeginMethod - Calling 'SetMetaObjectValueFromProperty' with parameter values: ["[\"[\\\"[\\\\\\\"[\\\\\\\\\\\\\\\"[\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"[\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"[\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"[\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"[\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
then it continues for about thouse 65MB and ends with:
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"]\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"]\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"]\\\\\\\\\\\\\\\"]\\\\\\\"]\\\"]\"]"], Mediachase.MetaDataPlus.Configurator.MetaField, Mediachase.MetaDataPlus.MetaObject 2016-02-04 11:19:49,019 DEBUG [1] EPiServer.Logging.Compatibility.LogManager+CompatibilityWrapper.DebugFormat - Adding 'C:\Projects\<projectUrl>\src\<Web>\modulesbin' to the AppDomain shadow copy path 2016-02-04 11:19:49,036 DEBUG [1] EPiServer.Logging.Compatibility.LogManager+CompatibilityWrapper.DebugFormat - New shadow copy path : C:\Projects\<projectUrl>\src\<Web>\modulesbin\bin;C:\Projects\<projectUrl>\src\<Web>\modulesbin 2016-02-04 11:19:49,331 DEBUG [1] EPiServer.Logging.Compatibility.LogManager+CompatibilityWrapper.Debug - EPiServer.Global ctor
We can see that IIS is starting by caling Global constructor:
2016-02-04 11:19:49,331 DEBUG [1] EPiServer.Logging.Compatibility.LogManager+CompatibilityWrapper.Debug - EPiServer.Global ctor
IIS should not be crashed like that
Looked at that product seems to be just fine(no long fields) in manager and commerce UI in cms and in database
I suspect somewhere there is a reference to one of those drafts which is causing the issue. Let me check with colleague who may be able to tell us how to find out
Do you have any implementation/extension of Catalog content, including node, entry? I suspect there is something wrong with the content link. The requested content is a CatalogContentBase, but its provider is not CatalogContentProvider, which means its ContentLink's ProviderName is not "CatalogContent".
What does BaseBlockData inherit from?
BaseBlockData inherits from EPiServer.Core.BlockData
Yes, that we have for node:
[CatalogContentType(GUID = "nguid", MetaClassName = "Category", DisplayName = "Category")] public class BaseCategory : NodeContent { ....
and for entries(product has ~ 30 extra properties, variation about 4 extra properties):
[CatalogContentType(GUID = "nguid", MetaClassName = "Product", DisplayName = "Product", Description = "desc")] public class BaseProduct : ProductContent { ...
[CatalogContentType(GUID = "nguid", MetaClassName = "Variation", DisplayName = "Variation", Description = "desc")] public class BaseVariation : VariationContent { ....
None of them override ContentLink property
Attached with Visual Studio and reflected EPiServer.Commerce.Internal.Migration.dll and started debugging
Got to exception:
Mediachase.MetaDataPlus.IncorrectValueTypeException was unhandled Message: An unhandled exception of type 'Mediachase.MetaDataPlus.IncorrectValueTypeException' occurred in EPiServer.Commerce.Internal.Migration.dll Additional information: Incorrect value type. Must be MetaStringDictionary.
That led me to BaseProduct 6 properties that look like this:
[JsonIgnore] [Display(Name = "Manuals", Description = "")] public virtual StringDictionary Manuals { get; set; }
Old implementation of: http://world.episerver.com/forum/developer-forum/EPiServer-Commerce/Thread-Container/2014/7/MetaDataTypeStringDictionary-from-code/
To all of them I added(just to test this):
[Ignore]
So that Commerce would ignore it, an it did, job successfully finished with:
2/4/2016 2:35:11 PM OK Migrated 6 PreviouslyPublished drafts.
Dont know if 6 properties removed should have matched 6 updates or its just coincidence.
With these changes applied tested property content selection in question and still got the same exception:
The content has to belong to EPiServer.Commerce.Catalog.Provider.CatalogContentProvider Parameter name: content
as before.
I guess I need to use more of reflector!
ran:
SELECT * FROM tblContentSoftlink WHERE ContentLink LIKE '%[_]%'
returns ~3k rows every single one ContentLink column ends with CatalogContent and starts with a number like we expect it to, examples:
1073742787__CatalogContent 43648__CatalogContent
this
SELECT * FROM tblContentSoftlink WHERE ContentLink LIKE '%[_]%' AND ContentLink NOT LIKE '%CatalogContent'
returns 0 rows, so all of them for sure ends with CatalogContent
ran:
SELECT * FROM tblContentProperty CP INNER JOIN tblContentSoftlink S ON CP.LinkGuid = S.fkReferencedContentGUID WHERE S.ContentLink LIKE '%[_]%'
returns ~ 4k rows
this:
SELECT * FROM tblContentProperty CP INNER JOIN tblContentSoftlink S ON CP.LinkGuid = S.fkReferencedContentGUID WHERE S.ContentLink LIKE '%[_]%' AND String NOT LIKE '%CatalogContent'
returns 0 rows, also looks like String column is as it should be
ran:
SELECT * FROM tblWorkContentProperty CP INNER JOIN tblContentSoftlink S ON CP.LinkGuid = S.fkReferencedContentGUID WHERE S.ContentLink LIKE '%[_]%'
returns about 8k rows
this:
SELECT * FROM tblWorkContentProperty CP INNER JOIN tblContentSoftlink S ON CP.LinkGuid = S.fkReferencedContentGUID WHERE S.ContentLink LIKE '%[_]%' AND String NOT LIKE '%CatalogContent'
returns 0 rows as well
So it looks like all of contentLink/string fields that have __ in middle(that are commerce records) ends with CatalogContent, I assume its correct as it is the same way in other(9.x) projects as well
Is that the correct way how to diagnose if links are correct?
Used reflector to attach and see what exactly fails:
So it fails on content with ID=363 and Provider name is null for it
running:
SELECT * FROM [tblContent] WHERE [pkID]=363 SELECT * FROM [tblContentType] WHERE [pkId] IN (SELECT [fkContentTypeID] FROM [tblContent] WHERE [pkID]=363)
returns:
pkID fkContentTypeID fkParentID ArchiveContentGUID CreatorName ContentGUID VisibleInMenu Deleted ChildOrderRule PeerOrder ContentAssetsID ContentOwnerID DeletedBy DeletedDate fkMasterLanguageBranchID ContentPath ContentType IsLeafNode ----------- --------------- ----------- ------------------- ------------ ------------------------------------ ------------- ------- -------------- ----------- ---------------- --------------- ---------- ------------ ------------------------ ------------ ----------- ---------- 363 75 1 NULL 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 1 0 3 100 NULL NULL NULL NULL 18 .1. 2 1 (1 row(s) affected) pkID ContentTypeGUID Created Filename Name Description IdString Available SortOrder MetaDataInherit MetaDataDefault WorkflowEditFields ACL DisplayName ModelType DefaultWebFormTemplate DefaultMvcController DefaultMvcPartialView ContentType ----------- ------------------------------------ ----------------------- --------------------- -------------------------- --------- --------- ----------- --------------- --------------- ------------------ ----- ------------ ------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- --------------------- ---------------------- ----------- 75 4FEF3ED0-6776-41E0-9450-3FE8A995E52F 2014-07-01 11:50:14.777 NULL RootContent Used as root/welcome page ?id= 1 NULL 0 0 NULL NULL NULL EPiServer.Commerce.Catalog.ContentTypes.RootContent, EPiServer.Business.Commerce, Version=9.7.0.1360, Culture=neutral, PublicKeyToken=8fe83dea738b45b7 NULL NULL NULL 2 (1 row(s) affected)
running these:
SELECT * FROM [tblContentProperty] WHERE [ContentLink] = 363 OR [LinkGuid]='5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3' SELECT * FROM [tblWorkContentProperty] WHERE [ContentLink] = 363 OR [LinkGuid]='5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3' SELECT * FROM [tblContentSoftlink] WHERE [fkOwnerContentID]=363 OR [fkReferencedContentGUID]='5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3'
returns:
fkPropertyDefinitionID fkContentID fkLanguageBranchID guid Boolean Number FloatNumber ContentType ContentLink Date String LongString LongStringLength LinkGuid ScopeName pkID ---------------------- ----------- ------------------ ------------------------------------ ------- ----------- ---------------------- ----------- ----------- ----- ------- ----------- ---------------- ------------------------------------ ---------- ----------- 552 849 18 B4A62714-6FC7-49AB-A51E-51D71347BDBA 0 NULL NULL NULL 363 NULL NULL NULL 0 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 NULL 32325 552 2229 18 E3F2BC1E-01C5-419F-81AA-FE2445442B8D 0 NULL NULL NULL 363 NULL NULL NULL 0 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 NULL 32226 552 2231 18 F904F78B-881B-4806-99DF-64480995F523 0 NULL NULL NULL 363 NULL NULL NULL 0 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 NULL 32236 552 2232 18 10948C82-0AFA-48BB-974D-C3A1C81F0AD1 0 NULL NULL NULL 363 NULL NULL NULL 0 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 NULL 32242 ........................... 552 2305 18 BE042D3D-E95A-450B-92EC-F54E69F228BE 0 NULL NULL NULL 363 NULL NULL NULL 0 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 NULL 62711 552 2306 18 4552091C-2E92-4912-AF25-434831266A18 0 NULL NULL NULL 363 NULL NULL NULL 0 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 NULL 32096 552 2307 18 EAA236E4-9A50-4F44-B833-AC5A8D3B453A 0 NULL NULL NULL 363 NULL NULL NULL 0 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 NULL 32100 552 2326 18 5307BD0D-CFDE-4F82-A5FA-A1D9722BED92 0 NULL NULL NULL 363 NULL NULL NULL 0 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 NULL 32027 552 2327 18 0BD406E6-CE1F-41C3-9A55-2168729ECC03 0 NULL NULL NULL 363 NULL NULL NULL 0 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 NULL 32032 552 2328 18 295888C1-F4B5-4B62-B623-D3D381476810 0 NULL NULL NULL 363 NULL NULL NULL 0 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 NULL 32035 (23 row(s) affected) pkID fkPropertyDefinitionID fkWorkContentID ScopeName guid Boolean Number FloatNumber ContentType ContentLink Date String LongString LinkGuid ----------- ---------------------- --------------- ---------- ------------------------------------ ------- ----------- ------------ ----------- ----------- ----- ------- ----------- ------------------------------------ 9565 552 2435 NULL 1CEBF535-9FD4-4165-AF6A-785F0EE484B4 0 NULL NULL NULL 363 NULL NULL NULL 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 9571 552 2437 NULL 99110341-8374-4020-B832-AA5A90859198 0 NULL NULL NULL 363 NULL NULL NULL 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 9580 552 2440 NULL D37DC93A-F44F-41C0-869D-E2D02AA9A769 0 NULL NULL NULL 363 NULL NULL NULL 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 9583 552 2441 NULL 932D5A53-931B-466E-8777-D13FCCA5DA66 0 NULL NULL NULL 363 NULL NULL NULL 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 ....................... 47077 552 16133 NULL F46E50E4-E319-4456-A92F-07B95DA68EC4 0 NULL NULL NULL 363 NULL NULL NULL 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 47088 552 16135 NULL B9E4C39A-C920-478B-BA4B-5F0D3EEAFFE1 0 NULL NULL NULL 363 NULL NULL NULL 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 47100 552 16146 NULL 7C183B7D-A380-4AD5-951A-C0D4B90A87A6 0 NULL NULL NULL 363 NULL NULL NULL 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 49953 552 16968 NULL 4BF9A2DF-E561-4685-8726-50A22B724650 0 NULL NULL NULL 363 NULL NULL NULL 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 49959 552 16969 NULL BE042D3D-E95A-450B-92EC-F54E69F228BE 0 NULL NULL NULL 363 NULL NULL NULL 5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3 (109 row(s) affected) pkID fkOwnerContentID LinkURL LinkType LinkProtocol ContentLink LastCheckedDate FirstDateBroken HttpStatusCode LinkStatus fkReferencedContentGUID OwnerLanguageID ReferencedLanguageID ----- ---------------- -------- ----------- ------------ ------------ ---------------- ---------------- -------------- ----------- ------------------------ --------------- -------------------- (0 row(s) affected)
I dont seem to have an entry in tblContent for my root page on a normal version 9 site. Can you take a backup and then try removing and see if that fixes it.
delete FROM [tblContentlanguage] WHERE [fkContentID]=363 delete FROM [tblWorkContent] WHERE [fkContentID]=363 delete FROM [tblContentAccess] WHERE [fkContentID]=363 delete FROM [tblContentProperty] WHERE [fkContentID]=363 delete FROM [tblContentProperty] WHERE [LinkGuid]='5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3' delete FROM [tblWorkContentProperty] WHERE [LinkGuid]='5FE98EF2-2A6C-46BD-A802-39B6E5F0A1D3' delete FROM [tblContent] WHERE [pkID]=363
Ran these sripts + iisreset, and afterwards it works,
also smoke tested whole solution, and nothing else seems to be broken by removing instance of this commerce root content
So my best guess is that they are there in database since commerce 1R2 or 7.x and migrationg to 9.x did not clean that up, or there could be many other reasons.
Anyway it now works fine, thanks Mark!
After migrating:
I have following exception:
this problem occurs on block like this(and others), for example:
when selecting ArticlePage it seems to fail to get what is under Root:
looks like this:
any pointers?