PC link attachment table in Pega 7 has more columns than in 6
SummaryPYMEMO 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 MessagesSQL insertion failed
Steps to Reproduceadding an entry in pc link attachment table with pymemo more than 64 characters
Root CauseDB column size was 64 Chars. So it was not accepting 250 Charc.
ResolutionAlter 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 19, 2017 - Updated February 21, 2017