java.io.IOException:Premature EOF

[SYadav1]

While querying records from Salesforce getting below error Many times.

Any Help would be highly appreciated.

Talend version used 7.2.1 and salesforce api version 53.0

talend error type=Java Exception, talend error origin=tSalesforceInput_1, talend error message=java.io.IOException:Premature EOF 

[Anonymous]

Hello @Santu Yadav​ ,

The error is usually produced when working with the job reaches a query time out on Salesforce side (2 minutes). Salesforce stops the job while job is waiting for the data which is truncated and therefore the Premature EOF (End Of File) error is reported.

The possible solution:

1. decrease the Batch Size for tSalesforceInput(in it's advanced settings), e.g. 1000
2. your SOQL query doesn't have any condition but the LIMIT option is used to reduce the number of exported records this can easily reach the query time out, in this case you should apply filters to reduce the queried number of records instead of using the LIMIT option

Best regards

Aiming

[SKoopers1685689527]

You're experiencing an issue while querying records from Salesforce using Talend 7.2.1 and Salesforce API version 53.0. The error message you're receiving is "java.io.IOException:Premature EOF," which often means that the end of a file or stream was reached unexpectedly during input. This could be due to network issues, timeout settings, or problems with the data. To troubleshoot, you could try adjusting timeout settings, ensuring stable network connection, checking for issues with the data being queried, or updating your Talend and Salesforce API versions. However, for a specific solution, it's best to contact Talend's support or check community forums where similar problems have been discussed. MyTHDHR Login

[lopdesaq34]

Hello, Foot Locker Survey

I'm sorry to hear that you're encountering this error while querying records from Salesforce. It seems like there might be an issue with the Talend version and Salesforce API version compatibility. Have you checked if the versions are compatible? It's also worth checking if there are any network or connectivity issues causing this error. If the issue persists, you may need to reach out to Talend support for further assistance as they would be more familiar with the specific error you're facing.