Category - HANA

Below You find short instruction useful in the following cases:

• You want to free unused space inside an SAP HANA database disk persistence.
• You observe low percentage of Used/Total Size(%) of the Data Volume.
• The Total Size of the Data Volume is too much larger than the Used Size.

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

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.

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.”