When trying to view the contents of the 'Preview Results' tab when configuring a custom report withn PRD, the following error is generated -
org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: Data Set
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.io.IOException: Server returned HTTP response code: 504 for URL: https://<customer instance>-stage.plateau.com/vjdbc/vjdbc
SuccessFactors Learning Management System (LMS) - All Supported Versions
Plateau Report Designer
The results of the report query that PRD is trying to return is too large and error is generated.
The error is being generated because there is a timeout from a server or intermediary waiting for the request to complete from the VJDBC connection.
If you are working on a report within PRD, what you need to is to add a limit to the data that is being returned. If no filters are added to the report then what PRD is trying to do is preview all data that should be returned.
As an example, you can test this by running your report in question within LMS for say a subset of three users. Now take a note of the three users, add them to the query in PRD and run it again. Instead of trying to preview the data for all users, it'll now just check for three.
HTTP response code 504; PRD; VJDBC; Preview Results; , KBA , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , LOD-SF-LMS-REP , Reporting Data , How To