SAP Knowledge Base Article - Public

2660097 - Report error ORA-00942


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. 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


SAP SuccessFactors Learning Management System (LMS)

Reproducing the Issue

Run custom report and receive both symptom output issues.


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


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


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 case can be opened providing Operations request referencing internal memo to resolve.


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


SAP SuccessFactors Learning all versions