2330747 - Custom report input error: Error occured while parsing datasets

When importing a custom report to LMS, the following error is generated:

Please report the following error to your system administrator:

com.plateausystems.elms.util.helper.ElmsFinderException: Error occurred while parsing datasets:
at com.plateausystems.elms.bo.customreport.impl.CustomReportServiceImpl.getReportDatasetVOX(CustomReportServiceImpl.java:1664)
at com.plateausystems.elms.bo.customreport.impl.CustomReportServiceImpl.getReportEntityVOs(CustomReportServiceImpl.java:2259)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

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

When a custom report is being imported, security for the report must be declared within the data set. If this is defined incorrectly then the error is generated. For example, the security for this report is based on PA_CPNT_EVTHST table.

So when the report is imported into LMS, the error is generated

The issue here is in relation to security settings of the table referenced within the query. In this case the PA_CPNT_EVTHST does not have a DMN_ID value.

See section 3.2 of KBA 2320765 for further details in relation to Domain Restrictions and how to use them within custom reports.

For our example, when you update the dataset and change the security to the PA_STUDENT table, no error is generated and the report imports as expected.

The security for the the report is therefore based on User table.

Custom report; PRD error; Error occurred while parsing datasets; parsing datasets; report security; domain restrictions; , KBA , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , LOD-SF-LMS-REP , Reporting Data , Problem