Pages

Friday, 1 July 2011

How to troubleshoot when no one is able to login to SAP system (ABAP stack)?

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


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.







Enter your email address:


Delivered by FeedBurner

19 comments:

  1. Hi,
    it's awesome durgaprasad.keep going on..

    ReplyDelete
  2. Hi

    What is the difference between R3trans -d and R3trans -x

    Plz Help me

    My E-mail ID is : saravana.msn@gmail.com

    ReplyDelete
  3. Suberb analysis

    ReplyDelete
  4. Nicely Explained Dear. Thanks A lot :)

    ReplyDelete
  5. how to resolve this in sql server 2005

    ReplyDelete
  6. thanks durga :)

    ReplyDelete
  7. super ji..thanks for your valueable info

    ReplyDelete
    Replies
    1. 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

      Delete
  8. That was so clear :) With no second thought or confusion for the reader !! Kudos , Expecting more and more from you ji :)

    ReplyDelete
    Replies
    1. Thank you so much.. Certainly, will strive to meet your expectations

      Delete
  9. 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

    ReplyDelete
  10. 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 ....

    ReplyDelete
  11. 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

    ReplyDelete
    Replies
    1. which command we should use on windows prompt to see the connectivity between os and database

      Delete
    2. window? means? you have to login to sidadm and fire this above command

      Delete

Please provide your valuable feedback: