Hana table partitioning | re-partitioning | Improve Performance

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 takes lot of time and customer wants to optimize overall run-time of table partitioning . Here i am providing tips to improve total run-time of Hana table partitioning along with table partitioning steps: Run delta merge on table before re-partitioning . Command for delta merge “MERGE ……

EHP8 Upgrade Error ‘SPDA_DISASSEMBLE_QUEUE’ EHP_INCLUSION Phase

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 message (CM_NO_DATA_RECEIVED) 1EETQ399XIf you put new packages in the download directory, use option ‘init’ to upload them 1EETQ204 Upgrade phase “EHP_INCLUSION” aborted with severe errors (“20190807115630”)   Solution: Not able to get any clue from SUM log files .It was giving same error logs highlighted ……

How to Fix “Start of UME Service Failed” in JAVA System

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 startup of the AS Java. Aug 2, 2019 12:22:39 PM …re.server.ume.service.UMEServiceFrame [SAPEngine_System_Thread[impl:5]_125] Fatal: service com.sap.security.core.ume.service ================= ERROR ================= Core service com.sap.security.core.ume.service failed. J2EE Engine cannot be started. com.sap.engine.frame.ServiceException: Start of UME service failed. Check help topic “Start of UME Service Failed”. Technical details: Name or ……

What is UPGANA.XML and File Location-How to access it.

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 file provides information about phases which took longest time in the upgrade process and we can investigate and see improvement scope for long running phase.   UPGANA.XML File Location: The UPGANA.XML file can exist in either: ../SUM/abap/htdoc/UPGANA.XML for SUM 1.0 ../SUM/abap/doc/analysis/UPGANA.XML for SUM 2.0 Note: ProcessOverview.html is ……

How to Stop and Start SAP HANA Tenant Database

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 commands for Stop and Start SAP HANA Tenant Database.   How to Stop SAP HANA Tenant Database: ( SMH is TENANT DATABASE SID): alter system stop database SMH   How to verify if Tenant database has been stopped: Execute SQL command: select * from m_databases; ACTIVE ……

How to Generate full system dump in hana

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 created 2019-07-22 11:09:20 (UTC) with script version 2.00 Called with command line options: -t <TENANT SID> Writing to file /usr/sap/<SID>/SYS/global/sapcontrol/snapshots/fullsysteminfodump_SMH_SM1_solman_2019_07_22_11_09_20.zip —– 2019-07-22 16:39:20 Generate esserver stack file —– SNo running esserver found for database <TENANT SID> —– 2019-07-22 16:39:23 Exporting xsenginetraces —– No files found matching ……

How to Generate a Runtime Dump on SAP HANA

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 sidadm user 2) Run command ‘hdbcons’ 3) On the hdbcons console run command below > runtimedump dump This will create a runtimedump for the host . runtime dump file will be under traces directory with naming like ‘indexserver….rtedump.trc’.   Generate runtime dump from Python script ……

kernel profiler trace HANA

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 command as HANA sidadm >hdbcons -p <pid_of_the_problematic_tenant_indexserver> >profiler clear >profiler start {wait for 4-5min} >profiler stop >profiler print -o profiler_cpu.dot,profiler_wait.dot   This will basically create a kernel profiler trace and a HANA runtime dump. The tracefiles will be stored in the HANA tracedirectory.   SAMPLE ……

Oracle 18c installation-Prerequisite checks fails-PRVG-0282 : failed to retrieve the operating system distribution ID

Problem : During Oracle 18c installation while running prerequisites check it fails with below error . “PRVG-0282 : failed to retrieve the operating system distribution ID” The command used was: ./RUNINSTALLER -ohcheck Next step and resolution : Check if your Oracle18C is supported with your operating system version and check oracle documentation for supported version mapping.In my case i was getting error on SLES 12 SP 03 which is supported to oracle 18c. If you are on supported version of operating system then set below parameter to ignore this error: CV_ASSUME_DISTID=SUSE12   parameter in the /oracle/<SID>/18.0.0/cv/admin/cvu_config file.  in case of  oracle ……