Forum Discussion

nguyenhieubis's avatar
nguyenhieubis
Frequent Visitor
2 years ago

Issues with Snapshot Isolation Transaction Failures in Cross-Warehouse Ingestion

I have a Workspace that includes: Lakehouse lh_bronze: Where I create views at the SQL endpoint of the lakehouse. Warehouse wh_silver: Where data from the views in lakehouse bronze is stored. Dat...
data warehouse
v-cboorla-msft's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Hi nguyenhieubis 

 

Could you please confirm whether you are getting above error message on each execution. Or you are observing this error on few executions.

 

Thank you.

nguyenhieubis's avatar
nguyenhieubis
Frequent Visitor
2 years ago

For example: In one pipeline run, approximately 12 SQL statements are executed, and one of them will encounter this error. With 10 pipeline runs per day, this error occurs in about 2 runs.

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    Hi nguyenhieubis 

     

    Apologies for the inconvenience that you are facing here.

    There might be a chance of an intermittent issue could you please follow the below steps that might help you.

    Temporary Glitch: Clearing cookies and caches can sometimes resolve temporary glitches within the application that might be causing the issue.

    Corrupted Data: In rare cases, corrupted data stored in the browser's cache related to Microsoft Fabric might be causing the issue. Clearing the cache removes this potentially problematic data.

    Hard Refresh: A hard refresh bypasses the cached version of the webpage and forces the browser to download the latest version from the server. Press Ctrl+Shift+R (Windows) or Cmd+Shift+R (Mac).

    Try Microsoft Edge: If you are currently using Chrome or Firefox, try switching to Microsoft Edge to see if the issue persists. Edge is the native browser for Microsoft products and might have better compatibility with Microsoft Fabric.

     

    If the issue still persists, please do let us know. Glad to help.

     

    I hope this information helps.

     

    Thank you.

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      2 years ago

      Hi nguyenhieubis 

       

      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's avatar
        v-cboorla-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        2 years ago

        Hi nguyenhieubis 


        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.