If you want to add a new “HANA System” to your “HANA Administration Console”, then you can use the following steps…
Everything About SAP Basis
-
Inactive Partner Profile Was Found
You may get the error message like “Inactive partner profile was found” after a system copy operation for your BW system, then...
-
RFC connection CPIC-CALL: ThSAPOCMINIT, cmRc=2 thRc=679
You can get the “RFC connection CPIC-CALL: ThSAPOCMINIT, cmRc=2 thRc=679″ error while trying to make a connection on RZ70 or SLD_UC...
-
Huge difference by table TST03 between Memory allocation
Sometimes table TST03 can appear to be very large with it’s LOB segment, in this case, we need to check and compare the “Memory...
-
SAP extends support for Business Suite 7 from 2025 to 2027
SAP will provide mainstream maintenance for core applications of SAP Business Suite 7 software until the end of 2027 followed by optional extended...
-
DB Statistics on ORACLE Databases – RTCCTOOL Error for DVM
You can get the “DB Statistics on ORACLE Databases” error while executing RTCCTOOL on your SAP system with the DVM subject and the...
-
You Cannot Use a Request of This Type
When you want to save some changes to a transport request, then the error “You cannot use request SIDKXXXXX” happens and the transport...
-
Enabling SNOTE for Digitally Signed SAP Notes for 740 and Above
SAP recognizes a security threat during upload of SAP Note into customer landscape. The SAP Note can get modified maliciously and the customer can...
-
Enabling the System for SAP Note Transport-based Correction Instruction Rollback
You can rollback TCI similar to regular SAP Notes from Note Assistant. To do this, you first enable or update SNOTE for TCI rollback as follows,...
-
Enabling SNOTE for Transport-based Correction Instructions
SAP Note transport-based correction instruction (TCI) is a new way to deliver ABAP correction instructions to customer in a flexible manner. ...
-
SAP Technical Communication User for SAPHUB Connection
SAP provides a communication channel between SAP systems and SAP backbone systems, to be able to use this communication channel, customers must...
Find The Schema Owner of HANA Schema
If you want to know the owner of the HANA schema then you can use the following SQL statement , don’t forget that you need “READ Access” authorization to “SYS” schema to execute this sql.
Current size of the “Used Memory” in HANA
You can get the current size of the “used memory” for your HANA system easily with following SQL command…
Installation “XPI Inspector Tool” for Tracing the PI / PO Issues
We can check and collect the related informations and traces to solving the issues or improving the PI or PO systems’ performance via “XPI Inspector Tool”…
“no valid destination” when using logon groups and the SAP Web Dispatcher
Web Dispatcher trace file “dev_webdisp” shows the following messages in case of the situation ;
HANA Database Upgrade from 1.0 to 2.0
Start the process by following selection ;
HANA Administration Console -> Select the System -> Lifecycle Management
-> Platform Lifecycle Management -> SAP HANA Platform Lifecycle Management
SAP HANA Offline Cockpit
To diagnosis and analyze errors while SAP HANA is stopped or cannot be reached due to performance problems, you can access diagnosis files in the SAP HANA cockpit for offline administration.
SAP HANA Cockpit
If you want to administrate and monitor your SAP HANA databases , you can use the “SAP HANA Cockpit” tool.SAP HANA cockpit, a web-based HTML5 user interface that you access through a browser, runs on SAP HANA extended application services, advanced model.
Internal error: No PAT07 entries for package XXX
If you installed the SPAM/SAINT version 0063 and want to install a new Add-On or upgrade already installed Add-On , then you probably get the error message “Internal error: No PAT07 entries for package XXX” and installation queue will be failed.
WorkProcess Hangs on Program SAPLSENA with Reason ENQ
If your SAP work processes hangs on program SAPLSENA with the reason ENQ , then you should check the log files and compare you situation with this article…
SAP HANA License Types
You can find the details of “SAP HANA License Types” and difference of the “Unenforced” and “Enforced” options in this article…
Use SAP HANA HDBSQL to execute SQL commands at OS level
If you want to access SQL prompt using HDBSQL at OS level, then you need to follow below steps and passwords of the user <SID>ADM and one of the HANA database users’s password.
Check and Install HANA License
You can find the details of HANA licensing issues in this post, so you can; “Check” , “Get” and “Install” your SAP HANA license easily…
SAP HANA System START|STOP|RESTART Information Log
You can easily find the detail informations of your SAP HANA system; when was started/stopped/restarted from the log file “history.glf”
maximum number of connected terminals reached
If you are getting an error message like “maximum number of connected terminals reached” while trying to logon your SAP system then you should check the related profile parameter like described in this article.
Entry found in buffer with no data file(s) transferred yet
If you are getting an error message like “Entry found in buffer with no data file(s) transferred yet” while trying to import a transport request to your SAP system, you should check the following solution before trying to search on other sites 
SAPCONTROL Command Funtions for SAP HANA
You can use the “sapcontrol” command for various operations and informations on SAP HANA systems with assigned FUNCTION switches.
BR0022E Setting of BRARCHIVE lock failed
If you are getting an error message “BR0022E Setting of BRARCHIVE lock failed” with the detail information like “BR0021I Please delete file W:\oracle\<SID>\oraarch\.lock.bra if BRARCHIVE was killed” while taking BACKUP operation via DB13, then you should check the LOCK file situation like described in this article…
Possible Rowstore Table Corruption When Continuous Page Flush is Enabled
If you encounter corruptions in row store tables consistency check reports like “pointing to free variable part found;rowid=xxx;
offset=8;typeid=37;ext_rowid=xxx” then you should check the following OSS note and the steps which we completed.
Reset the HANA SYSTEM User’s Password
If your – HANA - SYSTEM user’s password is lost, then we can reset the password for this user as operating system administrator with starting the “index server” in emergency mode.
Object Missing in the Database
If you are getting an error like “Object Missing in the Database” in transaction DB02 then you should follow the steps below to eliminate the problem from you SAP system.
Unknown Objects in ABAP Dictionary
If you are getting an error message under the DB02 –> Missing Tables and Indexes –> Unknown Objects in ABAP Dictionary area, then you can follow the steps below to get rid of this error message for your SAP system.
Creating SERVICE in SUSE Linux Ent 12 SP1
If you want to make a process as a “service” and want to start that service at the time of booting of Suse Enterprise linux then you can check the following example to create your own service easily…
STRUST – Issuer Certificate Missing in Database
If you are getting an error message like “Issuer certificate missing in database” while importing the certificate response via STRUST transaction then try the following steps…
Featured Posts
-
Inactive Partner Profile Was Found
-
RFC connection CPIC-CALL: ThSAPOCMINIT, cmRc=2 thRc=679
-
Huge difference by table TST03 between Memory allocation
-
SAP extends support for Business Suite 7 from 2025 to 2027
-
DB Statistics on ORACLE Databases – RTCCTOOL Error for DVM
-
You Cannot Use a Request of This Type
-
Enabling SNOTE for Digitally Signed SAP Notes for 740 and Above
-
Enabling the System for SAP Note Transport-based Correction Instruction Rollback
-
Enabling SNOTE for Transport-based Correction Instructions
-
SAP Technical Communication User for SAPHUB Connection
Recent Comments