topic Issue with tOracleBulkExec in Talend Studio

Issue with tOracleBulkExec

Anonymous — Sat, 16 Nov 2024 04:12:01 GMT

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?

Re: Issue with tOracleBulkExec

Anonymous — Fri, 01 Nov 2019 17:04:07 GMT

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

Re: Issue with tOracleBulkExec

Anonymous — Wed, 06 Nov 2019 19:50:33 GMT

Job design:

tDBOutputBulkExec properties:

Basic and Advanced properties:

Re: Issue with tOracleBulkExec

Anonymous — Tue, 12 Nov 2019 17:51:04 GMT

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