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 · Accepted solution]

Hello Marco,

As mentioned in the SAP Note 2425002 - SAP HANA 2.0: Deprecation reported by the HANA statistics server, there are several features that are been deprecated. Deprecation is the first step where SAP provide time to user to either move that functionality or do no use it as this feature is going to be decommissioned in future SPS.

If you see, API feature of REPOSITORY component is deprecated from HANA 2.0 SP 01. So from where this API feature is been called or used in the system? If you run query you will get the LAST_TIMESTAMP when this feature was been called.

SELECT * FROM M_FEATURE_USAGE WHERE IS_DEPRECATED='TRUE'

If you scroll to right of the result, you will get STATEMENT_ID and STATEMENT_HASH, so you can search SQL Plan Cache with this STATEMENT_HASH. If you are not able to find the STATEMENT_HASH, kindly put the filter and check the query that ran on LAST_TIMESTAMP value. You will find that every time there is an increase in CALL_COUNT of API feature when it calls below procedure.

call SYS.REPOSITORY_REST (?,?)

Authorization to call this procedure is inside CONTENT_ADMIN and MODELING role which is the default role you get when a SYSTEM user is created during installation. If you remove above roles, then you won't be able to see anything under Content section.

So, REPOSITORY_REST is called every time you try to check content as this procedure validate authorization of user. So, I feel this procedure is part of API feature for REPOSITORY component.

If you see, I have CALL_COUNT for M_TENANTS feature which is again deprecated as per SAP Note. I got this alert as I manually ran query “SELECT * FROM M_TENANTS” from my console. So when M_TENANT table has been called, it increases the CALL_COUNT in M_FEATURE_USAGE

I think SAP has set an alert, monitoring M_FEATURE_USAGE table and alert users that the deprecated feature has been used, so kindly take appropriate action. So if you try to use any of the deprecated feature it will give you alert. But frequency of this alert depends on how often you call that deprecated feature. M_TENANT alert I got only once as I manually called that table.

So if you use any of the IS_DEPRECATED=TRUE feature, you will get an alert. Either you can stop this alert if you are confident that you don't use any feature mentioned in SAP Note 2425002 which is deprecated.

NOTE: This is my analysis and I’m not SAP employee. You can raise incident and confirm.

Regards,

Dennis Padia