topic Re: Conflict while updating database in Application Development and Automation Discussions

Conflict while updating database

Former Member — Tue, 18 Jan 2011 09:59:42 GMT

Hi,

We have a Z table. There is a lock object created for that table. So we are using ENQUEUE FM to lock the table before updating it. After modifying the table, DEQUEUE FM is being used to release the lock.

Now the problem is, we got an error "The database system detected a deadlock and avoided it by rolling back your transaction."

May be two people tried to modify the same record thats why we got this error.

After releasing the lock using the DEQUEUE FM, COMMIT statement is not used.

My question is, are we getting this problem due to the absence of COMMIT statement or is there any other reason?

We are unable to replicate this error.

Please reply.

Thanks,

Ibrahim.

Re: Conflict while updating database

Rushikesh_Yeole — Tue, 18 Jan 2011 10:06:13 GMT

To replicate the sccenario, use program to update table in debugging in 1 session.

and update table through SE11 in maintainece table entries.

You can check with this.

Commit work will not create a problem.

Let me know any querries.

Re: Conflict while updating database

RaymondGiuseppi — Tue, 18 Jan 2011 10:10:51 GMT

Use SM21 to read actual error message, some database locks are not related to SAP lock concept, e.g. Oracle has some problem with insertion in certain configuration. Which message do you get via SM21.

Regards,

Raymond