NullPointerException in tOracleBulkExec

Six Stars

NullPointerException in tOracleBulkExec

Hi,

 

We are about to move a lot of data from a oracle database into a new oracle db and also a MSSQL db. For MSSQL the bulk exec runs just fine but when we use tOracleBulkExec we always get a null pointer exception.

 

I've tried different settings in the component but no luck. I have installed sqlldr.

 

The row that causes the error is:

lr_tDBBulkExec_2.close();

 

Any ideas?

 

Thanks

Andreas


Accepted Solutions
Six Stars

Re: NullPointerException in tOracleBulkExec

Re installed the client and now it works. Must have messed up before, sorry for the inconvenience. 


All Replies
Forteen Stars

Re: NullPointerException in tOracleBulkExec

@yoxler,Did you use tOracleConnection component in your work flow? If so, is there any connector(onsubjobok or oncomponentOk) between tOracleConnection and tOracleBulkExec?

 

since it could be connection or Bulk file path issue. since check the below link

https://help.talend.com/reader/NNO~fmVQU4rlkF9Depfdxw/kjYl_YFAdMYvz4O4QFyT_A

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: NullPointerException in tOracleBulkExec

I have a connection to the database and use it in the component. The connection is connected to a Prejob. I've tried to just do normal inserts using tDBOutput and that works so conneciton to the DB and table is OK

 

tbulkexec.PNG

Forteen Stars

Re: NullPointerException in tOracleBulkExec

@yoxler , where are you creating bulk file and can you show job design?

 

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: NullPointerException in tOracleBulkExec

I've tried both with a csv file and db output bulk files, with the same results.

 

The disabled flow for MSSQL works fine with the csv file. The java stuff only prints time. 

 

tbulkexec.PNG

Forteen Stars

Re: NullPointerException in tOracleBulkExec

@yoxler ,can you show configuration of "bulk exec" component,the one which is failing?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: NullPointerException in tOracleBulkExec

The basic settings is the one I posted before. this is the advanced. Only thing I changed is the field terminator

Capture.PNG

Forteen Stars

Re: NullPointerException in tOracleBulkExec

@yoxler ,can you verify the schema of bulk file and tDBBulkExec

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: NullPointerException in tOracleBulkExec

Perhaps it has something todo with the SQLLDR installation. I will try to reeinstall it

Forteen Stars

Re: NullPointerException in tOracleBulkExec

@yoxler ,yes when you try to use Bulk component you need to make sure all the required jars installed and DB side setting also need to be done.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: NullPointerException in tOracleBulkExec

as far as I can see the bulk file looks OK. Also the .clt file looks good.

Six Stars

Re: NullPointerException in tOracleBulkExec

Re installed the client and now it works. Must have messed up before, sorry for the inconvenience. 

Forteen Stars

Re: NullPointerException in tOracleBulkExec

@yoxler ,great,please mark the solution and also provide Kudos.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads