2241379 - Previewing a table in PRD generates an error but the report returns data in LMS

Symptom

When generating a report in LMS, it returns data as expected but when previewing the same report in PRD, it fails to return data. The following error is generated:

Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: 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:java.sql.SQLException: java.sql.SQLException: Unsupported JDBC-Type: -102

Environment

SuccessFactors Learning Management System (LMS) - All Supported Versions

Product

SAP SuccessFactors Learning all versions

Keywords

PRD error, Cannot get the result set metadata, org.eclipse.birt.report.data.oda.jdbc.JDBCException, SQL statement does not return a ResultSet object, java.sql.SQLException, Unsupported JDBC-Type: -102, date column, to_char , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.