Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Gatway issue

There were a couple of dashboards are running on scheduled basis. All of sudden, they are throwing an issue and failing. Here is the error description. What is the cause of failing the reports? Any suggestions

 

An error occurred while processing the data in the dataset.
Refresh failed:

Total Casualty Dashboard has failed to refresh.
Failure details: 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":"Oracle: ORA-03135: connection lost contact\nProcess ID: 60327\nSession ID: 599 Serial number: 6941\n"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Oracle"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"dw"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232008"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"ORA-03135: connection lost contact\nProcess ID: 60327\nSession ID: 599 Serial number: 6941\n"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Parent Reporting Unit.
Next refresh for Total Casualty Dashboard is scheduled for July 2, 2020 14:00 UTC.


Learn more >

 


Technical Information


Activity Id:
c5d99572-ba8b-477b-acb1-53c137fa9d83


Request Id:
9dc1cee0-1bfa-4c3e-8982-f9d1af852ff3


Cluster Name:
WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net


Refresh Start Time:
July 1, 2020 14:02 UTC


Refresh End Time:
July 1, 2020 14:20 UTC

 

 

1 Reply

  • Hi there

    The issue is in your table "Parent Reporting Unit"

    And if I am reading the error correctly the issue is with the Oracle Client "ORA-03135: connection lost contact"

    If you can make sure you have the latest Power BI Gateway installed and that your Gateway and data source connection can access the table?