inifile_checker –> enable = True & [inifile_checker]/replicate = true Key Highlights : [inifile_checker]/replicate = true- This parameter is very useful in the scenario where we have muli -tier and multi-target replication setup in the landscape . If we are changing any parameter in the primary site and [inifile_checker]/replicate = true- parameter is enabled then automatically it will…
Hana table partitioning is one of major problems for most of the customers to re partition of HANA tables due to the reason that a table partition cannot contain more than 2,147,483,648 (2 billion) rows. During the time customer need to perform table re partitioning due to 2 billion limit and For large tables – table partitioning…
Issue: During EHP8 upgrade ,we faced issue during SPDA_DISASSEMBLE_QUEUE step of EHP_INCLUSION Phase. 4 ETQ399 … ERROR in patch queue handling 1 ETQ124 Scanned file ‘log/SPDA_EHP_INCLUSION.LOG’ from offset 548255 to 846628 for errors. 1EETQ399 Last error code set is: RFC system SID nr 00 function ‘SPDA_DISASSEMBLE_QUEUE’ 1EETQ399XRFC failed with code 1 key RFC_COMMUNICATION_FAILURE: 1EETQ399Xconnection closed without…
Issue: If your Java system server nodes are not coming up and in the server log files you see similar entries as below . Aug 2, 2019 12:22:39 PM com.sap.security.core.persistence [SAPEngine_System_Thread[impl:5]_125] Fatal: Initialization of ABAP data source (com.sap.security.core.persistence.datasource.imp.R3Persistence) failed: “Name or password is incorrect (repeat logon)”. This message is critical if it appears during the…
After the successful completion of an upgrade via Software Update Manager (SUM) tool, UPGANA.XML file plays important role for doing run time analysis. and it is very important in case of we need to analyze our previous mock upgrade run-time behavior and based on analysis we want to improve downtime for upcoming upgrade . UPGANA.XML…
There are multiple way to stop and start SAP HANA Tenant Database . But i personally prefer to stop and start SAP HANA Tenant Database using SAP HANA Studio . Step 1- Launch SAP HANA Studio and open SQL console . Once SQL Console is open then you can execute below mentioned sql…
In this tutorial I’ll explain How to list all the HANA databases for Multi tenant Databases. Step 1– Launch SAP HANA Studio and open SQL console .( using SYSTEMDB) Step 2 – Execute query ” select * from m_databases “. Note: If above query is executed from different user apart from “SYSTEM”…
If You are experiencing high memory consumption / out of memory situations . SAP is asking you to generate full system dump for further analysis. This blog with help you to generate Generate full system dump in hana. Goto /usr/sap/<SID>/HDBXX/exe/python_support directory Run python script fullSystemInfoDump.py as following: <HOSTNAME>:/usr/sap/<SID>/HDB10/exe/python_support> python fullSystemInfoDump.py -t <TENANT SID> System Info Dump…
If You are experiencing high memory consumption / out of memory situations . SAP is asking you to generate a runtime dump for further analysis. This blog with help you to generate a runtime dump in HANA database. Easiest way to generate runtime dump is from OS Level: 1) Log into the HANA host as…
How to Generate Kernel Profiler trace in HANA If You are experiencing high memory consumption / out of memory situations . SAP is asking you to provide a Kernel Profiler Trace. This blog with help you to generate kernel profiler trace in HANA database. start a kernel profiler trace on OS level by running the following…