Getting Null Pointer exception while importing data via transform map
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-22-2024 11:46 AM - edited 04-22-2024 11:48 AM
We are importing CMDB data of another instance using transform map in xml. While importing certain data, we are getting an error like 'java.lang.NullPointerException'.
Error Message: Import set: ISET0011169 transform stopped due to error: java.lang.NullPointerException.
Does anyone have an idea, what does it mean in transform map, and how can we rectify such errors?
- 1,150 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-22-2024 11:47 AM
Hi @Harika Ravuri ,
Please open the import log and check the error in details.
-Thanks,
AshishKM
Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-22-2024 11:51 AM
It is showing the same which i mentioned above.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-22-2024 11:50 AM
Hi there @Harika Ravuri
Double-check your transform map configuration that all mandatory fields are mapped correctly from the source to the target table. Verify that there are no missing mappings or mappings to fields that do not exist in the target table.
also review the source data, particularly for the records causing the error. Look for any inconsistencies, missing values, or unexpected data formats that could lead to null values during the transformation process.
finally have a look at logs for more details about it.
If this helps kindly accept the response thanks much.
Kind Regards,
Mohamed Azarudeen Z
Developer @ KPMG
Microsoft MVP (AI Services), India
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-27-2025 07:46 AM
Harika,
Were you ever able to get this resolved? I am facing the same issue with our SG-SCCM Computer Identity Data Source for the CMDB. I did take a look at the Robust Import Set Transformer it was utilizing and the transform definition where there were a couple of mapped fields that did not match a source field. However, removing these and reprocessing the data did not resolve. It does not appear that there are any scripts running on this transformer unless they are located elsewhere.