One Star

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: http://www.talendforge.org/forum/viewtopic.php?id=14454 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!
1 REPLY
One Star

Re: java.lang.NullPointerException in tSugarCRMOutput_1

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