<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Azure Cosmos DB Mirroring in Fabric – Internal System Error, 0 Rows Replicated (STG vs PRD) in Data Warehouse</title>
    <link>https://community.fabric.microsoft.com/t5/Data-Warehouse/Azure-Cosmos-DB-Mirroring-in-Fabric-Internal-System-Error-0-Rows/m-p/5177249#M4514</link>
    <description>&lt;DIV class=""&gt;
&lt;DIV class=""&gt;
&lt;DIV class=""&gt;
&lt;DIV id="bodyDisplay_3" class=""&gt;
&lt;DIV class=""&gt;
&lt;P&gt;Hi&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;
&lt;DIV class=""&gt;
&lt;DIV class=""&gt;
&lt;DIV class=""&gt;
&lt;DIV id="bodyDisplay_3" class=""&gt;
&lt;DIV class=""&gt;
&lt;P&gt;Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.&lt;/P&gt;
&lt;P&gt;&lt;LI-WRAPPER&gt;&lt;/LI-WRAPPER&gt;&lt;/P&gt;
&lt;DIV class=""&gt;
&lt;DIV class=""&gt;
&lt;DIV class=""&gt;&amp;nbsp;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;</description>
    <pubDate>Mon, 04 May 2026 06:47:59 GMT</pubDate>
    <dc:creator>v-aatheeque</dc:creator>
    <dc:date>2026-05-04T06:47:59Z</dc:date>
    <item>
      <title>Azure Cosmos DB Mirroring in Fabric – Internal System Error, 0 Rows Replicated (STG vs PRD)</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Warehouse/Azure-Cosmos-DB-Mirroring-in-Fabric-Internal-System-Error-0-Rows/m-p/5159516#M4485</link>
      <description>&lt;P class=""&gt;&lt;STRONG&gt;&lt;SPAN&gt;Hello community,&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;We are experiencing a persistent issue with &lt;/SPAN&gt;&lt;STRONG&gt;Azure Cosmos DB → Microsoft Fabric Mirroring&lt;/STRONG&gt;&lt;SPAN&gt; and would like to understand if others have encountered this and how it was resolved.&lt;/SPAN&gt;&lt;/P&gt;&lt;H3&gt;&lt;STRONG&gt;&lt;SPAN&gt;Context&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;/H3&gt;&lt;UL&gt;&lt;LI&gt;&lt;SPAN&gt;Source: Azure Cosmos DB (SQL / NoSQL API)&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Target: Microsoft Fabric – Mirrored Database (OneLake)&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Capacity: F4 (stable, not saturated)&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Region: East US&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Setup works correctly in &lt;/SPAN&gt;&lt;STRONG&gt;&lt;SPAN&gt;PRD&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;SPAN&gt;, but fails in &lt;/SPAN&gt;&lt;STRONG&gt;&lt;SPAN&gt;STG&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;H3&gt;&lt;STRONG&gt;&lt;SPAN&gt;Issue&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;/H3&gt;&lt;P class=""&gt;&lt;SPAN&gt;After stop/start cycles (including automation via API), the mirroring enters an unrecoverable state:&lt;/SPAN&gt;&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;&lt;SPAN&gt;Status: &lt;/SPAN&gt;&lt;EM&gt;&lt;SPAN&gt;Running&lt;/SPAN&gt;&lt;/EM&gt;&lt;SPAN&gt; or &lt;/SPAN&gt;&lt;EM&gt;&lt;SPAN&gt;Running with warnings&lt;/SPAN&gt;&lt;/EM&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Rows replicated: &lt;/SPAN&gt;&lt;STRONG&gt;&lt;SPAN&gt;0&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;“Last completed” never updates&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;No new data is reflected&lt;/SPAN&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;P class=""&gt;&lt;STRONG&gt;&lt;SPAN&gt;Error observed:&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;Internal system error occurred.&lt;BR /&gt;ArtifactId: 2b8f2d06-5c02-44a9-871d-5321214ef14d&lt;BR /&gt;SequenceNumber: &amp;lt;n&amp;gt;&lt;BR /&gt;ProcessedRows: 0&lt;BR /&gt;ProcessedBytes: 0&lt;/P&gt;&lt;H3&gt;&lt;STRONG&gt;&lt;SPAN&gt;What we have already tested&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;/H3&gt;&lt;UL&gt;&lt;LI&gt;&lt;SPAN&gt;Recreated mirroring multiple times&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Created new connections&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Tested different containers&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Tested with new containers and simple documents&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Restarted capacity&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Verified pipelines can read Cosmos data (works correctly)&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Compared with PRD (same setup works fine)&lt;/SPAN&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;H3&gt;&lt;STRONG&gt;&lt;SPAN&gt;Key observations&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;/H3&gt;&lt;UL&gt;&lt;LI&gt;&lt;SPAN&gt;Issue only occurs in STG environment&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Cosmos DB is healthy and accessible&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Pipelines work, but mirroring always fails&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Appears related to Change Feed or internal mirroring state&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Mirror does not recover even after restart or recreation&lt;/SPAN&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;H3&gt;&lt;STRONG&gt;&lt;SPAN&gt;Questions&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;/H3&gt;&lt;OL&gt;&lt;LI&gt;&lt;SPAN&gt;Has anyone experienced this &lt;/SPAN&gt;&lt;EM&gt;&lt;SPAN&gt;Internal system error / SequenceNumber&lt;/SPAN&gt;&lt;/EM&gt;&lt;SPAN&gt; issue?&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Is this a known limitation or bug in Fabric mirroring?&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Is there any way to reset or recover the mirroring state without recreating everything?&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Is recreating the Cosmos account the only reliable solution?&lt;/SPAN&gt;&lt;/LI&gt;&lt;LI&gt;&lt;SPAN&gt;Any best practices to avoid this when using automated start/stop?&lt;/SPAN&gt;&lt;/LI&gt;&lt;/OL&gt;&lt;P class=""&gt;&lt;SPAN&gt;Any insights or similar experiences would be greatly appreciated.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Thank you!&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 27 Apr 2026 20:29:11 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Warehouse/Azure-Cosmos-DB-Mirroring-in-Fabric-Internal-System-Error-0-Rows/m-p/5159516#M4485</guid>
      <dc:creator>DiegoF93</dc:creator>
      <dc:date>2026-04-27T20:29:11Z</dc:date>
    </item>
    <item>
      <title>Re: Azure Cosmos DB Mirroring in Fabric – Internal System Error, 0 Rows Replicated (STG vs PRD)</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Warehouse/Azure-Cosmos-DB-Mirroring-in-Fabric-Internal-System-Error-0-Rows/m-p/5159520#M4486</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="372943" data-lia-user-login="DiegoF93" class="lia-mention lia-mention-user"&gt;DiegoF93&lt;/a&gt;,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Note: This response was enhanced with the assistance of an AI tool. The information has been verified against the official Microsoft Fabric documentation.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;This pattern mirroring stuck at "Running" with 0 rows and a frozen "Last completed" after a stop/start cycle is a known transient state with Cosmos DB mirroring. The root cause is usually a stale internal Change Feed checkpoint that doesn't reset cleanly on restart.&lt;/P&gt;&lt;P&gt;A few targeted things to try:&lt;/P&gt;&lt;P&gt;1. &lt;STRONG&gt;Delete and recreate but wait 10+ minutes before recreating&lt;/STRONG&gt;&lt;BR /&gt;The internal Change Feed lease container in Cosmos needs time to fully release after a stop. If you recreate too quickly, the new mirror picks up a corrupted lease state. Wait at least 10 minutes after deleting before creating a new one.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;2. &lt;STRONG&gt;Check the Cosmos DB Change Feed lease container&lt;/STRONG&gt;&lt;BR /&gt;Fabric Mirroring uses the Cosmos DB Change Feed internally. Go to your Cosmos account → Data Explorer → look for a container named _fabric_mirror_leases or similar. If it exists and has stale documents, delete them before recreating the mirror.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;3. &lt;STRONG&gt;STG vs PRD check if it's a network/firewall difference&lt;/STRONG&gt;&lt;BR /&gt;Since PRD works but STG doesn't, verify that STG's Fabric capacity has the same network access to Cosmos DB (no VNet restrictions, IP allowlist includes Fabric East US egress IPs).&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;4. &lt;STRONG&gt;Open a support ticket with the ArtifactId&lt;/STRONG&gt;&lt;BR /&gt;The Internal system error with a specific ArtifactId means the error is logged server-side at Microsoft. File a support request referencing that ArtifactId the Fabric team can trace the exact failure from their telemetry.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Note: This response was drafted with AI assistance and reviewed/validated before posting.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Docs: &lt;A href="https://learn.microsoft.com/en-us/fabric/mirroring/troubleshooting" target="_blank" rel="noopener"&gt;Troubleshoot Fabric mirrored databases&lt;/A&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 19 Jun 2026 08:41:17 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Warehouse/Azure-Cosmos-DB-Mirroring-in-Fabric-Internal-System-Error-0-Rows/m-p/5159520#M4486</guid>
      <dc:creator>Tamanchu</dc:creator>
      <dc:date>2026-06-19T08:41:17Z</dc:date>
    </item>
    <item>
      <title>Re: Azure Cosmos DB Mirroring in Fabric – Internal System Error, 0 Rows Replicated (STG vs PRD)</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Warehouse/Azure-Cosmos-DB-Mirroring-in-Fabric-Internal-System-Error-0-Rows/m-p/5177249#M4514</link>
      <description>&lt;DIV class=""&gt;
&lt;DIV class=""&gt;
&lt;DIV class=""&gt;
&lt;DIV id="bodyDisplay_3" class=""&gt;
&lt;DIV class=""&gt;
&lt;P&gt;Hi&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;
&lt;DIV class=""&gt;
&lt;DIV class=""&gt;
&lt;DIV class=""&gt;
&lt;DIV id="bodyDisplay_3" class=""&gt;
&lt;DIV class=""&gt;
&lt;P&gt;Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.&lt;/P&gt;
&lt;P&gt;&lt;LI-WRAPPER&gt;&lt;/LI-WRAPPER&gt;&lt;/P&gt;
&lt;DIV class=""&gt;
&lt;DIV class=""&gt;
&lt;DIV class=""&gt;&amp;nbsp;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;</description>
      <pubDate>Mon, 04 May 2026 06:47:59 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Warehouse/Azure-Cosmos-DB-Mirroring-in-Fabric-Internal-System-Error-0-Rows/m-p/5177249#M4514</guid>
      <dc:creator>v-aatheeque</dc:creator>
      <dc:date>2026-05-04T06:47:59Z</dc:date>
    </item>
    <item>
      <title>Re: Azure Cosmos DB Mirroring in Fabric – Internal System Error, 0 Rows Replicated (STG vs PRD)</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Warehouse/Azure-Cosmos-DB-Mirroring-in-Fabric-Internal-System-Error-0-Rows/m-p/5178595#M4519</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="372943" data-lia-user-login="DiegoF93" class="lia-mention lia-mention-user"&gt;DiegoF93&lt;/a&gt;&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.&lt;/P&gt;
&lt;P&gt;&lt;LI-WRAPPER&gt;&lt;/LI-WRAPPER&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 06 May 2026 11:53:12 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Warehouse/Azure-Cosmos-DB-Mirroring-in-Fabric-Internal-System-Error-0-Rows/m-p/5178595#M4519</guid>
      <dc:creator>v-aatheeque</dc:creator>
      <dc:date>2026-05-06T11:53:12Z</dc:date>
    </item>
  </channel>
</rss>

