Reindexing embedded page properties inside agent activity
Hi,
Below steps are configured in an agent activity.
Obj-open by handle
Call pxchangestage (to a resolve stage)
Call RecreateIndexesForInstance
Obj-save
Commit
Work object transitions to the specified stage. A data transform specified on a connector inside the stage sets a property value inside an embedded page. Also, there is a declare index rule for that embedded page.
But we observed that changes made to the embedded page properties do not getting reflected to the database (index table).
Is there anything missing here ? Why changes made by agent are not indexed and saved to the database ?
Ernst & Young LLP
MT
Call pxchangestage (to a resolve stage) - This step is most likely causing a Commit to trigger as the case is being resolved. Commit in turn will release the lock. And, that is the possible cause of failure of RecreateIndexesForInstance step.
Can you just create a wrapper activity to open the case with lock and then call your agent activity from it, and then manually run the wrapper rule? Enable the 'Locking' event in tracer to verify if you still have the lock after pxchangestage step.
EIB
PL
@Nirmalya.SenSharmaI added a obj refresh and lock step after change stage. When I trace the activity manually, I verified that the lock still remains after change stage step. There is "already owned lock" message on tracer. Also when running it manually, reindex activity runs as it should. Changes on embedded page properties are saved and committed to the database. However, changes are not committed to the database when the agent itself runs that activity even though I don't see any difference on tracer outputs.
Synechron
US
@EngincanY Is this issue resolved, we are facing similar issue in our application.