When editing an Advanced report the following error message is observed "Error has occurred in generating query results" when editing existing ODS Canvas reports
- 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.
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.
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.
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-ADV , Advanced Reporting (ODS) , Problem