Environment variable related to SAP with Oracle Database

An environment variable is a variable whose value is set outside the program, typically through functionality built into the operating system or microservice. An environment variable is made up of a name/value pair, and any number may be created and available for reference at a point in time. The environment variable helps in pointing out […]

Read More

SAP Memory Concepts

 SAP Memory Concepts Roll Memory –>The roll area holds the user environment information needed by work processes when executing dialog steps. Extended Memory –> Specifies how much of the SAP extended memory was requested by this user. Heap memory–> Private memory (heap memory) requested by the user. Swap Memory –> SAP swap area is only used for a limited number of ABAP commands.   […]

Read More

Unix/Linux command that are helpful for SAP Basis

Below is the list of few Unix/Linux command that are helpful for SAP Basis Purpose. Command Details dpmon or dpmon pf= <Instance profile path> ABAP Dispatcher queue monitor jsmon pf=<instance profile path> Java Server monitoring ps -ef Running work process ps –eaf|grep dw sap Process overview ps –eaf|grep ora To check oracle service is running kill -9 <PID> Kill work process […]

Read More

How to check which user utilized maximum SM12 Lock in SAP

Sometimes it happens when few user process/program/transactions utilized maximum all SM12 lock entry, which may lead temporary bottle neck in system. Also, its lead to ABAP dump of LOCK_TABLE_OVERFLOW in many situations. Note: ** The size of the lock table limits the maximum number of lock entries, the maximum number of elementary lock names, and […]

Read More

Quick guide to checks any SAP Performance issue in SAP ABAP system

Critical tasks: Check that the R/3System is up –> Log onto the R/3 System Check that daily backup executed without errors –> DB12 Check database backup from DB02 or another backup tool. Log backup –> Log backup is completing successfully and adequate log area is there. Network Issue –> verify there is any network issue […]

Read More

ABAP Dump: TSV_TNEW_PAGE_ALLOC_FAILED for program SAPLSTUW in 000 client

Error: In ST22, we can notice that  ABAP dump TSV_TNEW_PAGE_ALLOC_FAILED in 000 client is coming for standard program  SAPLSTUW , like below. Reason/Solution: On Solution end as per  SAP Note  “2597255 – CDMC Statistic collection job failing due to dump in function module SWNC_GET_WORKLOAD_STATISTIC” which suggest this program error and can be corrected by applying this note or […]

Read More

SAPCONNECT email job long running in SAP system

Few suggestion/checks regarding this slow running SAPCONNECT email job (program RSCONN01) in SAP ABAP system. Usually this email jobs finishes in few second/min, but rarely we noticed its taking 1000+ second to complete the job and many 1000+ entries waits to process in SOST, also there is no error log in SM37, SOST tcode, related […]

Read More

Performance issue on COOIS / COOISPI / PPIO_ENTRY

We usually find in EWA report or in other SAP reports that high response time or performance issue shown related to tcode/report COOIS / COOISPI / PPIO_ENTRY. Also in some cases the short dumps TIME_OUT, MEMORY_NO_MORE_PAGING or TSV_TNEW_PAGE_ALLOC_FAILED may also be observed. To check or troubleshoot more on this, below few points need to check. […]

Read More

Huge difference by table TST03 between database and SP12 – Memory allocation for Oracle database

The database side the table TST03 can appear to be very large and to confirm this the size of the table needs to be compared with the actual data stored in the TemSe. This is only for Oracle database system. Below the step to check the size difference To compare: The size of the table […]

Read More

SM21- “Audit event recording was stopped (reason = MAXSIZE)”                

Error/Warning: In  SM21- below log is coming on regular basis related to “Audit event recording was stopped (reason = MAXSIZE)” If we check SM21 log, above log is coming on regular basis in our SAP system, like above screenshot. Reason/Solution: On further checking , the max size of the audit file is filled, that’s why […]

Read More

Single Sign on ( SSO) between SAP EP portal and SAP ABAP system

Below is step to configure SSO Between  EP Portal to ABAP system. 1) Create/verify the )parameter present in ABAP system or not. Go to RZ10 –> login/create_sso2_ticket  = login/accept_sso2_ticket =1; icm/full_host_name         = login/password_change_for_SSO= 2) Import the certificate from portal Login in to NWA (portal http://<hostname.com>:5$$00/nwa), navigate to certificate and keys section Select “Ticketkeystore” option and […]

Read More

SAP GUI History Not Getting Saved after MS office upgrade

Issue: SAP GUI History not saved, we usually check using backspace button. Sometime its happen when we upgrade our MS office. Pre-Requisites: –> Close all your SAP sessions including SAP logon pad Resolution/Procedure: –> Open SAP GUI Configuration –> In your GUI Configuration options click on ‘Local Data’ folder and then ‘History’ –> Change history […]

Read More