Data in import set table but can not be transformed into target table

[Cheng Luo]

I am using a dev instance dev64918.service-now.com to load some system configuration data from xml file into cmdb using import set. After loading, I can see the import set table was updated with records properly. However when I tried to use transform map(field map) to transform those data into target table(user defined). I can see the record in import set table was changed into Processed state. However the target table was still empty. Screen shot for the import set table and transform record attached. Anyone can help on this?

[Hitoshi Ozawa]

In the transform map, are all mandatory field mapped to a value? Seems like there's a mistake in the transform map. Try hardcoding the values and checking if a record is entered. If it is, try outputting field values to a log to make sure they are correct.

[Cheng Luo]

Hi,

Just attached the definition of transform map & the target table cmdb_ci_zos_server inheritance hierarchy as screenshots below. For the transform map, I am just using Auto Map Matching Fields to create field maps. No idea about what are all mandatory fields here. You referred there is a mistake in the transform map. Could you please point out?

[Cheng Luo]

Just find that the field maps are the cause. Seemed I defined maps from a source table field, which is just storing a blank. When switching to a proper field, the target table got populated properly.

[Hitoshi Ozawa]

Good to hear that you've been able to fix the problem.

[shloke04]

Same thing I have replied above with issue lies in your field mappings before:

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke