2633497 - Error when trying to preview results for standart report on PRD

Symptom

The customer has imported a standard report from LMS on PRD and gets the following error when trying to preview results:

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: ORA-00972: identifier is too long

Environment

SAP SuccessFactors Learning Management Systems (LMS)

Reproducing the Issue

Open the latest version of PRD;
Open the Report Zip;
After loading the file, double-click one of the Data Sets from the report;
Go to preview results;
After a few minutes the system will show the message: Error happened while running the report;
Click on Details to check the full error message;
Search for Caused by to check the error details and look for the message "ORA-00972: identifier is too long"

Cause

The result of the report query that PRD is trying to return is too large and there is a limitation on the waiting time for the request to complete from the VJDBC connection.

Resolution

While customizing and testing the report from PRD, the customer will need to limit the data that is being returned, and once the report is ready to be imported to the instance, the limit can be removed.

You can limit the query results by running the report for a couple of users/curriculas/items for example.

If you need assistance to modify the query, please contact your CSM/CEE to engage Professional Services Team, refer to KBA 2379690 for more information.

Keywords

LMS, SAP, PRD, report, standard, plateau report designer, identifier is too long, Error happened while running the report , KBA , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-REP , Reporting Data , Problem

Product

SAP SuccessFactors Learning all versions