Many inactive CI's under K_CI table

  • KM03687018
  • 28-Jul-2020
  • 28-Jul-2020

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

Many inactive CI's under K_CI table

Error

If we run DLC against this table, we can observe hundreds of CIs. Can we delete?

Cause

OBR Collects dimension data from Topology source and also loads such data in K_CI table

Fix

We can use below query:

select CI_UID,Display_Name,dsi_key_id from K_CI where display_name is null or name is null

 

We can filter them and check are they rea based on CI_UID and Creation date. If they are very old we can delete with DLC and inactive option as they will not impact Fact data in OBR