3649436 - Learning custom report failure (withSubQuals | org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet)

When running a Learning custom report, it fails. The following entries can be found in the error:

• Failed to prepare the query execution for the data set: withSubQuals.
• Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).

SAP SuccessFactors Learning

The “PKG_STUDENT_GET_DELM_STUD_QUAL_STAT_RMDAY” function (or similar) is being used.

The “PKG_STUDENT_GET_DELM_STUD_QUAL_STAT_RMDAY” function is not supported, as it can lead to performance issues. This, along with associated data and configurations factors, can result in report failures when running in Learning. It is recommended to use the “PV_DELM_STUD_QUAL_STAT_RMDAY” view as an alternative in the "rptdesign" file.

For additional support with Learning custom report development, please contact the SAP Professional Services team (as per KBA 2149831).

• KBA 2379690 - Custom Report Development and Support - SAP SuccessFactors Learning
• KBA 2149831 - SAP Professional Services / SAP Certified Partner / SAP Account Management Team [SuccessFactors Cloud]
• SAP SuccessFactors Learning Custom Report Exchange

lms, learning, custom, report, fails, failure, error, exception, problem, run, running, schedule, process, failed to prepare the query execution for the data set: withSubQuals, withSubQuals, failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet), org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet, code, query , KBA , LOD-SF-LMS-CRI , Custom Report Issues , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-REP , Reporting Data , Problem