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 over 3 weeks ago

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?