tSalesforceOutput_1 - java.lang.NullPointerException during commit

One Star

tSalesforceOutput_1 - java.lang.NullPointerException during commit

Hi There,
I am running a job in talend that updates salesforce and every 200 rows I get this error.
I have extended Output selected and the rows to commit is set at 200.
When I try any value less than 200 it gives me the same error.
I am using:
Version: 3.2.0
Build id: r30698-20091006-1107
I am using the ID as the Key and then updating one field, thats it. The updates go into salesforce ok but these errors are stopping me from running large amounts of data in as I am handholding it a lot more than i really want to be.
Exception in component tSalesforceOutput_1
java.lang.NullPointerException
at org.talend.salesforce.SforceManagementImpl.update(SforceManagementImpl.java:707)
at sparkle.s0004_updatedbtosf_0_2.S0004_UpdateDBtoSF.tMSSqlInput_1Process(S0004_UpdateDBtoSF.java:6513)
at sparkle.s0004_updatedbtosf_0_2.S0004_UpdateDBtoSF.tJava_1Process(S0004_UpdateDBtoSF.java:648)
at sparkle.s0004_updatedbtosf_0_2.S0004_UpdateDBtoSF.runJobInTOS(S0004_UpdateDBtoSF.java:11657)
at sparkle.s0004_updatedbtosf_0_2.S0004_UpdateDBtoSF.main(S0004_UpdateDBtoSF.java:11484)
disconnected
This is the error above.
It seems like it wants to do a commit and is flopping over at this point.
Any help would be appreciated.
One Star

Re: tSalesforceOutput_1 - java.lang.NullPointerException during commit

I have explored this further and it looks like its to do with an update to a row that doesn't exist in SalesForce inside the commit, how best to actually catch this and deal with it or ignore it?
Highlighted
Community Manager

Re: tSalesforceOutput_1 - java.lang.NullPointerException during commit

Hello
how best to actually catch this and deal with it or ignore it?

Did you try to uncheck the 'die on error' box on advanced setting tab.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tSalesforceOutput_1 - java.lang.NullPointerException during commit

When I did that it didn't seem to make the changes to the following account objects afterwards. It seems using the batch commit its all or nothing.
I had to drop the commit no. down a bit and watch the rows that where causing errors and not getting set to migrated, hand crank them and mark them as erroneous, there was no other way to do this.
Do you have any suggestion on how to programatically do this?

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download