tSalesforce Gregorian Calendar / org.talend.daikon Exception

[Anonymous]

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.

[Anonymous]

@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.

[TRF]

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.

[Anonymous]

@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.

[Anonymous]

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 ….

[Chah]

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,