SAP Knowledge Base Article - Public

2596953 - Unable to generate Matrix Grid Report

Symptom

A Gateway Timeout or 900-001-06 error or DAOException error are thrown when generating the Matrix Grid Report.

"Your request has not been processed successfully. Please try again.
If the problem persists, please contact client support and provide the event code and the server timestamp below."

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors Succession Management
  • SAP SuccessFactors Matrix Grid Report

Reproducing the Issue

  1. Go to Succession > Matrix Grid Report (Performance-Potential or How vs. What);
  2. Select the necessary filters > Generate the report;
  3. Report keeps on loading:

matrix1.png

  1. After awhile, an error message is displayed:

matrix2.png

or

MXG_Error.png

Cause

This gateway timeout error may be related to unsupported matrix grid filters configured in your data model.

Resolution

Matrix Grid Reports support only a set of fields as filters. When configuring an unsupported field, as filter, the system does not complete the processing of the page and throws an error. In some cases, the error page does not display and, instead, the report simply retrieves no users. This happens for some unsupported fields such as "username" and "gender". The cause and resolution still apply to this case.

For complete information on the supported filters in Matrix Grid Report, you can access the wiki page "Matrix Grid Reports - Custom Filters".

To avoid this error, it is necessary to remove the unsupported filters configuration from the XML code of your instance. To complete tasks in Provisioning, contact your Implementation Partner. If you are no longer working with an Implementation Partner, contact SAP Cloud Support, opening an case under component "LOD-SF-SCM-MXG" (Matrix Grid Report).

Partners and Cloud Support Only

  1. Go to Provisioning > Import/Export Data Model;
  2. Export file > Submit;
  3. Verify if unsupported fields are configured as filter (matrix-filter="true");
  4. Modify the data model, to remove these filters;
  5. Save the XML file;
  6. Import the modified file in Import/Export Data Model > Import File > Choose File > Submit.

Code example of how unsupported fields must be configured:

<standard-element id="empId" max-length="255" required="false" matrix-filter="false">
<label>Emp Id</label>
</standard-element>

Keywords

matrix report, matrix filter, gateway timeout, error, 9-box, 9box, 9 box, MXG, supported filters, unsupported, error message, application issue, dao, exception, error, DAOException, Caught, Exception , KBA , LOD-SF-SCM-MXG , Matrix Grid Reports (9 Box) , Problem

Product

SAP SuccessFactors Succession & Development all versions