Invalidated Procedure?

[Former Member]

My previously working procedures have suddenly become unusable. Each of their object icon in the Navigator now has a small gray box. Calling any of the procedure gives the following error message. Also, all the action buttons (Execute, Refresh) in the Definition view are grayed out. So Hana really thinks the procedures are not valid.

Could not execute 'call SCHEMA.PROC_NAME()'

SAP DBTech JDBC: [430]: invalidated procedure: PROC_NAME: line 1 col 24 (at pos 23)

What's the meaning of "Invalidated Procedure"? I can't find a "validate" feature for procedures. BTW, these are RLang procedures.

Thanks,

Ming

[former_member621066]

Hello,

we also had the problem, that we could not call a procedure anymore which had been working fine until that point. Error message was 430 (invalidated procedure). We then dropped the procedure and tried to re-create it with the same query, but it would still run into the 430 error. Is there anyhing else we can do about it? one more info: We had a hana update a few days before

[prince_ebi]

Hi,

If you used some views in the procedure please check that view. Maybe somebody modified the view after you created the procedure. Some columns might be removed from the VIEW you used during the procedure.

In this case, you will get the error "invalidated procedure"