Category Archives: HANA

Output of the Report RSUSR003 in SAP HANA

What is the need of checking report RSUSR003? Sometimes you need to check whether all standard users are not having default password or exists. Having a default password of SAP* in production system can lead to a major security breach. Here we are going to open execute report RSUSR003 in our HANA production system. To know… Read More »

HANA High Availability Cluster Testing – Part 2

This is the second post for HANA High Availability Cluster Testing. Please refer to HANA High Availability Cluster Testing – Part 1 before going through below post. TEST 5: CRASH PRIMARY SITE NODE (NODE 1) Simulate a crash of the primary site node running the primary HANA database. TEST PROCEDURE Crash the primary node by… Read More »

HANA High Availability Cluster Testing – Part 1

In the earlier posts, we have learned Concepts of High Availability in HANA. Now we will learn about HANA High Availability Cluster Testing. Now we need to test whether our configuration is working as expected. Auto-failover – in this method you need to deploy additional host to the current HANA database and configure it to work… Read More »

Hana Architecture Overview

Hana Architecture Overview: “HANA” means High-Performance Analytic Appliance is a combination of hardware and software platform.SAP HANA Database is Main-Memory centric data management platform. The database runs on SUSE Linux Enterprises Server and builds on C++ Language. SAP HANA Database can be distributed to multiple machines. HANA Features Few of the important HANA features are listed… Read More »

How to Check HANA Replication status

How to Check HANA Replication status? There are some ways to gather information about the overall status of the sites and of the system replication. One is via HANA Studio. We can go inside Landscape and then go to System Replication. Using landscapeHostConfiguration.py Check the overall status of the primary system using as <sid>adm OS… Read More »

ADS (Adobe document services) issues in HANA and troubleshooting steps

ADS (Adobe document services) issues in HANA and troubleshooting steps: Issue :1 Error message: ‘com.adobe.ProcessingError: File not found on URL location: dest:FP_ICF_DATA_<SID>//sap/bc/fp/form/layout/<form name>.xdp?fp-language=<language key>. Login to java portal where ADS is installed. In our case, we have installed in the solution manager JAVA system. Go to Configuration and then click on Destination Service as shown… Read More »

SQL Commands used for HANA database user

SQL Commands used for HANA database user The following sql command will show details for all sap hana users with deactivated status. Query: select USER_NAME, USER_DEACTIVATED from “SYS”.”USERS”; After executing the command, we will get below message: Statement ‘select USER_NAME, USER_DEACTIVATED from “SYS”.”USERS”‘ successfully executed in 247 ms 698 µs (server processing time: 0 ms… Read More »