Forum Discussion
ServerError_DM_GWPipeline_Gateway_MonitoredDbConnectionError
Hi Anonymous ,
Sorry for late reply.This issue has been resolved, please upgrade the gateway to the October release (3000.242.5).
Best regards,
Community Support Team_ Scott Chang
I was able to captured some specific instances of the error, and identified that the issue is happening across all DirectQuery connections (8 Oracle DB connections, and Snowflake). I cannot find any common element between them. Since it's also happening with Snowflake, that rules out the possibility of it being an issue with the in-house DBs.
QueryExecutionReport reports "QueryExecution failed with error: Failed to retrieve connection: no connection with ID exists."
I did also find this "Object reference" error in GatewayError.log which matches up with the errors in GatewayInfo.log:
[DM.GatewayCore] Error while updating connection status. ConnectionId: c5480ca0-0add-414f-a2e6-cf54f47c9864 - System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.Data.Mashup.MashupConnection.UpdateProgress(IEnumerable`1 progresses)
at Microsoft.Data.Mashup.MashupConnection.get_Progress()
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.AdoNetStatusUtils.GetCurrentStatusFromMashupConnection(MashupConnection connection)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.AdoNetMonitoredDbConnectionPool.GetAndProcessStatus(Guid connectionId, IAdoMonitoredConnection connectionWithStatus, Nullable`1 activeQueryIdToRemove)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.AdoNetMonitoredDbConnectionPool.UpdateConnectionStatus(Guid connectionId)
Confirming I have this exact issue - PowerBI live service is failing to refresh seemingly at random due to a "
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
