SAP Knowledge Base Article - Public

2472225 - Errors when attempting to Modify or Preview Standard report in PRD (ORA-00942)

Symptom

Errors when attempting to Modify or Preview Standard report in Plateau Report Designer (PRD) / BIRT

Environment

SAP SuccessFactors Learning Management System (LMS)

Reproducing the Issue

  1. Export an LMS standard report (out of box)
  2. Attempt to open the report in the PRD and preview or modify the query
  3. Note these errors are produced:
  4. Error when attempting to Modify:
    1. org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot get the result set metadata.
    2.     org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
    3. SQL error #1:java.sql.SQLException: java.sql.SQLException: ORA-00942: table or view does not exist 
  5. Error when attempting to Preview:
    1. Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
    2. Failed to prepare the query execution for the data set: reg_details
    3. Cannot get the result set metadata.
    4.     org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
    5. SQL error #1:java.sql.SQLException: java.sql.SQLException: ORA-00942: table or view does not exist 

Cause

This issue may be caused by data sets in the report that by default are not readily accessible

Resolution

Please create a Support case for support to investigate further

Keywords

SF SuccessFactors LMS Learning Management System PRD Plateau Report Designer BIRT modify preview edit change view SQL error exception Cannot get the result set metadata ORA-00942 table or view does not exist COSD-15205 , KBA , LOD-SF-LMS-REP , Reporting Data , Problem

Product

SAP SuccessFactors Learning all versions