08-19-2011 4:10 AM
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
08-19-2011 5:11 AM
use Locking concept ..
Lock the table before delete.
So that if another program tries to lock again dead lock situation will not occur
08-19-2011 5:57 AM
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
08-20-2011 9:55 AM
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