Updating Life Cycle Stage and Status from Data Source Import and updating Discovered Items Table

[Shree14]

Hi All,

I'm importing a 1.7 million CIs data from SFTP in CSV format through Data Source.

I have configured the Transform Map to update the CIs Life Cycle as 'End of Life - Retired', if the Source CI status is Terminated, by making CI name & Host ID as Coalesce.

Also I have chhecked 'Run Business Rule' to True on Target table : cmdb_ci.

But since the records count is more, Schedule Job is taking more than 2 days and Transaction is getting cancelled.

If I uncheck the 'Run Business Rule', the CI's life Cycle will update but it won't update the CI state as 'Decommissioned' on Discovered Items table through BR[sn_sec_cmn_src_ci].

Please let us know how do I optimize this and update records on both 'cmdb_ci' and 'sn_sec_cmn_src_ci' tables.

Thanks,

Shree

[Estelle1]

Hi guys,

I know this is an old post but just in case someone has the similar issue. Here are the solutions.

If import life cycle stage or status is assigned to a sys id. For example, target.life_cycle_stage = "[sys_id]", the record will be referenced without the display value.

So we need to set the display value as well. For example, target.setDisplayValue("life_cycle_stage","Operational");

The issue will be solved this way. No need to uncheck the run business rule checkbox.

Best,

Estelle