Saviynt Forums

Deepanshu271 · ‎01/11/2024

Hi,

I was trying to deploy the custom sftp utility jar and followed the steps as well.

Below is my accountImport

{

"fullyQualifiedClassName": "com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs",
"methodName": "saviyntFileTransfer_SFTP",
"arguments": {
"SFTPHOST": "${connectionJSON.SFTPHOST}",
"SFTPPORT": "${connectionJSON.SFTPPORT}",
"SFTPUSER": "${connectionJSON.SFTPUSER}",
"SFTPPASS": "${connectionJSON.SFTPPASS}",
"ACTION": "download",
"SFTP_DIRECTORY":"/upload/",
"SAVIYNT_DIRECTORY":"/saviynt_shared/saviynt/Import/",
"FILE_NAME_LIST":"AWS_TEST.csv",
"SFTP_LOGFILE_DIRECTORY":"/saviynt_shared/saviynt/Import/Success/",
"DELETE_SOURCE_FILE_AFTER_DOWNLOAD":"yes",
"LOG_FILE_AGE":"2"
}
}

after running the application data import job although the job is success but i don't see the file in datafiles in saviynt.

below are the details:

{log":"11-Jan-2024 12:01:24.487 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789******#### SFTP Utility Execution Started ####******\n"

{log":"11-Jan-2024 12:01:24.488 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789 :: ACTION ::download\n"

{log":"11-Jan-2024 12:01:24.488 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789 :: UserName::sftpdipslocal\n"

{log":"11-Jan-2024 12:01:24.488 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789SFTP_KEY_PATH::null\n"

{log":"11-Jan-2024 12:01:24.489 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789 :: SFTP_KEYFILE_NAME ::null\n"

{log":"11-Jan-2024 12:01:24.489 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789 :: Checking for SFTP_CERT_DEFAULT_PATH property\n"

{log":"11-Jan-2024 12:01:24.489 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789 :: SFTPHOST::DESKTOP-KUFHFAU\n"

{log":"11-Jan-2024 12:01:24.489 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789 :: SFTPPORT::22\n"

{log":"11-Jan-2024 12:01:24.490 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789 :: certPath::null\n"

{log":"11-Jan-2024 12:01:24.490 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789 :: FILE_NAME_LIST:::AWS_TEST.csv\n"

{log":"11-Jan-2024 12:01:24.490 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789 :: SAVIYNT_DIRECTORY:::/saviynt_shared/saviynt/Import/\n"

{log":"11-Jan-2024 12:01:24.490 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789 :: SFTP_DIRECTORY::/upload/\n"

{log":"11-Jan-2024 12:01:24.491 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789 :: FILE_NAME_REGEX::null\n"

{log":"11-Jan-2024 12:01:24.491 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789 :: FILE_EXTENSION::null\n"

{log":"11-Jan-2024 12:01:24.491 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789 :: Action:Download - File Name::/upload/AWS_TEST.csv\n"

{log":"11-Jan-2024 12:01:24.492 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789 :: Final destination folder:::/saviynt_shared/saviynt/Import/\n"

{log":"11-Jan-2024 12:01:24.492 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.SFTPExecutornew.downLoadFile :: Inside Download Method using Username Password\n"

{log":"2024-01-11 12:01:24

{log":"11-Jan-2024 12:01:24.503 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.SFTPExecutornew.downLoadFile :: Error in Download using Username Password Method\n"

{log":"11-Jan-2024 12:01:24.503 INFO [quartzScheduler_Worker-2] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 28789 :: download failed for file :::/upload/AWS_TEST.csv\n"

my sftp user details are for local bitvise ssh instance

port is 22

I am able to connect with ssh server using winscp but saviynt this issue is happening.

Kindly help.

Regards,

Deepanshu Bisht

rushikeshvartak · ‎01/11/2024

Refer https://forums.saviynt.com/t5/identity-governance/trouble-with-sftp-jarconnector/m-p/36378

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Deepanshu271 · ‎01/11/2024

hey rushikesh,

Still not working.

do we have any simple external jar code example that i can utilize for testing

rushikeshvartak · ‎01/11/2024

External jar for sftp jar connector ?

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Deepanshu271 · ‎01/12/2024

No external jar for any operation in general such as sending email or generating a report etc

rushikeshvartak · ‎01/14/2024

Refer

https://forums.saviynt.com/t5/identity-governance/sftp-connection-failing/m-p/52081

https://forums.saviynt.com/t5/identity-governance/saviynt-sftp-integration/m-p/29162

https://forums.saviynt.com/t5/identity-governance/trouble-with-sftp-jarconnector/m-p/36378

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Saviynt Forums

SFTP Utility jar connection issue