2660097 - Custom report error: ORA-00942

When running a custom report one of the following error 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

SAP SuccessFactors Learning

Run custom report and receive both symptom's output issues.

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

Adjust particular custom report to not include aliasing of known table prefixes or column names. For example, the following error can be seen "The following items have errors: Table learningHistory:+ Column binding "ACTIVE_99" has referred to a data set column "ACTIVE_99" which does not exist."

-OR-

In case a multitude of these reports were designed this way, they were already working as business model and have same report design working in other environments, a Support case can be opened providing Operations request referencing internal memo to further analysis.

lms, learning, sf, successfactors, ucp, flag, alias, rebuild, birt, schema, grant, permissions, security, access, ORA, DenableUnifiedConnectionPooling, reporting, report, custom, blank , KBA , LOD-SF-LMS-CRI , Custom Report Issues , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-REP , Reporting Data , Problem