Support Article

PC link attachment table in Pega 7 has more columns than in 6



PYMEMO is newly exposed in Pega 7 and accepting only 64 characters, in the application it is sending more characters and SQL insertion is getting failed.

Error Messages

SQL insertion failed

Steps to Reproduce

adding an entry in pc link attachment table with pymemo more than 64 characters

Root Cause

DB column size was 64 Chars. So it was not accepting 250 Charc.


Alter table pegadata.pc_link_attachment modify pymemo varchar2(255);
Before executing the query, kindly verify and update query as per your setup:
  1. Make sure pc_link_attachment table is owned by pegadata, if not replace the pegadata with the owner of pc_link_attachment table.
  2. 255 indicates 255 characher, replace it with your requirement.

Published February 19, 2017 - Updated February 21, 2017

Have a question? Get answers now.

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