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…

SAP Security : “Password Blacklist” Import Methods for ABAP / JAVA / HANA

SAP Security : "Password Blacklist" Import Methods for ABAP / JAVA / HANA
November 16, 2017 | No Comments »

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

Database Connectivity from SAP (Linux) to Remote SQL Server
November 09, 2017 | No Comments »

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

Editing UME Properties Which Cannot be Modifiable
October 24, 2017 | No Comments »

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 Transport Request Name in STMS Import Queue
October 09, 2017 | No Comments »

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.

Monitor SAP HANA Systems during START and STOP Process

Monitor SAP HANA Systems during START and STOP Process
August 14, 2017 | No Comments »

You can get detail informations and status via “Diagnosis Mode” about your SAP HANA system during the START and STOP operations.

Export & Import a List of SAP HANA Systems

Export & Import a List of SAP HANA Systems
August 08, 2017 | No Comments »

You can Export a list of your SAP HANA systems from your “SAP HANA Studio” or you can Import a list of SAP HANA systems to your “SAP HANA Studio” easily with following steps…

HANA Database Services /Stop/Start/Kill/Reconfigure

HANA Database Services /Stop/Start/Kill/Reconfigure
August 02, 2017 | No Comments »

We can easily “Stop / Start / Kill / Reconfigure” HANA system services and “Reset Memory Statistics” over “SAP HANA Administration Console”

Add a HANA System to HANA Administration Console

Add a HANA System to HANA Administration Console
July 27, 2017 | 1 Comment »

If you want to add a new “HANA System” to your “HANA Administration Console”, then you can use the following steps…

Find The Schema Owner of HANA Schema

Find The Schema Owner of HANA Schema
July 12, 2017 | No Comments »

If you want to know the owner of the HANA schema then you can use the following SQL statement , don’t forget that you need “READ Access” authorization to “SYS” schema to execute this sql.

Current size of the “Used Memory” in HANA

Current size of the "Used Memory" in HANA
July 10, 2017 | No Comments »

You can get the current size of the “used memory” for your HANA system easily with following SQL command…

Installation “XPI Inspector Tool” for Tracing the PI / PO Issues

Installation "XPI Inspector Tool" for Tracing the PI / PO Issues
June 29, 2017 | No Comments »

We can check and collect the related informations and traces to solving the issues or improving the PI or PO systems’ performance via “XPI Inspector Tool”…

“no valid destination” when using logon groups and the SAP Web Dispatcher

"no valid destination" when using logon groups and the SAP Web Dispatcher
June 19, 2017 | No Comments »

Web Dispatcher trace file “dev_webdisp” shows the following messages in case of the situation ;

HANA Database Upgrade from 1.0 to 2.0

HANA Database Upgrade from 1.0 to 2.0
June 13, 2017 | No Comments »

Start the process by following selection ;

HANA Administration Console -> Select the System -> Lifecycle Management

-> Platform Lifecycle Management -> SAP HANA Platform Lifecycle Management

SAP HANA Offline Cockpit

SAP HANA Offline Cockpit
March 02, 2017 | No Comments »

To diagnosis and analyze errors while SAP HANA is stopped or cannot be reached due to performance problems, you can access diagnosis files in the SAP HANA cockpit for offline administration.

SAP HANA Cockpit

SAP HANA Cockpit
February 24, 2017 | No Comments »

If you want to administrate and monitor your SAP HANA databases , you can use the “SAP HANA Cockpit” tool.SAP HANA cockpit, a web-based HTML5 user interface that you access through a browser, runs on SAP HANA extended application services, advanced model.

Internal error: No PAT07 entries for package XXX

Internal error: No PAT07 entries for package XXX
February 22, 2017 | No Comments »

If you installed the SPAM/SAINT version 0063 and want to install a new Add-On or upgrade already installed Add-On , then you probably get the error message “Internal error: No PAT07 entries for package XXX” and installation queue will be failed.

WorkProcess Hangs on Program SAPLSENA with Reason ENQ

WorkProcess Hangs on Program SAPLSENA with Reason ENQ
February 20, 2017 | No Comments »

If your SAP work processes hangs on program SAPLSENA with the reason ENQ , then you should check the log files and compare you situation with this article…

SAP HANA License Types

SAP HANA License Types
February 17, 2017 | 5 Comments »

You can find the details of “SAP HANA License Types” and difference of the “Unenforced” and “Enforced” options in this article…

Use SAP HANA HDBSQL to execute SQL commands at OS level

Use SAP HANA HDBSQL to execute SQL commands at OS level
February 14, 2017 | No Comments »

If you want to access SQL prompt using HDBSQL at OS level, then you need to follow below steps and  passwords of the user <SID>ADM and one of the HANA database users’s password.

Check and Install HANA License

Check and Install HANA License
February 10, 2017 | 1 Comment »

You can find the details of HANA licensing issues in this post, so you can; “Check” , “Get” and “Install” your SAP HANA license easily…

SAP HANA System START|STOP|RESTART Information Log

SAP HANA System START|STOP|RESTART Information Log
February 08, 2017 | No Comments »

You can easily find the detail informations of your SAP HANA system; when was started/stopped/restarted from the log file  “history.glf”

maximum number of connected terminals reached

maximum number of connected terminals reached
February 02, 2017 | No Comments »

If you are getting an error message like “maximum number of connected terminals reached” while trying to logon your SAP system then you should check the related profile parameter like described in this article.

Entry found in buffer with no data file(s) transferred yet

Entry found in buffer with no data file(s) transferred yet
January 25, 2017 | No Comments »

If you are getting an error message like “Entry found in buffer with no data file(s) transferred yet” while trying to import a transport request to your SAP system, you should check the following solution before trying to search on other sites :)

Blogroll