SAP Knowledge Base Article - Public

3727890 - Errors Commonly faced while using Plateau Report Designer (PRD) Tool

Symptom

Below are the Commonly faced errors while using Plateau Report Designer (PRD) Tool and resolution is mentioned in the KBA

Environment

SAP SuccessFactors Learning

Plateau Report Designer (PRD) Tool

Cause

Resolution

                                                                Common Errors                                                    KBA explaining the Cause and Solution

1] java.lang.IllegalStateException: Unable to acquire application service.

    Ensure that the org.eclipse.core.runtime bundle is resolved and started (see config.ini).

2805787 - java.lang.IllegalStateException Error When Launching Report Designer Tool (PRD) - SAP for Me 

2] "org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException:                         javax.net.ssl.SSLException: Received fatal alert: protocol_version" OR "Failed to load the JNI shared library ..." 

2703987 - PRD gives "Received fatal alert: protocol_version" or JNI error message - SAP for Me 

3] Caused by: com.plateau.common.reportservice.impl.ReportEngineException: parameterHandle is null:                                         task=org.eclipse.birt.report.engine.api.impl.GetParameterDefinitionTask@100e6de3                                                                   scalar=org.eclipse.birt.report.engine.api.impl.ScalarParameterDefn@23505a51.report=org.eclipse.birt.report.engine.

     api.impl.ReportRunnable@70598df3 

2399627 - 'Exception occurred while trying to fetch report' report error generated - SAP for Me
4] Could not create com.plateausystems.elms.bo.customreport.valueobject.LibraryVO record!2564508 - Error while importing Plateau Themes Library File - SAP for Me
5] org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException:                          java.net.UnknownHostException2074219 - Configure PRD to connect to a database through a proxy - SAP for Me

6] There is an error in get connection, java.sql.SQLException: sun.security.provider.certpath.SunCertPathBuilderException:

    unable to find valid certification path to requested target 

3618463 - Error happens when connecting to LMS database using Plateau Report Designer - SAP for Me

7] After a recent refresh, connecting with Plateau Report Developer (PRD) client, the connection fails with one of these errors:

  • Failed: java.sql.SQLException: java.io.IOException: Server returned HTTP response code: 500 for URL: https://<LMS-URL>/vjdbc/vjdbc
  • Error in processing user's credential!
2538866 - Plateau Report Developer connection error after Learning Instance Refresh - SAP for Me

8] org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException:

    java.io.FileNotFoundException: https://<baseURL>/vjdbc/vjdbc 

2613553 - Plateau Report Designer error 'FileNotFoundException' - SAP for Me 

9] Caused by: com.plateau.common.reportservice.impl.ReportEngineException: parameterHandle is null:                                                                    task=org.eclipse.birt.report.engine.api.impl.GetParameterDefinitionTask@6a9ff051 scalar=org.eclipse.birt.report.engine.api.impl.

ScalarParameterDefn@50261484 report=org.eclipse.birt.report.engine.api.impl.ReportRunnable@7ad9c9ea  Scalar Parameter Name is : <CUSTOM_REPORT_NAME>

2451033 - PRD error "Exception occurred while trying to read report design" when importing report - SAP for Me

10]Caused by: com.plateau.common.reportservice.impl.ReportEngineException: parameterHandle isnull:                                                                   task=org.eclipse.birt.report.engine.api.impl.GetParameterDefinitionTask@6a9ff051 scalar=org.eclipse.birt.report.engine.api.impl.

 ScalarParameterDefn@50261484 report=org.eclipse.birt.report.engine.api.impl.ReportRunnable@7ad9c9ea  Scalar Parameter   Name is : <report name>  

2281174 - Importing PRD report error - Exception occurred while trying to read report design - SAP for Me
11] Any of the following errors Listed in the below KBA may occur when trying to connect to Learning Database using PRD (Plateau Report Designer): 2531352 - Errors When Connecting to Plateau Report Designer - SAP for Me
12] Errors when attempting to Modify or Preview Standard report in Plateau Report Designer (PRD) / BIRT 2472225 - Errors when attempting to Modify or Preview Standard report in PRD (ORA-00942) - SAP for Me

13] Exception occurred while trying to fetch report with id: [ID#] [...] at com.plateausystems.elms.bo.customreport.impl.

     CustomReportServiceImpl.getReportDesignVOX [...]                                                                                                                 Causedby:com.plateau.common.reportservice.impl.ReportEngineException: parameterHandle is null 

2719250 - Learning Report Error: Exception occurred while trying to fetch report with id: [ID#] - SAP for Me

14] org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException:                          sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target 

2581167 - PRD error "unable to find valid certification path to requested target" - SAP for Me

15] Error is generated when testing connection to SuccessFactors Learning in Plateau Report Designer:

     org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException:                                                     java.net.UnknownHostException: <host name>

     OR

     org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException:                                                     java.net.SocketException:Connection reset

2104429 - 'java.net.UnknownHostException' error generated when testing connection to PRD - SAP for Me

16] After following the steps to install and configure the Plateau Report Designer (PRD), user is still not able to have a successful        connection to the Learning Management System(LMS) database.

2568009 - User not able to access PRD - SAP for Me
17] Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot get the result set metadata. 2633497 - Error when trying to preview results for standart report on PRD - SAP for Me

18] When adding the PA_CPNT_FORMULA & PA_CPNT_FORMULA_FIN_VAR tables in a query, the system throws the following              error: There is an error in get connection, java.SQL.Exception: java.io.IOException: Server returned HTTP response code:            504 FOR url: <CUSTOMER LMS URL>. 

2635356 - PRD generates a 504 error when referencing PA_CPNT_FORMULA and PA_CPNT_FORMULA_FIN_VAR - SAP for Me

19] After importing the custom report into the Plateau Report Designer tool, user unable to preview the report, as encountered          an error message:"HTTP ERROR: 500. Problem accessing /viewer/frameset. Reason: Server Error. Powered by Jetty." 

3657398 - Preview report options are not working in Plateau Report Designer tool - SAP for Me
20] Customer exported a default report from LMS but is not able to preview it results in PRD 2623219 - Receiving java.sql.SQLException: ORA-00942: table or view does not exist when runnning default report on PRD - SAP for Me
21] Unknown user error2318510 - "Unknown user" error when connecting to PRD - SAP for Me

See Also

2171592 - Process to enable the use of Plateau/Learning Report Designer (PRD) - SAP for Me

2777238 - Learning Report Designer (a.k.a. Plateau Report Designer) Setup and Troubleshooting Tips - SAP for Me

Keywords

Plateau Report Designer tool, SAP SuccessFactors Learning, LMS, Commonly faced errors , resolution KBA , KBA , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , Problem

Product

SAP SuccessFactors Learning all versions