topic Re: tELTPostgresqlOutput java.lang.NullPointerException in Talend Studio

tELTPostgresqlOutput java.lang.NullPointerException

Anonymous — Mon, 11 May 2015 20:30:43 GMT

Hi,
i have a problem with the tELTPostgresqlOutput component and I can't solve it after trying around a lot.
Didn't find anything which solves my problem.
I wanted to test the tELTPostgresql Components but I always get that error:
Exception in component tELTPostgresqlOutput_1

java.lang.NullPointerException
The connection is working. Already tried it for other postgresql components.
Using version:
"Talend Open Studio for Data Integration"
Version: 5.6.1
Build id: V5.6.1_20141207_1530

I hope anybody can help me.
Always saw good solutions in this forum. Thanks for that so far
Best regards
Here some pictures:
My ELT postgresqlOutput:

elt_Map:

ELT_input:

ELT overview:

Re: tELTPostgresqlOutput java.lang.NullPointerException

Anonymous — Wed, 13 May 2015 04:13:03 GMT

Hi,
From you screenshot, we have seen you used a tMysqlConnection component? Is there any tMySqlxxx component in your work flow? If so, why there is no any connector between them(OnSubjobOK or On componentOK)?

Could you please post the whole job as screenshot?

Best regards
Sabrina

Re: tELTPostgresqlOutput java.lang.NullPointerException

Anonymous — Wed, 13 May 2015 12:41:48 GMT

there is no mySQL connection

thanks for your help

Re: tELTPostgresqlOutput java.lang.NullPointerException

Anonymous — Thu, 14 May 2015 09:50:58 GMT

Hi,
It is tpostgresqlconnection(a little difference in colour between tpostgresqlconnection and tMysqlconnction) . Sorry for my mistake.
Could you please remove or deactivate tpostgresqlconnection component to see if it working well?

Best regards
Sabrina

Re: tELTPostgresqlOutput java.lang.NullPointerException

Anonymous — Thu, 14 May 2015 13:46:40 GMT

Hi Sabrina,
i deactivated tpostgresqlconnection and got the following error again:
Exception in component tELTPostgresqlOutput_1
java.lang.NullPointerException
at ***.elt_post_0_1.elt_post.tELTPostgresqlMap_1Process(elt_post.java:434)
at ***.elt_post_0_1.elt_post.runJobInTOS(elt_post.java:731)
at ***.elt_post_0_1.elt_post.main(elt_post.java:588)

Re: tELTPostgresqlOutput java.lang.NullPointerException

Anonymous — Mon, 18 May 2015 10:35:50 GMT

Hi,
The connection is working?
Could you please use tLogrow to output result on console instead of using tELTPostgresqlOutput to see if it works?
Best regards
Sabrina

Re: tELTPostgresqlOutput java.lang.NullPointerException

Anonymous — Tue, 19 May 2015 10:21:43 GMT

Hi Sabrina,
I cannot connect any of these tELTPostgresql-components with the tLogRow...
Best regards
Saju

Re: tELTPostgresqlOutput java.lang.NullPointerException

Anonymous — Fri, 22 May 2015 12:12:47 GMT

Dear Talend Community,
can anyone help me with this problem or did anyone experience the same problems?
I hope anyone can help me with this topic, so that I can stay go on using and recommending Talend, because I really like the tool so far
Best regards.
Saju

Re: tELTPostgresqlOutput java.lang.NullPointerException

Anonymous — Tue, 26 May 2015 12:07:45 GMT

Hi saju,
Sorry for delay!
We are making investigation on your issue. Would you mind sending a exported job .zip file to us so that we can more information and details to address your issue quickly?
Best regards
Sabrina

Re: tELTPostgresqlOutput java.lang.NullPointerException

Anonymous — Tue, 26 May 2015 13:28:34 GMT

hi all
you any trigger between connection component & yout ELT subjob.
Perhaps your job try to connect to DB as connection is not defined yet.
Add a trigger on " component ok" betweeen connection & the rest of the job.
ps : did you check that connection is OK ?
hope it helps
regards
laurent

Re: tELTPostgresqlOutput java.lang.NullPointerException

Anonymous — Tue, 26 May 2015 13:39:55 GMT

Hi laurent!!!
thanks alot! This worked perfectly for me.
I added a trigger "OnSubjobOk" between the connection and the rest of the job.
Thanks also to Sabrina for your help.
Best regards
saju

Re: tELTPostgresqlOutput java.lang.NullPointerException

Anonymous — Wed, 27 May 2015 14:46:46 GMT

yo're welcome,
thanks to put topic as 'resolved'
regards
laurent