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