SAP Knowledge Base Article - Public

2648522 - Error Message Occurred When Running Person and Employment Info (as of Date) Report

Symptom

  • You would receive an application error when running Person and Employment Info (as of Date) report  Online and Offline (Export or download).
  • The application error id would be accompanied by the fingerprint id = 9e0aafead962313f319b06882ba307e3ec0251e0

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 Employee Central -Ad-hoc reports

Reproducing the Issue

  1. Go to Adhoc report 
  2. Select Sub- Domain Person and Employment Info (as of Date) Report
  3. Create report
  4. Save 
  5. Run report  Online and Offline (Export or download)
  6. Result: errorId=b190ad5e-141e-4dee-a6f8-edb5873c6b7c, fingerprint=97214ccd98f20c6be17730981c5c81b792e0fea2, timestamp=2019-05-29T21:42:07.068-0400)

Cause

  • This is a known issue with the EC Ad Hoc domain in Ad Hoc wherein the maximum join depth limit is being reached when the HANA database runs a query.
  • The report has columns from multiple country-specific Job Information and Personal Information tables.

Resolution

  • The report query becomes too large for the system to execute as it involves multiple countries. Ideally, fields from only 2 countries’ Job Information should be included in one adhoc report. However, the number of countries depends on the volume of data.
  • Customer Action:
  1. AS Customer do not have access to Provisioning, Please contact Employee Central Support Engineer Team.
  2. Open an case with component: LOD-SF-EC-REP
  • Employee Central Support Engineer Team Action:
  1. Please refer to Internal Meno 
  2. Go Provisioning
  3. Company Settings
  4. Check if the following feature was enabled: Enable Cell Level Permissions on "Group by Reports" [Can be used for demo, not ready for production]
  5. Disable the feature and use switch instead : Enable Cell Level Permissions on "Group by Reports V2" [Demoable, Not Ready for Production]
  • Please see the following KBA for more information on this feature: 2080162 - Employee Central: Ad Hoc Report Types Explained

Keywords

ECT-89279,  Person and Employment Info (as of Date) report, fingerprint=9e0aafead962313f319b06882ba307e3ec0251e0, 9e0aafead962313f319b06882ba307e3ec0251e0, Adhoc report, cross domain, ECT-99304, Maximum, trimming, AYT-24278, group by reports v2, provisioning switch, Enable Cell Level Permissions on "Group by Reports" [Can be used for demo, not ready for production], SQL internal parse tree depth exceeds its maximum: join depth exceeds its maximum: , KBA , person and employment info (as of date) , enable cell level permissions , group by reports , cross domain , internal parse tree depth exceeds , join depth exceeds its maximum , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM suite all versions