2021 - Page 6 of 11 - SAP Basis World

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

SAP HANA – problem with allocator: Pool/RowEngine/GlobalHeap

In HANA version: 2.00.048 You can observe some memory leak. The problem is mainly visible in this collector: Pool/RowEngine/GlobalHeap. It can use 70-80GB of RAM and more during calculations. SAP note 1999997 indicates that the problem can only occur until Hana 2.00.046 but we already know that’s not true. Meanwhile a note 2902494 says about leaks on this pool, but still doesn’t provide a solution. Parallel to the above allocator, you may also observe a problem with another allocator i.e. Pool/RowEngine/QueryExecution/SearchAlloc.

Archive - 2021