Home Page - SAP Basis World

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.

Sybase – update to version 16.0 SP03 PL09

In my last post I wrote about bug in earlier Sybase version. Today shortly I show You how to update SYB database to newest version on SP03 level. I’ll be using saphostctrl command. The following steps are required.

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*

Sybase – Adaptive Server had XXX major and XXX minor page faults since boot

In last time I observed in my Sybase database situations like this:

The dataserver process of the SAP ASE server leaks memory – total size of memory allocated to the dataserver process is constantly growing.
SAP ASE server is inaccessible and silently crashes.
In logs I found many entries like in below frame.

SAP Security Notes Summary – May 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.

HANA – Ptime Exception: insufficient privilege: [2950] user is not authorized : occurred while unfolding

In a few words, I will try to outline the situation in which I get the error mentioned in the topic of the article.

Firstly, technical user was created to access HANA Calculation Views (CV).
Secondly, CVs are built in specific package and they are using data from other packages.
Thirdly, user can access one CV, which built as a projection from database table and is joined with two CVs generated by BW (master data).