I Help You Better Understand The SAP Basis World

1
Zero administration memory management for the ABAP server
2
SAP HANA – unique constraint violation
3
SAP Solution Manager 7.2 – secure storage link broken
4
SAP PO – increase performance…
5
SAP Security Notes Summary – June 2021
6
STAT files grow too large

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...
Read More

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

Read More

Copyright © 2026. SAPBasisWorld.com Privacy Policy