Support Article
302 DB error - invalid character or exceeding length exception
SA-63541
Summary
When the browser setting is Fr_CA, auto notes are updated in French. These notes are saved as a Notes attachment to the case. This works when the notes are saved in English. However, it fails for notes in French which contains special characters (such as é).
Error Messages
Error in Tracer:
302 DB error - invalid character or exceeding length exception
Steps to Reproduce
- Create a new activity rule.
- Set the Notes values on the Note page as below,
a) Update Pages and Classes for the Note = Data-WorkAttach-Note page.
b) Set the Note.pyNote = CEE Contrat de crédit pour entrepris. - Invoke the out-of-the-box pzSaveQuickNote activity.
- Run this with a Trace. It fails in the out-of-the-box Work-.AttachNote activity in Step 7.
Root Cause
A defect in Pegasystems’ code or rules.
The pzSaveQuickNote activity truncated the value that is saved such that it did not exceed the 64 byte column length of the pyLabel property in the database. This is performed before the string is encoded to bytes for storage. If the truncated value contained multi-byte characters (such as é), the encoded string value exceeded the 64 byte column length. The truncation must take into account the encoded length and not the raw string length.
Resolution
Apply HFix-46648.
Published February 28, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.