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:
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?
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?
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)
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
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
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
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