Praveen Kumar Nandagopal (PraveenKumarN5872)
Vice President
PraveenKumarN5872 Member since 2015 1 post
Posted: August 23, 2016
Last activity: August 25, 2016
Posted: 23 Aug 2016 10:34 EDT
Last activity: 25 Aug 2016 15:59 EDT

Blob Update


  We are working on a Performance Initiative where in For a Workobject we store message log entries in a seperate table. Since these log entries are more as when the volume increases the updates to the log tables are taking longer time.To avoid this we came up with an approach of moving the log entries to a new table when the WO is resolved. We do this movement of one table to another using DB stored proceedure.


Now the issue is when SP moves the data it doesn't update the pzinskey/pxobjclass in the blob because of which when i try to open the record using obj-openby-Handle/Obj-Open it always fails.The workaround is that do the movement of data in PEGA itself but we might be doing lot of DB operations as we need to hit DB to save the record and delete the record and also we need to do Open the blob as well. This seems to be a Costlier operation.

Just wanted to Check if anyone has faced a similiar issue and anyother approach that was considered to fix the issue.


Low-Code App Development System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.