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

[manmathpanda]

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.

In transform history , shwoing as below

Regards,

Manmath

[Ankur Bawiskar]

Hi Manmath,

Was this issue coming earlier? if no then what change has been done after that?

Also is there any transform script etc?

Which version you are using?

Are you fetching information from oracle database using jdbc; there is a know error PRB1155952

Regards

Ankur

[manmathpanda]

Hi Ankur,

Previously we are using jakartha and now we upgraded to Madrid and there was mid server issue and the servicenow team has solved that and now midserver is working properly .

Now in data source , when i am transforming data , it is not transforming .

--> yes script is there but i have removed them form mapping table. without script and date field i am mapping other fields.

-> i am usning Madrid version.

--> Yes we are fetching information from oracle database uisng jdbc.

Regards,

Manmath

[manmathpanda]

Hi Ankur,

after removing date fields, script fields also the data is not transferring and the error is showing same

If i will click on this above highlighted importset then the error is showing as below

if i will click on this error , it is redirecting to an employee's record.

please give some suggestion if you find anything.

Regards,

manmath

[Harshal Gawali]

Hi Manmath,

Most tables have an attribute set with the Display property set to true. If a new record is created or updated and the column with the Display value is set to an empty value, the result is identified by the Display value "(empty)".

As for Web Service Import Set, the results are identified by the Display value; empty results could cause the NullPointerException error.

NOTE: Display values could be caused by newly added attributes that set Display to true accidentally.

If my answer is helpful mark it as helpful.

Thanks,

Harshal Gawali.

[manmathpanda]

Hi Harshal,

Thanks for your response.

after removing date fields, script fields also the data is not transferring and the error is showing same

If i will click on this above highlighted importset then the error is showing as below

if i will click on this error , it is redirecting to an employee's record.

please give some suggestion if you find anything. and there are almost same 10 records in staging table.  

Regards,

manmath