CMDB Classes are not switching via ETL

[siddheshagn]

Context: I’m moving CIs between classes: cmdb_ci_hardware_mainframe ↔ cmdb_ci_mainframe using two ETLs:
It works in DEV and TEST but fails in UAT: no records move to the destination class even though the ETL definition, entity mappings, and sys_properties were migrated to UAT. I also deleted the Source native key in UAT to force updates/inserts, but behavior didn’t change.

I have attached sys_properites snaphot along with the properties which has being used robust transform maps , along with the errors in the staging table errors from import set table I have attached the snapshot of ETL mapping as well. 

Kindly let me know for more details.

Regards,

Siddhesh Agnihotri.

[Kieran Anson]

I've run into this issue previously, SN support advised that the properties on the RTE record are multi-levelled. 

In addition to what you've set, you can add the following to set the value on the individual IRE elements, changing the property name based on the documented values

ire.input.items.settings.updateWithoutSwitch