SAP Basis/Netweaver Tutorials, Monitoring, Administration(Certification) and FAQs Headline Animator

SAP Basis/Netweaver Tutorials, Monitoring, Administration(Certification) and FAQs


Saturday, 2 July 2011

How to terminate a user session in SAP?


This article answers the following queries :
  •     How to terminate a user session in SAP ?
  •     How to kill or terminate a process in SAP ?
  •     How to log off a user either locally or system-wide in SAP ?

 Sometimes  there will be a requirement to terminate a user session.
For example: An user has run a report or program with inappropriate selection criteria, which leads work process going to PRIV mode occupying so much memory impacting performance of the system. In those cases, you will have to check with the user and terminate his session or logoff user system wide if he is no longer working.
To terminate a user from the system either locally or system wide :
Go to SM04 transaction. Select the user to be terminated. In the below example am terminating user TEST from the system.













Go to User -> Log off user -> Local   (To log off user from this instance alone)
Go to User -> Log off user -> System-Wide (To log off user from all the instances of the system)


How to terminate a process in SAP ?
If you would like to terminate a particular process of a user which is impacting a system proceed as follows :
Go to SM50 and identify the process and highlight the same. Go to Process -> Cancel without core and execute the same.



System prompts you to confirm the deletion of process.



Click on Yes to confirm the termination. System terminates the process and prompts a message on the screen confirming the same as below




Please note in the above scenario, a process can be terminated through “Process -> Cancel with core” option also but in this case core file will get generated regarding the same








Enter your email address:


Delivered by FeedBurner



What is Dpmon tool ? How to use it ?

This article answers the following query :

  • What is dpmon tool ? How to use it ?

What is dpmon tool ?

dpmon is an auxiliary tool provided by SAP to use from operating system level. This tool provides the functionalities similar to workprocess overview of SAP (SM50 or SM66).

This tool will be of great use if by any reason, we are not able to login to SAP system through SAP GUI. We can use dpmon and login to SAP system at operating system level and we can identify the reasons for the issue and we can action accordingly.

How to open dpmon tool ?

(Am demonstrating the usage of dpmon tool based on AIX or HP-UX operating systems)

Login to Central Instance(CI) host of the SAP system using  <sidadm> userid.

After logging in goto the CI, please go to the profiles path.


You can use any of the following commands to go to the profiles directory

cd /usr/sap/<SID>/SYS/profile          (or)

cd /sapmnt/<SID>/profile                   (or)

cdpro


Please find below screenshot



Use the command as shown below :

dpmon pf=<profilename>




It displays “Dispatcher Queue Statistics as below”. In this screenshot we can figure out if any dispatcher waits are there







Click on l in the above screenshot to view work process overview as below :







From the above screen, we can make out if all the dialog workprocesses are full.
In that case, PID of a problematic process can be taken and that process can be killed at Oslevel by Kill -9 <PID>. After that you can login to the system as you have just killed one dialog process and it is free so that it will allow you to login to the SAP system from SAPGUI.

In addition to that, following are the commands that can be executed in dpmon tool in the above screen :

Press k  to kill workprocess (with core)

Press s to stop workprocess

Press q to quit from dpmon tool








Enter your email address:


Delivered by FeedBurner




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

Thursday, 30 June 2011

How to run a report in SAP?

This article answers the following queries:
  • How to run a report or program in SAP?
  • What is the need of RSBTCDEL program?
  • How to delete old background or batch jobs in SAP?
  • How to run a report in background in SAP ?
----------------------------------------------------------------------------------------
In SAP environment, there will be frequent requirement by ABAPers /functional/technical team to run various reports. This can be done through SE38 transaction code.

Go to transaction SE38 as shown below and provide the program/report name which you would like to run.

In the below example, am running a report / program RSBTCDEL which is used to delete old background jobs



Click on execute button to run the report. Depending on the program/report, you will be prompted to enter the input parameters(variants) so that system can action the same.

In the below report, am selecting to delete all batch jobs that are with username BASIS , older than 30 days and which are finished or canceled.



Click on execute button, once you have provided the inputs. Then the program will run in dialog mode and the status similar to below screen will appear on the status bar.

How to run a report or program in background mode in SAP?


In case you would like to run the program in background, please follow these steps:
Navigate to Program -> Execute in Background as shown below




Once you execute as shown above, program will run in the background.











Enter your email address:


Delivered by FeedBurner

How to view the contents of any table in SAP ?

This article answers the following queries :

  • How to view the contents of any table in SAP ?
  • What is the use of data browser in SAP ?
  • What is the transaction code for data browser in SAP ?
  • How to find out number of records in a table in SAP?

Data Browser  in SAP is used to
                      
      • View the contents of a table
      • Find out number of records in a table
Data Browser can be accessed by transaction code SE16 in SAP.

Go to transaction SE16 as shown below :



Please provide the tablename of which you would like to view the details  and click the highlighted button in the above screen to view the following screen.

In the above example, we are viewing the contents of T000 table




Click on “Number of Entries” pushbutton to find out number of rows in the table.



Click on close to close the above window and click on execute button to view the contents of the table as below.












Enter your email address:


Delivered by FeedBurner

What are the different transaction codes related to client operations in SAP ?

This article answers the following queries :



  • What are the different transaction codes(Tcodes) related to client operation ?
  • How to maintain new client entries in SCC4 ?






Following are the important Tcodes which are useful for various client operations in SAP.



 SCC4 : This transaction is used to list all the clients that are present in the SAP system. This also includes details like :


  • Last changed date of the client
  • Last changed by
  • Logical system name associated with the client
  • Client role

Using this transaction, a new client details can be maintained as below :

i)   Press change icon to be in change mode
ii)  Click on “new entries” push button to create new client details



All the client details that are available in SCC4 are present in the T000 table in the backend.


SCC5  :  This transaction is used to delete a client from an SAP system

SCCL  : This transaction is used to perform local client copy in  SAP system

SCC9  : This transaction is used to perform remote client copy in SAP system

SCC3  : This transaction is used to monitor client copy progress

SCC8   : This transaction is used for client export

SCC7   : This transaction is used to perform client import post processing  
            activities







Enter your email address:


Delivered by FeedBurner

How to open the client in SAP system?

This article answers the following queries:


  •     How to open the client in  SAP system ?
  •     How to view when was the client settings last changed ?
  •     How to view who has last changed the client settings?
  •    What are the various client settings and their significance


Often in business scenarios, there will be requirements which cannot be transported and which have to be modified directly in respective tables and other repository objects. To perform these operations client to be opened.


Goto transaction SCC4. This lists clients’ overview as below:




From the above screen, we can make out what are the existing clients in the SAP system, their names and the date they are last modified.

Double click on the client to be opened. It displays similar screen as below  with the complete client details like last changed date, last changed by, client role and associated logical system of the client



In the above screen, we can see the highlighted option that no changes allowed and no changes to repository and cross-client customizing objects. These 2 settings means that client is NOT opened.

To open the client we should set the client settings as shown below for a client:




In addition to the above 2 settings, in SE06, System change option should be set to “modifiable” as shown below :

Goto transaction SE06 :



Click on System change option to goto below screen




In the above screen, set the Global setting as “modifiable” to make sure client is opened.

In case you would like to restrict changes to a client, please set this Global setting as non-modifiable so that no changes can be done.

Please note that the above setting of system change can be done through SE03 transaction as well.

What are the various client settings and their significance?

Changes and transports for Client specific objects :

i) Changes without automatic recording : Changes will be done without recording in a change  request

ii) Automatic recording of changes : Changes will be done and  request will get generated & changes will be captured in that

iii) No changes allowed : No changes will be allowed

iv) Changes w/o automatic recording no transports allowed : This flag means  customizing changes will be permitted but changes are not automatically recorded in the change request.


Cross –Client object changes :

i)        No changes to cross-client object changes
ii)       No changes to repository objects
iii)     No changes to cross-client and repository objects
iv)     Changes to cross-client and repository objects.








Enter your email address:


Delivered by FeedBurner