Data pipeline failed with Sql error number: 24525

[StephB]

Hi,

I am using Fabirc Data Factory to refresh a fact table in the Fabric Warehouse.  I use an activity that execute a SQL SP.  Mainly, this SP read data from a delta table in the Lakehouse and load fact table. Sine the begining of the week I have this error message:

Execution fail against sql server. Please contact SQL Server team if you need further support. Sql error number: 24525. Error Message: Internal error. Unable to interact with an internal metadata table. Please try the operation again and contact Customer Support Services if this persists.
Statement ID: {03CA2AD1-602A-4F0A-A0D1-CE499C47645C} | Query hash: 0x2BAAD28CC845304F | Distributed request ID: {CDA887EF-4142-427D-A892-2E320D03EBDA}

The pipeline is schedule to execute daily at 5:30 AM ET.  I did not made modification since a while.

Is someone has a tip on that issue please.

Thanks

Stephane

[StephB]

I did not have a answer to this problem...But I change some processes in my pipeline to use some materialized temp table and the error disappeared.  Not sure why...but now it works, until the next time the error is triggered, I guess.

[v-cboorla-msft]

Hi @StephB 

Thanks for using Microsoft Fabric Community.

Apologies for the issue that you are facing.

Here are some trouble shooting steps to over come the issue.

• The error message suggests that you try the operation again. This may resolve the issue if it was a temporary problem.
• If the issue persists, you can try checking the metadata table that the error message refers to. Ensure that the table is not corrupted and that it contains the necessary information.

Meanwhile you can refer the Link which might helps you.

I hope this helps. Please do let us know if you have any further queries.

[v-cboorla-msft]

Hi @StephB 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help .

Thanks

[v-cboorla-msft]

Hi @StephB 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others. If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread .

Thanks