Unnecessary Operations of CatalogVerificationService Cause Slow Deployments (Doc ID 1515345.1)

Last updated on OCTOBER 01, 2015

Applies to:

Oracle ATG Web Commerce - Version 9.0 and later
Information in this document applies to any platform.

Symptoms

CatalogMaintenanceService (CMS) runs on each datasource of a switching datasource during deployments of catalog data from a Merchandising server. The CatalogVerificationService section of CMS may be taking a particularly long time to complete on a large catalog or on a site with high traffic.

When CatalogVerificationService is doing a lot of work, SQL queries that are using SELECT COUNT(*) on the tables in the catalog's SQL tables may appear in database reports as taking a long time and a lot of database resources to complete.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms