Loading

Data 360: Best Practices for Managing SFTP Data Stream Errors Due to Scheduling Conflicts and Connection Limits

Fecha de publicación: Nov 11, 2025
Descripción

When an SFTP data stream fails, it will be marked with an error status in the refresh history, showing "Failure." You can get more details by downloading the associated file from the refresh history by clicking the icon next to the "Failure" keyword.

Common error messages that pertain to this Knowledge Article include:

Exception while uploading data using com.salesforce.dataconnectors.datawriter.ObjectStoreWriter$ObjectStreamProviderHelper - Unable to position the currentPosition from -1 to 0

Root Cause:

SFTP servers often enforce limits on the number of simultaneous connections allowed per user or connection. If multiple data streams are scheduled to run at the same time using the same SFTP connection, this can exceed the server's connection limit, resulting in errors and failures.

Solución

To mitigate these errors and ensure reliable operation of your SFTP data streams, follow these best practices:

  1. Stagger Data Stream Schedules:

    • Avoid Concurrent Scheduling: Schedule data streams in a way that prevents overlap. Aim for a minimum gap of 30 minutes between the start times of each data stream that uses the same SFTP connection. This reduces the likelihood of hitting connection limits.
    • Scheduling Multiple Streams:If you need to schedule multiple streams together and can alter the settings of your SFTP server, make sure that for each stream pulling, allow only 5 concurrent connections. For example, if you have 10 data streams pulling at the same time, you would need to be able to set 50 concurrent connections as a limit.

  2. Monitor Connection Limits:

    • Understand Your Server’s Capabilities: Check the maximum number of concurrent connections your SFTP server allows for each user or connection. Adjust your data stream schedules accordingly to stay within these limits.

  3. Optimize Data Stream Settings:

    • Reduce Frequency Where Possible: If certain data streams do not need to run frequently, consider reducing their run frequency to lessen the load on the SFTP server.

  4. Consult with Your IT Team:

    • Work with your IT team to ensure that the SFTP server is configured optimally to handle the anticipated data stream load, and to adjust server settings if necessary.

  5. Contact Support if Issues Persist:

    • If you continue to experience problems despite adjusting schedules and optimizing settings, contact Salesforce Support for further assistance.
Número del artículo de conocimiento

002627932

 
Cargando
Salesforce Help | Article