SAP Knowledge Base Article - Public

2839650 - Reports received by email when scheduled through Report Distributor Tool doesn't contain data

Symptom

  • Reports received by email using Report Distributor Tool doesn't contain any data
  • Reports give output  without any issues when run online/offline from Report Center 

Environment

 SAP SuccessFactors HCM Suite

Reproducing the Issue

  1. Navigate to Report Center
  2. Click View Schedules --> Switch to legacy Report Distributor tool 
  3. Schedule Reports by choosing Destination as Email 
  4. Select Email Recipients
  5. Click Run Report Distributor
  6. In the email which you have received file contains below mentioned error

[Report query or data access restrictions prevent the viewing of this component]
No data can be shown for this request. Things to try
- access to this data may not be allowed (check role permissions)
- resubmit your request

    7. In the logs from Analytics you can see below mentioned exception

ERROR Hrml.DataObjects.OdsReporting.AdHoc.HrmlBizXRoleBasedSecurityException: Exception of type 'Hrml.DataObjects.OdsReporting.AdHoc.HrmlBizXRoleBasedSecurityException' was thrown.

Resolution

Suppose if a user has multiple entries in User Maintenance one with user name something@***.com and the other with EmployeeId_CompanyId then in email recipients of Report Distributor Tool we need to select one with EmployeeId.

Keywords

Report, Query, Data, Access, Restrictions, Prevent, Viewing, Component, No, Request, Things, Check, Role, Permissions, Resubmit, DataObjects, Hrml, OdsReporting, Adhoc, Exception, Thrown, HrmlBizXRoleBasedSecurityException , KBA , LOD-SF-ANA-RDT , Report Distributor (Advanced Reporting, ORD) , Problem

Product

SAP SuccessFactors HCM Suite all versions