SAP Knowledge Base Article - Public

2834914 - Error has occurred in generating query results when editing existing Advanced reports

Symptom

When editing an Advanced report the following error message is observed "Error has occurred in generating query results" when editing existing ODS Canvas reports

Environment

  • Advanced Reporting
  • Success Factors

Reproducing the Issue

The report is working when previewing and exporting the report output but when it is edited the following error "Error has occurred in generating query results" is seen.

When checking logs the following error is also seen

Error: System.NullReferenceException: Object reference not set to an instance of an object.

Cause

Every member that is used in queries will go through checks for permitted members in the query. As part of these checks, WFA-BizX mapping is resolved through entity metadata stored in WFA. In the case of VBM, this resolving(parsing) of the mapping is causing the issue as the metadata doesn't contain the parameters specific to the MDF field.

Resolution

Engineering have proposed that this will be resolved in the 1911 release.  The workaround is to revert VBM to Consumer Based Metadata (CBM) as In CBM, there is no mapping for the MDF field(EXTERNAL_CODE) to a BizX element. Without any mapping, the code doesn't run into any issues while parsing/resolving the metadata.

Keywords

Advanced Reporting, ODS, Error has occurred in generating query results, Object reference not set to an instance of an object. CBM, VBM , KBA , LOD-SF-ANA-ODS , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors Workforce Analytics all versions