Cannot see Stored Procedure in the Warehouse

[supri03]

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 !

[v-nikhilan-msft]

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.

[v-nikhilan-msft]

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

[v-nikhilan-msft]

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