Trouble with SFTP JarConnector

[yodeler]

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:

"fullyQualifiedClassName":"com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs",
"methodName":"saviyntFileTransfer_SFTP",
"arguments": {
"SFTPHOST":"${connectionJSON.SFTPHOST}",
"SFTPPORT":"${connectionJSON.SFTPPORT}",
"SFTPUSER":"${connectionJSON.SFTPUSER}",
"SFTPPASS":"${connectionJSON.SFTPPASS}",
"ACTION":"upload",
"SFTP_DIRECTORY":"/HR_Workday/Reporting/",
"SAVIYNT_DIRECTORY":"/opt/saviynt/reports/",
"FILE_NAME_LIST":"sample.csv",
"SFTP_LOGFILE_DIRECTORY":"/opt/saviynt/Import/Success/",
"DELETE_SOURCE_FILE_AFTER_DOWNLOAD":"no",
"SFTP_KEY_PATH":"",
"SFTP_KEYFILE_NAME":"",
"SFTP_ CERT_DEFAULT_PATH":"",
"LOG_FILE_AGE":"2"
}
}

[yodeler · Accepted solution]

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.

[Dave]

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.

Thank you!