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

Copyright © 2021. SAPBasisWorld.com Privacy Policy