Issue with BLOB
We are having an issue with a property that is being saved only in the exposed column but not in BLOB ,so when a case is opened then it shows blank value because BLOB data is copied to exposed column.
Observation :- An utility sets this property value gets triggered on post submission of a flow action and earlier case worker used to perform this action which advance the flow and set this value then it's working but recently this action is being performed in batch requestor/API context using svcperformFlowAction which advance the flow then we started seeing this behaviour , when we trace it out everything looks fine like SQL merge statement , i see the save and commitment are happening through OOTB rules (RecalcuateAndSave and commitwitherrorHandling) .
I tried with optimization again on this property,tested the class connectivity and restarting the server but still issue remain as is .
The value is present in expose column but not in the blob . Is there way to identify/resolve the issue ?
Accepted Solution
Updated: 28 Feb 2024 7:15 EST
Skandiabanken
SE
@jmartt we had to create incident# INC-A6200.. it's not been concluded with accurate root cause as per the reported issue but we had workaround for this as part of this SR.
Basically this problem is happening , when we have a property name and flow name are same ,internal pega code is removing the properties from blob while it's saving , in our case it was easy to rename the flow name instead of property name to solve the issue.
In our case , this problem is happening only when the flow is being resumed through svcPerformFlowAction by agents..( not in the context of browser requestor)
Bits in Glass
IN
@BRAHMESH@ Usually case date gets stored into blob and optimized column. But in your case data going into only optimized column not blob. And the column itself is not there in blob. Is my understanding correct?
Skandiabanken
SE
@Anoop Krishna Yes.. data is only in optimized column not in blob.
NCS Pte. Ltd
SG
Hi @BRAHMESH@: I noticed in your SQL to read from BLOB, you are passing dynamic values to the second and third parameter of pr_read_from_stream function. Can you please help to make it static. Your SQL should be something like below.
select pr_read_from_stream('CreditDecision',pzInsKey,pzPvStream) from table name.
Please see this too.
Thanks.
Skandiabanken
SE
@ArulDevan Same results even tried with suggested query format
The issue we are having is , the mentioned column data is storing only in exposed column and not in the BLOB.
Pegasystems Inc.
CA
@BRAHMESH@ can you please check with UpdateWorkObject OOTB activity rule to save the information instead of Recalculate and Save? What information is stored in the clipboard? I hope it's empty. can you please confirm?
Accepted Solution
Updated: 28 Feb 2024 7:15 EST
Skandiabanken
SE
@jmartt we had to create incident# INC-A6200.. it's not been concluded with accurate root cause as per the reported issue but we had workaround for this as part of this SR.
Basically this problem is happening , when we have a property name and flow name are same ,internal pega code is removing the properties from blob while it's saving , in our case it was easy to rename the flow name instead of property name to solve the issue.
In our case , this problem is happening only when the flow is being resumed through svcPerformFlowAction by agents..( not in the context of browser requestor)
PT Bank Sinarmas Tbk
ID
Hi @BRAHMESH@, We are facing the same issue. But after checking, we don't have the same property and flow name. Is there another root cause? Thank you.