BMC Helix CMDB AI Import Job is Not Listed on CMDB Atrium Console Exception While Building the Root Cache

Knowledge Article

Article Number

000421111

Old Article Number

Article Type

Solutions to a Product Problem

Title

BMC Helix CMDB AI Import Job is Not Listed on CMDB Atrium Console Exception While Building the Root Cache

Summary

Atrium Integrator job does not get listed in CMDB console with error as the cache was not built due to below error
Exception while building the root cache: java.lang.NullPointerException: Cannot invoke "String.compareTo(String)" because the return value of "com.bmc.atrium.pentaho.ardbc.AIJobDirectoryInfo.getDirPath()" is null

Product

BMC Helix ITSM

Component

BMC Helix CMDB

Applies to

23.30.1

Problem

Cause

There was a directory referred in one of the jobs in form UDM:Repository:Job was not present in UDM:Repository:Directory form and this was not allowing cache to be built and resulting not listing any Atrium Integrator job on console

Solution

Open the directory form UDM:Repository:Directory
When this directory id is searched. It will not be available.

Open the UDM:Repository:Job search for the directory id which is referred to as directory ID in job "Job 1"
The job will be referring to this directory id.

Delete this reference and the issue will be solved.

========================================

You can run below query to find out all such records where directory id does not exists.

select distinct(C46531) DirectoryID from T453 where C46531 not in (select C1 from T481)

NOTE: In this scenario
453 is schemaid of UDM:Repository:Job
481 is schemaid of UDM:Repository:Directory

Attachment(s):