Category - HANA

1
SAP HANA – a data backup cannot be created because another data backup is running
2
SAP HANA – Replicated table with LOB columns is much bigger than in source system
3
SAP HANA – reclaim unused data
4
SAP HANA – unique constraint violation
5
SAP HANA – problem with allocator: Pool/RowEngine/GlobalHeap
6
Recommendation – Learn more about SAP HANA Cloud

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

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.

Read More

Recommendation – Learn more about SAP HANA Cloud

Maybe You’ll be interested. Today I found information: “SAP HANA Product Management runs a Customer Engagement Initiative (CEI) for SAP HANA Cloud. Join the “Kick-starting with SAP HANA Cloud – Deep Dives & Customer Feedback” Initiative to learn more about SAP HANA Cloud, our latest database solution.”

Source: https://influence.sap.com/sap/ino/#/campaign/2726
Read More

Copyright © 2021. SAPBasisWorld.com Privacy Policy