SAP Knowledge Base Article - Preview

2660097 - Report error ORA-00942

Symptom

When running a custom report one of the following is received:

  1. When output is HTML
    1. Table (id = 18):
      + Cannot get the result set metadata.
      org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
      SQL error #1:ORA-00942: table or view does not exist
      ;
      java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  2. When output is CSV
    1. The report data is blank


Read more...

Environment

SAP SuccessFactors Learning Management System (LMS)

Product

SAP SuccessFactors Learning all versions

Keywords

SAP SF LMS Learning UCP flag alias rebuild birt schema grant permissions security access ORA DenableUnifiedConnectionPooling reporting , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS , Learning Management System , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.