tOracleOutputBulkExec- NullPointer Exception error

Five Stars

tOracleOutputBulkExec- NullPointer Exception error

I'm trying this job execution in Talend Open studio.
The same scenario, when executed with Normal tOracleOutput/tLogRow, works fine.
While using tOracleOutputBulExecution, the intermediate data file out.csv is also created properly but while loading into the table I get this error.
Am I missing any setting here in Bulk Execution?

JobJob.png

Basic setting: Basic Setting.png

Advanced Setting: Advanced Setting.png

Output: Output Error.png

Forteen Stars

Re: tOracleOutputBulkExec- NullPointer Exception error

Hi,

 

is your database on the same server with a Studio (Talend Job)?

 

-----------
Five Stars

Re: tOracleOutputBulkExec- NullPointer Exception error

No. Database is in Linux server and Open Studio in Windows.

Five Stars

Re: tOracleOutputBulkExec- NullPointer Exception error

Any update on this issue?

Employee

Re: tOracleOutputBulkExec- NullPointer Exception error

Hi,

 

    A quick query. Have you given Schema length definition for all your String variables? Since you have specified Create if not exists, this could be one reason of the error.

 

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 :-)

Five Stars

Re: tOracleOutputBulkExec- NullPointer Exception error

Yes, I have the schema string variables defined with length and I also tried "default" instead of  "Create if not exist" option.
I'm still getting the same error.

Employee

Re: tOracleOutputBulkExec- NullPointer Exception error

Hi,

 

    Could you please take a executable shell script and try to run directly from DB server to verify the idea shared by @vapukov ?

 

     Sometimes it might be due to firewall issues. I hope you are giving the connection details also correctly.

 

      Sorry. could not thing about any other right now. Any other ideas guys ?

 @rhall_2_0  @TRF  @akumar2301 @manodwhb 

 

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 :-)

Forteen Stars

Re: tOracleOutputBulkExec- NullPointer Exception error

all talend BulkExec components require to have csv file on the local for database server disk - https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/Q3j6rgEPNXLD7q0lIPgpBg

 

as it is seen from the pictures in the first post - file created on the local machine, so not depending on other possible errors this must be checked first

-----------

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog