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.
Everything About SAP Basis
-
Inconsistency in SOAMANAGER after a System Refresh
You can receiving an error stating “There are severe inconsistencies in the Web Service configuration” when you try to access...
-
Logon Error : Select one of the installed languages
If you get an error message “select one of the languages” while trying to logon SAP system with specific language, then you should check...
-
No System Found in Another Group for Import Queue SID
If you get the error message “No System Found in Another Group for Import Queue SID” while trying to import a transport of request in...
-
SAP Host Agent error: Unable to open sumjava_connectivity with Permission Denied message
When you try to start SUM Java page, “HTTP 404 Not Found” page comes with “Unable to open connection file …… Permission...
-
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...
-
Find out inactive RFC Definitions in SM59
If you want to find out which RFC definations are not using under SM59 transaction for your SAP system, then you can use the “Check Internal...
-
HCM Renewal 2.0 post Upgrade activity from HR-CEE Add-on Dumps for SAPLHRPL MP000800
After upgrading HCM Renewal Add-on, system may get some “SYNTAX_ERROR” dumps for some programs like...
-
BRTOOLS Actions “could not load SSF library” Warning
After the Kernel upgrade, you can get the “BR1301W Error message from likeywlib: 543 likey_init: Couldn’t load SAPSECULIB...
-
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...
-
IDOC is ready for dispatch (ALE service)
You can see the message “IDOC is ready for dispatch (ALE service)” in the transaction BD87 and your IDOC’s cannot be send to the...
Change Request Must be Assigned to a Project
If your are getting a message like “Change Request Must be Assigned to a Project” while trying to get a change request on a SAP system, then you can check the below settings to be sure that related client is configured as “must be assigned to a project” or not.
SUM Error : ConnectContext for /lmsl/sumjava/SID failed
If you are getting an error like “ConnectContext for /lmsl/sumjava/SID failed” in your HostAgent log files while trying to start SUM tool, then you can try the following solution to eliminate the situation.
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 Host Agent “Profile permission violation” Error
If you are getting an error like “Profile permission violation” from SAP Host Agent while especially SUM operations then you need to check “host_profile” is editable for another user than the root user.
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…
SLD Content (Model Version and SAP_CR) Update
If you are getting an error like “Cannot perform the selected import” while loading “CIM Model” or “CIM Data” on SAP NW SLD (System Landscape Directory) because of the version situation, then you need to update related model version and the content of your system…
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…
List all Connected Applications to SAP HANA
You can use below SQL query to list all application connections which are connected to SAP HANA system from SQL editor.
LIST & KILL Sessions on HANA
If you need to LIST all sessions or KILL a specific active session on HANA then you can use the following SQL queries to do these kind of actions easily..
Check Memory Usage and DB Size on HANA via SQL
You can use the following SQL queries to check your HANA system’s memory usage details…
Activate / Deactivate user in SAP HANA DB
The administrator can “activate / deactivate” a user account with the following SQL command or SQL console of the SAP HANA studio, the only prerequisite is, you need to have system privilege “USER ADMIN”.
CHECK_REQUIREMENTS QUEUE_NOT_EMPTY Error while SPAM Update
You are trying to update your SPAM version on your SAP system and process canceled with the error CHECK_REQUIREMENTS –> QUEUE_NOT_EMPTY.In this case, you can check the below steps to clarify and solve the issue…
HANA Backup and Recovery SQL Queries
You can find some helpful SQL queries in this article to check your HANA database backup status to use in case of recovery situation.
Useful Python Scripts for HANA
All python scripts can be found in exe/python_support directory.
These scripts can affect the system therefore it’s better to check with ‘-help’ switch before executing the scripts.
Featured Posts
-
Inconsistency in SOAMANAGER after a System Refresh
-
Logon Error : Select one of the installed languages
-
No System Found in Another Group for Import Queue SID
-
SAP Host Agent error: Unable to open sumjava_connectivity with Permission Denied message
-
Error: Backint exited with exit code 2 instead of 0. console output: No additional Information was received
-
Find out inactive RFC Definitions in SM59
-
HCM Renewal 2.0 post Upgrade activity from HR-CEE Add-on Dumps for SAPLHRPL MP000800
-
BRTOOLS Actions “could not load SSF library” Warning
-
Import of HANA Delivery Unit Activation Error
-
IDOC is ready for dispatch (ALE service)
Recent Comments