Substate of an asset is not changing through data load from transform map

[san1989]

Hello,

I have created a data source and transform map to load the data on the hardware table.

When I loaded the data, I changed the state of the asset to 'Retired' from 'In stock'. When the asset state is 'in stock' the substate is 'available'. When I changed the state to 'Retired' substate has to become empty. It is still showing 'Available'.

If I does manually substate is becoming empty. Also, corresponding Ci state is also changing when I change asset state. But through transform map it is only changing the state. I checked run business rule on transform map.

Can you please let me know why they were not changing (synchronization not working).

Thanks

[Tony Chatfield1]

Hi, spinning up a London dev instance and looking at state changes for this ‘hardware’ CI
https://dev50421.service-now.com/nav_to.do?uri=alm_hardware.do?sys_id=00a96c0d3790200044e0bfc8bcbe5d...

The sub-state change you are seeing via a manual (UI) update of ‘State’ appears to be the result of OOB Client script
https://dev50421.service-now.com/nav_to.do?uri=sys_script_client.do?sys_id=3bbeaaec372b100044e0bfc8bcbe5dce

When you state you want the sub-state to be empty, do you mean you want the value to be ‘none’ ?
The most appropriate solution would be to set the sub-state via your transform script, based on the state change you are making.

[san1989]

Yeah Tony, I have written the on Before script and its working.

Thanks