Issue
Symptoms
-Duplicate metric is showing "Incomplete"
-There is no Duplicate metric entry in cmdb_health_result
-When Duplicate job runs, below error is showing in the system logs:
Error CMDBHealth : DUPLICATE Error while processing batch : cmdb_ci_dns_name Last processed id : 0008a185db197b84b5bbb0a2399619af. Marking as incomplete and exiting. CMDBHealth
2019-07-11 00:02:11
Error CMDBHealth : DUPLICATE error : java.lang.NullPointerException
at com.snc.cmdb.identify_reconcile.IdentificationEngine.getMatchingIndependentCI(IdentificationEngine.java:2786)
at com.snc.cmdb.identify_reconcile.IdentificationEngine.runAudit(IdentificationEngine.java:2999)
at com.snc.cmdb.identify_reconcile.IdentificationEngine.runIdentificationAudit(IdentificationEngine.java:1818)
at com.snc.cmdb.health.DuplicateProcessor.processRecords(DuplicateProcessor.java:87)
at com.snc.cmdb.health.MetricProcessor.process(MetricProcessor.java:106)
at com.snc.cmdb.health.MetricProcessorScript.execute(MetricProcessorScript.java:35)
at com.snc.cmdb.health.MetricProcessorScript.jsStaticFunction_duplicateProcessor(MetricProcessorScript.java:59)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Note: NullPointerException is thrown by IdentificationEngine.getMatchingIndependentCI
Release
London, Madrid
Cause
Based on the error, when IRE queries cmdb_ci_dns_name table, it gets "null" result.
This is likely caused by a query business rule on cmdb_ci_dns_name table.
The business rule might have filtered out some CIs which IRE is trying to access.
Resolution
Either disable the query business rule, or use "Identification Inclusion Rule" to filter out the CIs that the query business rule blocks.