Forum Discussion

Max_agileDSS's avatar
Max_agileDSS
Frequent Visitor
1 year ago
Solved

ISSUE: Fabric SQL database replication error to one-lake

Hi everyone,   I've been facing a weird error since few days. I created a SQL Database in a workspace (Canada Central), but the mirroring replication process to OneLake doesn’t seem to be working ...
Need Help
sql database
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    11 months ago

    Thankyou, ToddChitt and j_hoff for your responses.

    Hi Max_agileDSS,

    We appreciate your inquiry submitted through the Microsoft Fabric Community Forum.

    The backend team has resolved the issue, as shown in the screenshot below:

    Please confirm whether you are still experiencing the problem. If you have any further queries, feel free to contact the Microsoft Fabric Community.

    Thank you.

j_hoff's avatar
j_hoff
Frequent Visitor
11 months ago

I'm experiencing the exact same issue. The replication had been working fine for several months until I altered a table (added two new columns) a couple of days ago. I noticed that the two new columns were not populating in the SQL Analytics Endpoint so I checked the replication status and it is showing "RunningWithWarnings" for the table I had altered. I then created a brand new table in the dbo schema. The replication status for the brand new table shows "Failed". I then inserted a record into an existing table and it replicated to OneLake within a minute. Running the DMV's provided in Microsoft's troublshooting guide also did not return anything out of the ordinary. I saw that there is a Service Status issue reported on Microsoft Fabric's support site that involves mirroring and a fix is expected to be deployed by end-of-day 9/13/2025. I do not know if the two are related, but I've got my fingers crossed that it will get fixed.