Hi ,
Observed these two queries taking long time to run. To Count large volume of data in the billing customer data table it is taking more time.
Queries:-
5ghmypfjkskhf – SELECT COUNT(CON_CHOOSER_MOBILE_NO) AS “MOBILEPHONE” FROM PEGAMARKETINGEXTERNAL.V_CAR_BLL_ACC_GDF;
5rqv48ckdvuv1– SELECT COUNT(ADR_ELECTRONIC_ADDRESS_DESC) AS “EMAIL” FROM PEGAMARKETINGEXTERNAL.V_CAR_BLL_ACC_GDF;
These queries are triggering from CDH Health Check.
Any Idea on How to disable this particular Healthchecks in CDH ?
This query is coming from the CDH System Health Check rule PegaCDH-Data-SystemHealthCheck-ConfigCheck.ValidateClassMappings, so the fix is to disable that specific health check entry in the System Health Check configuration. Open the CDH health check settings, find the ValidateClassMappings check, and mark it as inactive so it no longer runs those COUNT queries on the large external table. After saving the configuration, run the health check again to confirm the query is no longer triggered. This keeps the rest of the health checks working while stopping this one expensive validation. If needed, clear the related cache or restart the node once so the updated setting is picked up properly.
