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

Shree14
Tera Contributor

‎07-25-2023 11:06 AM

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

0 Helpfuls
  • 558 Views
1 REPLY 1

Estelle1
Tera Guru

‎02-20-2025 06:52 PM

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

0 Helpfuls