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 ?
@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?
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.
@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)
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.
@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?
