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
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"
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.
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.
LMS, SAP, PRD, report, standard, plateau report designer, identifier is too long, Error happened while running the report , KBA , LOD-SF-LMS-PRD , Plateau Report Designer , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS , SuccessFactors Learning , Problem