SAP Knowledge Base Article - Public

2440576 - "SQL statement does not return a ResultSet object" report error generated.

Symptom

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

When generating a report, the following text appears at the bottom of a HTML report.

Table studqual-includesubqual:
 + 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-29531: no method legacyGetNewDate in class TimezoneUtil
 ORA-06512: at "<CUSTOMER_SCHEMA_NAME>.PKG_TOOL", line 888
 ORA-06512: at "<CUSTOMER_SCHEMA_NAME>.PKG_STUDENT", line 4640
 ORA-06512: at line 1

  ;
     java.sql.SQLException: ORA-29531: no method legacyGetNewDate in class TimezoneUtil
 ORA-06512: at "<CUSTOMER_SCHEMA_NAME>.PKG_TOOL", line 888
 ORA-06512: at "<CUSTOMER_SCHEMA_NAME>.PKG_STUDENT", line 4640
 ORA-06512: at line 1

Environment

SuccessFactors Learning Management System (LMS) - All Supported Versions

Cause

There is an issue with a database packge which needs to be resolved by Operations team.

User Learning Collection Status Group.jpg

Resolution

Create an incident and a Operations ticket will be create by the CS team to requesting them to resolve the error.

Keywords

Table studqual-includesubqual; SQL statement does not return a ResultSet object; ORA-29531; ORA-29531; no method legacyGetNewDate in class TimezoneUtil; , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-DB , DB Data & Services , Problem

Product

SAP SuccessFactors Learning all versions