Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

302 DB error - invalid character or exceeding length exception



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

  1. Create a new activity rule.
  2. 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.
  3. Invoke the out-of-the-box pzSaveQuickNote activity.
  4. 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.


Apply HFix-46648.


Published February 28, 2019 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us