Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

"Error in Download using Username Password Method" using SFTP

SPAL
New Contributor
New Contributor

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

3 REPLIES 3

rushikeshvartak
All-Star
All-Star
{
  "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"
  }
}
 

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

SPAL
New Contributor
New Contributor

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

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...

 


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