Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 0683p000009MACn.png
Best regards
Here some pictures:
My ELT postgresqlOutput:
0683p000009MDdC.png
elt_Map:
0683p000009MDdH.png
ELT_input:

0683p000009MDVd.png
ELT overview:
0683p000009MDVd.png
Labels (3)
11 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

there is no mySQL connection
0683p000009MDdM.png
thanks for your help
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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)
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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

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  0683p000009MACn.png
Best regards.
Saju
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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