TI_RB

Reports do not refresh

Submitted by on ‎05-26-2023 05:53 AM

We are having problems with 40% of our reports where they don't refresh. The error is "DM_GWPipeline_Gateway_MashupDataAccessError". We have already refreshed the DW server but it didn't work. The full error is bellow, only changing the name of the tables.

 

An error occurred while processing the data in the dataset.
Falha na atualização:

Falha na atualização do Fortali - Cargas Abertas.
Detalhes da falha: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

{"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":"<ccon>Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"11"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"<ccon><ip>192.168.1.18</ip>;bi_rbfortali</ccon>"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"-2"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: dimTempo.

Investigating
See more ideas labeled with:
2 Comments (2 New)
Comments
avatar user
Anonymous
Not applicable
‎05-28-2023 07:27 PM

Hi  @TI_RB ,

 


Would you mind providing more details? For example, the data source you are using and the connection mode? If it uses a gateway, please make sure your gateway is up to date

 

Best regards.
Community Support Team_Caitlyn

TI_RB
Frequent Visitor
‎05-29-2023 12:12 PM

@Anonymous , we're using a gateway, personal mode. Our data source is a SQL dw. Does this help?

Idea Statuses