tDBOutput_1 null java.lang.NullPointerException: null

[JayZ1]

I was unsure what was causing a null pointer exception.

I am connecting to 2 databases and running a query and inserting that data into another database. (MSSQL->Oracle) there are NULL values in the data but i thought I would still be able to insert data without any issues, can anyone help me with this?

Also i wasn't sure if i needed to use denormalization, any idea whats causing the issue?

[Anonymous]

Your tDBConnection_1 and tDBConnection_2 need to be connected to the main the Subjob OR connected to a tPreJob component. Having your tDBConnection_2 unconnected means that the main Subjob can potentially run before the connection has been created.

[Anj24]

Also, make sure to close both the DBConnection using the tDBClose component as this also cause NullPointerException in some cases.

[VKohler1665560143]

I appreciate the information and advice you have shared.

Employee Connection Insite