process chain stopped due to deadlock

[Former Member]

dear friends ,

today my daily running process chain had stopped due to deadlock occured in CRM , and again i have to re-schedule the process chain after production hours. instead doing this activity can i re schedule my process chain immediately when the deadlock happens?

so friends suggest me is there any other option is availabe to over come this issue?

i.e whener my process ends due to deadlock i dont want to do manual process chain restart instead it should restart automatically...

please help me friends...

thanks,

anand

[former_member188080]

Hi,

Unless and until you change the design of PC it may not happen.

It seems for eg Master data load is running and transaction data load started which is referring to same MD table and both the PC creates lock while accessing this table.

Best way complete Master data run and then start TD PC post that. so they should fall in series and not in parallel.

Once the PC stops due to lock you are not left with any choice then to manually correct it.

let me know if you have any questions

Thanks and regards

Kiran

[Former Member]

kiran,

thank you so much for your reply

this is to infor you that , this deadlock is not happening in frequesntly for this daily running process chain...

it is happing quite often and am thinking this is not because of process chain settings...

could you please help me in this regard?

[Former Member]

Hi

Deadlocks occur when two or more applications lock each other. Each application is waiting for the other to release the lock.

please wait some time once the whole process is refreshed and then schedule.if you start immediately system access manipulation differs which turns errors .

Thanks

[waqar_ahmed]

Hi,

Deadlock is occured when you have parallel process chain, try to make your process chain in serial order and then there won't be any deadlock.

Hope this helps,

regards,

ray

[Former Member]

hai Ray,

thank you so much for your reply ...

problem is not with process chains... accessing the DB table concurrently so am getting the dead lock in table.

table name is : TRFCQOUT

SUGGEST ME IN THIS ..

thnaks in advance