SAP Knowledge Base Article - Public

3451138 - Scheduled same report to SFTP multiple times with different filters, however in SFTP customer could only see one report

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

Product

SAP SuccessFactors Learning 2311