topic Re: Error with SQL analytics endpoint after adding a shortcut to a schema in a different workspace in Data Engineering

Error with SQL analytics endpoint after adding a shortcut to a schema in a different workspace

Liam_McCauley — Thu, 24 Apr 2025 08:58:51 GMT

A colleague created a lakehouse called PAGP_Capitation, and I have Admin privileges on the workspace.

I created a Semantic model, and a Power BI report for this lakehouse.

This morning, a created 2 shortcuts to schemas in another lakehouse (in another workspace), and tried to update the Semantic model. I went in to edit mode, and clicked on Edit tables, and got the following error:

I opened up the SQL analytics endpoint, which said "We're loading your SQL analytics endpoint metadata".

I deleted the shortcuts, but got the same message in the SQL analytics enpoint.

I clicked on the refresh button at the top left of the screen, under "Home", and got this error:

The SQL query failed while running. Message=[METADATA DB] <ccon>(CODE:80002) The [dms$system].[DbObjects] appears to be corrupted (cannot find any definition of type 2)!</ccon>, Code=50000, State=0

How can I resolve this?

Re: Error with SQL analytics endpoint after adding a shortcut to a schema in a different workspace

v-prasare — Fri, 25 Apr 2025 07:27:30 GMT

Hi @Liam_McCauley,

According to the preview limitations of Lakehouse schemas, the SQL Analytics Endpoint and Semantic Model are among the functionalitites which are not supported in the current release of public preview:

Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn

In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Re: Error with SQL analytics endpoint after adding a shortcut to a schema in a different workspace

Liam_McCauley — Mon, 28 Apr 2025 16:15:40 GMT

And it resolved itself over the weekend without any human intervention.

Re: Error with SQL analytics endpoint after adding a shortcut to a schema in a different workspace

Liam_McCauley — Tue, 29 Apr 2025 13:10:18 GMT

Hi Prashanth,

I looked at that link, and I don't see where it says SQL Analytics Endpoint and Semantic Model are not supported. Can you tell me which line in the table says this, please?

In fact, this link explicitly tells you how to use Semantic Models with lakehouse schemas:

Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn

Re: Error with SQL analytics endpoint after adding a shortcut to a schema in a different workspace

v-prasare — Thu, 08 May 2025 13:36:13 GMT

Hi @Liam_McCauley,

If your issue got resolved, then please consider Accept it as the solution to help the other members find similar transient issues more quickly

Thanks,

Prashanth Are

MS Fabric community support