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..
Everything About SAP Basis
-
STARTSAP_NBAS Phase Canceled with Error ipc/shm_psize_40
SUM upgrade SAP Netweaver from 7.31 to 740 was canceled in the STARTSAP_NBAS phase with the error of “ipc/shm_psize_40″...
-
User Type is Not Active
Sometimes you can get the error like “User Type “XX” is Not Active” message while you are creating a new user via SU01, in...
-
Adding Server Process (Node) to SAP JAVA Stack
The installation procedure configures the optimal number of server processes in an instance based on the available hardware resources. This enables...
-
Kernel NMI watchdog: BUG: soft lockup error on SUSE Linux 12 SP2
If you are getting an error like “Kernel NMI watchdog: BUG: soft lockup error” for your SUSE Linux 12 SP2 OS, then you can check the...
-
HANA Log Status Check Point in Time Recovery Possible or Not
Production database has to be in RECOVERY mode all the time.If a SAP HANA database log mode in set to OVERWRITE, backup can still be done but...
-
HANA Log File System is Full
If hana log file system is full, then your DB will not be response.In this case you need to check below steps and you should not delete any log files...
-
Change Request Must be Assigned to a Project
If your are getting a message like “Change Request Must be Assigned to a Project” while trying to get a change request on a SAP system,...
-
SUM Error : ConnectContext for /lmsl/sumjava/SID failed
If you are getting an error like “ConnectContext for /lmsl/sumjava/SID failed” in your HostAgent log files while trying to start SUM...
-
Specifying the port for SAP HANA Cockpit before installation
During the installation of SAP HANA Cockpit, the installation assigns free ports to SAP HANA Cockpit and SAP HANA Cockpit Manager. ...
-
Installing HANA Cockpit 2.0
SAP HANA cockpit is part of the SAP HANA platform 2.0.The SAP HANA 2.0 Cockpit install comprises XS Advanced, a set of XSA multi-target applications,...
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.
Job RDDIMPDP is not triggered by sapevt
If you are getting an error message like “Background jobs cannot be started.” in your “tp system log” then probably RDDIMPDP job is not triggered by sapevt on your SAP system, in this case you can check the following parameter to solve the issue…
SAP HANA Release Strategy for HANA 1.0 and HANA 2.0
There are several terms used to describe parts of the SAP HANA release strategy.Also HANA 1.0 and HANA 2.0 have big differences according to SAP HANA release strategy documentations and snotes which i am going to try to explain in this article.
Find Installed Plugins on HANA Database
If you want to list “Plug-ins” which installed on your HANA database system, then you can do this via “SAP HANA Administration Console” or on OS level with following steps…
Reloading the reginfo secinfo on JAVA Systems
If you have a Standalone Gateway installation, or a Java instance system, then you can reload the security files (reginfo and secinfo) without having to restart the Gateway or the (A)SCS instance via GWMON tool.
HANA Database Revision Upgrade on OS Level (HDBLCM)
You can upgrade your “HANA Database Revision Level” with Web Support or OS level steps, in this note; i would like to share my “HANA 1.0″ revision upgrade from level 03 to level 11 on “SUSE Linux 12 SP2″ Operating System via OS level steps.
Check for SAP HANA Components Updates
HANA database can be updated using SAP HANA Platform Lifecycle Management, before that you should download the needed files and at this point you can use “Check for SAP HANA Components Update” option to make life eaiser…
SAP Security : “Password Blacklist” Import Methods for ABAP / JAVA / HANA
According to security reasons you might want to implement “SAP Password Blacklist” to your various SAP / DB systems, then you can use the following patterns for this issue…
Database Connectivity from SAP (Linux) to Remote SQL Server
If you want to make a connection from your SAP system which is working on SUSE linux to remote SQL server then you can follow the below steps and check the related OSS notes which are defined in this article.
Editing UME Properties Which Cannot be Modifiable
If you cannot edit some of the JAVA parameters from ConfigTool, then you should try the following way to modifiy this kind of parameters easily…
SYNCMARK Transport Request Name in STMS Import Queue
SYNCMARK entries are only needed when TP is allowed to import several transport requests in parallel, ans it’s used to avoid that two transport requests that contain the same object are imported parallel and should be automatically removed after the process.
Featured Posts
-
STARTSAP_NBAS Phase Canceled with Error ipc/shm_psize_40
-
User Type is Not Active
-
Adding Server Process (Node) to SAP JAVA Stack
-
Kernel NMI watchdog: BUG: soft lockup error on SUSE Linux 12 SP2
-
HANA Log Status Check Point in Time Recovery Possible or Not
-
HANA Log File System is Full
-
Change Request Must be Assigned to a Project
-
SUM Error : ConnectContext for /lmsl/sumjava/SID failed
-
Specifying the port for SAP HANA Cockpit before installation
-
Installing HANA Cockpit 2.0
Recent Comments