topic tDBOutputbulkexecute issue in Talend Studio

tDBOutputbulkexecute issue

Anonymous — Sat, 16 Nov 2024 04:11:10 GMT

Hi,

I am trying to load data from Sybase to oracle Database which gets loaded successfully when I do it with normal tDBoutput however I have to load millions of rows so I thought of using tDBoutputbulkexecute component. but getting an error as

Exception in component tDBOutputBulkExec
java.lang.NullPointerException

Please advise.

P.S. Both of my databases are running on different servers.

Re: tDBOutputbulkexecute issue

fdenis — Mon, 04 Nov 2019 09:00:52 GMT

for nullPointer the best way is to run your code on debug mode step by step to found the point where is the error.
good luck
a lot of tine it's due to a open string (forgotten ").

Re: tDBOutputbulkexecute issue

Aravind_Ravi — Mon, 04 Nov 2019 09:45:31 GMT

Cloud you please share the screen sot of the Job Design.? If the error is in output component the try running the records with "Limit". then you can find where exactly the error is.

If this is what you are looking for then, Press the "Accept as Solution " Button. Give A Kudos

Thanks,
AR

Re: tDBOutputbulkexecute issue

Anonymous — Wed, 06 Nov 2019 05:46:09 GMT

Hi AR,

Thanks for your reply. attached is my job design. is this issue happening because my source Sybase is on different server and oracle database where I am loading data is on different. if so what is the alternative to overcome this issue so I can load millions of rows quickly into oracle/

thanks,

Prashant

JobDesign.PNG

Re: tDBOutputbulkexecute issue

fdenis — Wed, 06 Nov 2019 10:57:58 GMT

you can use bulk but you have to check the compatibility of file format (if it's not compatible extract datas on the right format) then transfer file before bulk load.