Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

SQL Query is NOT running in Fabric Warehouse.

I'm receiving below error when run a query in Data Warehouse of Fabric.

Note: This is happening if the browser tab is ideal for couple mins and if we refresh the browser table then the query is working fine.

Activity ID: ba697533-92fe-48f2-8ce8-177bd4de8f47
Request ID: ceacd5ac-c747-e346-e39f-6dad15f4cfb0
Correlation ID: f08f508e-6bba-764c-5319-109edcc7f463
Status code: 401
Time: Thu Sep 14 2023 16:54:00 GMT-0500 (Central Daylight Time)
Service version: 13.0.21509.81
Client version: 2309.1.15569-train
Cluster URI: https://wabi-west-us3-a-primary-redirect.analysis.windows.net/

 

 

 

data warehouse
one lake
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    my apologies for delayed response.

    I really appreciate you checking with me.

    Today, I didn't get his error (I haven't done anything).

    I'll send the email if get this error again.

    Again, I appreciate you for checking and helping me.

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,
    Welcome to Microsoft Fabric platform and thanks for posting your question here.
    As I understand that you are trying to execute queries in Fabric Warehouse, but facing issue when browser tab is ideal for couple of mins.

    When I tried to repro the scenario, I am able to execute the query in Fabric Warehouse even after 1 hr of ideal period.


    Could you please share in further details like what query you are trying to execute and region you are trying to use Fabric.

     

    You may try the following steps and let us know.

    1. Clear “Cookies and Cached data” of your browser.

    2. Private Mode (New InPrivate Window).    

    3. Try in different browser.

    Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

     

    Thank you for your respose.

    If the session is ideal for couple mins any query is NOT running and throwing as error (sent you the screenshot in inital message).

    But after doing a hard refresh of the webpage then the query is running.

    I appreciate you provided work arounds but why the query is not running if my session is ideal for couple mins.

    I can't refresh the page everytime.

    I'm providing a screenshot of a query which I just ran.

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous ,

      Thanks for using the Fabric community and reporting this . 

      I have reached to the internal for help on this. I will update you once I hear from them.

      In mean time can you please share in which region you are working and facing this issue?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous ,

        I'm using Microsoft 365 E5 Developer trail subscription from US location.