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.
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...
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…
Deactivating HTTPs for Webdynpro pages
If you want to deactivate HTTPs redirection method for “Webdynpro” pages, then you can use the below steps to do it easily…
CMC/BI LaunchPad Session Timeout
If you are getting an error “CMC/BI Lanunchpad Session Timeout” due to default value of 20 min. then you can change this value up to 60 min. with following easy steps.
Business Objects Upgrade from 4.0 to 4.1 sp4
This document describes the upgrade process of the “Business Objects Software” from the version 4.0 to version 4.1 sp4.You can download the related files from following service.sap.com location
Windows Pagefile Calculator
You can easily calculate your pagefile requirements with the excel file which included in the SAP Note 1518419
The standalone Software Update Manager GUI is no longer supported
If you are getting an error like “The standalone Software Update Manager GUI is no longer supported. You have to use the browser-based SL Common GUI. For more information, see section SL Common Graphic User Interface of the SUM user guide” while attempting to start SUM tool then you should check the following note.
SAP HANA Studio Installation
You can easily install “SAP HANA Studio” in this article , just follow the steps…
Download SAP HANA Studio
If you have a valid user ID from SAP then you can download “SAP HANA Studio” from SAP Service Market Place with the following address
HANA Cloud Platform for Trial
SAP provides a trial instance of HANA Cloud and you can be used for learnind porposes.If you want to discover new SAP HANA Cloud Platform for free then you can create a trial account with the following steps easily…
HANA TCP/IP Ports
You can find the TCP/IP (Transmission Control Protocol/Internet Protocol) ports for HANA system in this post.
Suite on HANA Sizing Report
If you are wondendering of your SAP Suite system’s “Memory and DB” size transformation after a HANA migration operation then you should implement the following OSS notes and execute the SAP report “/SDF/HDB_SIZING” to get these detail informations.
HANA Installation on SUSE Linux
You can install the HANA on SUSE linux OS system accordingly this post easily , just follow the screens and check the remarks…
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