topic Re: Cannot see Stored Procedure in the Warehouse in Data Warehouse

Cannot see Stored Procedure in the Warehouse

supri03 — Thu, 18 Jan 2024 03:30:55 GMT

Hi All,

I have have a stored procedure, the code executed successfully, but I can't view it in Stored Procedures Folder.

When I run the command EXEC command, I get this below error

Please guide me on this, thanks !

Re: Cannot see Stored Procedure in the Warehouse

Anonymous — Thu, 18 Jan 2024 09:58:35 GMT

Hi supri03
Thanks for using Fabric Community.
The error "The query references an object that is not supported in distributing process mode" indicates that the stored procedure is attempting to use a feature or object that isn't compatible with distributed processing. This often involves system functions, temporary tables, or certain table-valued functions.

Avoid using the queries that join external data with system views, load external data in a temp table, or use some security or metadata functions to filter external data.

Can you please review the code of the stored procedure? Try to examine the code for any unsupported objects or functions. Check the Fabric documentation for a comprehensive list of unsupported features in distributed mode.
Please refer to this link for limitations in Fabric Warehouse: https://learn.microsoft.com/en-us/fabric/data-warehouse/limitations
https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-query-editor

Hope this helps. Please let us know if you have any further queries.

Re: Cannot see Stored Procedure in the Warehouse

Anonymous — Fri, 19 Jan 2024 17:21:38 GMT

Hi supri03
We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
Thanks

Re: Cannot see Stored Procedure in the Warehouse

Anonymous — Mon, 22 Jan 2024 15:45:08 GMT

Hi @supri03
We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
Thanks