SAP Knowledge Base Article - Public

2601509 - TREX-ERROR in Report

Symptom

When running a report you get the following error message:

TREX-ERROR (2626): executor timeout/[Request Info: Object Name = "HANADB".".c003:1fs:jdx_fsp_pro_cpel_edis", FM Name = TREX_DBS_SEARCH_CELL_TABLE]

Environment

  • SAP Business ByDesign
  • SAP Hybris Cloud for Customer

Reproducing the Issue

  1. Open the required report from the respective work center.
  2. Enter the selection parameters.
  3. Click on Go.

You will get the above error. In some scenarios, you will also get this error without any selection parameters or on opening the report.

Cause

This error is usually caused by too much data in this report.

Resolution

There are several actions possible to reduce the data volume:

  1. Enter additional selection parameters. For example, if you are requesting data for a whole year, reduce it to 6 months, or monthly.
  2. If it is a custom report, change the report and / or data source design to enable a better peformance. Please check the KBA mentioned below.

See Also

2366796 - Best Practices for Modelling Data Sources and Reports - Performance

2393253 - Performance in HCM reports  (ByDesign only)

Keywords

time out, TREX, data volume, huge data, reporting , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions