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

Environment

Business By Design
Cloud for Customer

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. 

   Note : This you need to check for each characteristic which is added to the same report view.

Keywords

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

Product

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