Issue with Import Set and Transform Map

[SN_Learn]

Hi All,

I am working on the import set and transform map for the 'Load balancer' table. To upload some data I have mapped all the fields and the 'name' field has been set to Coalesce. There is identification and reconciliation rule also defined on this table and discovery source 'ImportSet' has been given the highest priority to update the data.

In the transform map, one onBefore script is written to follow this reconciliation rule as well:

var cmdbUtilIRE = new CMDBTransformUtil();
cmdbUtilIRE.setDataSource('ImportSet');
cmdbUtilIRE.identifyAndReconcile(source, map, log);
ignore = true;
if (cmdbUtilIRE.hasError()) {
        var errorMessage = cmdbUtilIRE.getError();
        log.error(errorMessage);
} else {
        log.info('IE Output Payload: ' + cmdbUtilIRE.getOutputPayload());
        log.info('Imported CI: ' +  cmdbUtilIRE.getOutputRecordSysId());
}

Now if I upload the data all the field are populating correctly except one field which is 'operational_status' which is coming 'planned' always for all the records but in the spreadsheet it is different. I have checked the loaded data and over there the operation status is showing as per the spreadsheet but in the records it is always planned.

The default value from the dictionary level is set to planned for this state.

The other fields are following the reconciliation rules as defined but the operational_status field is not changing at all.

Could anyone please guide what is the issue, thanks.

[piyushsain]

Hi @SN_Learn 

There might be an Insert BR which is changing the value to planned, can you please check any before insert BR