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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2012-04-12 01:58 PM

java.lang.NullPointerException in tSugarCRMOutput_1

Hello, I get the following error when running my job (SQL in to SugarCRM out):
Exception in component tSugarCRMOutput_1
java.lang.NullPointerException
at suqarcrm_data_xfer.product_sales_0_1.Product_Sales.tMSSqlInput_1Process(Product_Sales.java:649)
at suqarcrm_data_xfer.product_sales_0_1.Product_Sales.runJobInTOS(Product_Sales.java:929)
at suqarcrm_data_xfer.product_sales_0_1.Product_Sales.main(Product_Sales.java:797)
Searching the forums I found this thread: https://community.talend.com/t5/Design-and-Development/java-lang-NullPointerException-using-mysql/td... which points to null values in my outgoing data. However, we checked the data coming from SQL and there are no null values. Is there another possibility? Is this definitely a schema problem?
Thanks for any help on this!
Labels (3)
Labels
176 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2012-04-12 02:08 PM
Author

Make sure you remove any columns on your output schema to Sugar that are not getting mapped, or are restricted from inserts/updates.
176 Views
0 Likes