on 05-18-2015 5:02 PM
hi Experts,
We are upgrading our solution manager 7.1 SP11 to SP13 through Software Update Manager [SUM] SP13 on windows environment.
but from almost 30 hours i was stuck at this very step: " ABAP: Phase MAIN_NEWBAS/XPRAS_AIMMRG is running ... "
Java installation is completed successful. I dont see any dumps in shadow systems. in SM66 i see one background job running from 30 hours.and in SM37 i see the job RDDEXECL active from the same time stamp.
please advice we are in serious concern about this.
thanks,
Raja
the following 2 images are SM37 job and its job log
thanks everyone for their help, it really did help me to solve it.
This is how i finally solved it...
My Issue:
"
2EETW000 sql error: 1205 Transaction (Process ID 117) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
2EETW125 SQL error "1205" during "1205" access: "Transaction (Process ID 117) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction."
1 ETP111 exit code : "12"
Found this in XPRASUPG.ELG log.
in SM37 the job that is keep on running for last 2 days in active state "RDDEXECL "
so even though log says there is an error due to dead lock, it never showed up..as the job RDDEXECL keep on running.
we have 3 approaches here
1. restart SUM
2. Restart shadow instance
3. restart the job " RDDEXECL"
i have choosed option 3 as im little worried to try other 2 options as im in middle of execution phase.if it hadnt worked i would have to go through the restart of SUM/Shadow instance.
thanks,
Raja
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
I repeat my post from above:
we are at same point.
I read note 1947874 and checked job status in SM37.
After that all RDDEXECL jobs were shown as finished.
I can't login into shadow instance. So I had a look into via dpmon pf=Instance.
There I can see, that all dialog workprocesses are in use. Thats the cause why I can't login.
But tables are not changing, instance seems blocked.
Is it an option to restart shadow instance now? Or where can I see, what's the problem?
Regards,
Julia
Hi Raja,
As you are performing Solman 7.1 SP11 to SP13 upgrade and step "MAIN_NEWBAS/XPRAS_AIMMRG" should not take more than 2 hrs to complete;
So there might be chances of deadlock occurrence. Please check the same in DB01. also please check upgrade logs in <drive>:\usr\sap\SUM\abap\log provide the screenshot of logs.
Thanks.
Regards,
Jaskirat Singh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Singh,
I have attached the logs which shows that there is a deadlock error.
But i dont see them in the shawdow system DB02.
as far as i understand i think the step " MAIN_NEWBAS/XPRAS_AIMMRG " found a deadlock, and waited so long that he got terminated.
can we re-start at this point or what should be my approach here..?
HI Raja,
Did you check the deadlock in Tcode DB01.
Also you should not restart upgrade at this point. If you encountered an error in SUM GUI then you continue to resume upgrade by clicking on continue.
Also have a look at below Snote which says repetition of task solves the deadlock issue; But don't apply Snote correction in your system.
1155807 - Database deadlock when executing DD_INT_UPDATE_DDFTX |
Regards,
Jaskirat Singh
Hello,
we are at same point.
I read note 1947874 and checked job status in SM37.
After that all RDDEXECL jobs were shown as finished.
I can't login into shadow instance. So I had a look into via dpmon pf=Instance.
There I can see, that all dialog workprocesses are in use. Thats the cause why I can't login.
But tables are not changing, instance seems blocked.
Is it an option to restart shadow instance now? Or where can I see, what's the problem?
Regards,
Julia
Hi Raja,
- Are you getting any dump related to this in ST22?
- Check the status of the job RDDEXECL
run the transaction sm37 and job->check.
- Attached the logs for the phase and also the job log.
With Regards
Ashutosh Chaturvedi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raja ,
If the status of the process does not change for a long time in SM50 then more probable that the work process is stalled .
You may also take a trace using ST12 , ST05 . Check for any DB deadlocks or long held locks .
Is there any CPU / Memory contention ?
Believe you could wait for some more time , in the meantime take a trace or check in STAD
Thanks ,
Manu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raja ,
This phase generally takes a long time to complete . If the Job is active [ Check in sm66 , sm50 , etc ] and updating there is nothing to worry .
The following Note should help you
1947874 - Performance analysis for XPRAS_AIMMRG phase
Troubleshoot as recommended in the Note
Thanks ,
Manu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.