Developer forum

Forum » Integration » Issues while creating product index.

Issues while creating product index.

E-mail notifications
Dmitrij Jazel
Reply
Posted on 16/10/2014 10:50:20

Hello guys,

I am having trouble creating Search index for products. Application: 8.3.1.2

Shop finished importing ca. 350 000 products from ERP.

Now I need to build an index of those products, in order to increase performance of the webshop.

Starting building index ... and eventually some error jums out.

First time I tryed manually update - and got :

[501] An error occured while updating an index.

Index: Products
Date: 10/15/2014 4:28:10 PM
Solution: 
Error message: Object reference not set to an instance of an object.
Call stack: at Dynamicweb.eCommerce.Products.Group.get_AllGroupsByLanguageID(String languageID)
at Dynamicweb.eCommerce.Products.Group.get_GroupByID(String groupID)
at Dynamicweb.eCommerce.Products.Group.GetGroupsByIDs(IEnumerable`1 groupIDs, Boolean applyFiltering)
at Dynamicweb.eCommerce.Products.ProductGroupRelationCollection.get_GroupCollection()
at Dynamicweb.eCommerce.Searching.Index.ProductIndexEntry.GetProductShops(Product p)
at Dynamicweb.eCommerce.Searching.Index.ProductIndexEntry.Initialize(Product p)
at Dynamicweb.eCommerce.Searching.Index.ProductIndexEntry..ctor(Product p)
at Dynamicweb.eCommerce.Searching.Index.ProductIndexEntry.Create(IDataReader reader)
at Dynamicweb.eCommerce.Searching.Index.ProductIndexer.Index(IndexerDataRequest request)
at Dynamicweb.Searching.Indexer.PerformIndexModifications(IEnumerable`1 fromEntries, IndexUpdateParameters parameters)
at Dynamicweb.Searching.Indexer.PerformUpdate(IEnumerable`1 data, IndexerQueueContentType expectedContentType, IndexUpdateParameters parameters)
at Dynamicweb.Searching.IndexManager.UpdateIndexInternal(Indexer i, Boolean isFullUpdate, Boolean updateSpell, IDictionary`2 flags)

Second time I setup a scheduled task, and got another message that is:

[501] An error occured while updating an index.

Index: Products
Date: 10/15/2014 4:28:10 PM
Solution: 
Error message: Object reference not set to an instance of an object.
Call stack: at Dynamicweb.eCommerce.Products.Group.get_AllGroupsByLanguageID(String languageID)
at Dynamicweb.eCommerce.Products.Group.get_GroupByID(String groupID)
at Dynamicweb.eCommerce.Products.Group.GetGroupsByIDs(IEnumerable`1 groupIDs, Boolean applyFiltering)
at Dynamicweb.eCommerce.Products.ProductGroupRelationCollection.get_GroupCollection()
at Dynamicweb.eCommerce.Searching.Index.ProductIndexEntry.GetProductShops(Product p)
at Dynamicweb.eCommerce.Searching.Index.ProductIndexEntry.Initialize(Product p)
at Dynamicweb.eCommerce.Searching.Index.ProductIndexEntry..ctor(Product p)
at Dynamicweb.eCommerce.Searching.Index.ProductIndexEntry.Create(IDataReader reader)
at Dynamicweb.eCommerce.Searching.Index.ProductIndexer.Index(IndexerDataRequest request)
at Dynamicweb.Searching.Indexer.PerformIndexModifications(IEnumerable`1 fromEntries, IndexUpdateParameters parameters)
at Dynamicweb.Searching.Indexer.PerformUpdate(IEnumerable`1 data, IndexerQueueContentType expectedContentType, IndexUpdateParameters parameters)
at Dynamicweb.Searching.IndexManager.UpdateIndexInternal(Indexer i, Boolean isFullUpdate, Boolean updateSpell, IDictionary`2 flags).

Not sure why this would happen, or maybe you have some suggestions that I can do/check in order to assure that index will go fine. Or what can cause this errors? During creation of the index, there is not much information about it, just a MB size of index.

Suggestions? :-)

 

/Dmitrij


Replies

 
Morten Snedker
Posted on 17/10/2014 09:25:14
Reply
This post has been marked as an answer

Hi Dmitrij,

We have made about 22,7 zillion improvements to the index from 8.3.1.2 up until latest 8.4. If 8.4.1.21 does not fix the problem, a video will go viral with me eating my socks. 

 

BR 
Snedker

Votes for this answer: 1
 
Dmitrij Jazel
Posted on 17/10/2014 10:55:22
Reply

hej Morten :-)

Hehe, no need to put you in that misery :-P I will try to get solution updated.

Thanks for info so far :-)

 

/Dmitrij

 
Dmitrij Jazel
Posted on 03/11/2014 17:01:37
Reply

Hej Morten :)

 

OK I got application updated.

And here is the message: [501] An error occured while updating an index.

Any suggestions why one can get such error? :)

 

/Dmitrij

 
Morten Snedker
Posted on 03/11/2014 20:10:07
Reply

No. For a fast resolution I suggest that you prepare a copy of the database and report support case with link to the database. Then we'll be able to debug it.

 

Regards /Snedker

 
Dmitrij Jazel
Posted on 03/11/2014 23:47:20
Reply

Oh... I just noticed, I am still getting the same error, exact one I got above.

For this project we are using SQL 2008 R2, and it has ~350K products

Just updated to newest 8.5.0.2.

 

And just saw your comment, and thought about that video again :-))) joking :-P

But we need to try to solve it somehow... I think we probably will contact you through developer support. :-)

 

/Dmitrij

 

You must be logged in to post in the forum