Discussion

deferred commit

Commit Error: A commit cannot be performed because a deferred save of instance ***-***-***-*****-TESTCYCLE **-1413 failed: code: SQLState: Message

I get this message only on a few object upon submission.

I see this message usually for Test cycles. Could anyone kindly let me know what might be causing this error?

thanks,

**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.

Comments

Keep up to date on this post and subscribe to comments

January 8, 2009 - 12:13pm

vidyatperot wrote:

Commit Error: A commit cannot be performed because a deferred save of instance ***-***-***-*****-TESTCYCLE **-1413 failed: code: SQLState: Message

Vidy -- this sounds like a framework issue. Feel free to file an SR and I will respond there. I'd need to know the circumstances surrounding the issue.

Jon

January 22, 2009 - 5:16am

i am getting the following error
Save failed - Commit Error: A commit cannot be performed because a deferred save of instance PEGASAMPLE C-73 failed: code: SQLState: Message:
Work ID:** Save failed - Commit Error: A commit cannot be performed because a deferred save of instance PEGASAMPLE C-73 failed: code: SQLState: Message:

any clue about why this happens

January 22, 2009 - 8:35am

In general we will get this issue in these cases:
«Obj-Open unable to acquire lock on the given object
«Saving Object without acquiring lock on it

Chaitanya

January 22, 2009 - 10:20am

hi,

Work ID:** Save failed - Commit Error: A commit cannot be performed because a deferred save of instance PEGASAMPLE C-73 failed: code: SQLState: Message:

The above error comes if the lock of the workobject is held by some other user,in this error the workobject C-73 might be held by some other user.

In v54 you can see the acquired locks
View-->System->Locks-->AllLocks ,the work object C-73must be there.Here you will have the option to release the locks.

This error comes when we try to open the workobject and not saving it,
saving the workobject will release the locks.

Causes of the error:
-->you might have open the work object and trying the close the browser window.
-->you might have not used the obj-save or commit method after updating the work object.

Hope iam correct,correct me if iam wrong.

Cheers...
Suman

[:)]

January 22, 2009 - 10:23am

Thanks for your replies. The lock issue proved to be correct. Thanks a lot again.

February 13, 2013 - 3:46am
  • pyCommitError:** A commit cannot be performed because a deferred delete of instance @@@@@@@ failed: code: <none> SQLState: <none> Message: <none>

can anyone help me in this

 

February 27, 2013 - 2:10pm

I've seen this issue to be occuring in our applications for the reason that we're updating multiple work objects sequentially with deferred obj saves followed by a single commit for all those deferred obj-saves. Whenever any one of these work objects failed to save [because of some reasons which we later figured out], all the work-objects, which were following this one, failed with the same message.

 

However, a change in the requestor session helps as the deferred save doesn't remain valid for this new requestor.

 

Though not sure if this happens to be true in other applications as well.

May 7, 2013 - 11:33am

Hi,

What is the change you have done in the Requestor session.

We are also seeing the same issue in our application.

Please provide the changes what you have doneand how it got resolved.

 

Thank you,

Prathyusha

May 7, 2013 - 12:04pm

Prathyusha,

 

What I meant was Log out from your application and log in again to avoid this issue.

 

Thanks,

arka

July 19, 2016 - 12:25pm

 

   Hi,

          A commit cannot be performed because a deferred save of instance PEGASAMPLE C-73 failed: code: SQLState: Message:

Beacuse you may not create a new schema for database. 

For Postgres, creating schema --> F:\Pega Install Software72\PRPCPersonalEdition\pgsql\bin\Pg admin3(with elephant icon) --> open.