Troubleshooting an SFTP Connection

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.