on 03-24-2014 9:08 AM
Hi,
The dead lock problem is like 2 process both require table A and B.
Process 1 locked table A and waiting for table B, while process 2 locked table B and waiting for table A.
As both process waiting for the other process to release, so it will wait forever and the system solve this problem by killing one of them, and the process being killed got the error you mentioned.
So... back to your question, to solve your problem there are 2 parts
1) For the data loading or process failed
You may just retry it now, as the other process most likely ended
2) To prevent it from happen again
You may need to check the process/loading occur at the time period and re-schedule them to prevent the process to lock each other again, for how to locate the process, it is all about your knowledge to the system, so help we can offer are limited
Regards
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I think data volume is huge so try with applying filter selection by some restrictions with reduced volume. Also increase the no. of parallel processing from setting of Batch manager in DTP and change the job class to 'A'.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sanjeev,
I suppose this is master data load for you.
Sometimes there might be a fight between the resources and hence running a load might dump out due to timeout error and may throw a deadlock error.
I would suggest you to check for this dump in ST22 and then decide further actions according to the log mentioned there.
Best Regards,
Arpit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sanjeev,
There might be various solutions.
If this is a master data load, try to repeat the failed step.
If this is a transaction data, take the required steps to delete old data and then try to repeat again.
If this is still failing, you need to check the log in ST22 as already adviced.
Also you might try to split the data load on basis of selections and then try as well.
Best Regards,
Arpit
Hello Sanjeev,
From the Error, you have mentioned it seems some Job has been abruptly come to an end . Many reason for this . Google it out.
Please check the T Code St22 or Sm37 for more on that job i.e how and why it failed
Post this, you can raise up the matter with your BASIS team.
Hope this helps !
Regards
YN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Sanjeev,
Please refer to the below link, it should help you:
however, I think you will need basis's help even for this.
Hope this helps!
Regards,
Sheen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Take basis/DB team help and solve your issue.
to know the more clarity about your issue, from source system find the related ecc job(related to your info pack) of at SM37 and see the log details.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.