SAP Knowledge Base Article - Public

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

Reproducing the Issue

  1. For example, export the User Item History Audit Report (CSV) report from LMS and open within the Plateau Report Designer.
  2. Set the proper credentials within the data source being used.
  3. Open the data set and select the preview tab. Error is generated.

Cause

There is a date/time value within a date field/column which is not support within the jdbc driver.

Resolution

To correct this you will need to open the SQL within the data set, identify the date column in question and replace it with the line below which should correct the problem.

to_char(<date column in question>,'DD-MON-YYYY HH24:MI:SS') as CREATED_DATE

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 , Plateau Report Designer , Problem

Product

SAP SuccessFactors Learning all versions