Hi!

Looking at the code of AddStaticAttributePropertyValues I'm guessing that the problem occurs in this chunk:

content.ApplicationId = entryRow.ApplicationId.ToString();
content.CatalogId = entryRow.CatalogId;
content.Code = entryRow.Code;
content.MetaClassId = entryRow.MetaClassId;
content.Name = entryRow.Name;
content.StartPublish = entryRow.StartDate.ToLocalTime();
content.StopPublish = entryRow.EndDate.ToLocalTime();
content.Categories.ContentLink = content.ContentLink;
content.Associations.ContentLink = content.ContentLink;
content.ParentEntries.ContentLink = content.ContentLink;

That would guess that either start date, end date or application id is missing on an entry. Can you look into the test data where you have this problem and see if you can find a suspicious entry?

Regards

Per Gunsarfs

Hi,

Thanks, I ran this queries in the database,

-------------

SELECT ApplicationId
FROM CatalogEntry
GROUP BY ApplicationId

SELECT StartDate
FROM CatalogEntry
GROUP BY StartDate

SELECT EndDate
FROM CatalogEntry
GROUP BY EndDate

------------

And everything looked good, on ApplicationId used for all items and all items had valid start and end dates. Is there another table I should check in?

/Viktor

Hmm, then I'm not really sure what it could be.

I would suggest turning on debug logging, as there is a decent amount of logging in the CatalogPropertyLoader class. If debug logging is turned on for that class (I suggest you scope the logging for the class or it's namespace, as full debug logging is very verbose) you should see a message just before the exception that the "LoadStaticContentProperties" method was called, and arguments what it was called with. That should give some clues as to what item that has the problematic data.

/Per

Hi,

Ok got this message in the log,

------------

2015-09-09 11:23:34,566 DEBUG ?.? - Calling 'GetClosestSetting' with parameter values: 1322
2015-09-09 11:23:34,573 DEBUG ?.? - Calling 'ResolveContent' with parameter values: 4b37b5d7-54b4-4011-d98d-2627165539b7
2015-09-09 11:23:34,580 DEBUG ?.? - Calling 'ResolveContent' with parameter values: 596__CatalogContent
2015-09-09 11:23:34,587 DEBUG ?.? - Calling 'LoadContent' with parameter values: 596__CatalogContent, EPiServer.Core.LanguageSelectorForProvider
2015-09-09 11:23:34,595 DEBUG ?.? - Calling 'LoadContents' with parameter values: System.Collections.Generic.List`1[EPiServer.Core.ContentReference], EPiServer.Core.LanguageSelectorForProvider
2015-09-09 11:23:34,608 DEBUG ?.? - Calling 'GetItems' with parameter values: System.Collections.Generic.List`1[EPiServer.Core.ContentReference], de
2015-09-09 11:23:34,616 DEBUG ?.? - Calling 'GetContentFromBuilder' with parameter values: System.Linq.GroupedEnumerable`3[EPiServer.Core.ContentReference,Mediachase.Commerce.Catalog.CatalogContentType,EPiServer.Core.ContentReference]
2015-09-09 11:23:34,624 DEBUG ?.? - Calling 'Create' with parameter values: System.Collections.Generic.List`1[EPiServer.Core.ContentReference], de
2015-09-09 11:23:34,637 DEBUG ?.? - Calling 'Create' with parameter values: Variation, 5, de, 1
2015-09-09 11:23:34,644 DEBUG ?.? - Calling 'GetContentTypeModel' with parameter values: 5
2015-09-09 11:23:34,650 DEBUG ?.? - Calling 'Create' with parameter values: Company.Brand.Core.Models.MetaData.SiteProductContent, de, 1
2015-09-09 11:23:34,657 DEBUG ?.? - Calling 'CreateContent' with parameter values: EPiServer.DataAbstraction.ContentType, EPiServer.Construction.BuildingContext
2015-09-09 11:23:34,663 DEBUG ?.? - Calling 'VerifyLanguageSetup' with parameter values: Castle.Proxies.SiteProductContentProxy, de, 1
2015-09-09 11:23:34,673 DEBUG ?.? - Calling 'LoadProperties' with parameter values: Mediachase.Commerce.Catalog.Dto.CatalogEntryDto+CatalogEntryRow, Mediachase.Commerce.Catalog.Dto.CatalogEntryDto+CatalogItemSeoRow, Mediachase.Commerce.Catalog.Dto.CatalogEntryDto+VariationRow
2015-09-09 11:23:34,679 DEBUG ?.? - Calling 'LoadStaticContentProperties' with parameter values: Mediachase.Commerce.Catalog.Dto.CatalogEntryDto+CatalogEntryRow, Mediachase.Commerce.Catalog.Dto.CatalogEntryDto+CatalogItemSeoRow, Mediachase.Commerce.Catalog.Dto.CatalogEntryDto+VariationRow, Castle.Proxies.SiteProductContentProxy
2015-09-09 11:23:34,733 ERROR ?.? - 1.2.5 Unhandled exception in ASP.NET
System.NullReferenceException: Object reference not set to an instance of an object.
at EPiServer.Commerce.Catalog.Provider.Construction.CatalogPropertyLoader.AddStaticAttributePropertyValues(CatalogEntryRow entryRow, EntryContentBase content)
at EPiServer.Commerce.Catalog.Provider.Construction.CatalogPropertyLoader.LoadStaticContentProperties(CatalogEntryRow entryRow, CatalogItemSeoRow seoRow, VariationRow variationRow, EntryContentBase content)
at EPiServer.Commerce.Catalog.Provider.Construction.CatalogPropertyLoader.LoadProperties(CatalogEntryRow entryRow, CatalogItemSeoRow seoRow, VariationRow variationRow, EntryContentBase content)
at EPiServer.Commerce.Catalog.Provider.Construction.EntryBuilder.ConstructEntries(CatalogEntryDto entryDto, String language, IList`1 contentLinks, IList`1 entryNodeRelations)
at EPiServer.Commerce.Catalog.Provider.Construction.EntryBuilder.Create(IList`1 contentLinks, String language)
at EPiServer.Commerce.Catalog.Provider.CatalogContentLoader.GetContentFromBuilder[T](String language, IEnumerable`1 linkByType)
at EPiServer.Commerce.Catalog.Provider.CatalogContentLoader.GetItems[T](IList`1 contentLinks, String language)

------------

I have looked any closer at the log output but will do that now, just wanted to postit here first.

/Viktor

Hi,

Ok, I found entry with id 596, I was also able to find it in the Commerce Manager. I deleted the item from Commerce Manager and could not find it anymore but the site still crashed at the same point and entry with id 596 was still in the database so ran the following SQL query,

-----

DELETE FROM CatalogItemSeo WHERE CatalogEntryId = 596
DELETE FROM CatalogEntry WHERE CatalogEntryId = 596

-----

to remove the item and now the startpage loades but I still get the same error when loading the product list page for the next error product. I guess if I remove that product from the database I will get the error for the next product etc. etc.

/Viktor

Hi,

When you delete an item from Commerce Manager, it should delete all information in related tables properly, no SQL needed.

I suspect you have a faulty catalog, but it's really hard for us to diagnose remotely like this to know what is wrong. What I can suggest is to try to export the catalog, delete it then reimport. It hopefully correct the faulty values.

If the problem still exists, you might need to contact our Developer Support services for proper investigation.

Regards,

/Q

Hi,

Yes, just stupid me who did not switch the connection string for the commerce manager to my local DB when trying to delete the item...

I exported the catalog but when I import it again it creates two levels of nodes but the third level is created right under the catalog, but I still get the same error message on the site.

The site was created on a pre-release version of EPiServer 7.5 so it my be some junk in the database? I will contact developer support.

/Viktor

"

I exported the catalog but when I import it again it creates two levels of nodes but the third level is created right under the catalog, but I still get the same error message on the site.

"

Sound like issues with NodeRelation and/or NodeEntryRelation.

A possible way to try:

- Install a 7.5 site, attach to the database

- export the catalog

- import again in your current site.

Of course contacting our developer support services is one way to go.

Regards,

/Q

Hi,

I connected the Commerce database to a Quicksilver installation and did the export there and then imported again but still with the same structure error. I have sent the database to developer support now and hope they can find something wrong. Thanks for your help! 

/Viktor

Hi,

The support case related to your issue has been resolved. The problem was the ParentEntries property definition for your content type was missing from [tblPropertyDefinition].

This is supposed to fix your issue:

  insert into [dbo].[tblPropertyDefinition]
  ([fkContentTypeID]
      ,[fkPropertyDefinitionTypeID]
      ,[FieldOrder]
      ,[Name]
      ,[Property]
      ,[Required]
      ,[Advanced]
      ,[Searchable]
      ,[EditCaption]
      ,[HelpText]
      ,[ObjectProgID]
      ,[DefaultValueType]
      ,[LongStringSettings]
      ,[SettingsID]
      ,[LanguageSpecific]
      ,[DisplayEditUI]
      ,[ExistsOnModel])
   
  (SELECT TOP 1 
      21
      ,[fkPropertyDefinitionTypeID]
      ,[FieldOrder]
      ,[Name]
      ,[Property]
      ,[Required]
      ,[Advanced]
      ,[Searchable]
      ,[EditCaption]
      ,[HelpText]
      ,[ObjectProgID]
      ,[DefaultValueType]
      ,[LongStringSettings]
      ,[SettingsID]
      ,[LanguageSpecific]
      ,[DisplayEditUI]
      ,[ExistsOnModel]
  FROM [dbo].[tblPropertyDefinition]
  where Name = 'ParentEntries')

With 21 is the pkID of your content type in tblContentType.

Regards.

/Q

Hi,

Ok that query solved the issue for the start page and product lists but now I get the same error message when trying to load some product pages and some product pages work, all products work on the product listing pages. I will debug some and see if I can see anything.

/Viktor

You should compare between the [tblPropertyDefinition] table between your production database and development database. I suspect there might be other properties missing.

/Q

Hi,

Ahh, ok you are right the same property was missing from content 42, 43 and 44 so adding them seems to have solved it for all products. Thanks!

Is there something corrupt in our test database or is it a bug in the upgrade scripts?

/Viktor

I suspect it's an error in the database migration - when you transfer between databases those rows might be lost. I think the upgrade scripts won't touch those things - do you have an old version of database which has not been upgraded to check?

If it's an issue with our upgrade scripts (very unlikely, but still a possibility), let us know and we'll work on it right away.

Regards,

/Q

Hi,

I just had an issue related to this matter. I got the same error in a Commerce 8.16.1 solution and found out 
that all my custom content models (defined in code) was deleted from the tblContent every time the Commerce Manager app-pool was recycled.

The models was then recreated when I recycled the app-pool for the CMS site. I resolved it by moving my models to a separate assembly and
then added them to the bin folder for both applications. Is this the correct way to do or should I somehow disable the 
assembly scanning for the Commerce Manager site?

Kind Regards,

Christer Heinbäck

Hi,

So if I understand correctly, your typed content types are deleted because the assembly contains them was not in bin folder of Commerce Manager?

That sounds very strange. It should not behave that way. Make sure you have this in CM's web.config. enableModelSyncCommit should be false. 

  <episerver>
    <applicationSettings enableModelSyncCommit="false" uiUrl="~/UI/" enableScheduler="false" />
  </episerver>

Regards, 
/Q

Hi Quan,

My applicationSettings look a bit diffrent and the enableModelSyncComit attribute is missing:

  <episerver>
    <workflowSettings disable="true"/>
    <applicationSettings httpCacheability="Public" pageValidateTemplate="false" uiShowGlobalizationUserInterface="true" uiUrl="~/EPiServer/CMS/" urlRebaseKind="ToRootRelative" enableScheduler="false"/>
  </episerver>

I will try adding the attribute. Should I remove all other attributes?

Regards,

Christer

Hi,

I don't think the other settings are needed. enableModelSyncCommit and enableScheduler should be there. and IIRC then uiUrl was required by Framework. 

/Q