Highlighted
Four Stars

Oracle Bulk Exec component Error (Null pointer exception)

Hi, 

I'm trying to load a huge amount of records in an oracle DB, and i need to use the bulk components to do that, i know there is 3 components, the bulkouput, the bulkexec, and the outputbulkexec that does the same thing that the other 2 components, but i failed when the exec component executes and receive an NullPointerException i try the both ways (with the two components and with the fusion of the components) but always gives me that error, y sucessfully load the data in a .csv file, but when i try to load that file gives me that error. I reference the exec component to the file in the settings.

Any help with this issue?Captura de pantalla (166)_LI.jpg
There is the job i design, i try another ways but always fail in the same point.

Thanks in advance for your help.

  • Big Data
  • Data Integration
3 REPLIES
Eleven Stars TRF
Eleven Stars

Re: Oracle Bulk Exec component Error (Null pointer exception)

Check the line number in the error message and go to this line in the source code to see the reason of the null pointer exception.
Are you sure it comes from the tOracleXxx and not from the tMap?

TRF
Four Stars

Re: Oracle Bulk Exec component Error (Null pointer exception)

The error message doesn't show what is the line with error, and yes i'm sure that component is the one that crashes.
Ten Stars

Re: Oracle Bulk Exec component Error (Null pointer exception)

for reduce guessing, would be good to attach:

- components configuration

- error text (with screenshot of crashed Job)

-----------