Salesforce connection fails with the error 'SERVER_UNAVAILABLE'
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.
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.
@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).
