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 i...
oluong's avatar
oluong
Helper I
8 years ago

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
8 years ago

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
    8 years ago

    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.