Errors processing prices in index in DW10 site upgrade from 9

E-mail notifications

Imar Spaanjaars

Posted on 28/11/2025 15:01:04

We're seeing the following in the logs for the index builder:

Error processing prices. System.Collections.Generic.KeyNotFoundException: The given key 'ProductDefaultUnitID' was not present in the dictionary.

   at Dynamicweb.Ecommerce.Indexing.ProductIndexBuilder.HandlePrices(String productId, String variantId, String languageId, IndexDocument document, CountryCollection countries, Currency defaultCurrency, List`1 allCurrencies)

   at Dynamicweb.Ecommerce.Indexing.ProductIndexBuilder.ProcessProducts(SqlConnection connection, IIndexWriter writer, Tracker tracker)

I don't see ProductDefaultUnitID anywhere in our setup. Is that a required field somewhere I need to add? Or is it tripping over casing? (It's called ProductDefaultUnitId in the database).

Imar

Replies

Michael Knudsen

Posted on 28/11/2025 15:12:00

Hello Imar,

- 'ProductDefaultUnitId' can't be NULL in DW10, so if you update all 'ProductDefaultUnitId' = NULL in EcomProducts, the error will disapears.

I had a similar issue this week and Morten Snedker was my hero :-)

Br. Michael Knudsen

Imar Spaanjaars

Posted on 28/11/2025 19:59:05

Thanks Michael. Are you sure it's the same thing? It doesn't seem to be a data issue, but a Lucene document issue or so where ProductDefaultUnitID is not in the indexed document.

Does your field list include ProductDefaultUnitID, either directly or from a SchemaExtender?

Imar

Michael Knudsen

Posted on 01/12/2025 07:27:09

Hello Imar,

- try remove the NULL values in 'ProductDefaultUnitId' (EcomProducts) and build the index again... and let me know if it isn't solved.

Br. Michael Knudsen

Imar Spaanjaars

Posted on 01/12/2025 11:15:23

Alright, will give that a try. The index takes hours to rebuild so will have to try tonight.

Imar Spaanjaars

Posted on 13/01/2026 12:12:32

Just following up on this: setting ProductDefaultUnitId to none-null did indeed fix the issue (or at least one of the few we had :-) )

You must be logged in to post in the forum

Developer forum

Errors processing prices in index in DW10 site upgrade from 9

Replies