HANA Tutorial
- What is the reason of duplicate entries in primary key of the SAP HANA DB.
You are facing duplicate entries in the primary key of your table in the SAP HANA DB. Prerequisite: You are using SAP HANA DB revision 36 or previo ... - Start of Shadow Instance Failed when upgrade Schema
Developer trace dev_w* shows the following warning and error because start of Shadow Instance failed during upgrade.Warning: Env(MSSQL_SCHEMA) [prd] & ... - HANA Cockpit URL Shows a Blank Page
When we open the HANA Cockpit, it always shows a blank page.Solution: The Role sap.hana.admin.roles::Monitoring or sap.hana.admin.roles::Administrator ... 
Parameter 'DBNAME' not specified in HANA Database
Getting an error when we create a HANA database connection using funtion "Managed System Configuration" on a solution manager system.The fol ...- What has to be Considered for Suite on HANA?
The minimum requirement for Suite on HANA is NetWeaver release 7.40.SAP cluster and pool tables are changed to transparent tables on SAP HANA, so comp ... 
SAP HANA Alert Monitoring
HANA is the solution for in-memory computing. SAP HANA is a flexible data source that allows customers to examine great sizes of data in real time. Th ...- Troubleshoot Grey HANA Metrics in Technical Monitoring
In Transaction SM_WORKCENTER or SOLMAN_WORKCENTER. We have selected Technical Monitoring, System Monitoring and systems - Select Managed System.It say ... 
Create a Calculation View for HANA Modeling
What does a Calculation View look like? Under the Calculation View Tab open the pre created Analytic view SALESTESTWhen you click on it, on the left s ...- Data Collector Performance Issues in DBA Cockpit
What are Data Collector Performance issues in DBA Cockpit? DBA Cockpit for SAP Sybase ASE sets up a number of data collectors. The defa ... 
SAP HANA Authentication Mechanisms
Authentication Mechanisms Supported by SAP HANAAuthentication is the process by which the uniqueness of database users gaining access to SAP HANA is c ...- Information about SAP HANA Threads
Information about current SAP HANA threads can be found at the following locations: Monitoring view M_SERVICE_THREADS SAP HANA Studio -> Administra ... - Runtime Error DBIF_RSQL_TABLE_UNKNOWN
Error DBIF_RSQL_TABLE_UNKNOWN while replicating the tables affected using SLT into HANA database.We have installed HANA application accelerator (add-o ... - Garbage Collection in SAP HANA Environments
SAP HANAWhat is garbage collection in SAP HANA environments? Solution In the SAP HANA environments, The term 'garbage collection' is qui ... 
SAP HANA DXC (Direct Extractor Connection) Overview
What is DXC (Direct Extractor Connection) ?Direct Extractor Connection (DXC) is a HANA Data Provisioning tool which utilizes the existing BW Datasourc ...- Audit Trail SAP HANA Security
Get Detailed Information On Those who Accessed SAP HANA database Auditing helps getting detailed information regarding who did what on SAP HANA dat ... 
SQLScript in SAP HANA
Function of SQLScript in SAP HANAMore numbers of customers today are opting for SAP HANA in order to get rid of the common problems that they face whi ...- HANA DB System Stop takes longer than Expected
Recently the Operating System firmware of Hana DB System with multiple instance has been upgraded. Therefore when logged in to OS level, running a com ... - HANA Alert 51 'Size of diagnosis files'
This tutorial focuses on why alert 51 is generated checking the size of diagnosis files in order to free the disk space for new logs, traces and to de ... 
SAP HANA Application Lifecycle Manager
Transporting native SAP HANA content with SAP HANA Application Lifecycle ManagerThis tutorial focuses on Application Lifecycle management aspects and ...
Data Aging in SAP S/4HANA
Data Aging is referred to as a Suite-tailored data management concept, provided by SAP NetWeaver ABAP and is primarily meant for reducing the SAP HANA ...- Configure Optimal Settings on SLES 11 SP2/SAP SP2 for running HANA
How can we configure optimal settings for running SAP HANA on SLES 11 SP2 or SLES 11 for SAP SP2?SolutionTo optimize the use of HANA DB with SLES 11 S ... - How can the resident memory be smaller than the allocated memory?
Normally the allocated memory should be fully contained in the resident memory, nevertheless there are a few exceptions: If parts of the virtual memor ... 
How Does S/4 HANA Help Earn the Money You have Invested?
S/4 HANA is known to be the latest innovative thought process by SAP and been designed with quite a few interesting features. Some of these being a go ...
Integration of Microsoft Excel with SAP HANA
How to Integrate Microsoft Excel with SAP HANAMicrosoft Excel is measured as one of the most popular Business Intelligence (BI) reporting and analysis ...
HANA Alert 17 'Record Count of Non-partitioned Column-store Tables'
How to handle ‘Record count of non-partitioned column-store tables’ HANA Alert 17?The alert called “SCHEMA.TABLENAME has record coun ...- Fix for getting current user from a stored procedure in SAP HANA DB.
Due to a programming error in SAP HANA DB Revsion 25 and previous, the function "CURRENT_USER" of a SQLScript procedure in definer mode retu ... 
SAP HANA Transport Container
Transporting ABAP for SAP HANA content with HANA content with HANA Transport ContainerWhat is HANA Transport Container?A HANA transport container is a ...
SAP HANA MDC Service Connection Setup
Setting up the SAP HANA MDC connection is divided into 3 stages: Determining the ports used (SystemDB and http(s)). Setup on your SAProuter. Setting u ...- Common Errors reported by CHECK_TABLE_CONSISTENCY
Answered
What are Common Errors reported by CHECK_TABLE_CONSISTENCY? In general, you should execute the consistency check again on any table displaying crit ... - HANA Studio not responding when uploading large MS Excel files
Whenever we are uploading a large MS Excel files using the option File -> Import -> SAP HANA Content -> Data From Local File, SAP HANA Studio ...
×