2533497 - LMS : User Exam Data Report Error

Symptom

User Exam Data Report fails with the error below

Table questionDetail:

+ 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-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at "XYZ_PROD_TMS.PKG_EXAM", line 851
ORA-06512: at "XYZ_PROD_TMS.PKG_EXAM", line 598
ORA-06512: at "XYZ_PROD_TMS.PKG_EXAM", line 639
ORA-06512: at "XYZ_PROD_TMS.PKG_EXAM", line 948

java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at "XYZ_PROD_TMS.PKG_EXAM", line 851
ORA-06512: at "XYZ_PROD_TMS.PKG_EXAM", line 598
ORA-06512: at "XYZ_PROD_TMS.PKG_EXAM", line 639
ORA-06512: at "XYZ_PROD_TMS.PKG_EXAM", line 948

Environment

SuccessFactors LMS
Learning Management System

Cause

This Error happens due to some questions whose question data exceeds the allowed size limit (4000 bytes).

While creating questions, if you copy and paste the text from Rich Text Editor (for example, Microsoft Word), all the metadata will also be copied. This means there will too many extra text like tags which will also be copied. Below you can see how much data is copied in the background when you copy a text as small as "HI"

Text You See - HI

Text That gets copied:
<font face="Verdana" size="3"><span style="LINE-HEIGHT: 115%; LETTER-SPACING: 0.2pt; FONT-FAMILY: "Verdana", "sans-serif"; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Arial; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-weight: bold">H</span><span style="LINE-HEIGHT: 115%; LETTER-SPACING: 0.1pt; FONT-FAMILY: "Verdana", "sans-serif"; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Arial; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA; mso-bidi-font-weight: bold">I</span></font>

Whenever you copy the text, please make sure to copy it to a simple text editor like Notepad. Then copy from the Notepad and then paste in the application. This will eliminate all the additional tags. (please note that it will also remove the customizations such as font color, bold, italics, etc. You can make these changes within the application)

Resolution

Keywords

User Exam Data Report, UserExamData, PKG_EXAM , KBA , LOD-SF-LMS-REP , Reporting Data , Problem

Product

SAP SuccessFactors Learning all versions