Transform Map java.lang.NullPointerException

[stevejarman]

We have a Transform Map that was working fine prior to our upgrade to Jakarta. Post upgrade, we're now finding that it fails on the first record with nothing but "java.lang.NullPointerException" as the error.

If we set the first record to Ignore, then the second record fails, and so on - i.e. it's not something specific to the record itself. We can also see that it correctly generates the XML payload for the new record, so it doesn't seem to be anything to do with the mapping itself, but with the insertion/update of the record in the table.

I've tried recreating the Transform Map from scratch and ended up with the exact same result.

Is anyone able to suggest anything that we might be able to try here to get this fixed?

[henry_cheng · Accepted solution]

Hi Steve,

From your description it seems you are hitting a known problem PRB1155952 on Jakarta release.

If there is any data type in the staging table that has 'Basic Date/Time' data type then you will get this error.

The PRB occurs when transforming a 'Basic Date/Time' to 'Date/Time' field and it creates a NullPointerException.

The problem has been fixed in Jakarta Patch 5 and onwards. Currently you can try below as a workaround.

Workaround: Change the staging table's field to Date/Time and run the transform again.

Cheers

Henry

[stevejarman]

You're a legend Henry

Thanks very much. All sorted.

[RichardSaunders]

I second that, thank you! henry.cheng