Support Article
Blob save issue after properties removed
SA-38616
Summary
A large (multiple megabytes) value was set in the text property pyWorkPage.Attachment.pyAttachmentValue.
Using a repair activity to remove the large property and save the item back to the database, updates the Clipboard. However, the BLOB column is still large.
Error Messages
Not Applicable
Steps to Reproduce
- Create a work object with a text field containing several megabyte of data.
- Save that item to the database.
- Review the size of the object in the database.
- Create an activity that opens the work object using the Obj-Open-By-Handle method.
- Use the Property-Set method to replace the large data with smaller data.
- Use the Obj-Save method with Write now selected.
- Review the size of the object in the database, and observe it has not changed.
Root Cause
A defect in Pegasystems' code prevented reclaiming the BLOB storage on save back to the database.
Resolution
Apply HFix-32989.
Published June 19, 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.