Support Article

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

SA-33914

Summary



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.

Resolution



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.