Symptom
When running a custom report one of the following is received:
-
When output is HTML
- 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 - When output is CSV
- 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 case 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 , Learning Management System , Problem