Skip to main content

Troubleshooting an SFTP Connection

Solve common SFTP import and export issues in Nexadata, including connection errors, missing files, and permission problems.

Updated this week

Common Issues and Fixes


Issue 1: SFTP Connection Not Appearing in Dropdown

Symptoms:

  • The SFTP connection does not show up when creating a Dataset or Output.

  • The connection was previously available but has disappeared.

Possible Causes:

  • The connection was deleted or renamed.

  • Your account does not have access to the connection.

  • The connection was not properly saved during setup.

Solutions:

  • Go to Data Connections and verify that the SFTP connection exists and is active.

  • Check with your administrator to confirm you have access permissions.

  • Recreate the connection if it was deleted.


Issue 2: "File Not Found" When Selecting SFTP Path

Symptoms:

  • No files are listed when typing into the SFTP path field.

  • Auto-complete doesn’t return any results.

Possible Causes:

  • The directory path is incorrect.

  • The SFTP server is unreachable or slow to respond.

  • File permissions are blocking access.

Solutions:

  • Verify the file path manually by connecting to the SFTP server outside Nexadata (e.g., via FileZilla or command line).

  • Check file and folder permissions on the server.

  • Ensure the server is online and not experiencing downtime.


Issue 3: Dataset Submission Fails

Symptoms:

  • Clicking Submit when creating a dataset results in an error message.

  • The dataset doesn’t appear in the Datasets list.

Possible Causes:

  • Incorrect or empty SFTP file path.

  • Unsupported file format or unreadable file.

  • Auto-detection of delimiter fails on malformed files.

Solutions:

  • Confirm that the selected file is in a supported format (CSV or TXT).

  • Try disabling Auto Detect Delimiter and manually choose one.

  • Ensure the file is not empty or corrupted.


Issue 4: Output File Not Written to SFTP Server

Symptoms:

  • Pipeline completes, but no output file appears in the destination folder.

  • Dynamic or Static output doesn't show up as expected.

Possible Causes:

  • Incorrect file path in SFTP Output settings.

  • SFTP write permissions are missing.

  • The output was written, but to a different folder than expected.

Solutions:

  • Double-check the SFTP Path in your output configuration.

    • For Dynamic, only specify a folder.

    • For Static, include the full filename.

  • Make sure your Nexadata connection has write permissions on the SFTP server.

  • Confirm pipeline execution was successful and not canceled or failed mid-run.

📸 [Optional] Insert screenshot showing a correctly configured SFTP Output for clarity.


Issue 5: Delimiter Issues When Importing Tabular Data

Symptoms:

  • Data is not parsed correctly into columns.

  • Unexpected characters or misaligned values in the preview.

Possible Causes:

  • Incorrect delimiter detected.

  • File contains inconsistent row formatting.

Solutions:

  • Disable Auto Detect Delimiter and manually select the appropriate one (Comma, Tab, Pipe, etc.).

  • Open the source file and inspect it manually for formatting inconsistencies.


Tips for Reliable SFTP Setup

  • ✅ Use Dynamic Output to avoid overwriting existing files and preserve version history.

  • ✅ Confirm with your IT team that Nexadata’s IPs are whitelisted on the SFTP server.

  • ✅ Use standardized file naming conventions to make browsing and automation easier.

  • 🔐 Always verify that read/write permissions are properly configured for your connection.


Still Having Issues?

If you've checked all the above and still encounter problems:

  • Contact your administrator to verify your connection setup.

  • Reach out to Nexadata Support with logs and screenshots of your configuration.

Did this answer your question?