Discussion
Apple India Pvt Ltd
IN
Last activity: 4 Oct 2018 11:08 EDT
A commit cannot be performed because a deferred save of instance
Hi Can anyone help me,
I am new to pega, and working on Pega 5.5, When I am trying to Update the status while executing mannually I am getting below error, please help me to find the proper solution for this.
Error Message: A commit cannot be performed because a deferred save of instance WESFARMERS-INS-WORK-POLICY-PERS-MOTOR CMOF12326476 failed: code: SQLState: Message:
Thanks
Bala Gangadhar P
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Coforge DPA
GB
HI ,
Ideally , this can be because the lock on work object is not held while you are trying to save the work object.
Make sure you acquire the lock before updating and save.
Hope this helps.
Regards
Coforge
AU
There can be other scenario where you might be realising the lock ( using commit method) before this commit actullay happens. Like Bhavya said, to get the lock you can try using the method 'Obj-refresh and Lock" before commit step.
Pegasystems Inc.
US
Hello!
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s available on the top right pane of this page. Once created, please reply back here with the URL of the new post.
We have also sent you a private message opening up a communication channel in case you have any further questions.
Thanks,
Pegasystems Inc.
US
Hi B.,
Please use the OOTB "UpdateStatus" Activity to change the Status of the Work Item, Work Object, or Case.
Regards,
Henry
Pega Academy
Optum
IN
Hi
There is another scenario which results this exception.
1. Try to do Obj-Save (without commit) on a page which has errors(this will results an exception )
2. After that , clear the error
3. during the next commit operation , the Exception "Error Message: A commit cannot be performed because a deferred save of instance WESFARMERS-INS-WORK-POLICY-PERS-MOTOR CMOF12326476 failed: code: SQLState: Message:" will be triggered (because during this commit, the failed Save which was present in the differed list is also attempting to get committed resulting an error).
Apple India Pvt Ltd
IN
Guys,
There you need to verify below scenarioes when you are getting this error.
1. Verify your Access Role having access to that class to save/update/delete previliege or not
2. Test connectivity on your class and save it then it may fix.
3. If everything is fine then just check weather your work object aquired lock or not. If not use Obj-Refresh-And-Lock method in your activity.
4. If above also failing then delete above (step 3) and restart the instance and try perform the action.
In my scenario is not able to save because my work object is not aquired lock.
Regards,
Bala Gangadhar Patuvardhanam