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

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

SAP SuccessFactors Learning Management System (LMS)

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 

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

Please create a Support case for support to investigate further

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