Forum Discussion

vamshikrishna20's avatar
vamshikrishna20
Helper III
4 years ago
Solved

Gateway Error Details

Hello Everyone , 

 

Can someone please help me with meaning for this below gateway error .

 

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":"ODBC: ERROR [HY000] [Splunk][SplunkODBC] (70) Error response received from the server: [WARN]:

[grnp-0136.exelonds.com] Configuration initialization for /opt/splunk/var/run/searchpeers/DE91F74C-281C-4EE4-A50A-30F752A85D52-1633658240

took longer than expected (1341ms) when dispatching a search with search ID remote_grnp-0111.exelonds.com_1633658458.403943_0D3CA0F1-2C4D-4C76-8F79-B2AE0116B760.

This usually indicates problems with underlying storage performance."}},

{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},

{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},

{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath",

"detail":{"type":1,"value":"dsn=Splunk ODBC"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors",

"detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},

{"code":"Microsoft.Data.Mashup.ValueError.Reason",

"detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: TFS_SCA_PowerBI_Executive_Report.

Cluster URI:        WABI-US-EAST2-redirect.analysis.windows.net

Activity ID:         00000000-0000-0000-0000-000000000000

Request ID:        f66ee0ce-8771-4d38-8169-e347e957ee11

Time:    2021-10-08 02:01:04Z


TIA

  • Hi, 

    As far as I’m concerned, if the error message is related to the “MashupDataAccessError”, it means that your on-premise gateway has a connection error with the on-premise data source, then the below message also mentioned: “This usually indicates problems with underlying storage performance.”

    I think this error is related to your slow performance of the connection between your on-premise data source and on-premise gateway.

     

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-robertq-msft's avatar
    v-robertq-msft
    Community Support

    Hi, 

    As far as I’m concerned, if the error message is related to the “MashupDataAccessError”, it means that your on-premise gateway has a connection error with the on-premise data source, then the below message also mentioned: “This usually indicates problems with underlying storage performance.”

    I think this error is related to your slow performance of the connection between your on-premise data source and on-premise gateway.

     

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.