topic Re: NullPointerException in tOracleBulkExec in Talend Studio

NullPointerException in tOracleBulkExec

yoxler — Sat, 16 Nov 2024 06:26:14 GMT

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

Re: NullPointerException in tOracleBulkExec

manodwhb — Tue, 05 Mar 2019 07:28:52 GMT

@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

Re: NullPointerException in tOracleBulkExec

yoxler — Tue, 05 Mar 2019 07:59:29 GMT

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

Re: NullPointerException in tOracleBulkExec

manodwhb — Tue, 05 Mar 2019 09:01:11 GMT

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

Re: NullPointerException in tOracleBulkExec

yoxler — Tue, 05 Mar 2019 09:31:43 GMT

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.

Re: NullPointerException in tOracleBulkExec

manodwhb — Tue, 05 Mar 2019 09:37:19 GMT

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

Re: NullPointerException in tOracleBulkExec

yoxler — Tue, 05 Mar 2019 09:41:37 GMT

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

Re: NullPointerException in tOracleBulkExec

manodwhb — Tue, 05 Mar 2019 09:59:10 GMT

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

Re: NullPointerException in tOracleBulkExec

yoxler — Tue, 05 Mar 2019 09:59:11 GMT

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

Re: NullPointerException in tOracleBulkExec

manodwhb — Tue, 05 Mar 2019 10:01:10 GMT

@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.

Re: NullPointerException in tOracleBulkExec

yoxler — Tue, 05 Mar 2019 10:01:38 GMT

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

Re: NullPointerException in tOracleBulkExec

yoxler — Tue, 05 Mar 2019 10:06:24 GMT

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

Re: NullPointerException in tOracleBulkExec

manodwhb — Tue, 05 Mar 2019 10:23:05 GMT

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