2636960 - Error Message Occurred While Running Adhoc Report - Post 1802 release

SAP Knowledge Base Article - Public

2636960 - Error Message Occurred While Running Adhoc Report - Post 1802 release

Symptom

  • You would receive an error message when trying to Run any Adhoc Report created between B1802 release and Patch :PTCH-27663( b1802p6 (21-Apr-18))
  • The error message would be starting with: ANALYTICS_LIST_VIEW_BUILDER_SUBDOMAIN_

Environment

Employee Central - Ad Hoc Reports

Reproducing the Issue

  • Run Any Adhoc Report created after  B1802  release and before Patch :PTCH-27663( b1802p6 (21-Apr-18))
  • Result: error message starting with: ANALYTICS_LIST_VIEW_BUILDER_SUBDOMAIN_

Error Example:

  • Due to change in datamodel this report is no longer valid. Please edit and save the report again.
  • The following selected view columns are not valid.  ?ANALYTICS_LIST_VIEW_BUILDER_SUBDOMAIN_

Untitled picture.png

Cause

  • This is a known issue with B1802 release for All Adhoc Report created between B1802 release and Patch PTCH-27663
  • There was a Bug which make Logical column name to lower case.

Resolution

  • Please be advised that fix has been rolled out with Patch: PTCH-27663( b1802p6 (21-Apr-18)) on Friday 21 April 2018
  • The attributes were lower cased for GDPR permission mapping 

Solution:

  1. Go to Adhoc Report
  2. Select any Adhoc Report created after  B1802  release and before this PTCH-27663( b1802p6 (21-Apr-18))
  3. Click on Edit mode or Edit report
  4. Click Save
  5. Run again
  6. Result : No errror message

Additional information: System automatically deselects the corrupted columns

  • Go to Adhoc Report
  • Select any Adhoc Report created after B1802 release and before this PTCH-27663( b1802p6 (21-Apr-18))
  • Click on Edit mode or Edit report
  •  In edit mode, the system automatically deselects the corrupted columns.
  • Add corrupted columns again
  • Click Save
  • Run again
  • Result : No error message

 

Note: Adding the columns again will refresh the column metadata

See Also

  • 2631543 - Person and Employment Info (As of Date) Ad Hoc Report: Columns cannot be selected in Edit mode or return blank/null while executing the report - Post 1802 release
  • 2635083 - Employee Status Field is Showing Numeric Values in Ad Hoc Reporting - that covers the issue (what to look for).

Keywords

ECT-97501, ECT-97673,ANALYTICS_LIST_VIEW_BUILDER_SUBDOMAIN_, Adhoc Report, PTCH-27663,1802, error,Patch, ANALYTICS_LIST_VIEW_BUILDER_SUBDOMAIN_, Due to change in datamodel this report is no longer valid. Please edit and save the report again. , KBA , LOD-SF-EC-REP , Reporting Data , LOD-SF-EC , Employee Central , Problem

Product

SAP SuccessFactors HCM Core 1802