2764031 - Learning History User-Side Report Not Returning Data and Throwing a DB Error

Learning history user side report is not returning the data and throwing the following error:

org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.

SQL error #1:SAP DBTech JDBC: [2048]: column store error: "Customer_SCHEMA"."PKG_STUDENT_GET_EMPLOYEE_REPORTING_HEIRARCHY": line 25 col 5 (at pos 1091): [2048] (range 3): column store error: search table error:  [6994] Hierarchy source data: Invalid graph topology. The following nodes are element of orphaned cycles: (0000123);

com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [2048]: column store error: "Customer_SCHEMA"."PKG_STUDENT_GET_EMPLOYEE_REPORTING_HEIRARCHY": line 25 col 5 (at pos 1091): [2048] (range 3): column store error: search table error:  [6994] Hierarchy source data: Invalid graph topology. The following nodes are element of orphaned cycles:

SAP SuccessFactors Learning Management System

1. Go to Learning > My Employees > Reports > Learning History
2. Run report and select "All Subordinates" or "All."
3. Select the rest of appropriate criteria and click Run Report 

This is due to a data issue or a result of orphaned records in the system.

Please find all the subordinates for a specific supervisor having this issue and check the primary supervisor for each subordinate.

Note: The system can't accept if you assign yourself as a supervisor to your own id. For example, supervisor id (ex:0000123) shouldn't be the same as the user's own id (ex:0000123). Each user should have valid a supervisor.

SF, success factors, LMS, Learning histroy user side report, DB error, Java error, no data, database , KBA , LOD-SF-LMS-REP , Reporting Data , Problem