SAP Knowledge Base Article - Public

2443149 - Error while exporting an ORD report from LMS - Online Report Designer / Learning

Symptom

Exported result of an LMS report in Online Report Designer (ORD) is truncated with the following error message:

"Error:1 The result was truncated because the number of transferred bytes reached the set limit."

Error.jpg

Environment

Online Report Designer > Live Data > Learning

Reproducing the Issue

  1. Preview the report under concern - no issues.
  2. Export the report from the preview screen.
    or
    Create a report distributor bundle and export the report.
  3. The report's ouput is truncated with the error message.
    The behaviour remains the same for CSV, XLS or XLSX output

Cause

The LMS system has a limitation defined for the asynchronouse storage (asyncStorageMaxSize) and this is defined in bytes.
The error message indicates that the amount of data the report attempted to fetch has exceeded the aformentioned limit.

Resolution

Option A:
Reduce the report's output size byr applying filters to the report.

Option B:
Increase the asyncStorageMaxSize  limit.

  1. Admin Center > Learning > Learning Administration > System Admin > System Configuration > REPORT_SYSTEM

    config1.jpg



  2. Edit the asyncStorageMaxSize value.

    config2.jpg

    We highly recommend the first option since increasing the asyncStorageMaxSize might result in latency / timeout issues while executing LMS reports in ORD.

See Also

2286760 - LMS reports are aborting

Troubleshooting Learning Fields for ORD

Keywords

Export ORD - LMS - Learning - Report is truncated - Error:1 The result was truncated because the number of transferred bytes reached the set limit , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-LMS-REP , Reporting Data , Problem

Product

SAP SuccessFactors HCM Suite all versions

Attachments

config1.jpg
config2.jpg
Error.jpg