"Error in Download using Username Password Method" using SFTP

[SPAL]

Hi Team,

We are setting up SFTP Connection and using username,password based authentication.

Saviynt Connector Configurations : Configured all the steps as defined in the configuration document.{SFTP Integration guide} 

Getting below error:

"2024-04-29T08:27:41.497+00:00","ecm-worker","","null-q4svp","","29-Apr-2024 08:27:41.245 INFO [quartzScheduler_Worker-3] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 14249 :: Final destination folder:::/saviynt_shared/saviynt/Import/"
"2024-04-29T08:27:41.497+00:00","ecm-worker","","null-q4svp","","29-Apr-2024 08:27:41.245 INFO [quartzScheduler_Worker-3] com.saviynt.connector.SFTPConnector.SFTPExecutornew.downLoadFile :: Inside Download Method using Username Password"
"2024-04-29T08:27:41.497+00:00","ecm-worker","","null-q4svp","","29-Apr-2024 08:27:41.398 INFO [quartzScheduler_Worker-3] com.saviynt.connector.SFTPConnector.SFTPExecutornew.downLoadFile :: Error in Download using Username Password Method"
"2024-04-29T08:27:41.497+00:00","ecm-worker","","null-q4svp","","29-Apr-2024 08:27:41.398 INFO [quartzScheduler_Worker-3] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 14249 :: download failed for file :::/Saviynt/Frontier_Sample_Accounts_Import.csv"
"2024-04-29T08:27:41.418+00:00","ecm-worker","provisoning.JarConnectorService","quartzScheduler_Worker-3-q4svp","DEBUG","TargetToSource mapping is missing"
"2024-04-29T08:27:41.418+00:00","ecm-worker","provisoning.JarConnectorService","quartzScheduler_Worker-3-q4svp","DEBUG","End importAccountsFull"
"2024-04-29T08:27:41.418+00:00","ecm-worker","provisoning.JarConnectorService","quartzScheduler_Worker-3-q4svp","DEBUG","done"

Things Validated:

1. Service Account has all the required privileges to upload/download files.
2. System has been restarted from UI to reflect the Jar upload.
3. IMPORTPARAMSMAP='jobtype:2,importtype:1,importtypeoptions:accounts is set.

ImportAccountsJSON: 

{
"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":"/Saviynt/",
"SAVIYNT_DIRECTORY":"/saviynt_shared/saviynt/Import/",
"FILE_NAME_LIST":"Frontier_Sample_Accounts_Import.csv",
"SFTP_LOGFILE_DIRECTORY":"/saviynt_shared/saviynt/Import/Success/",
"DELETE_SOURCE_FILE_AFTER_DOWNLOAD":"no",
"LOG_FILE_AGE":"2"
}
}

Things Tried:

1. "SFTP_DIRECTORY":"/Saviynt/" and  "/Saviynt"

2. With and without SFTP keys.

Please let us know if we are missing any config or if there is any additional steps that needs to be followed.

Regards,
Saksham

[rushikeshvartak]

{

  "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": "/home/saviynt/ALL_ENDPOINTS/",

    "SAVIYNT_DIRECTORY": "/saviynt_shared/saviynt/Import/",

    "SFTP_LOGFILE_DIRECTORY": "/saviynt_shared/saviynt/Import/Success/",

    "DELETE_SOURCE_FILE_AFTER_DOWNLOAD": "No",

    "LOG_FILE_AGE": "7",

    "FILE_NAME_LIST": "Frontier_Sample_Accounts_Import.csv"

  }

}

[SPAL]

Hi @rushikeshvartak ,

I have tried using with the above ImportAccountJson, but still we are getting the same error as shown in the logs.

"2024-04-30T06:05:31.250+00:00","ecm-worker","","null-d2gl4","","30-Apr-2024 06:05:30.755 INFO [quartzScheduler_Worker-9] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 91164 :: Final destination folder:::/saviynt_shared/saviynt/Import/"
"2024-04-30T06:05:31.250+00:00","ecm-worker","","null-d2gl4","","30-Apr-2024 06:05:30.758 INFO [quartzScheduler_Worker-9] com.saviynt.connector.SFTPConnector.SFTPExecutornew.downLoadFile :: Inside Download Method using Username Password"
"2024-04-30T06:05:31.250+00:00","ecm-worker","","null-d2gl4","","30-Apr-2024 06:05:30.937 INFO [quartzScheduler_Worker-9] com.saviynt.connector.SFTPConnector.SFTPExecutornew.downLoadFile :: Error in Download using Username Password Method"
"2024-04-30T06:05:31.250+00:00","ecm-worker","","null-d2gl4","","30-Apr-2024 06:05:30.937 INFO [quartzScheduler_Worker-9] com.saviynt.connector.SFTPConnector.FileTransferUtilitywithargs.saviyntFileTransfer_SFTP 91164 :: download failed for file :::/home/saviynt/ALL_ENDPOINTS/Frontier_Sample_Accounts_Import.csv"
"2024-04-30T06:05:30.966+00:00","ecm-worker","provisoning.JarConnectorService","quartzScheduler_Worker-9-d2gl4","DEBUG","TargetToSource mapping is missing"
"2024-04-30T06:05:30.966+00:00","ecm-worker","provisoning.JarConnectorService","quartzScheduler_Worker-9-d2gl4","DEBUG","End importAccountsFull"
"2024-04-30T06:05:30.966+00:00","ecm-worker","provisoning.JarConnectorService","quartzScheduler_Worker-9-d2gl4","DEBUG","done"

Regards,

Saksham

[rushikeshvartak]

Please add TargetToSource mapping

{
"fullyQualifiedClassName": "com.jar.jar",
"methodName": "accountImport",
"arguments": {
"connect_url": "${connectionJSON.url}",
"connect_username": "${connectionJSON.username}",
"connect_password": "${connectionJSON.password}",
"endpoint": "JAR",
"securitySystem": "JAR"
},
"targetToSourceMappingJSON": {
"accounts.name": "accountName_character",
"accounts.description": "Description_character",
"accounts.Status": "Status_character",
"endpoints.endpointname": "endpoint_character",
"securitysystems.systemname": "securitySystem_character"
}
}

https://docs.saviyntcloud.com/bundle/JAR-v24x/page/Content/Understanding-the-Integration-between-EIC...