Trouble with SFTP JarConnector

New Contributor II
New Contributor II

I am trying to place an analytic file csv into a remote FTP location. For testing, I placed a sample file to be picked up and moved. I also confirmed SFTP credentials worked by using a different application.

version 5.5 SP3.12

These are the errors I receive in the log. the ultimate ending says success, but there is no file.

2023-05-26 14:51:48,082 [quartzScheduler_Worker-4] DEBUG provisoning.JarConnectorService - Start importAccountsFull
2023-05-26 14:51:48,082 [quartzScheduler_Worker-4] DEBUG provisoning.JarConnectorService - Lets Invoke Class Namecom.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs method saviyntFileTransfer_SFTP
2023-05-26 14:51:48,152 [quartzScheduler_Worker-4] DEBUG provisoning.JarConnectorService - Failed to import Account
2023-05-26 14:51:48,152 [quartzScheduler_Worker-4] DEBUG provisoning.JarConnectorService - End importAccountsFull
2023-05-26 14:51:48,152 [quartzScheduler_Worker-4] DEBUG provisoning.JarConnectorService - done
2023-05-26 14:51:48,152 [quartzScheduler_Worker-4] DEBUG provisoning.JarConnectorService - Elapsed seconds: 0
2023-05-26 14:51:48,152 [quartzScheduler_Worker-4] DEBUG services.ImportUtilityService - Writing job history to import logs.
2023-05-26 14:51:48,152 [quartzScheduler_Worker-4] DEBUG services.ImportUtilityService - Number of log entries to be written : 2
2023-05-26 14:51:48,157 [quartzScheduler_Worker-4] DEBUG integration.ExternalConnectionCallService - END INVOKING EXTERNAL CONNECTION
2023-05-26 14:51:48,157 [quartzScheduler_Worker-4] DEBUG jobs.SapImportJob - FINISH externalConnectionCallService
2023-05-26 14:51:48,163 [quartzScheduler_Worker-4] DEBUG jobs.SapImportJob - Setting the value of import status
2023-05-26 14:51:48,163 [quartzScheduler_Worker-4] DEBUG jobs.SapImportJob - Import status :: Success

This is my import account JSON:

"arguments": {


New Contributor II
New Contributor II

Nevermind, I figured it out. I found an error in the "success" folder that said the file list should not contain filenames with extensions. I was able to get it to work after removing the .csv 

Please update the SFTP connector documentation. The sample in the document shows "AWS_TEST.csv" for the FILE_NAME_LIST example.

Community Manager
Community Manager

Hi @yodeler - On the docs page in the top-right corner there is a Feedback link. Click on it and your feedback will go directly to the documentation team.

Docs Feedback.jpg

Thank you!