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

ORA-12899 error on inserting attachments in PC_LINK_ATTACHMENT

SA-49224

Summary



ORA-12899 error occurs when inserting attachments in the PC_LINK_ATTACHMENT table.


Error Messages



Step Status FAIL
Step Status Info ** ORA-12899: value too large for column "<SCHEMA>"."PC_LINK_ATTACHMENT"."PYMEMO" (actual: 90, maximum: 64)



Steps to Reproduce

  1. Set up an email listener to create a case from an email.
  2. Use the out-of-the-box AddAttachmentFromMail activity in the 'Work-' class and Pega-ProcessEngine:07-10-01 ruleset to add attachments from the email.
  3. Send the email with attachments with multi-byte characters and name length greater than 64 bytes.


Root Cause



The attachment name included multi-byte characters and the name size was greater than 64 characters or bytes. Hence, the database was unable to insert the attachment name in PC_LINK_ATTACHMENT table.


Resolution



Perform either of the below local-changes:
  • Limit the length of the string to fit in the current column or expand the column size to allow for the largest anticipated string.
  • Save As the AddAttachmentFromMail activity and write custom logic to truncate the attachment name to fit into current column.

​​​​​​​
Suggest Edit

Published March 9, 2018 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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