2693449 - Resolutions to update bulk products

Symptom

There are over 400,000 products in customer's system. Customers want to update the online date for all products. When customers use below script or impex to update, they get "java.lang.OutOfMemoryError: GC overhead limit exceeded" error.

Date d = Date.parse('yyyy-MM-dd', '2010-04-03')
flexibleSearchService.search("SELECT {pk} FROM {Product} WHERE {Product.catalog} = '8796093186648' AND {Product.catalogversion} = '8796126085721'").result.each {
it.onlineDate = d
modelService.save(it)
}

UPDATE Product[batchmode=true];catalogVersion(catalog(id),version)[unique=true];onlineDate(code);
;electronicsProductCatalog:Staged
;2018-09-07 19:53:24.000000

Environment

SAP Hybris Commerce 5.7 to 1808

Product

SAP Commerce 1811 ; SAP Hybris Commerce 1808 ; SAP Hybris Commerce 6.0 ; SAP Hybris Commerce 6.1 ; SAP Hybris Commerce 6.2 ; SAP Hybris Commerce 6.3 ; SAP Hybris Commerce 6.4 ; SAP Hybris Commerce 6.5 ; SAP Hybris Commerce 6.6 ; SAP Hybris Commerce 6.7 ; SAP hybris Commerce 5.7

Keywords

out of memory, groovy, product , KBA , CEC-SCC-PLA-PL , Platform , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.