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:
- Make sure pc_link_attachment table is owned by pegadata, if not replace the pegadata with the owner of pc_link_attachment table.
- 255 indicates 255 characher, replace it with your requirement.
Published February 21, 2017 - 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.