2381411 - LMS Custom reports are missing data

SAP Knowledge Base Articles - public

2381411 - LMS Custom reports are missing data


  • Custom reports are missing data in the Learning Management System (LMS)
  • The reports used to return all data
  • No changes were made and no errors are being reported via the UI


  • SAP SuccessFactors
  • Learning Management System (LMS)

Reproducing the Issue

  1. Run on demand or schedule a Custom Report to be run
  2. Parallel execution of SQL Statements is used in the report query
    • Example:
      • SELECT /*+ parallel */ customers.cust_first_name, customers.cust_last_name FROM sales, customers
  3. Returned report results do not contain all of the expected data
  4. No errors are shown in the LMS User Interface


  • The use of Parallelism can cause an overuse of server resources
  • Parallel Execution of SQL Queries may be terminated on the server side to preserve shared resources



  • It is recommended NOT to use parallel hints in your SQL
  • Remove the Parallelism from the SQL query and the report will return all expected data


SF SuccessFactors Success Factors LMS Learning Management System report reporting data rows missing not all there gone appear display incorrect result not correct parallel query execution ORA-12805 LRN-15072 Error in Server Side Logs: odaconsumer - org.eclipse.birt.data.engine.odaconsumer TMS Cannot fetch the next data row.org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot move down to next row in the result set.SQL error #1:ORA-12805: parallel query server died unexpectedly ; java.sql.SQLException: ORA-12805: parallel query server died unexpectedly , KBA , LOD-SF-LMS , SuccessFactors Learning , Problem


SAP SuccessFactors Learning 1608