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.
Everything About SAP Basis
-
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...
-
STARTSAP_NBAS Phase Canceled with Error ipc/shm_psize_40
SUM upgrade SAP Netweaver from 7.31 to 740 was canceled in the STARTSAP_NBAS phase with the error of “ipc/shm_psize_40″ parameter value...
-
User Type is Not Active
Sometimes you can get the error like “User Type “XX” is Not Active” message while you are creating a new user via SU01, in...
-
Adding Server Process (Node) to SAP JAVA Stack
The installation procedure configures the optimal number of server processes in an instance based on the available hardware resources. This enables...
-
Kernel NMI watchdog: BUG: soft lockup error on SUSE Linux 12 SP2
If you are getting an error like “Kernel NMI watchdog: BUG: soft lockup error” for your SUSE Linux 12 SP2 OS, then you can check the...
-
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...
-
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...
-
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,...
-
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...
-
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. ...
STARTSAP_NBAS Phase Canceled with Error ipc/shm_psize_40
SUM upgrade SAP Netweaver from 7.31 to 740 was canceled in the STARTSAP_NBAS phase with the error of “ipc/shm_psize_40″ parameter value and solved with the following steps that you can find in this article…
User Type is Not Active
Sometimes you can get the error like “User Type “XX” is Not Active” message while you are creating a new user via SU01, in this case it’s a good idea to check transaction USMM (System Measurement) transaction code to clarify the issue…
Adding Server Process (Node) to SAP JAVA Stack
The installation procedure configures the optimal number of server processes in an instance based on the available hardware resources. This enables optimal utilization of the hardware resources and of the capacity of the ICM to handle multiple server processes.
Kernel NMI watchdog: BUG: soft lockup error on SUSE Linux 12 SP2
If you are getting an error like “Kernel NMI watchdog: BUG: soft lockup error” for your SUSE Linux 12 SP2 OS, then you can check the below parameter to solve it.
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.
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…
Featured Posts
-
Table Config for Index is Not Valid
-
STARTSAP_NBAS Phase Canceled with Error ipc/shm_psize_40
-
User Type is Not Active
-
Adding Server Process (Node) to SAP JAVA Stack
-
Kernel NMI watchdog: BUG: soft lockup error on SUSE Linux 12 SP2
-
HANA Log Status Check Point in Time Recovery Possible or Not
-
HANA Log File System is Full
-
Change Request Must be Assigned to a Project
-
SUM Error : ConnectContext for /lmsl/sumjava/SID failed
-
Specifying the port for SAP HANA Cockpit before installation
Recent Comments