Micro Focus Email

Send E-mail

Self-Solve Knowledge Search

Many inactive CI's under K_CI table

Many inactive CI's under K_CI table

Many inactive CI's under K_CI table

Many inactive CI's under K_CI table

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

B-SL:100 HPSL:100 LIB4:false TYPE:errormsg HPTYPE:technical_documents ATT:0

Summary

Many inactive CI's under K_CI table

Problem

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

Additional Information

Was this document helpful? Feedback