Problem in table locking while running the parallel jobs (deadlock?)

[Former Member]

Hi,

I am trying to delete the entried from a custom table. If I schedule the parallel jobs, I am getting the following dump while deleting the entries from table. This is happening for custom table ( in CRM system).

Exception : DBIF_RSQL_SQL_ERROR

And complaining that, deadlock occured. I am not sure what it is..

Could you please help me out, how can we solve this issue?

Thanks,

Sandeep

[Former Member]

Hi,

I am trying to delete the entried from a custom table. If I schedule the parallel jobs, I am getting the following dump while deleting the entries from table. This is happening for custom table ( in CRM system).

Exception : DBIF_RSQL_SQL_ERROR

And complaining that, deadlock occured. I am not sure what it is..

Could you please help me out, how can we solve this issue?

Thanks,

Sandeep

[JoffyJohn]

use Locking concept ..

Lock the table before delete.

So that if another program tries to lock again dead lock situation will not occur

[anup_deshmukh4]

Hello Sandeep ,

I would suggest you Record based Lock Objects ,

take a look at below link...to get a general idea..!

<link removed>

Hope it helps,

Thanks and Regards,

Edited by: Suhas Saha on Aug 19, 2011 11:27 AM

[Former Member]

Hi,

I used ENQUE-DEQUEUE...

All the Jobs are running fine...however last two jobs just getting strucked...and running forever..Unlock of the table is also not happening.

Thanks,

Sandeep