This article answers the following queries :
- How to troubleshoot when no one is able to login to SAP system (ABAP stack)?
- What could be the reasons if no one is able to login to SAP system (ABAP stack)?
Sometimes users may complain that they are :
i) Unable to login to SAP system from SAPGUI
ii) Other users who have already logged in may complain that system is not responding
iii) Some users who have already logged in may complain that system is very slow and response time is very high
Please note that in most of the above cases even SAP basis administrator cannot login to SAP system through GUI. So, he should use database, operating system tools (like PuTTy) and dpmon to identify the issue and troubleshoot.
The most likely reasons for all the above scenarios could be
i) Oraarch is full and system is not able to respond to user queries due to that and all dialog processes are occupied within a while due to that and system is not allowing any other users to login due to lack of dialog workprocesses
Solution : As even basis administrator cannot login through SAP GUI at this point of time, Please check at operating system level. If you find that oraarch filesystem is 100% full, please trigger archive log backup immediately and make sure there is enough space. Once there is sufficient space, system will start processing and all the dialog users activities will be resumed and within a while there will be free workprocesses to login and issue will get resolved
ii) Some critical filesystem at Oslevel is full and system is not able to perform any activity due to that. Within a while all the dialog workprocesses are full and no other user is allowed to login
Solution : As even administrator cannot login through SAP GUI at this point of time, Please check at oslevel whether any filesystem is 100% full. If so, please contact OS team and make sure sufficient space is free either by requesting them to add more space or by deleting some unnecessary files
iii) Some tablespace like PSAPSR3 is 100% full and system is not able to perform requests of existing users. Within due time all the workprocesses will get occupied and system will stop responding and it won’t allow any other new user to login due to lack of free workprocesses
Solution : (In Unix related Operating systems (AIX, HP-UX), login to system through <ORASID> user and run brtools to run whether any tablespace is 100% full. If so, please add some datafiles and make sure sufficient free space is created. After that system automatically resumes processing.
iv) Update got deactivated and system is not able to perform updates and thus all dialog/background workprocesses are full within due time and system is not allowing any other users to login
Solution : In some cases, in all the above error cases i) , ii) and iii) , SAP system may deactivate update automatically to prevent loss of data. So, after fixing the respective issue, we need to manually activate the update through SM13 so that system will resume processing. But you can activate the update only if system allows you to login through SAP GUI.
If you are not able to login to SAP system through SAPGUI, please use dpmon tool to do the same.
How to use dpmon tool
How to use dpmon tool
v) Other scenario could be some processes has gone into PRIV mode consuming so much memory. This leads to memory bottlenecks and all other users requests will either take lot of time to process thus experiencing slowness or high response times.
After a while it also may happen that all dialog workprocesses got full and no other user will be able to login due to lack of free workprocesses
Solution : This has 2 scenarios :
i) If you are able to login to SAP system through SAPGUI, please goto SM66 and identify the processes that have gone into PRIV mode. After identifying the transactions that are being run in PRIV mode, please check with respective user and terminate the processes or logoff the users from the system after confirmation that his process is non critical and can be terminated.
Terminating user session
ii) If even basis administrator could not login to SAP system, then use dpmon tool to identify the processes that have gone to PRIV mode.
After identifying processes that have gone to PRIV mode, cross check with the user and after confirmation that his session can be terminated, kill his session by providing PID number
For example: In AIX or HP-UX use command below
Kill -9 <PID>
In the above command, PID is process identification number.
After that system will release all the memory allocated to PRIV mode processes and will sytem will start processing normally.
19 comments:
Hi,
it's awesome durgaprasad.keep going on..
good
Hi
What is the difference between R3trans -d and R3trans -x
Plz Help me
My E-mail ID is : saravana.msn@gmail.com
Suberb analysis
Nicely Explained Dear. Thanks A lot :)
how to resolve this in sql server 2005
thanks durga :)
super ji..thanks for your valueable info
That was so clear :) With no second thought or confusion for the reader !! Kudos , Expecting more and more from you ji :)
Thank you so much.. Certainly, will strive to meet your expectations
Welcome
Welcome Mohan
All the steps are ok but What if we did not find any Work process with PRIV mode? what could be the next solution step? Please let me know? I faced this question in the interview
Hello sir, I have a doubt
If update got deactivated and basis admin also unable to login to sapgui then how to activate update process by using dpmon tool ? Can u plz explain it ....
r3trans -x will show database connectivity and will not check weather it is access to tables..
r3trans -d will show database connectivity and will check weather it is access to tables..
r3trans -v show the version pf it..
mainly r3trans is use to check the connectivity between os and database
which command we should use on windows prompt to see the connectivity between os and database
Hi Durga Prasad,
I would like to learn SAP basis and I need your suggestions.coluld please help me.
Mail me: Kaitha.srikanthreddy67@gmail.com
nice blog
window? means? you have to login to sidadm and fire this above command
Post a Comment