SAP Knowledge Base Article - Public

2356785 - TREX-ERROR (1987): invalid hexadecimal data detected in query table on column UUID

Symptom

When you try to load a report face XYZ, the following error message might comes up:

 TREX-ERROR (1987): invalid hexadecimal data detected in query table on column UUID

Reproducing the Issue

  1. Go to Business Analytics
  2. Go to Design Reports
  3. Search for the report XYZ
  4. Open the report XYZ

The report throws the aforementioned Trex error: TREX-ERROR (1987)

Cause

You should have set the Hierarchy and Result row for one same characteristic (e.g. Sales Unit). This will result in error in the calculation view.

If hierarchy is set the key figures are aggregated at parent level anyway, so you need to remove the result row settings on this field to avoid the error.

Resolution

  1. Open the report XYZ;
  2. Select the view XYZ_View;
  3. Click on Settings button → Characteristics → for the particular field;
  4. Switch the Result Row value to Do Not Show;
  5. Save the Report View in order to preserv the changes. 

Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement

Product

SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Hybris Cloud for Customer 1708 ; SAP Hybris Cloud for Customer 1711