SAP Knowledge Base Article - Preview

3201037 - How to correct invalid AMDP procedures

Symptom

  • You identified invalid AMDP procedures
  • Below are examples of AMDP Procedures:

CL_CAPEVAL_AMDP=>CALCULATE_UTILIZATION_BUCKET
CL_CAPEVAL_AMDP=>CALCULATE_UTILIZATION_BUCKET#stb2#20200316013750
CL_CAPEVAL_AMDP=>CALCULATE_UTILIZATION_BUCKET#stbt#20200316013750
CL_CAPEVAL_AMDP=>CALC_CAPACITY_UTILIZATION
CL_CAPEVAL_AMDP=>CALC_CAPACITY_UTILIZATION#stb2#20200316013750
CL_CAPEVAL_AMDP=>CALC_CAPACITY_UTILIZATION#stbt#20200316013750
CL_CAPEVAL_AMDP=>DO_CAPACITY_EVALUATON
CL_CAPEVAL_AMDP=>DO_CAPACITY_EVALUATON#stb2#20200316013750
CL_CAPEVAL_AMDP=>DO_CAPACITY_EVALUATON#stbt#20200316013750

  • Invalid procedures can be identified with the following:

- In the result of SQL: "HANA_Objects_Procedures"
- Execution or activation of a Stored Procedure fail with SQL error 430 (invalidated procedure)
- Stored Procedure is invalid
- Check ID M1920 of SQL "HANA_Configuration_MiniChecks" returns columns C = 'X'


Read more...

Environment

  • SAP HANA, Platform edition 1.0
  • SAP HANA, Platform edition 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

invalid, invalidated, 430, valid, false, activate, activating, M1920, recompile, recompilation, validity, HANA_Objects_Procedures
, KBA , HAN-DB , SAP HANA Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.