Duplicate Metric fails with status "Incomplete", error in the log: Error CMDBHealth : DUPLICATE error : java.lang.NullPointerException at com.snc.cmdb.identify_reconcile.IdentificationEngine.getMatchingIndependentCI(IdentificationEngine.java:2786) - Support and Troubleshooting

Duplicate Metric fails with status "Incomplete", error in the log: Error CMDBHealth : DUPLICATE error : java.lang.NullPointerException at com.snc.cmdb.identify_reconcile.IdentificationEngine.getMatchingIndependentCI(IdentificationEngine.java:2786) 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.

Additional Information Create an identification inclusion rule