topic Re: tSalesforce Gregorian Calendar / org.talend.daikon Exception in Talend Studio

tSalesforce Gregorian Calendar / org.talend.daikon Exception

Anonymous — Sat, 16 Nov 2024 08:30:40 GMT

Hello,

This error is showing when using tSalesforceConnection and tSalesforceInput components:

org.talend.components.api.exception.ComponentException: org.talend.daikon.exception.error.DefaultErrorCode@b9b00e0:{failedBatch=[BatchInfo  id='7510Y00000Bcn94QAB'
 jobId='7500Y000009aLf1QAE'
 state='Queued'
 stateMessage='null'
 createdDate='java.util.GregorianCalendar[time=1521778504000,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=2,minimalDaysInFirstWeek=4,ERA=1,YEAR=2018,MONTH=2,WEEK_OF_YEAR=12,WEEK_OF_MONTH=4,DAY_OF_MONTH=23,DAY_OF_YEAR=82,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=4,AM_PM=0,HOUR=4,HOUR_OF_DAY=4,MINUTE=15,SECOND=4,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0]'
 systemModstamp='java.util.GregorianCalendar[time=1521778504000,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=2,minimalDaysInFirstWeek=4,ERA=1,YEAR=2018,MONTH=2,WEEK_OF_YEAR=12,WEEK_OF_MONTH=4,DAY_OF_MONTH=23,DAY_OF_YEAR=82,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=4,AM_PM=0,HOUR=4,HOUR_OF_DAY=4,MINUTE=15,SECOND=4,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0]'
 numberRecordsProcessed='0'
 numberRecordsFailed='0'
 totalProcessingTime='0'
 apiActiveProcessingTime='0'
 apexProcessingTime='0'
]
}
	at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.doBulkQuery(SalesforceBulkRuntime.java:513)
	at org.talend.components.salesforce.runtime.SalesforceBulkQueryInputReader.executeSalesforceBulkQuery(SalesforceBulkQueryInputReader.java:114)
	at org.talend.components.salesforce.runtime.SalesforceBulkQueryInputReader.start(SalesforceBulkQueryInputReader.java:56)
	at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73)
	at company_name.job_name_0_6.job_name.tSalesforceInput_2Process(job_name.java:2082)
	at company_name.job_name_0_6.job_name.tSalesforceConnection_1Process(job_name.java:1454)
	at company_name.job_name_0_6.job_name.runJobInTOS(job_name.java:34563)
	at company_name.job_name_0_6.job_name.runJob(job_name.java:34347)
	at company_name.company_namemain_0_1.company_nameMain.tRunJob_1Process(company_nameMain.java:859)
	at company_name.company_namemain_0_1.company_nameMain.runJobInTOS(company_nameMain.java:6841)
	at company_name.company_namemain_0_1.company_nameMain.main(company_nameMain.java:6695)

The error usually appears after process being stuck at the component for a longer period of time.

It occurs in about 30% of the time, and I don't know what is causing it. The network connection is good and stable.

Re: tSalesforce Gregorian Calendar / org.talend.daikon Exception

Anonymous — Wed, 28 Mar 2018 08:15:49 GMT

Hello,

Could you please clarify in which Talend version/edition you are? Would you mind posting your component setting screenshots on forum?

Please mask your sensitive data.

Best regards

Sabrina

Re: tSalesforce Gregorian Calendar / org.talend.daikon Exception

TRF — Wed, 28 Mar 2018 08:20:15 GMT

Hi,

How many records expected as the result?

What if you try the same query from the Salesforce Developer Console or DataLoader?

If you can't try, what if you try to query a smaller object?

Re: tSalesforce Gregorian Calendar / org.talend.daikon Exception

Anonymous — Wed, 28 Mar 2018 11:08:42 GMT

Version: TOS_DI-20170623_1246-V6.4.1

Settings:

Re: tSalesforce Gregorian Calendar / org.talend.daikon Exception

Anonymous — Wed, 28 Mar 2018 11:16:44 GMT

@TRF

More than 10,000.

It will work trough Developer Console (up to 10,000).

It doesn't matter if the Object is small or big - success or failure is random and not connected to the query size.

Sometimes it fails to query 3 records, sometimes it succeeds to query 40,000.

Re: tSalesforce Gregorian Calendar / org.talend.daikon Exception

Anonymous — Wed, 28 Mar 2018 12:12:26 GMT

Another example:

Connection works, 2x Input works, third Input fails (with the same exception).

Re: tSalesforce Gregorian Calendar / org.talend.daikon Exception

TRF — Wed, 28 Mar 2018 13:20:16 GMT

Hi,

I suspect network microcut.

Try with Dataloader (more than once) which use same API as TOS and for which you'll have to bring back the same data volume to your computer using the same route and crossing the same network equipments.

Edit: if possible, try using an other network (maybe your 4g connection)

Re: tSalesforce Gregorian Calendar / org.talend.daikon Exception

TRF — Thu, 29 Mar 2018 10:30:14 GMT

Did this help you?

If so, thank's to mark your case as solved.

Re: tSalesforce Gregorian Calendar / org.talend.daikon Exception

Anonymous — Wed, 04 Apr 2018 14:45:14 GMT

@TRF

I have not managed to reproduce the error with Salesforce Data Loader.

@xdshi

Do you have any input on this issue?

Re: tSalesforce Gregorian Calendar / org.talend.daikon Exception

TRF — Wed, 04 Apr 2018 14:50:53 GMT

At least did you tried with another kind of network connection?

Re: tSalesforce Gregorian Calendar / org.talend.daikon Exception

Anonymous — Wed, 04 Apr 2018 14:57:49 GMT

@TRF

Unfortunately, I can't.
I'm using my client's remote VPN machine, and I need to know the root cause before I tell them the problem is on their side.

Re: tSalesforce Gregorian Calendar / org.talend.daikon Exception

TRF — Wed, 04 Apr 2018 16:48:45 GMT

I'm pretty sure the problem is caused by your network connection.

I understand this is not a suffisiant proof for your client but I can't tell you more than I've already done.

Re: tSalesforce Gregorian Calendar / org.talend.daikon Exception

Anonymous — Thu, 05 Apr 2018 12:33:25 GMT

@TRF

I have finally managed to run Data Loader at the same time Talend has failed.

It performed flawlessly multiple times while tSalesforceInput was failing.

Re: tSalesforce Gregorian Calendar / org.talend.daikon Exception

Anonymous — Wed, 05 Sep 2018 16:10:53 GMT

Did you finally find a solution for this behaviour?

We are experiencing the same errors in Talend Integration Cloud where the Talend jobs are running on the machines of our clients.

We do the same jobs running on more than 5 different environments (using Talend Remote Engines) and the jobs fail randomly.

Very curious if you found the cause of the problem.

The problem is also treated by Talend Support but at the moment we are still in the dark ….

Re: tSalesforce Gregorian Calendar / org.talend.daikon Exception

Chah — Thu, 17 Jun 2021 19:26:30 GMT

Hello,

Did you find solution for this problem?

I am facing the same error inspite of that we are using Talen v7.1

Thanks in advance,