Symptom
Report Distributor bundle created on LMS ORD report fails with status "Runtime Failure".
Error Message:
Encountered a problem while processing EMAIL 7. Timestamp: "<time stamp>". Detail : User does not have sufficient permission to view this query. User cannot run report on "426" for oqtLMS. User modules = 431,433,430,432
Environment
SAP SuccessFactors HCM Suite
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
- Online Report Designer
Reproducing the Issue
- Login to instance
- Navigate to Report Distributor
- Run the bundle
- Check bundle's status in 'Job Status'
- Bundle fails with status "Runtime Failure"
Cause
As the error message states Encountered a problem while processing EMAIL 7. Timestamp: "<time stamp>". Detail : User does not have sufficient permission to view this query. User cannot run report on "426" for oqtLMS. User modules = 431,433,430,432, the issue here is missing RBP Permission of the 7th user listed in Recipients list.
Resolution
You would have to provide permission to the domain which is mentioned in the message User cannot run report on "###" as per Learning permissions for ORD
And the domain names, with reference to their IDs are below:
404 AdhocUserCurriculumItemStatus
406 AdhocUserLearningItem
423 AdhocItemEvaluation
424 AdhocItemCostAndOrderInformation
425 AdhocScheduledOfferingRegistration
426 AdhocItemProgress
430 AdhocCurriculumItemStatusUser
431 AdhocItemProgressUser
432 AdhocLearningItemAssignmentAndHistoryUser
433 AdhocScheduledOfferingRegistrationUser
434 AdhocProgramData
See Also
Internal Note : SAP Internal employees, please refer to Internal Memo for more details.
Keywords
LMS, ORD, Report, distributor, bundle, runtime, run, time, failure, user, cannot, permission, permissions, legacy , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-RDT , Report Distributor (Advanced Reporting, ORD) , Problem