If you want to uninstall your SAP HANA “Application Server” then you need to use “./sapinst” option of SWPM to do it easily…
Everything About SAP Basis
-
Asking and Answering Questions in the SAP Community
SAP provides a convenient channel through which you can ask questions about any SAP topic. Before asking a question, you can also browse...
-
Performance Issues on ABAP Stack
Today we are going to check performance issues on ABAP stack…The system may be up and running, but performance issues will hurt...
-
What is RISE with SAP ?
RISE with SAP is a “Business Transformation as a Service (BTaaS) product that focuses on shifting customers into the SAP cloud product...
-
SAP Spool : “Waiting in host spooler (Position 1)”
When you get an issue on printing side of your SAP system and you found the error “Waiting in host spooler (Position 1)” then you can...
-
SAP Security Patch Day for December 2022
On 13th of December2022, SAP Security Patch Day saw the release of 14new Patch Day Security Notes. Further, there were 5updates to previously...
-
ITAB_DUPLICATE_KEY in XPRA phase
If you are getting the ITAB_DUPLICATE_KEY error while you are in XPRA phase like shown in the following structure, then you can check the solution...
-
“Upgrade is running! No import possible” in ACT_UPG
If the SAP system in upgrade mode and no import possible, then you can use the following database query on the “UVERS” table. ...
-
ORA-12154: TNS:could not resolve the connect identifier specified
You may get “ORA-12154: TNS:could not resolve the connect identifier specified” error in your workprocess log file while trying to start...
-
SAP Security Mandate: SAP Software and Log4J Remote Code Execution
SAP continues to investigate the remote code execution vulnerability (CVE-2021-44228) related to Apache Log4j disclosed on Dec 10, 2021. SAP...
-
SAP HANA 2.0 Revision Strategy
SAP HANA corrections are shipped in the form of “Revisions” and “Support Packages”, new capabilities are only comes with SAP...
SLD Content (Model Version and SAP_CR) Update
If you are getting an error like “Cannot perform the selected import” while loading “CIM Model” or “CIM Data” on SAP NW SLD (System Landscape Directory) because of the version situation, then you need to update related model version and the content of your system…
Find SAP HANA Database LOG and TRACE File Directories
HANA LOG and TRACE files are located under /usr/sap/< SID >/HDB< Instance number >/< hostname >/trace directory.If you are using multitenant structure, then this directory shows SYSTEMDB and you can find TENANT logs and trace files under own directory (DB_SID).
HANA Software Installation via “hdbinst” command
You can install HANA database easily via command “hdbinst” on OS level in approximately 15 minutes (you can use “hdbsetup” for GUI installation)…
Get Description for a HANA Table Instead of usage DESC
There is no DESC command on HANA database to get “description” about a table structure, therefore if you need to get this information u can use the following SQL command on HANA database…
Create Diagnosis Dump File with HANA Studio
We can create the “Diagnosis File” via HANA Studio to use in case of our incedent requests.File generation process will take from seconds to minutes according to you HANA Database and using the HANA Studio is the easiest way to create these diagnosis files with just a few clicks…
Upgrade HANA 1.0 to HANA 2.0 on OS Level
You can find “Upgrade HANA 1.0 to HANA 2.0 via Hana Administration Console” in the blog but this time we are going to do this on “Operation System” level…
Find Active HANA Ports via SQL Queries
If you want to list “Active HANA Ports” on OS or HANA Admin Tool via SQL, then you can try to use below SQL queries to do it easily ;
SAP HANA Status Check via SAPCONTROL
You can easily check you SAP HANA system’s status on Linux system via “sapcontrol” command…To do this “GetSystemInstanceList” and
“GetProcessList” switchs are enough…
List all Connected Applications to SAP HANA
You can use below SQL query to list all application connections which are connected to SAP HANA system from SQL editor.
LIST & KILL Sessions on HANA
If you need to LIST all sessions or KILL a specific active session on HANA then you can use the following SQL queries to do these kind of actions easily..
Check Memory Usage and DB Size on HANA via SQL
You can use the following SQL queries to check your HANA system’s memory usage details…
Activate / Deactivate user in SAP HANA DB
The administrator can “activate / deactivate” a user account with the following SQL command or SQL console of the SAP HANA studio, the only prerequisite is, you need to have system privilege “USER ADMIN”.
CHECK_REQUIREMENTS QUEUE_NOT_EMPTY Error while SPAM Update
You are trying to update your SPAM version on your SAP system and process canceled with the error CHECK_REQUIREMENTS –> QUEUE_NOT_EMPTY.In this case, you can check the below steps to clarify and solve the issue…
HANA Backup and Recovery SQL Queries
You can find some helpful SQL queries in this article to check your HANA database backup status to use in case of recovery situation.
Useful Python Scripts for HANA
All python scripts can be found in exe/python_support directory.
These scripts can affect the system therefore it’s better to check with ‘-help’ switch before executing the scripts.
HANA Cleaner Python Script – hanacleaner.py
SAP HANA cleanup tasks like purging the backup catalog or deleting old trace files need to be implemented individually.SAP created a Python script which called as HANACLEANER.PY to perform these tasks automatically.
Changing HTTP to HTTPS for Repository and Directory Tools for NWA
If you want to use HTTPS protocol for your NWA internal addresses instead of HTTP address redirection, then you can use the following steps to implement this solution…
S/4 HANA Readiness Check
“S/4 HANA Readiness Check” is a tool from SAP that help you to prepare your SAP system to S/4 HANA upgrade.You can use this cloud-based tool to create a detail report of your current SAP system before start the S/4 HANA project.
HA_SYSTEM_CHECK : “duplicate type ‘ASCS’ found at instance list”
If you are getting the error like “duplicate type ‘ASCS’ found at instance list” on upgrade phase “HA_SYSTEM_CHK” while EHP8 running on the SAP Business Suite ECC 6.0 system then you can check the below parameter value to eliminate this problem and continue your Upgrade process…
SAPGENPSE Usage for PSE Files
You can use the “sapgenpse” command line tool to manage all PSE (Personal Security Environment) file operations easily on all operating systems.
Configuring SAP Cryptographic Library for SNC
To set up a server to use the SAP Cryptographic Library for SNC, you can use the below configurations and tools depending of your server type.
Generating a Keystore (PSE) using SAPGENPSE
We can use the crytography tool SAPGENPSE to generate a keystore in which we can store a certificate.
First of all we need to define SECUDIR environment variable.The crytography tool SAPGENPSE generates the keystores and stores in this directory.
SAP Landscape Management 3.0 (SAP LAMA) Installation
SAP Landscape Management – SAP LAMA , (formely knows as “SAP Landscape Virtualization Management – SAP LVM”) is a landscape administration solution that helps the manage system administration tasks and reduce the manual steps with automation steps and supports the centralized landscape managament.
Featured Posts
-
Asking and Answering Questions in the SAP Community
-
Performance Issues on ABAP Stack
-
What is RISE with SAP ?
-
SAP Spool : “Waiting in host spooler (Position 1)”
-
SAP Security Patch Day for December 2022
-
ITAB_DUPLICATE_KEY in XPRA phase
-
“Upgrade is running! No import possible” in ACT_UPG
-
ORA-12154: TNS:could not resolve the connect identifier specified
-
SAP Security Mandate: SAP Software and Log4J Remote Code Execution
-
SAP HANA 2.0 Revision Strategy
Recent Comments