and more in a single search tool across platforms. Read the announcement here. |
03/06/2023 05:34 AM
Hi,
As we understood Saviynt has OOTB feature to transfer files from Saviynt to SFTP location and SFTP location to Saviynt. In this process we got a good experience in downloading the file from SFTP location to Saviynt Datafiles location. However we are facing a challenge while uploading the file from Saviynt location (/saviynt_shared/saviynt/Reports/) to SFTP location.
Expectation : Reports which we generate need to be sent to SFTP location in txt format.
Observations :
1. Analytic reports are storing in /Reports/ location in zip format and as per the upload functionality zip format is not supported.
2. Tried uploading .csv file from /datafiles/ location to SFTP server and successfully transferred.
@rushikeshvartak any help will be highly appreciated.
Thanks in advance
Regards,
Venkat Aligineni
03/06/2023 08:44 AM
Hi @venkat
(/saviynt_shared/saviynt/Reports/) will be stored in xlsx format always. This format is supported to upload SFTP.
Also currently format changes are not supported, so the same format needs to be uploaded to SFTP location
03/16/2023 02:34 AM
Hi @Darshanjain
I had created a analytic report (TestReverseFeed) and provided the save to file location as /saviynt_shared/saviynt/Reports/
When I tried to transfer the above file to SFTP location it was not succeeding.
Connection Details :
"ACTION":"upload",
"SFTP_DIRECTORY":"/home/*********/Dev_Test/",
"SAVIYNT_DIRECTORY":"/saviynt_shared/saviynt/Reports/",
"FILE_NAME_REGEX":"^.*TestReverse?[-_.A-Za-z0-9]*",
"SFTP_LOGFILE_DIRECTORY":"/saviynt_shared/saviynt/Import/Success/",
"DELETE_SOURCE_FILE_AFTER_DOWNLOAD":"no ",
"SFTP_CERT_DEFAULT_PATH":"/saviynt_shared/saviynt/Import/Datafiles/",
"FILE_EXTENSION":".xlsx",
"LOG_FILE_AGE":"5"
I would like to know what was the file name will be in the reports folder?
Is there a way to check what file available in the reports folder?
Thanks & Regards,
Venkat Aligineni
9177247342
03/16/2023 03:12 AM
I would suggest you to check with saviynt support team to get the exact path if you have used this directly from documentation.
Also do you see anything in the logs to check why its not succeeding.
Thanks
Darshan
Thanks
Darshan
03/16/2023 05:40 AM
Hi @Darshanjain
Please find the log
"ecm-worker","2023-03-16T12:34:24.842+00:00","{"log":"2023-03-16 12:34:24,400 [quartzScheduler_Worker-2] DEBUG println.PrintlnToLogger - Println :: \u001b[1;31m| Error \u001b[22;39m\u0009at com.saviynt.provisoning.JarConnectorService.invokeExternalClass(JarConnectorService.groovy:1160)\u001b[m\n","stream":"stdout","time":"2023-03-16T12:34:24.400048432Z"}"
"ecm-worker","2023-03-16T12:34:24.842+00:00","{"log":"2023-03-16 12:34:24,400 [quartzScheduler_Worker-2] DEBUG println.PrintlnToLogger - Println :: \u001b[1;31m| Error \u001b[22;39m\u0009at com.saviynt.provisoning.JarConnectorService.this$2$invokeExternalClass(JarConnectorService.groovy)\u001b[m\n","stream":"stdout","time":"2023-03-16T12:34:24.400060334Z"}"
"ecm-worker","2023-03-16T12:34:24.842+00:00","{"log":"2023-03-16 12:34:24,400 [quartzScheduler_Worker-2] DEBUG println.PrintlnToLogger - Println :: \u001b[1;31m| Error \u001b[22;39m\u0009at com.saviynt.provisoning.JarConnectorService$this$2$invokeExternalClass$2.callCurrent(Unknown Source)\u001b[m\n","stream":"stdout","time":"2023-03-16T12:34:24.400109062Z"}"
"ecm-worker","2023-03-16T12:34:24.842+00:00","{"log":"2023-03-16 12:34:24,400 [quartzScheduler_Worker-2] DEBUG println.PrintlnToLogger - Println :: \u001b[1;31m| Error \u001b[22;39m\u0009at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:49)\u001b[m\n","stream":"stdout","time":"2023-03-16T12:34:24.400115847Z"}"
03/16/2023 06:34 AM
Use jar connector to read report data using rest api and prepare txt and send to sftp location