Extended automatic cancellation for spooled operation

[oluong]

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.

Show technical 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

[oluong]

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.

Show technical 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]

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]

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.