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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

java.lang.NullPointerException using mysql

I get the following error code when I run my job. I am using Windows 7 with TOS 4.0.3.r47759.
I think it might be schema problem but I'm not sure where it is. Any ideas?
Here is a screenshot of my job > http://dl.dropbox.com/u/774969/talend_error_2.png
Thanks.
Starting job trefis_mysql_to_sfdc_sandbox_contact at 13:26 28/02/2011.
Exception in component tMap_1
java.lang.NullPointerException
at trefis.trefis_mysql_to_sfdc_sandbox_contact_0_4.trefis_mysql_to_sfdc_sandbox_contact.tMysqlInput_1Process(trefis_mysql_to_sfdc_sandbox_contact.java:4114)
at trefis.trefis_mysql_to_sfdc_sandbox_contact_0_4.trefis_mysql_to_sfdc_sandbox_contact.runJobInTOS(trefis_mysql_to_sfdc_sandbox_contact.java:13239)
at trefis.trefis_mysql_to_sfdc_sandbox_contact_0_4.trefis_mysql_to_sfdc_sandbox_contact.main(trefis_mysql_to_sfdc_sandbox_contact.java:13048)
Job trefis_mysql_to_sfdc_sandbox_contact ended at 13:26 28/02/2011.
Labels (3)
3 Replies
Anonymous
Not applicable
Author

Hi
I can't see the screenshot of job, please upload it directly to our forum.
Best regards
Shong
Anonymous
Not applicable
Author

I've attached the screenshot. Thanks.
Anonymous
Not applicable
Author

Hi
The error occurs on tMap, it seems there are some null value in some of fields, if this is the case, you need to handle the null value like this:
row1.name==null?"":row1.name
Let us know if you have any questions!
Best regards
Shong