SAP Knowledge Base Article - Public

2165725 - Ad Hoc scheduled Reports failed with an Exception: Excel Too Many Rows

Symptom

When running a relevant big Ad Hoc report offline the report doesn't generate the excel file and it shows as failed via the report Schedule tab.

When you check the respective Job details from the Monitor Jobs in Provisioning you see that the below error is thrown:

Full exception:com.successfactors.jobscheduler.ScheduledJobExecutionException: com.successfactors.spreadsheetreports.app.exception.ExcelTooManyRowsException: The report you requested failed to generate. The error occurred because Excel's worksheet limit is1048576 rows of data and the query ' From ARB ' has returned 4451400 rows. If the report you are attempting to generate provides filters to narrow your report search criteria, then please generate the report again and use the filters to reduce the size of the report data returned.

Environment

  • SuccessFactors HCM Core 
  • Ad Hoc Reports Export Offline
  • Job Schedule

Reproducing the Issue

  1. From your instance select Analytics - Reporting - Ad Hoc Reports
  2. Select the desired report. In this example, the report was based on Multi Dataset report which could be run only offline and as excel format.
  3. Run the report offline
  4. Scheduled Reports tab would show the Report Name with a Failed status
  5. Using the report name, date and time you can finc the respective Job that run for this report via Provisioning -Monitor Jobs - Ad Hoc Reports Export Offline
  6. Once you identify the Job from the details you can see the following:

Full exception:com.successfactors.jobscheduler.ScheduledJobExecutionException: com.successfactors.spreadsheetreports.app.exception.ExcelTooManyRowsException: The report you requested failed to generate. The error occurred because Excel's worksheet limit is1048576 rows of data and the query ' From ARB ' has returned 4451400 rows. If the report you are attempting to generate provides filters to narrow your report search criteria, then please generate the report again and use the filters to reduce the size of the report data returned.

Cause

The system behaviour is as designed.

Resolution

The report/Job schedule fails because Excel's worksheet limit was reached as explained in the job details shown via Provisioning.

The workaround is to reduce the report data based on the Excel Limit.

The report you requested failed to generate. The error occurred because Excel's worksheet limit is 1048576 rows of data and the query ' From ARB ' has returned 4451400 rows. If the report you are attempting to generate provides filters to narrow your report search criteria, then please generate the report again and use the filters to reduce the size of the report data returned.

Keywords

KBA , excel's worksheet limit , job schedule , jobscheduler , report job , scheduled reports , report failed , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HXM Core all versions