Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/21/2024 07:51 PM
I want to transfer files from Datafiles to an external SFTP server.
In the SFTP connection's "Files To Put," I have entered the following:
====Files To Put====
================
There are files in Datafiles.
When I run the job with this setup, it seems there is an issue with eic_src_dir, causing the job to fail.
The following log is displayed in the Log Viewer:
DEBUG-Exception in putFilesInTarget : |org.json.JSONException: JSONObject["SourceDirectory"] not found.| at org.json.JSONObject.get(JSONObject.java:570) ~[json-20230227.jar!/:na]| at org.json.JSONObject.getString(JSONObject.java:857) ~[json-20230227.jar!/:na]| at com.saviynt.ssm.sftpconnector.service.SFTPConnectorService.putFilesInDirectory(SFTPConnectorService.java:360) ~[na:na]| at com.saviynt.ssm.sftpconnector.service.SFTPConnectorService.putFilesInTarget(SFTPConnectorService.java:341) ~[na:na]| at com.saviynt.ssm.sftpconnector.SFTPConnector.putFiles(SFTPConnector.java:64) ~[na:na]| at com.saviynt.ssm.connectorms.controller.FileTransferController.putFiles(FileTransferController.java:85) ~[classes!/:2021.1.0.0-SNAPSHOT]
How should I write "Files To Put" to transfer files from Datafiles to the SFTP server?
05/21/2024 10:39 PM
The file upload for Reports keyword in the eic_src_dir configuration now refers to /saviynt_shared/reports directory for the SFTP File Transfer and S3 File Transfer connectors.
https://docs.saviyntcloud.com/bundle/Release-Notes/page/Content/v23/Release-Notes-23-8.htm
05/22/2024 12:22 AM
First of all, what I want to transfer is not Analytics Report but Datafiles in the File Directory.
I rewrote Files To Put as follows, but I still get an error that the source directory cannot be found.
[
{
"eic_src_dir":"/saviynt_shared/saviynt/Import/Datafiles",
"target_dir":"/tmp/",
"file_list":["file2.csv"],
"regex_list":["^.*\\.zip"]
}
]
2024-05-22T16:14:56+09:00-connectorms-c.s.s.s.service.SFTPConnectorService-http-nio-8980-exec-3-zjh98-DEBUG-Exception in putFilesInTarget : |org.json.JSONException: JSONObject["SourceDirectory"] not found.| at org.json.JSONObject.get(JSONObject.java:570) ~[json-20230227.jar!/:na]| at org.json.JSONObject.getString(JSONObject.java:857) ~[json-20230227.jar!/:na]| at com.saviynt.ssm.sftpconnector.service.SFTPConnectorService.putFilesInDirectory(SFTPConnectorService.java:360) ~[na:na]| at com.saviynt.ssm.sftpconnector.service.SFTPConnectorService.putFilesInTarget(SFTPConnectorService.java:341) ~[na:na]| at com.saviynt.ssm.sftpconnector.SFTPConnector.putFiles(SFTPConnector.java:64) ~[na:na]| at com.saviynt.ssm.connectorms.controller.FileTransferController.putFiles(FileTransferController.java:85) ~[classes!/:2021.1.0.0-SNAPSHOT]|
06/13/2024 12:51 AM
Anyone managed to find the workaround yet?
06/13/2024 01:21 AM
Hi @JPMac , instead of giving full directory can you just try with
Datafiles in eic_src_dir
06/13/2024 01:32 AM
No, transferring CSV files from datafile is not resolved.
You can transfer them by specifying "reports/analytics/<report name >."
06/13/2024 02:32 AM
Could we move the data files to reports and then utilize that report for uploading to SFTP?
Thanks,
Chirag Gupta
06/13/2024 02:38 AM
06/13/2024 10:03 PM
Yes you can use saviynt REST APIs for same.
Refer Saviynt API Documentation https://docs.saviyntcloud.com/bundle/API-Reference-Guide/page/Content/API-References.htm