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).

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP SuccessFactors Learning

The “PKG_STUDENT_GET_DELM_STUD_QUAL_STAT_RMDAY” function (or similar) is being used, and it shouldn’t be 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’s 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 team that delivers services (KBA 2149831).

• KBA 2379690 - Custom Report Development and Support - SAP SuccessFactors Learning
• SAP SuccessFactors Learning Custom Report Exchange

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-REP , Reporting Data , LOD-SF-LMS , Learning Management System , Problem