Parent column of the cmdb_ci_service table points to different tables in 2 different instances.

[HugoFirst]

While looking to load data into the CSDM tables, I ran into an issue with the parent field in the Service table ( cmdb_ci_service ).  

In my personal development instance, where I did much of my preliminary research, the parent field of this Services table points to itself ( cmdb_ci_service ).   This is what I expect.

However, when I started working in my Dev instance, the parent field of cmdb_ci_service points to the service_offering table.  This complicates things greatly.

The build tag on both instances is the same: glide-yokohama-12-18-2024__patch6-07-17-2025

Has anyone seen this kind fo discrepancy before?  This is the first time for me.

[Swapna Abburi]

Hi @HugoFirst 

How are you importing data? If you are using transform maps, then it could be that CI with same name present in both the classes (service and offerings). 

[HugoFirst]

I am not importing data.  I have a fix script that takes data from a couple of existing tables to fabricate records for Business Services and Technical Managment Services.  Each Technical Management Service should have a parent Business Service.   But that is not possible if the parent field for the cmdb_ci_service table points to service_offering.