Home Page - SAP Basis World

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.

SAP HANA – unique constraint violation

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…

SAP PO – increase performance…

Below You’ll find some tips which should be kept in mind if You want to increase the performance of Your SAP PO system. I note that these are only guidelines and more details You can found in the attached notes… The article will be divided into several sections.

SAP Security Notes Summary – June 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.

STAT files grow too large

If Your configuration is bad You can observe the STAT files in the DIR_DATA directory start growing to very large sizes. For example each stat file could be hundreds of MB or more. This can start filling up the file system. Below You find solution and you will be able to control this problem