topic Re: Stored Procedure is cannot found when create the database procedure proxy. in Application Development and Automation Discussions

Stored Procedure is cannot found when create the database procedure proxy.

former_member329238 — Tue, 16 Aug 2016 07:56:24 GMT

Hi Experts,

I have created a procedure proxy via XS artifact (.hdbprocedure), when i try to create the proxy for this procedure. Unfortunately, i am not able to find the created procedure in the wizard. Is there anyone can help on this?

Below are the screenshots for the details:

Re: Stored Procedure is cannot found when create the database procedure proxy.

Former Member — Tue, 16 Aug 2016 08:00:47 GMT

Hi,

There is a great document available on SCN on how to do this, .

You can check your steps there.

Jonathan B.

Re: Stored Procedure is cannot found when create the database procedure proxy.

Former Member — Tue, 16 Aug 2016 08:03:40 GMT

Hank,

I think your mistake is that you didn't share the procedure, can you check if you can find the procedure on the repository ?

And that you created it from the 'ABAP perspective' instead of the 'Modler' perspective (I think the 'HANA Development' perspective would have also been good.).

Jonathan B.

Re: Stored Procedure is cannot found when create the database procedure proxy.

pfefferf — Tue, 16 Aug 2016 08:10:41 GMT

As already answered database procedure proxies support only the depreated ".procedure" procedures and not the newer ".hdbprocedure" procedures.

Regards,

Florian

Re: Stored Procedure is cannot found when create the database procedure proxy.

former_member329238 — Tue, 16 Aug 2016 09:46:20 GMT

Hi Florian,

As suggested, i created the deprecated procedure. Now i am able to see the procedure from content assistant. However, when i try to finish the processing, it shown me the error message "HANA Procedure is not available in DB Catalog (names are case sensitive!)". Actually, the procedure name was filled automatically. Any suggestion on this?

Best Regards,

Hank.

Re: Stored Procedure is cannot found when create the database procedure proxy.

pfefferf — Tue, 16 Aug 2016 09:55:05 GMT

Did you check if the procedure exists in the DB catalog (check it in the catalog view). What I would also avoid are the Upper/Lower-case names of the packages (instead of "HDBModel.Procedures" I would write "hdbmodel.procedures"). Don't know if that can/will cause any issues, but it is the recommended way.

Regards,

Florian

Re: Stored Procedure is cannot found when create the database procedure proxy.

former_member329238 — Fri, 19 Aug 2016 08:23:24 GMT

Hi Florian,

Sorry for the late response and disturb again.

I tried with your suggestion changed the package into low case. And it still show me the same error message.

Content assistant:

The procedure in DB catalog:

The error message:

Is there anything wrong with this?

Best Regards,

Hank.

Stored Procedure is cannot found when create the database procedure proxy.

Re: Stored Procedure is cannot found when create the database procedure proxy.

ravilla — Tue, 06 Aug 2019 11:49:22 GMT

Hi Florian,

i have also same issue, created stored procedure in HANA Development in Repository, this will visible in catalog of my schema. but when i am trying to expose into ABAP, shows "HANA Procedure is not available in DB Catalog (names are case sensitive!)".

kinldly help me.

Thanks

Ravilla

Re: Stored Procedure is cannot found when create the database procedure proxy.

Former Member — Tue, 15 Sep 2020 00:45:54 GMT

Hi florian.pfeffer,

I have the same issue. I can see my procedure is under _SYS_BIC schema. But when I've tried creating the db procedure proxy, it cannot find HANA procedure what I've created.

Regards,

Tri