Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

"java.lang.NullPointerException" showing while transforming records from staging table to target table?

manmathpanda
Giga Guru

Hi Developers,

I am facing an issue in transform map and the issue is like while run transfer , error is showing as "java.lang.NullPointerException" .

 

For this i checked below

1> checked the mappings of source table and target table and the mapping is correct

2> in community i found that if date type of source table "basic data/time" then this error is showing but in staging table the date type is mentioned not "Basic data/time".

3> To check without date field and scripts , i removed these fields from mapping table and tried to run the transform map but still this error is showing , so could not understand what will be the issue here.

Need suggestion from you dear developers.

 

find_real_file.png

find_real_file.png

 

In transform history , shwoing as below

find_real_file.png

 

 

Regards,

Manmath

10 REPLIES 10

Konstantin11
Kilo Guru

Hi Manmath, were you able to resolve the issue?
I'm facing the same now during transform of sc_task record, throws an exception during loading of variables, which are not part of the payload, just loading it from RITM.