CA Service Management

Expand all | Collapse all

Not able to add or update relationship mapping to the existing CIs using gr loader

  • 1.  Not able to add or update relationship mapping to the existing CIs using gr loader

    Posted Feb 17, 2017 02:01 PM

    We were not able to add or update the relationship mapping for CIs. We tried both the ways of mapping the relations using gr loader. First by loading the CIs and then the relationship mapping for the CIs. Second loading the CIs and relationship mappings together. Both of these resulted in below errors.

    <!--ERROR: Dependent CI not found.-->

    <!--ERROR: Provider CI not found.-->

     

    We looked at the documentation from docops.ca.com and tried to execute, but the results are same.



  • 2.  Re: Not able to add or update relationship mapping to the existing CIs using gr loader

    Broadcom Employee
    Posted Feb 17, 2017 03:46 PM

    It's interesting you post this, because we have another thread for a similar discussion:

     

    Getting error while loading CI relationship using GRLoader 

     

    Does any of that help?



  • 3.  Re: Not able to add or update relationship mapping to the existing CIs using gr loader

    Posted Feb 22, 2017 01:48 PM

    Thanks Alex_Perretti. I have gone through the tech document # TEC479515

    I am successful with using xml for the relationship mapping for CIs using grloader. We have huge CI data in spreadsheet which needs to be loaded along with relationship mapping. Converting the spreadsheet to xml with the multiple child nodes is more consuming. So we wanted to use the spreadsheet format to load the data.

     We used the below format and loaded using gr loader.

    name

    class

    system_name

    dns_name

    is the child of

    CI_item_1

    Zone

    CI_item_1

    CI_item_1.dsn

    CI_item_Parent

    internally in grloader, this gets converted to an xml format as below

    <GRLoader>
    <relation>
    <!--ERROR: Dependent CI not found.-->
    <type>is the child of</type>
    <delete_flag></delete_flag>
    <provider>
    <id>628193FE541FAF4C850AD1B319C509D9</id>
    <name>CI_item_1</name>
    <system_name>CI_item_1</system_name>
    <dns_name>CI_item_1.dsn</dns_name>
    </provider>
    <dependent>
    <!--ERROR: Dependent CI not found. -->
    <name>CI_item_Parent</name>
    </dependent>
    </relation> .....

     

    But the grloader expects like below.

    <GRLoader>
    <relation>
    <!--ERROR: Dependent CI not found.-->
    <type>is the child of</type>
    <delete_flag></delete_flag>
    <provider>
    <id>628193FE541FAF4C850AD1B319C509D9</id>
    <name>CI_item_1</name>
    <system_name>CI_item_1</system_name>
    <dns_name>CI_item_1.dsn</dns_name>
    </provider>
    <dependent>
    <!--ERROR: Dependent CI not found. -->
    <name>CI_item_Parent</name>

    <system_name>CI_item_Parent</system_name>
    <dns_name>CI_item_Parent.dsn</dns_name>
    </dependent>
    </relation> ....

     

    We cannot have like this in spreadsheet. Let us know what spreadsheet format we should use in excel when we need to map more than identifier for the provider or dependent CI. 



  • 4.  Re: Not able to add or update relationship mapping to the existing CIs using gr loader

    Broadcom Employee
    Posted Feb 22, 2017 04:59 PM

    Vishwanathan,

     

    I sent an email in the Support case you opened. Please try to provide the information when you can.



  • 5.  Re: Not able to add or update relationship mapping to the existing CIs using gr loader

    Posted Feb 22, 2017 05:19 PM

    I replied to your e-mail. Thanks, Alex!