SAP Knowledge Base Article - Public

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

Environment

SAP SuccessFactors Learning Management System (LMS)

Reproducing the Issue

Run custom report and receive both symptom output issues.

Cause

Particular custom reporting is using aliasing with internal DB prefixes that exist.

Resolution

Adjust particular custom report to not include aliasing of known table prefixes or column names.

-OR-

If 1) a multitude of these reports were designed this way and 2) were already working as business model and 3) have same report design working in other environments, a Support incident can be opened providing Operations request referencing internal memo to resolve.

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 , SuccessFactors Learning , Problem

Product

SAP SuccessFactors Learning all versions