Deprecated feature API from component REPOSITORY

[mbortolon]

Hello experts

In a fresh installation(only "server") of SAP HANA DB 2.0 SPS03(036) my tenants and the systemdb sometimes show this warning:

For this warning there is the note: 2465027 - Deprecation of SAP HANA extended application services, classic model and SAP HANA Repository
(starting from the father note: 2425002 - SAP HANA 2.0: Deprecations reported by the HANA statistics server)

but I cannot understand why I have to do these activities in a fresh system, it not an upgrade from HANA 1.0!

Thanks,
Marco

[dennispadia]

Hello Marco,

Yes you are right it happens only from HANA Studio as from cockpit you cannot access catalog folder which calls the procedure call SYS.REPOSITORY_REST (?,?) to check authorization for content folder. As this alert is set to run once a day, if anyone from team has accessed catalog, the call count will gradually increase and this alert will stay.

Below is my observation, you can try at your side as well. Perform this in HANA Database > 2.0 SPS 03

Open SQL Plan > filter using "repository". Note call SYS.REPOSITORY_REST (?,?) last execution time. It you find no row, then proceed with next step

Also execute below query and note down the call_count and last_timestamp

Now expand "content" folder in HANA studio.

Now again go back to SQL plan cache or refresh if you have already have the screen. The time stamp is now changed.

Also check below query, the call count is now increased.

This is just my observation. There might be other cases as well where it calls API feature which I'm still exploring.

Regards,

Dennis

[mbortolon]

Thanks!

This is clear but how can I avoid this problem? I've 2 SYSTEMDB and 8 tenants, it means 10 emails at day plus the others
PS: I can use the CATALOG also from HANA Cockpit

[dennispadia]

Hello Marco,

CATALOG usage from HANA cockpit doesn't call the procedure REPOSITORY_REST to check authorization. Instead it uses some other method for authorization check. I can suggest two solution but I'm not from SAP so this words are basically my take on this issue.

1) You can disable this alert as you have mentioned that you have installed new HANA database. So you won't be using any old functionality which you want to be alerted for. I feel SAP has incorporated this alert so user can take necessary action before they can actually decomission functionality.

2) Start using HANA Cockpit as all new advancement is coming in cockpit only and chances are HANA studio will be going out of support in near future

Regards,

Dennis.

[mbortolon]

Hello Denis

1) Yeah, a former colleague that works in a big company have done this because they experience the same problem

2) But a colleague that works on BI told me that some functions are not available on HANA Cockpit (Calculation View handling, etc...)

Thanks,
Marco

[Tobias_P]

Hi Dennis,

I'm getting exactly the same messages, going through your steps. Plus some I don't know where they came from (Repository API).

Just for my understanding, do you ignore these error messages, because they are coming during "normal" Studio usage?

BR

Tobias

[dennispadia]

Hello tobias.ptz ,

This alerts starts coming from HANA 2.0 SPS 03 as the feature API got deprecated from that very version and in future it will be decommissioned. I'm ignoring this alert as we don't have any native development on classic HANA repository which uses this feature. (future development will be on HDI). If it's you fresh installation and you don't perform development on classic HANA repository you can ignore this alert. But if you want to find exact workaround, you can raise message to SAP.

Regards,

Dennis