SAP HANA corrections are shipped in the form of “Revisions” and “Support Packages”, new capabilities are only comes with SAP HANA Support Package Stacks “SPS” for once a year.
Everything About SAP Basis
-
Asking and Answering Questions in the SAP Community
SAP provides a convenient channel through which you can ask questions about any SAP topic. Before asking a question, you can also browse...
-
Performance Issues on ABAP Stack
Today we are going to check performance issues on ABAP stack…The system may be up and running, but performance issues will hurt...
-
What is RISE with SAP ?
RISE with SAP is a “Business Transformation as a Service (BTaaS) product that focuses on shifting customers into the SAP cloud product...
-
SAP Spool : “Waiting in host spooler (Position 1)”
When you get an issue on printing side of your SAP system and you found the error “Waiting in host spooler (Position 1)” then you can...
-
SAP Security Patch Day for December 2022
On 13th of December2022, SAP Security Patch Day saw the release of 14new Patch Day Security Notes. Further, there were 5updates to previously...
-
ITAB_DUPLICATE_KEY in XPRA phase
If you are getting the ITAB_DUPLICATE_KEY error while you are in XPRA phase like shown in the following structure, then you can check the solution...
-
“Upgrade is running! No import possible” in ACT_UPG
If the SAP system in upgrade mode and no import possible, then you can use the following database query on the “UVERS” table. ...
-
ORA-12154: TNS:could not resolve the connect identifier specified
You may get “ORA-12154: TNS:could not resolve the connect identifier specified” error in your workprocess log file while trying to start...
-
SAP Security Mandate: SAP Software and Log4J Remote Code Execution
SAP continues to investigate the remote code execution vulnerability (CVE-2021-44228) related to Apache Log4j disclosed on Dec 10, 2021. SAP...
-
SAP HANA 2.0 Revision Strategy
SAP HANA corrections are shipped in the form of “Revisions” and “Support Packages”, new capabilities are only comes with SAP...
Password was not used for a long period message on HANA
If you are getting trouble while trying to log on a SAP system with the message “Password was not used for a long period and therefore deactivated” on a HANA database system, then you can solve it easily with the following SQL statement.
HANA Backup Status Check via SQL
When you are getting an error while taking the HANA backup, you can check the backup status via SQL to ensure backup is still running or not with the following SQL statement.
Support Package Stack (SPS4) Upgrade on HANA 2.0 Server
This post will show you how can you upgrade your HANA database from HANA 2.0 SPS3 to HANA 2.0 SPS4, so you can easily implement the same steps on your HANA system to upgrade from any SP level to any SP level.
HANA Hardware Check Tool Landscape Script Error : EvalOs is Not Registered
You may get an error message like “EvalOs is not registered” after when you try to check you HANA system with “HANA Hardware Check Tool” for “Landscape Check”, in this case solution is very simple…
Adding SYSTEMDB database via DBACOCKPIT for DB13 Actions
If you want to manage your HANA SystemDB backup operations via DB13, then you can use the following steps to configure easily…
Error: Backint exited with exit code 2 instead of 0. console output: No additional Information was received
While using “backint” for backup on HANA database, backup process is cancelling with the error message “Error: Backint exited with exit code 2 instead of 0. console output: No additional Information was received”
Import of HANA Delivery Unit Activation Error
You can get the “Import of HANA Delivery Unit Activation” error while SPAM / SAINT or SUM operations on your HANA system, in this case you can check the below steps to solve the issue…
Table Config for Index is Not Valid
After upgraded SAP NW version from NW 7.3 to NW 7.4 on BPC (BW) systems with HANA database, BEX analyzer can give the error like “table config for index SAPSR3:….. is not valid”, also you can get this error message after homogeneous copy operations on BW systems.
HANA Backup Filename, Destination and Size Informations
You can check the SAP HANA backup Destination Path, Backup Size, Destination Type etc. informations via below SQL script.
HANA Log Status Check Point in Time Recovery Possible or Not
Production database has to be in RECOVERY mode all the time.If a SAP HANA database log mode in set to OVERWRITE, backup can still be done but recovery will only be done at the date of the backup.
HANA Log File System is Full
If hana log file system is full, then your DB will not be response.In this case you need to check below steps and you should not delete any log files on disk manually.
Specifying the port for SAP HANA Cockpit before installation
During the installation of SAP HANA Cockpit, the installation assigns free ports to SAP HANA Cockpit and SAP HANA Cockpit Manager.
Installing HANA Cockpit 2.0
SAP HANA cockpit is part of the SAP HANA platform 2.0.The SAP HANA 2.0 Cockpit install comprises XS Advanced, a set of XSA multi-target applications, and HANA Express.A single HANA 2.0 Cockpit can administer and monitor many SAP HANA database systems, including both SAP HANA SPS12 and SAP HANA 2.0 systems.
SAP HANA Database Software Installation
Installing “SAP HANA Database Software” is very easy prosedure with the command “hdblcm”, you only need to provide needed command line informations and thats it..
HANA Database Server Uninstall
If you want to uninstall your “SAP HANA Database Components” on DB server installation, then you can use the command “hdblcm” and complete the unintall operation fast and easily….
SAP Application Server on HANA Uninstall Steps
If you want to uninstall your SAP HANA “Application Server” then you need to use “./sapinst” option of SWPM to do it easily…
Find SAP HANA Database LOG and TRACE File Directories
HANA LOG and TRACE files are located under /usr/sap/< SID >/HDB< Instance number >/< hostname >/trace directory.If you are using multitenant structure, then this directory shows SYSTEMDB and you can find TENANT logs and trace files under own directory (DB_SID).
HANA Software Installation via “hdbinst” command
You can install HANA database easily via command “hdbinst” on OS level in approximately 15 minutes (you can use “hdbsetup” for GUI installation)…
Get Description for a HANA Table Instead of usage DESC
There is no DESC command on HANA database to get “description” about a table structure, therefore if you need to get this information u can use the following SQL command on HANA database…
Create Diagnosis Dump File with HANA Studio
We can create the “Diagnosis File” via HANA Studio to use in case of our incedent requests.File generation process will take from seconds to minutes according to you HANA Database and using the HANA Studio is the easiest way to create these diagnosis files with just a few clicks…
Upgrade HANA 1.0 to HANA 2.0 on OS Level
You can find “Upgrade HANA 1.0 to HANA 2.0 via Hana Administration Console” in the blog but this time we are going to do this on “Operation System” level…
Find Active HANA Ports via SQL Queries
If you want to list “Active HANA Ports” on OS or HANA Admin Tool via SQL, then you can try to use below SQL queries to do it easily ;
SAP HANA Status Check via SAPCONTROL
You can easily check you SAP HANA system’s status on Linux system via “sapcontrol” command…To do this “GetSystemInstanceList” and
“GetProcessList” switchs are enough…
Featured Posts
-
Asking and Answering Questions in the SAP Community
-
Performance Issues on ABAP Stack
-
What is RISE with SAP ?
-
SAP Spool : “Waiting in host spooler (Position 1)”
-
SAP Security Patch Day for December 2022
-
ITAB_DUPLICATE_KEY in XPRA phase
-
“Upgrade is running! No import possible” in ACT_UPG
-
ORA-12154: TNS:could not resolve the connect identifier specified
-
SAP Security Mandate: SAP Software and Log4J Remote Code Execution
-
SAP HANA 2.0 Revision Strategy
Recent Comments