Meaning of the return codes while importing TR through STMS : 0: Transport successful. 4: Warnings occurred. All the objects were transported successfully. Peculiarities occurred for certain objects. These might not have been intentional. Example: A warning is given during a transport if the request contains an object deletion. 6: Post-processing required The transport request […]
ERROR: DbslExeRead failed and table or view does not exist during SLT Migration
Issue: The below error comes up when exporting/importing a System Landscape Transformation (SLT) system, in system migration ( using SWPM): (EXP) ERROR: DbslExeRead failed rc = 103, table “/1CADMC/XXXXXXXX” (SQL error 942) ORA-00942: table or view does not exist (DB) INFO: disconnected from DB Reason: During the replication process, SAP LT Replication server creates various […]
Control and Parameter file concept of Oracle Database
Few basic concept of Control and Parameter file concept of Oracle Database. Control file: A control file, which is a small binary file that records the physical structure of the database. The control file includes: The database name Names and locations of associated datafiles and redo log files The timestamp of the database creation The […]
SAP HANA System Replication overview
SAP HANA system replication provides the possibility to copy and continuously synchronize a SAP HANA database to a secondary location in the same or another data center. Usually system replication is used to support high availability and disaster recovery. System Replication is a standard SAP HANA feature. In this method, all data is replicated to […]
How to check HANA memory utilization through HANA studio and HANA Cockpit
We can check meory utilization on HANA DB through HANA studio and HANA cockpit. SAP HANA Studio: You can see some of the most important memory indicators on the Overview tab of the SAP HANA studio administrative perspective: SAP HANA cockpit: The SAP HANA cockpit is available at SAP Fiori Launchpad site that provides you […]
SAP HANA Memory concept
The following type of memory areas are most important: Memory Area Context Level Details Physical memory operating system global Total amount of memory physically available on host level (typically RAM) Virtual memory operating system process Total amount of memory allocated by all processes held both in physical memory and in paging area on disk. SAP […]
High response times for Session_Manager in ST03 and STAD
High response times for Session_Manager report/program in ST03 and STAD Explanation: “There is another reason for high response times with the session manager. This is due to a general limitation in the statistics: the transaction is determined at the end of a dialog step. Usually the last dialog step of a transaction saves data and […]
Concept of Database time in SAP
Database time or database request time is the time that R/3 considers necessary to access the oracle database. The database time plays a role at the following points: The statistical records from STAD (formerly: STAT) and ST03N (formerly ST03) contain the database time as a component. The ABAP trace from ATRA or SE30 displays the […]
Most Important Performance Analysis Transactions
The following is a list of the most important performance analysis transactions and brief explanation of their purpose. ST02: SAP Memory Configuration monitor checks the SAP Buffers and SAP Memory areas for problems such as swapping. It is a snapshot about the utilization of SAP shared buffers. High water marks of utilization for example extended, […]
Database statistics Concept
Database statistics Concept: • The Oracle cost-based optimizer (CBO) uses the statistics to optimize access paths when retrieving data for queries. If the statistics are out-of-date, the CBO might generate inappropriate access paths (such as using the wrong index), resulting in poor performance By running update statistics regularly, you make sure that the database statistics […]
Change and Transport System Concept
Change and Transport System: Change and Transport System (CTS) is a tool that helps you to organize development projects in ABAP Workbench and customizing, and then transport the changes between the SAP systems in your system landscape. As well as ABAP objects, you can also transport Java objects and SAP-specific non-ABAP applications in your system […]
How to check Index in SAP system
How to check Index in SAP system Go to T- Code : se11 Enter table name for which you want to check the indexes. Click on Display. Here you find all the columns/ fields that it has. In this, Click on Indexes. Now, you can find all the indexes for the table. Click on execute and […]
List of Port used in SAP System
List of port that used for SAP ABAP and JAVA Netweaver system, most of them picked during installation automatically. So below table describe briefly about this. ABAP: Product name Port Name Service in etc/services Default Range Rule External Fixed Comments (Explanation of Table Headings) Application Server ABAP SAP Dispatcher sapdp<NN> 3200 3200-3299 32<NN> Yes Yes Used […]
Directory structure in SAP system
This is the overall directory structure in SAP system which present at OS level. Unix/Linux based: use / Windows based: use <drive>:\ Please note apart below list of directory, there are some more directory and sub-directory exist, which depend on type of SAP Product/Release and OS environment and also as per their use cases. Main […]
Find Who Imported Transport Request in STMS
If you want to track who imported a transport request from transaction code STMS. 1. Login in to the SAP system in which you need to check the log. 2. Execute transaction code STMS_IMPORT. Choose Goto > Import History. 3. Choose Edit > Display More. Find your transport number and you can track the user […]
Front-End Printing on Local Printers
Front-End Printing on Local Printers Normally, all printers on which you want to print from the SAP system must be created in the SAP system as output devices. Front-end printing is available to reduce the significant administration effort associated with this. This means that a user logged on to the SAP system through the SAP […]
SAP Spool Access Method Type
SAP Spool Access Method Type: When you configure the output device in a device definition, you specify the access method with which the output device is connected to the SAP System, such as whether you are using local or remote printing. The access method is identified by a letter and informs the system which architecture […]
SAP HANA Services
Below is the list of all services running in SAP HANA system. Core Services Server Component OS Process Service Name Description Name server hdbnameserver nameserver The name server, which runs in the system database only, owns the information about the topology of the SAP HANA system, including knowledge of the tenant databases that exist in […]
slog, alog and ulog
slog, alog and ulog files are one the important log files, to check the heart beat of the SAP server. We can understand by reading this logs files, Why the error has come and we can get an idea to overcome with the error. While doing the version upgrade, we have to check this log […]
SGEN in detail
Information about the SAP Load Generator (SGEN) Overview With transaction SGEN, you can generate ABAP loads in your SAP system. This includes the load generation for specific software components/packages, the generation for changed components after a system upgrade, and the regeneration of previously generated loads. You can also resume or repeat previous SGEN runs, include […]