Hello,

For about a week, the CommerceManager started to behave strangely. There were huge loading times, on the "Edit product" and "Add new product". And since today, it stopped working completely throwing this error :

[OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.]
   System.IO.MemoryStream.set_Capacity(Int32 value) +56
   System.IO.MemoryStream.EnsureCapacity(Int32 value) +48
   System.IO.MemoryStream.Write(Byte[] buffer, Int32 offset, Int32 count) +124
   System.Security.Cryptography.CryptoStream.FlushFinalBlock() +76
   System.Web.Configuration.MachineKeySection.EncryptOrDecryptData(Boolean fEncrypt, Byte[] buf, Byte[] modifier, Int32 start, Int32 length, Boolean useValidationSymAlgo) +164
   System.Web.UI.ObjectStateFormatter.Serialize(Object stateGraph) +168
   System.Web.UI.ObjectStateFormatter.System.Web.UI.IStateFormatter.Serialize(Object state) +4
   System.Web.UI.Util.SerializeWithAssert(IStateFormatter formatter, Object stateGraph) +37
   System.Web.UI.HiddenFieldPageStatePersister.Save() +106
   System.Web.UI.Page.SavePageStateToPersistenceMedium(Object state) +82
   System.Web.UI.Page.SaveAllState() +550
  System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2357

I have a production license version 4.1.2.16172

Hello,

How much memory does your server have and how much of it is being used?  What were the figures before you noticed this issue?

Mediachase Software

Hello,

The server has 4gb of memory. Before i was forced to restarted it, sqlserver process was using 1,5gb of memory. Which seems a bit to much to me...

1.5 GB for a SQL Server is not that much, but it all depends on the settings and how many applications are using SQL Server. What was the other memory used for? You should still have 2.0 GB available. Is your .NET/IIS application limited to a space it can use?

This is only a database server, with only the ecf database. No webserver, no nothing.

I think the OutOfMemory exception occurs when i make too many attempts to edit products in CommerceManager (which i explained earlier, behaves very strange).

It seems to be related to the problem i reported here : http://www.mediachase.com/Community/forums/thread/9764.aspx

Anyway, i cand send you either access to CommerceManager of the development site, or the ECF file with the XML export.

I've sent the ECF and SQL file to support.

It seems i fixed the problem. The MetaAtribute table had alomost 3 million records with null values. So i deleted them and everything looks and works fine. However, i still got this error when i go into one of the category :

System.NullReferenceException: Object reference not set to an instance of an object. at Mediachase.MetaDataPlus.MetaObject.GetElementaryFieldValues() at Mediachase.eCF.BusFacade.Filters.Products.MetaAttributesContentFilter.GetProductMetaFields(Product product) at Mediachase.eCF.BusFacade.Filters.Products.MetaAttributesContentFilter.CreateItem(Item& item, IMetaObject metaObject, String[] responseGroup, IList`1& errorArray) at Mediachase.eCF.BusFacade.ContentFilters.PopulateProductItem(Item& productItem, Product product, String currencyCode, String[] responseGroup, IList`1& errorArray) at Mediachase.eCF.BusFacade.Filters.Products.ProductSearchContentFilter.CreateProductItemsBySearch(SiteSearchRequest request, IList`1& errorArray) at Mediachase.eCF.BusFacade.ContentFilters.PopulateProductSearchItem(SiteSearchRequest request, IList`1& errorArray) at Mediachase.eCF.BusFacade.SiteManager.SiteSearch(SiteSearch search) at Mediachase.eCF.ClientLib2.ClientCatalog.SearchProducts(String searchIndex, String keywords, String[] searchFields, KeyValueAttribute[] filter, Int32 categoryid, Boolean incSubCategoryNodes, Decimal minprice, Decimal maxprice, String sort, Boolean sortOrder, String wherest, Int32 itemsPerPage, Int32 currentPage, String[] responseGroup, Int32& totalRecords, ErrorsError[]& errors)

Hi Victor,

Sorry for responding so late, but are you still experiencing the latest problem?

Thank you,

Mediachase Software

Yes, i do. However, not every product category behaves this way. Some of them are working just fine.

I read somewhere on your forum about serializing product meta-data by re-saving them.
Could this be the problem ?