Upgrade HANA 1.0 to HANA 2.0 on OS Level

Upgrade HANA 1.0 to HANA 2.0 on OS Level
May 03, 2018 | No Comments »

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…

Read More

Find Active HANA Ports via SQL Queries

Find Active HANA Ports via SQL Queries
April 26, 2018 | No Comments »

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 ;

Read More

SAP HANA Status Check via SAPCONTROL

SAP HANA Status Check via SAPCONTROL
April 23, 2018 | No Comments »

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…

Read More

List all Connected Applications to SAP HANA

List all Connected Applications to SAP HANA
April 19, 2018 | No Comments »

You can use below SQL query to list all application connections which are connected to SAP HANA system from SQL editor.

Read More

LIST & KILL Sessions on HANA

LIST & KILL Sessions on HANA
April 17, 2018 | No Comments »

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..

Read More

Check Memory Usage and DB Size on HANA via SQL

Check Memory Usage and DB Size on HANA via SQL
April 11, 2018 | No Comments »

You can use the following SQL queries to check your HANA system’s memory usage details…

Read More

Activate / Deactivate user in SAP HANA DB

Activate / Deactivate user in SAP HANA DB
April 09, 2018 | No Comments »

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”.

Read More

CHECK_REQUIREMENTS QUEUE_NOT_EMPTY Error while SPAM Update

CHECK_REQUIREMENTS QUEUE_NOT_EMPTY Error while SPAM Update
April 04, 2018 | 1 Comment »

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…

Read More

HANA Backup and Recovery SQL Queries

HANA Backup and Recovery SQL Queries
April 02, 2018 | No Comments »

You can find some helpful SQL queries in this article to check your HANA database backup status to use in case of recovery situation.

Read More

Useful Python Scripts for HANA

Useful Python Scripts for HANA
March 12, 2018 | No Comments »

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.

Read More

HANA Cleaner Python Script – hanacleaner.py

HANA Cleaner Python Script - hanacleaner.py
March 07, 2018 | No Comments »

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.

Read More

Changing HTTP to HTTPS for Repository and Directory Tools for NWA

Changing HTTP to HTTPS for Repository and Directory Tools for NWA
February 19, 2018 | No Comments »

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…

Read More

S/4 HANA Readiness Check

S/4 HANA Readiness Check
February 12, 2018 | No Comments »

“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.

Read More

HA_SYSTEM_CHECK : “duplicate type ‘ASCS’ found at instance list”

HA_SYSTEM_CHECK : "duplicate type 'ASCS' found at instance list"
February 07, 2018 | No Comments »

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…

Read More

SAPGENPSE Usage for PSE Files

SAPGENPSE Usage for PSE Files
February 05, 2018 | No Comments »

You can use the “sapgenpse” command line tool to manage all PSE (Personal Security Environment) file operations easily on all operating systems.

Read More

Configuring SAP Cryptographic Library for SNC

Configuring SAP Cryptographic Library for SNC
January 29, 2018 | No Comments »

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.

Read More

Generating a Keystore (PSE) using SAPGENPSE

Generating a Keystore (PSE) using SAPGENPSE
January 23, 2018 | No Comments »

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.

Read More

SAP Landscape Management 3.0 (SAP LAMA) Installation

SAP Landscape Management 3.0 (SAP LAMA) Installation
January 18, 2018 | No Comments »

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.

Read More

Job RDDIMPDP is not triggered by sapevt

Job RDDIMPDP is not triggered by sapevt
January 02, 2018 | No Comments »

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…

Read More

SAP HANA Release Strategy for HANA 1.0 and HANA 2.0

SAP HANA Release Strategy for HANA 1.0 and HANA 2.0
December 25, 2017 | No Comments »

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.

Read More

Find Installed Plugins on HANA Database

Find Installed Plugins on HANA Database
December 04, 2017 | No Comments »

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…

Read More

Reloading the reginfo secinfo on JAVA Systems

Reloading the reginfo secinfo on JAVA Systems
November 29, 2017 | No Comments »

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.

Read More

HANA Database Revision Upgrade on OS Level (HDBLCM)

HANA Database Revision Upgrade on OS Level (HDBLCM)
November 27, 2017 | No Comments »

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.

Read More

Check for SAP HANA Components Updates

Check for SAP HANA Components Updates
November 20, 2017 | No Comments »

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…

Read More

Page 3 of 17«12345»10...Last »

Recent Posts

Meta

Blogroll