NullPointerException in component tDBOutputBulkExec

[AAgrawal1612865303]

Hi All,

I am trying to upload a simple CSV Files with huge number of data ( Simply having one columns and 10K rows with numbers) into Oracle database.\

To boost the performance of the upload, i want to use the tDBOutputBulkExec instead of tDBOutput.

But i am getting the null pointer exception. Interestingly the same job is running fine in one of my college machine. Is it something to do with setup ?

I reinstall the Oracle Database driver and the whole Talend DI studio but it didnt help.

I tried to use The tDBOutputBulk and tDBBulkExec components in place of

tDBOutputBulkExec , but still same error in tDBBulkExec .

I am putting the screen shot of my simple job.

Below is the error :

Starting job AshishTest at 11:13 09/02/2021.

[statistics] connecting to socket on port 3819

[statistics] connected

Exception in component tDBOutputBulkExec_1_tOBE (AshishTest)

java.lang.NullPointerException

at talendashishtest.ashishtest_0_1.AshishTest.tFileInputDelimited_1Process(AshishTest.java:1134)

at talendashishtest.ashishtest_0_1.AshishTest.runJobInTOS(AshishTest.java:1746)

at talendashishtest.ashishtest_0_1.AshishTest.main(AshishTest.java:1580)

[statistics] disconnected

Job AshishTest ended at 11:13 09/02/2021. [Exit code = 1]

Any pointer ?

Attaching the job screen shot and the sample data to upload..

[AAgrawal1612865303 · Accepted solution]

Hi, Oracle Experts

sqlldr gave error when I tried to run it.

OS: Win7 64bit

"Oracle Database Client" I used is from this page: Oracle Database 12c Release 1 (12.1.0.2.0) for Microsoft Windows (x64)

    (Scroll down on that page, I use "Oracle Database Client (12.1.0.2.0) for Microsoft Windows (32-bit)". Tried x64 version client. It gave same error message.)

After hours searching online, I found this link that might be temporary solution: [Oracle] Fichier oranfsodm12.dll absent du package client , Blog de Jérémy Jeanson (The page is in French. Here is the link translated by Google https://translate.google.com/translate?sl=auto&tl=en&js=y&prev=_t&hl=en&ie=UTF-8&u=http%3A%2F%2Fblog...)

It suggests that, in bin folder, copying oraodm12.dll and renaming it to oranfsodm12.dll could be a fix. I tried, that works for me so far.

Does any have any other suggestion? It seems a bug in this version "Oracle Client", if any one has the link for other version of Oracle Database Client (which comes with sqlldr utility), please provide. I will appreciate it.