How to create a CI or a Relationship to a CI which have a defined dependency?

OliverTim
Tera Contributor

Dear All,

 

We're struggeling setting up a proper IH-ETL import for CIs which have defined dependencies (e.g. MSFT SQL Instance, Kubernetes Namespace etc.). We are not even able to create a relationship between 2 existing CIs having a dependency. ETL always returns a MISSING_DEPENDENCY error.

 

Baseline:

All our CIs and relationships are found in non ServiceNow databases. So we have to import them class by class. There is no discovery in place. 

 

Import procedure:

  1. We start to import the "basic" CIs first, like servers, clusters etc.
  2. In a second phase, we want to import additional CIs which have dependencies.
    1. Importing and relate CIs with no dependency works fine
    2. Class Manager view of a CI with a dependency
      CIClassManager_MSFTInstance.jpg

How we configured ETL:

  1. Class Mapping (in this case both CIs are already in the CMDB. We  just want to create the relationship)
    ClassMapping_Overview.jpg
    ClassMapping_MSFTInstance.jpg
    ClassMapping_Server.jpg
  2. Relationship
    Realtionship.jpg
  3. Result of the integration run
    Partial Load (find the JSON file as attachment)
    ParialLoad.jpg
    Warning Log  (find the JSON file as attachment)
    WarningLog.jpg

 

Does anyone have an idea how to import CIs with dependencies using ETL? Is it even possible to use ETL or do we have to switch to transform maps?

 

Thanks a lot in advance for your support.

 

Best Regards

Oliver

5 REPLIES 5

Pratiksha
Mega Sage
Mega Sage

I think you are missing on identification attribute for 

MSFT SQL Instance. Name and class should be added in the class mapping. 

Hi

Adding the class does not change anything. The MISSING_DEPENDENCY error still pops up.
ClassMapping_MSFTInstanceClass.jpg

Irston Antao
Tera Expert

@OliverTim  I have this question too, did you find a solution for the same?

Hi @Irston Antao 
After days of testing we found a solution.

  • It is key that the hiearchy of the relationship is according the hierarchy definied in dependent relationships (parent - child). The order in the "classic" relationship definition may be different. The dependent relationship is the "master".
  • The Kubernetes Namespace class is shipped with an error. The dependent relationship is the wrong way. Instead von Cluster (Parent) and Namespace (Child) it is the other way.

 

Now it works fine.

 

Kind Regards
Oliver