'UTF8->UCS2 conversion failed for bind number 21798159' Error Running Enrollment Verification in Canadian French When Student has a Degree

Last updated on MARCH 08, 2018

Applies to:

Symptoms

On : 9.2 version, Student Records Enrollment Verification report

The following error occurs when running the Enrollment Verification in Canadian French when the student has been awarded a degree.

ERROR
-----------------------
Application Program Failed
 Action Type : SQL UPDATE
 In Pgm Section : SQLRT: PROCESS-SETUP(BIND)
 With Return Code: 09976
 Error Message : UTF8->UCS2 conversion failed for bind number 21798159
 Stored Stmt : SRCCENVR_I_ENRLVER
 SQL Statement : INSERT INTO PS_ENRL_VER_RQ_PRT ( EMPLID, ENRL_VER_SEQ, ENRL_
  VER_LINE_NBR, PRINT_HEADER, DETAIL_PRINT_CODE, ENRL_VER_DATA
  ) VALUES (:1, :2, :3, :4, :5, :6)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Records and Enrollment > Enrollment Reporting > Enrollment Verification while logged in using Canadian French language.
2. Search for a student who has a diploma.
3. Attempt to produce the Enrollment Verification.

Changes

 Issue appears to only affect Oracle database.

Cause