One Star

tELTPostgresqlOutput java.lang.NullPointerException

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 Smiley Happy
Best regards
Here some pictures:
My ELT postgresqlOutput:

elt_Map:

ELT_input:


ELT overview:
11 REPLIES
Moderator

Re: tELTPostgresqlOutput java.lang.NullPointerException

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tELTPostgresqlOutput java.lang.NullPointerException

there is no mySQL connection

thanks for your help
Moderator

Re: tELTPostgresqlOutput java.lang.NullPointerException

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tELTPostgresqlOutput java.lang.NullPointerException

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)
Moderator

Re: tELTPostgresqlOutput java.lang.NullPointerException

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tELTPostgresqlOutput java.lang.NullPointerException

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

Re: tELTPostgresqlOutput java.lang.NullPointerException

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 Smiley Happy
Best regards.
Saju
Moderator

Re: tELTPostgresqlOutput java.lang.NullPointerException

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seventeen Stars

Re: tELTPostgresqlOutput java.lang.NullPointerException

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
One Star

Re: tELTPostgresqlOutput java.lang.NullPointerException

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. Smiley Happy
Best regards
saju
Seventeen Stars

Re: tELTPostgresqlOutput java.lang.NullPointerException

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