topic Unable to access stored procedure from warehouse in pipeline in Pipelines

Unable to access stored procedure from warehouse in pipeline

JE_test — Thu, 23 Nov 2023 10:10:01 GMT

Hi!

I'm unable to use my SP from a Warehouse in a pipeline.

If I click on "More" I get the following error message:

"undefined. Activity ID: undefined."

I have re-created the warehouse to see if that made a difference, but it did not.

Any ideas on how to resolve this?

Re: Unable to access stored procedure from warehouse in pipeline

Anonymous — Thu, 23 Nov 2023 15:50:12 GMT

Hi JE_test
Thanks for using Fabric Community.
Apologies for the issue you are facing. Can you please try the below method? I have attached the screenshots.

Click the open button. This opens the warehouse. If your stored procedure is successfully created in the warehouse, it will be shown in the warehouse.

If you are able to see the stored procedure in your warehouse and still not able to select in the pipeline level, there might be some issue with the stored procedure code.

Can you try creating a default stored procedure and check if you are able to access it in the pipeline?
1) Click on new stored procedure.

2) Run the query. A stored procedure gets created in the warehouse.

3) Check whether you are able to access this stored procedure. Please let me know if you have any further issues.

Thanks.

Re: Unable to access stored procedure from warehouse in pipeline

JE_test — Fri, 24 Nov 2023 07:41:10 GMT

I was later able to use my stored procedure by just typing its name manually instead of using the dropdown. It seems like only the dropdown is broken.

Re: Unable to access stored procedure from warehouse in pipeline

Anonymous — Mon, 27 Nov 2023 07:51:09 GMT

Hi JE_test
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.