Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by SAP Developer
Page 4 of 7
Diagnosis file of unavailable tenant in SAP HANA database
When a tenant database is unavailable due to some performance problems, the tenant database administrator can't access diagnosis files. In this case, a system administrator can access the diagnosis files of the tenant database from the system database using the SAP HANA studio.In the SAP HANA studio, open the Administration editor and choose Diagnosis Files and diagnosis files of the system database are displayed.Using the Database filter, select the tenant database → whose diagnosis files you want to see and diagnosis files of the selected tenant database will be displayed.
Read MoreCopying or moving a tenant database in SAP HANA
When you move or copy a tenant database, data is replicated from the original tenant database to the new tenant database in the target system. Following tables shows type of data replication for different type of data −Data and logs of the tenant databaseYesTrace and log files NoData backups NoConfiguration (*.ini) files with tenant-database-specific values NoCertificates and certificate collections stored in the tenant database Yes
Read MoreLock down of SAP HANA system
A SAP HANA system lockdown in the following scenarios −The temporary license key has expired.When a temporary license key is in use and the hardware key has changed.When permanent license key has expired and it is not renewed within 28 days.When installed license key is an enforced license key and the current memory consumption exceeds the licensed amount plus the tolerance.When all license keys installed in your database are deleted.You can’t run a query in lockdown mode and only a License Administrator can connect to database.
Read MoreLoading an individual column in SAP HANA using SQL
Yes, you can open SQL console and execute the statement −LOAD (, ...);This SQL query will load or unload entire column into or from main memory. Its load status is TRUE or FALSE. The table's load status is PARTIALLY.
Read MoreDifferent Package type in SAP HANA
In SAP HANA, packages are used to store design time repository objects under the Content folder in HANA Studio. You have two types of the package in HANA system:Structural This package only contains sub-packages and doesn’t store repository objects.Non-Structural This package stores both repository objects and sub-packages.
Read MoreM_Expensive statement in SAP HANA
This can be checked using system view M_EXPENSIVE_STATEMENTS.SELECT * FROM M_EXPENSIVE_STATEMENTSIn SAP HANA, the M_EXPENSIVE_STATEMENTS view provides convenient access to the most expensive statements that were executed on the system. A statement is considered being expensive if its runtime exceeds a particular threshold. Please note that the expensive statements trace needs to be activated first in the Performance → Expensive Statements Trace screen in the SAP HANA studio. Click Configure the Trace Configuration dialog
Read MoreMaximum number of columns in a table in SAP HANA
The maximum number of columns in a table is 1000.
Read MoreChecking various details in SAP HANA in multitenant environment
You can check the landscape of HANA system, navigate to Landscape tab in HANA studio. Services show all the services running on HANA system.The following screenshot shows SAP HANA system and all the key services running under system Landscape for the same system.You can see the service name corresponding to each server in HANA system landscape.
Read MoreIn SAP Business One, making HTTP request with SOAP body
You can use web services wrapper provided by SAP which allow programmer to use the services provided by DIS. To perform an easy integration, it is possible to use SoapUI in open source version. The connection is performed using login service and with reference of its wsdl, login request can be created and XML definition of message san be seen. 192.168.90.118 DB_TestConnection dst_MSSQL2008 manager Kuldip ln_English 192.168.90.118:30000 To connect SAP Business One to a program, there are various options that you can try. For more details you can refer this link −https://blogs.sap.com/2014/07/28/connecting-an-add-on-to-sap-business-one/
Read MoreValidity of SAP HANA permanent license after expiry
Note that the validity of your permanent License key is till predefined date and when it is expired, a temporary license key is issued, with a validity for only 28 days. During this period, you have to install a permanent License key again.
Read More