Salesforce import fails

Options
KatriM
KatriM Member
in General

Hi,

This is one of the error messages. In some cases there is no error message in the log file although no rows have been imported.

"Caused by: com.experian.aperturedatastudio.jdbc.sforce.phoenix.sql.ae: Socket Error: Read timed out
Caused by: java.net.SocketTimeoutException: Read timed out"

Do you know what can cause these kind of failed imports from Salesforce?

Is it possible to configure the connection so that the timeout won't happen?

And what does that phoenix mean there in that error message?

Tagged:

Answers

  • Josh Boxer
    Josh Boxer Administrator

    Pheonix is a language used by Salesforce (you can ignore)

    https://engineering.salesforce.com/evolving-apache-phoenix-overcoming-5-challenges-to-add-document-data-support/

    Not entirely sure about the timeout, would need to know how frequently this error is occuring (and what other error messages you are seeing). A simple change would be to increase the timeout(s) in the External system connection string and see if that makes a difference. Is it only this Salesforce Dataset causing the issue or multiple? If only this one, you could also reduce/limit the amount of data being requested to see if this is why Salesforce is returning this.

Categories