pystatuswork not getting updated

General
,
1

Hi , I am having the requirement like after some time i need to clear the cases in the queue .

fetching all the records , open & using the either pxforcecaseclose or pxchangestage in activity ,

But the status not getting updated in case instances ( for the particular case ) .

however it is getting updated at Audit logs and Reports (using RD to fetch records .) .

problem with updating the status in instances of the cases .

we have the same code in other environment , that is working fine and updating the status in clipboard , case instances , audit logs etc . .

I refer all the post in community . it doesn’t work for me .

can somebody please suggest .

Thanks in advance .

2

@KRISHKY Please trace the process and validate any lock acquired to the case.

3

@KRISHKY Resolved by Own .

if you face this kind of issue like pystatus work not updated after resolving the case using activity .

First check if you have dupliicate case for the same pzinskey . / same pyID .

if yes , then check the constraint on db table .& check if pzinskey is added as primary key in DB .

if not added pls add that .

in my scenario what happen is , the case status not updated when i use pxforcecaseclose method in activity .

it is inserting the new duplicate record instead of updating the existing record . this is due to unavailable of primarykey in the db table .

hope it helps .

Thanks