SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

SAP SuccessFactors Learning

Cause

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.

incorrect dataset.JPG

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

error.JPG

Resolution

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.

correct dataset.JPG

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

works.png

Keywords

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

Product

SAP SuccessFactors Learning all versions