Symptom
If you have scheduled same report multiple times a day with different filters, and you are not seeing multiple instances of the same report(with different filters data) in their SFTP instead you could only see one report present in the SFTP
Environment
SAP SuccessFactors Learning
Reproducing the Issue
1. Navigate to learning administration > System administration > configuration > System configuration
2.Configure the below by adding the SFTP details to schedule a report to SFTP location
- defaultReportFtpConfig.protocol=sftp
defaultReportFtpConfig.server=sftp8.sapsf.com
defaultReportFtpConfig.port=22
defaultReportFtpConfig.path=******
defaultReportFtpConfig.userID=******
defaultReportFtpConfig.password=**********
defaultReportFtpConfig.timeout=60000
defaultReportFtpConfig.enablePassiveMode=true
3. Navigate to learning administration > reports
4. Open a report and Schedule the job by selecting any filters
5. Set the Report destination to Remote file and Schedule the job at your desired time
5. Schedule the same report to the SFTP again with different filters and different time.
Cause
As per the current system design, Multiple reports will not be placed in SFTP for the same report scheduled with different filters. Instead the report will be overridden with latest schedule data
Resolution
Once the first schedule of the report ran, the report and the data for the filters you ran will be available in SFTP
However, If you schedule the same report (with different filters) to be run an hour after, then you will not see 2 reports in the SFTP folder (technically, that would be the expectation as although we are running the same report 2 times we are running with different filters at different times)
Instead the report that is already present in the SFTP (as a result of the first schedule) will be overridden with the latest scheduled data. Hence, you will not see 2 instances for the same report with different filters data.
That is first schedule data will be lost and will be replaced by latest schedule data.
This is as per the current system design.
Unfortunately, we cannot schedule the same report with different filters to different folders in the SFTP as well
Hence, you would need to make sure to download the first schedule report job data or configure third party Integration jobs to pick this file before the next schedule runs as the data will get overriden with next schedule data and first schedule data will be lost if you don't download it.
Keywords
reports, recurring jobs, schedule, multiple schedules , KBA , LOD-SF-LMS-REP , Reporting Data , Problem