Forum Discussion

oluong's avatar
oluong
Helper I
8 years ago

Extended automatic cancellation for spooled operation

Greetings community,

 

I was wondering if anyone can help me solve this problem.  We have 10 reports on power bi service, and the datasource comes from on-premise gateway.  I have one report that is failing during the schedule refresh.  When I used power bi desktop, it all works fine.  Here are the information:

 

Something went wrong
Cancellation occurred when sending or receiving a request.
Please try again later or contact support. If you contact support, please provide these details.
Get Help
 
Show technical details says:
 
Something went wrong
Cancellation occurred when sending or receiving a request.
Please try again later or contact support. If you contact support, please provide these details.
Cluster URIWABI-US-GOV-IOWA-redirect.analysis.usgovcloudapi.net
Activity IDd5148541-49c7-4d25-b924-9e02abb34b6a
Request ID8220d843-984f-8763-a1da-5b9c98eb9d9e
Time2018-07-16 16:59:57Z
Get Help
 
The on-premise gateway log shows these:
 
d5148541-49c7-4d25-b924-9e02abb34b6a E1136825 [DM.GatewayCore] Extended automatic cancellation for spooled operation f8413423-6590-486a-92ba-93ff09643dc3 from AcknowledgePacketAsync
DM.EnterpriseGateway Information: 0 : 2018-07-16T16:52:32.0895536Z DM.EnterpriseGateway e0c8b933-b57d-44f8-90fc-770c0d73f6ef 972231a6-eb7b-228b-62b4-1cbf4edafd1d MGAA d5148541-49c7-4d25-b924-9e02abb34b6a 38F14D63 [DM.GatewayCore] Packet index 1 acknowledged for async operation f8413423-6590-486a-92ba-93ff09643dc3
DM.EnterpriseGateway Information: 0 : 2018-07-16T16:52:32.0895536Z DM.EnterpriseGateway e0c8b933-b57d-44f8-90fc-770c0d73f6ef 972231a6-eb7b-228b-62b4-1cbf4edafd1d MGAA d5148541-49c7-4d25-b924-9e02abb34b6a CF10B447 [DM.GatewayCore] Deleting spooled packet index 1
 

 

 

 

3 Replies

  • Greetings community,

     

    I was wondering if anyone can help me solve this problem.  We have 10 reports on power bi service, and the datasource comes from on-premise gateway.  I have one report that is failing during the schedule refresh or a manual refresh.  When I used power bi desktop, it all works fine.  Here are the information:

     

    Something went wrong
    Cancellation occurred when sending or receiving a request.
    Please try again later or contact support. If you contact support, please provide these details.
    Get Help
     
    Show technical details says:
     
    Something went wrong
    Cancellation occurred when sending or receiving a request.
    Please try again later or contact support. If you contact support, please provide these details.
    Cluster URIWABI-US-GOV-IOWA-redirect.analysis.usgovcloudapi.net
    Activity IDd5148541-49c7-4d25-b924-9e02abb34b6a
    Request ID8220d843-984f-8763-a1da-5b9c98eb9d9e
    Time2018-07-16 16:59:57Z
    Get Help
     
    The on-premise gateway log shows these:
     
    d5148541-49c7-4d25-b924-9e02abb34b6a E1136825 [DM.GatewayCore] Extended automatic cancellation for spooled operation f8413423-6590-486a-92ba-93ff09643dc3 from AcknowledgePacketAsync
    DM.EnterpriseGateway Information: 0 : 2018-07-16T16:52:32.0895536Z DM.EnterpriseGateway e0c8b933-b57d-44f8-90fc-770c0d73f6ef 972231a6-eb7b-228b-62b4-1cbf4edafd1d MGAA d5148541-49c7-4d25-b924-9e02abb34b6a 38F14D63 [DM.GatewayCore] Packet index 1 acknowledged for async operation f8413423-6590-486a-92ba-93ff09643dc3
    DM.EnterpriseGateway Information: 0 : 2018-07-16T16:52:32.0895536Z DM.EnterpriseGateway e0c8b933-b57d-44f8-90fc-770c0d73f6ef 972231a6-eb7b-228b-62b4-1cbf4edafd1d MGAA d5148541-49c7-4d25-b924-9e02abb34b6a CF10B447 [DM.GatewayCore] Deleting spooled packet index 1
     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi oluong,

       

      How many datasource your reports has? One or many?

       

      In addition, you can also try to modify 'Spooler Operation Eviction Timeout' properties to check if this issue related to operation timeout.

       

      Enter to gateway install folder to find out 'Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config' file, then modify 'SpoolerOperationEvictionTimeout' property.(default 120 second)

       

      <C:\Program Files\On-premises data gateway\Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config>
      <setting name="SpoolerOperationEvictionTimeout" serializeAs="String">
              <value>00:05:00</value>
            </setting>

       

      BTW, current we not have permission to check gov related services, if above not help, please submit a support ticket for better support.

       

       

      submit a support ticket

       

      Regards,

      Xiaxoin Sheng

      • oluong's avatar
        oluong
        Helper I

        HiXiaxoin,

         

        Thank for you advise.  We did impliment the suggestion and the error is still present.  I have went ahead and submit a ticket.  Thank you so much.