Issue with tOracleBulkExec

[Anonymous]

I have a simple job created using tOracleBulkExec in Talend Cloud Data management platform (v7.1.1)
As I execute the Job, I can see the control file and the data file are getting created.
And even the database table  got created in the Oracle database but the data is not loading in the table  and throwing the below error as it tries to load through sqlldr: 

     Exception in component tDBOutputBulkExec_1_tOBE

      java.lang.NullPointerException

[FATAL]: d - tDBOutputBulkExec_1_tOBE null

What could be the issue?

[Anonymous]

Hi,

    Could you please share the screen shots of the component so that we will get better clarity? Please add screen shots of both basic and advanced properties.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[Anonymous]

Job design:

tDBOutputBulkExec properties:

Basic and Advanced properties:

[Anonymous]

Hi,

   Since the Oracle connection is getting established and table is getting created, the issue could be due to null check for some column of the table. 

   Could you please double check the schema of the table specified in the Bulk component and compare it with data? That could give you some clue.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved