Unnecessary Operations of CatalogVerificationService Cause Slow Deployments
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.
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.
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