2271675 - Advanced Reporting - No primary table defined - Metadata reload failure

When you try to run a report based on an Employee Central (Advanced Reporting) you get random errors.

When you try to validate the report from the Realms table, in this example, you get the error No primary table defined: TIMEOFF_TimeAccount as per below.

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

SAP SuccessFactors HCM Core

1. Login to the desired instance
2. Reporting
3. Try to run the desired report (Advanced Report) and random errors occurs. For example, Application error: An Error occurred in processing your request
4. Try to validate the report and the below messages are shown from the Realms Table
   • No primary table defined: TIMEOFF_EmployeeTime.
   • No primary table defined: EMPLOYMENT_VIEW_MERGE_EMP_JOB_INFO_T_GLOBAL.
   • No primary table defined: PERSON_VIEW_MERGE_EMP_PERSONAL_INFO_T.
   • No primary table defined: BENEFIT_BenefitEmployeeClaim.

Note: From the Logs, via the Backend tools, we could see some errors which led to the full metadata refresh Failed.

These errors indicate that a table used in the report template is not found in the target instance. The validator may be unable to find a table due to it not existing in the instance or simply having a different label in the instance configuration.

A missing table can also have the flow on effect of causing missing columns so these errors are often seen together and accompanied by other validation errors relating to joins and columns.

It could also mean that data was not replicated correctly.

The resolution for this issue requires a metadata refresh from the backend. This action can only be performed by the Support team. Therefore, please open a case with Support and provide the relevant details for investigation.

Note for Support: Please refer to the internal memo.

Standard, Report Failed, No primary table defined, Advanced Reporting Validation,  Application error: An Error occurred in processing your request thennan_ecstd_report_validate

, KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

SAP SuccessFactors HCM Core all versions