Developer forum

Forum » PIM » PIM Index failing, but why?

PIM Index failing, but why?

E-mail notifications
Lars Bruun
Lars Bruun
Reply
Posted on 09/11/2020 12:40:02

Hi, 

Where can i find out why this index fails`?

2020-11-09 12:29:40.371: Running (96439 / 105671).
2020-11-09 12:29:40.496: Reading next batch, starting from ProductautoID: 277432.
2020-11-09 12:29:41.371: Reading next batch, starting from ProductautoID: 277932.
2020-11-09 12:29:41.856: Reading next batch, starting from ProductautoID: 278103.
2020-11-09 12:29:43.684: Error processing products. System.InvalidCastException: Specified cast is not valid.    at Dynamicweb.Ecommerce.Indexing.ProductIndexBuilder.HandlePrices(String productId, String variantId, String languageId, IndexDocument document)    at Dynamicweb.Ecommerce.Indexing.ProductIndexBuilder.ProcessProducts(SqlConnection connection, IIndexWriter writer, Tracker tracker)
2020-11-09 12:29:43.684: Error processing products
2020-11-09 12:29:43.699: Completed processing products.
2020-11-09 12:29:43.699: Closing index writer, just trying...
2020-11-09 12:29:44.043: Closed index writer successfully.
2020-11-09 12:29:44.043: Ended build process.
2020-11-09 12:29:44.043: Failed (96654 / 105671).

Replies

 
Steffen Kruse Hansen Dynamicweb Employee
Steffen Kruse Hansen
Posted on 10/11/2020 07:48:46
Reply

Hi Lars,

My guess would be that there's a price in the database which is either empty or NULL. If you don't need the prices in the index, you can just change the settings of the IndexBuilder, and set the 'SkipPrices' setting. That way all the prices would just be skipped doing indexing.

Best regards,

Steffen

 
Niklas Malmqvist
Niklas Malmqvist
Posted on 19/04/2021 10:29:19
Reply

Thank you! This helped us solve the same error.

 

You must be logged in to post in the forum