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


  1. Create a work object with a text field containing several megabyte of data.
  2. Save that item to the database.
  3. Review the size of the object in the database.
  4. Create an activity that opens the work object using the Obj-Open-By-Handle method.
  5. Use the Property-Set method to replace the large data with smaller data.
  6. Use the Obj-Save method with Write now selected.
  7. 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 May 26, 2017 - Updated June 14, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.