ETL is not updating the asset

[Vaibhav Kumar Y]

Hello all,

We have created 2 ETL. With First ETL we are creating records in cmdb_ci_ip_switch table. After few minutes of the ci creation in the Ip switch table, asset record is getting created automatically.

Then we are running the 2nd ETL to update the asset records that just got created but it is not updating the asset instead it is changing the class to hardware from ip-switch in the cmdb_ci_ip_switch table even though in the 2nd ETL there is only mapping for alm_hardware table.

Note: we have updated the system properties for non cmdb tables and ci identifiers has also been created.

Please let us know if anyone knows how to fix it.

[Vaibhav Kumar Y · Accepted solution]

This issue is solved.
The problem here was the "Source Native Key". In the CI creation ETL , I used serial number as source native key and in the asset update ETL also I used serial number as source native key. That is why it was re-classifying the CIs.
Detail solution link below.
Detail solution