New records are getting created with sys ids?

Nani6 · ‎11-05-2015

Hi,

I have set up data import from prod to lower environments (Data source is XMLs), everything is fine I mean new records are getting created but some of the records are getting created with sys ids and also sys ids of these records are different in prod and in lower environments. Any help is greatly appreciable.

Thanks in advance.

Gurpreet07 · ‎11-05-2015

Hello Shrikanth,

The sys_id is received in source XMLs for referenced fields.In Field mapping of a reference field , if you haven't put any thing in Referenced value field name then by default system will compare the value from the source table with the display value of the target table's reference field and thus it seems like sys_id from source table is compared with name(display value) of the value in target table's reference field.

you need to do following

1. For Field mappings of referenced fields put sys_id in Referenced value field name. You may need to edit list layout of the field mappings related list to bring this field in the list.

Creating New Transform Maps - ServiceNow Wiki

2. If you want the same sys_id of the target record as in your source instance then you need to create an onBefore transform script with following code.

if (action == "insert"){target.setNewGuidValue(source.u_sys_id);}

Importing from Another ServiceNow Instance - ServiceNow Wiki

View solution in original post

Nani6 · ‎11-05-2015

Yes, let me check this might be the same issue in our case also. Thank you very much.

Nani6 · ‎11-05-2015

Hi Gurpreet,

Thanks for the reply.

Manikanta4 · ‎04-03-2022

Please provide the activated link. Currently it's not opening

Manikanta

Nani6 · ‎11-24-2015

Hi,

I have followed this process correctly but few records are getting created with no values in them.

Nani6 · ‎11-24-2015

For example group tables, new groups are created with empty values.