topic Re: Salesforce connection fails with the error 'SERVER_UNAVAILABLE' in Talend Studio

Salesforce connection fails with the error 'SERVER_UNAVAILABLE'

Anonymous — Sat, 16 Nov 2024 06:06:36 GMT

A production job take in ~500 source files and update sfdc with the following message

(I have attached a screen print of the subjob that fail and the dataloader configuration file)

2019-04-09 01:13:06;47b3Z0;47b3Z0;47b3Z0;_PRODUCTION;JOB_09_Load_Data;Default;6;Java Exception;tRunJob_2;java.lang.RuntimeException:Child job running failed.
java.lang.RuntimeException: IOException: [UnexpectedErrorFault [ApiFault exceptionCode='SERVER_UNAVAILABLE'
exceptionMessage='Request timed out waiting for connection: [config 15,000ms, actual 15,001ms] currentCheckoutReason=DBContext node=5 poolType=STANDARD
DB Patching ongoing: false'
extendedErrorDetails='{[0]}'
]
]
;1

This daily job fails once a week but the failure frequency had been increasing lately , particularly on Monday.

The other thing we notice, we set the timeout to 60 seconds on all tsalesforceoutput and dataloader configuration and yet the error message is showing 15 seconds

Appreciate if you can provide any recommendation on how to address the issue and let us know if you require any additional information.

Re: Salesforce connection fails with the error 'SERVER_UNAVAILABLE'

Anonymous — Thu, 18 Apr 2019 10:47:21 GMT

Hello,

From this error message, it cames out to be a Salesforce issue. What's the edition of salesforce are you using? Would you mind posting your tsalesforceOutput component setting screenshot on forum? Please mask your sensitive data.

Best regards

Sabrina

Re: Salesforce connection fails with the error 'SERVER_UNAVAILABLE'

Anonymous — Fri, 19 Apr 2019 22:32:54 GMT

Thanks Sabrina looking into issue.

Here is a screen shot of the tsalesforceoutput property

Tsaleforceoutput1.PNG

Re: Salesforce connection fails with the error 'SERVER_UNAVAILABLE'

Anonymous — Tue, 23 Apr 2019 08:19:37 GMT

Hello,

What's the edition of salesforce are you using?

Best regards

Sabrina

Re: Salesforce connection fails with the error 'SERVER_UNAVAILABLE'

TRF — Sat, 27 Apr 2019 11:37:08 GMT

@mlting, you could simplify your job using a tSalesforce component instead of DataLoader to populate Attachment object.

Much more better, you should user Files instead of Attachment.

Anyway, timeout defined on the tSalesforceXxxxx components including tSalesforceConnection is for queries, not for the connection itself for which you cannot change the timeout value (I think so).