Home Page - SAP Basis World

SAP HANA – reclaim unused data

7 August 2021
admin
HANA

Below You find short instruction useful in the following cases:

You want to free unused space inside an SAP HANA database disk persistence.
You observe low percentage of Used/Total Size(%) of the Data Volume.
The Total Size of the Data Volume is too much larger than the Used Size.

SAP Security Notes Summary – July 2021

Once a month I’ll publish review all SAP security notes and news that were released in a given month. SAP Security Notes contain SAP’s expert advice regarding important action items and patches to ensure the security of your systems.

Transactional RFC and issues

Remote Function Call (RFC) is the standard SAP interface for communication between SAP systems. RFC calls a function to be executed in a remote system.

The remote system need not be available at the time when the RFC client program is executing a tRFC. The tRFC component stores the called RFC function together with the corresponding data in the database of the SAP system, including a unique transaction identifier (TID).

Zero administration memory management for the ABAP server

SAP Memory Management is used for the administration of the memory in Application Server ABAP (AS ABAP). With the default settings of profile parameters in SAP Memory Management (zero administration memory management), smooth operation of your system is ensured.

17 July 2021
admin
HANA

In last time in our HANA traces I encountered problem like this:

[115248]{233308}[35/1791487910] 2021-XX-04 12:16:44.190701 e EmbeddedAPI      ExternalStatement.cc(01360) : [external statement] unhandled exception (external statement execution): ERROR [SQL-301] unique constraint violated: Table(sap.hana.xs.dt.base.server.persistency.userpreferences::UserPreferencesIntern) with error: unique constraint violation on pos=0 for table SID::SAP_REST_API:sap.hana.xs.dt.base.server.persistency.userpreferences::UserPreferencesIntern$delta_1$en, key: $trexexternalkey$=8,USERNAME,sap.watt.common.content.service.ContentServicePersistence already exists as udiv=108 at SQLUpdate/Storage/Impl/ColumnStorageChange.cc:208exception  1: no.71000301  (SQLUpdate/Storage/Impl/ColumnStorageChange.cc:208) TID: 115248    Table(sap.hana.xs.dt.base.server.persistency.userpreferences::UserPreferencesIntern) with error: unique constraint violation on pos=0 for table SID::SAP_REST_API:sap.hana.xs.dt.base.server.persistency.userpreferences::UserPreferencesIntern$delta_1$en, key...

SAP Solution Manager 7.2 – secure storage link broken

In last time I had problem in transaction SOLMAN_SETUP. Exactly in Managed System Configuration in step: Maintain RFCs. Without any problem I displayed all available RFC connection but if I only clicked specific connection I was getting error as below…