When running or scheduling the Exam Item Analysis (CSV) report you see the window gets stuck on 'Generating - initializing' or receive a timeout.
SAP SuccessFactors Learning (LMS)
Reproducing the Issue
Run or Schedule the Exam Item Analysis (CSV) report for some specific exams and encounter symtpom.
Due to database limitation executing a specific part of the query used in this report has to be rewritten to perform without issue on some instances.
Report query to be enhanced in LRN-65351
- Run the Exam Item Analysis report instead (the non-CSV version)
- Cloud Support can reference the above LRN and internal memo of this KBA and apply a specific backend setting to help alleviate longer processing time timeout until report query code is enhanced.
sap sf success factors learning lms exam item analysis (CSV) csv report performance initializing generating timeout times out time timed node sqlparser , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-BCJ , Assign (bulk), Add/ Delete Sub/ Cur, Revise, Import , Problem