Unable to access stored procedure from warehouse in pipeline

[JE_test]

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?

[JE_test · Accepted solution]

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.

[v-nikhilan-msft]

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

[v-nikhilan-msft]

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.