SCottrell

Report Schedule Refresh Issues

Submitted by on ‎06-21-2023 01:54 AM

We have been having on and off refresh issues for months

 

The issue seems to be caused by time out error while using the PBI gateway and I note several instances of similar issues being reported here but with no solution being offered.  Our Appliction Management team say that the Gateway is up and re-starting the gateway does not fix the problem.  

 

The issue can often resolve itself, but we have to wait hours, or sometimes even days.  This is having an organisational impact as key business reports are not being made available on time. 

 

Here is the error code from one of our failed reports this morning: 

 

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Timeout expired. The timeout period elapsed prior to completion of the operation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.HostingError.Reason","detail":{"type":1,"value":"Timeout"}}],"exceptionCulprit":1}}} Table: (xl)Firm Cohort.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: c4553a4e-6073-45d5-a96d-841692af8899
Request ID: 39cbf385-13bb-491a-b237-b01ca89dedd5
Time: 2023-06-21 08:10:59Z

 

Can this be investigated?

 

Thanks

SC

Investigating v-yanjiang-msft (Community Support) responded

Hi @SCottrell ,

The error message haven't provide more specific reason, as you said, it seems a time out error. There could be a number of reasons why this error is occurring. One possibility is that the data source is too large or complex for the system to process within the allotted time. Another possibility is that there is a problem with the network connection or server that is preventing the data from being retrieved in a timely manner.

If all these aspects don't help, to get the root cause, I suggest you create a support ticket, a dedicated engineer will come to help you dig the problem.

 

Best regards,

Community Support Team_yanjiang

See more ideas labeled with:
1 Comment (1 New)
Comments
v-yanjiang-msft
Community Support
Community Support
‎06-23-2023 01:58 AM
Status changed to: Investigating

Hi @SCottrell ,

The error message haven't provide more specific reason, as you said, it seems a time out error. There could be a number of reasons why this error is occurring. One possibility is that the data source is too large or complex for the system to process within the allotted time. Another possibility is that there is a problem with the network connection or server that is preventing the data from being retrieved in a timely manner.

If all these aspects don't help, to get the root cause, I suggest you create a support ticket, a dedicated engineer will come to help you dig the problem.

 

Best regards,

Community Support Team_yanjiang

Idea Statuses