HANA Tutorial
Alert 'Invalid user name or password' after HANA Database Copy
We are copying a database using File-Based data backup taken from another database.When we are connecting to target DB after recovery it shows the inv ...
Cross-Database-Access (CDA) in HANA MDC (Multitenant Database Containers)
Cross-Database-Access (CDA) in BW systems and HANA MDC (Multitenant Database Containers)Multiple isolated databases are supported by SAP HANA in a sin ...
Service Preparation for SAP S/4HANA Finance Readiness Check
1. Which preparation steps should be included in the production system in order to convert to SAP S/4HANA Finance?The user should follow the following ...- How Often are OOM dumps written?
In case of OOM situations SAP HANA may write a dump, e.g.: <service>_<host>.<port>.rtedump.<timestamp>.oom.trc <ser ... 
Data Aging Function Technicality in SAP HANA
How does Data Aging in SAP S/4HANA function technically?The SAP NetWeaver ABAP has built a data aging mechanism for ABAP applications which is built o ...- Alter Table Add Column Statement Hangs in HANA DATABASE
User-Defined Field (UDF) Creation UnsuccessfulWhile creating a user-defined field (UDF) for a document on SAP Business One version for SAP HANA , the ... 
HANA Data Types
Data Types in SAP HANA Working on any type of database requires a complete understanding of the database and its various types. This in-dept ...- SAP HANA High Availability Guide
As a part of data center readiness, with the SAP HANA platform, one can easily set up high availability (HA) and disaster recovery (DR) operations. By ... 
How to limit SAP HANA Memory Usage by Single User?
How can we limit the HANA memory usage of a statement executed by the single user? The limit of SAP HANA memory usage can be set in the User Editor ...
Create the Analytic Privilege for HANA Modeling
Steps to Create the Analytic Privilege Go to the Analytic Privilege tab and create on New. A page opens up that lets you create an analytic privilege ...- SAP HANA Client does not Support Windows 8 or Windows 10
We are not able to install SAP Business One 9.2, version for SAP HANA because HANA client does not support Windows 8 or Windows 10.SAP Business One 9. ... - Parameter Mismatch Alert in HANA Studio
How to adjust parameters mismatch for system replication?We have system replication environment and we are getting following parameter mismatch alert. ... - Table growth of non-partitioned column-store tables: HANA Alert ID 20
We want to resolve the total memory size for table growth of non-partitioned column table but we are receiving the HANA alert ‘Table growth of n ... - M_SQL_PLAN_CACHE: Interpret Time Information in SQL cache
Answered
Hello Experts, How can time information in the SQL cache (M_SQL_PLAN_CACHE) be interpreted? Thanks in advance. SOLUTION Tables like M_SQL_ ... 
Difference between System, User and I/O wait CPU Consumption
Answered
User CPU vs. System CPU vs. I/O Wait CPUCPU utilization is typically separated in system CPU, user CPU and I/O wait CPU consumption: CPU utiliz ...
Single Space Handling for ABAP in SAP HANA
ABAP_VARCHAR_MODEAn empty string ('') has been stored in database tables as a single space (' ') in ABAP. Program rely on special handling of the empt ....jpg)
S/4HANA and Data Warehousing Serves to Handle the Data in Predictable Way
S/4HANA is that analytics which is incorporated into the HANA applications to bring analysis (experiences) and the potentially activities nearly toget ...- Configure Automatic SAP HANA Data Collection with HANASitter
How can we automatize conditioned capturing of specific SAP HANA information (e.g. triggering of a runtime dump when a significant amount of threads i ... 
Java Stack to correct HANA node after takeover or failover in HANA Multitenant Database Environment
How to point Java stack to correct HANA node after takeover or failover in HANA multitenant database environment?We are having SAP Java stack applicat ...
Generate runtime dump on SAP HANA
How to generate a runtime dump on SAP HANA?SOLUTION:There are three ways through which we can record the runtime dump:From the OS Level First Log into ...- Explain Plan for a Prepared SQL Statement
How can we collect ExplainPlan of a prepared statement for analysing the performance?SolutionUser can utilize the SQL Plan Cache in order to get plan ... - Datasource Configuration File 'config20.xml'
This tutorial gives the details information about the causes and solution of why the datasource configuration file "config20.xml" cannot be ... 
Old System Replication Snapshots Exist
System replication takes advantage of SAP HANA database snapshots. The retention time of these snapshots is defined with the following parameter: ...- COMMIT Operations Performance Optimization
During COMMITs the changes of the transaction are persisted to disk and made visible for other transactions.Factors can influence the time of COMMIT o ... - HANA Runtime Dump Main Parts
What are the important sections or parts of SAP HANA Runtime Dump?SOLUTIONThe SAP HANA runtime dump consist many sections which are described in the t ... - Hot Data and Cold Data-Data Aging in SAP S/4HANA
What is hot data?Current data is known as the data appropriate to the operations of application objects, which are required in day-to day-business tra ... - Create Partitions for Tables Participating in Data Aging
The SAP HANA database provides a special time selection partitioning scheme, referred to as aging. Time selection or aging permits SAP Business Suite ... 
Define Summarization Level
In this SAP HANA tutorial, we learn the step-by-step procedure to define the summarization level in the SAP system with proper screenshots. What is ...
Getting list of existing pool and cluster tables in the system
How to get a list of the existing pool and cluster tables in the system? User need wants list existing pool and cluster tables in the system, ...
Create customer/vendor BP with reference in S/4HANA
The feature 'Create By Reference'for Customers and Vendor in t-code BP is available from 1610 FPS02 in S/4 HANA Landscape. The user ...
×