Question
Evonsys
IN
Last activity: 7 Oct 2021 4:15 EDT
pystatuswork not getting updated
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 .
Accepted Solution
Updated: 7 Oct 2021 4:15 EDT
Evonsys
IN
@GopalakrishnanIyyavu 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
TATA Consultancy Services
IN
@GopalakrishnanIyyavu Please trace the process and validate any lock acquired to the case.
Accepted Solution
Updated: 7 Oct 2021 4:15 EDT
Evonsys
IN
@GopalakrishnanIyyavu 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