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)

Environment

SuccessFactors Learning Management System (LMS) - All Supported Versions

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

Keywords

Custom report; PRD error; Error occurred while parsing datasets; parsing datasets; report security; domain restrictions; , KBA , LOD-SF-LMS-PRD , Plateau Report Designer , LOD-SF-LMS-REP , Reporting Data , Problem

Product

SAP SuccessFactors HCM Suite all versions