Symptom
User Exam Data Report fails with the error below
Table questionDetail:
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 smallORA-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