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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download