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

pyMemo column is empty for WorkObject created before upgrade

SA-4808

Summary



Attachments created before upgrade have no pyMemo value set – pulling the records from PC_Link_attachment table shows that they're empty in the exposed column as well.

Check usage of PRPC out-of-the-box activity “Work- •ProcessAttachments”.

Prior to Pega 7, PyMemo column in pc_link_attachment table is not exposed. So, whenever an attachment is created, pyMemo gets saved in BLOB column. Upon upgraded to Pega 7.1.6, pyMemo has become exposed column. So, for the cases created before upgrade, pyMemo is present in BLOB but not in the exposed column.

Error Messages



NA

Steps to Reproduce



1) Open a dispute case created before upgrade.
2) Go to attachments & History section. Attachment name is missing.

Root Cause



pyMemo column is not exposed in lower version of PPRC, however, this has become an exposed column in PRPC 7.1. Due to this, work object created earlier has got the exposed column as empty.

Resolution



Provided Link to PDN article on column populator:


The column populator is a command-line utility that allows update of rows in PegaRULES database tables after schema changes have been made that exposes a property as a database table column.

https://pdn.pega.com/pegarules-database/how-to-use-the-column-populator-utility
Suggest Edit

Published January 31, 2016 - 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