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
Check the gateway logs to see which connections are actually being used. Compare QueryStart versus QueryExecution to see if you can find gaps (ie queries started but didn't complete). If the logs are nominal look for other connections defined for the gateway but not present in the logs. You could then try to recreate these connections in the Power BI service.
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)
Since 10-08-2024 we have exactly the same problem with direct query connections.
We get the 'ServerError_DM_GWPipeline_Gateway_MonitoredDbConnectionError'
with Gateway version: 3000.238.11
Where you able to identify the reason for this error?
No, I haven't been ble to find anything. It's still happening consistently. I've been otherwise tied up and haven't had a chance to investigate further.
Thanks for commenting, and confirming that we're not the only one experiencing this issue since updating to 3000.238.11.
Per lbendlin 's suggestion above, I have posted this in the Issues subforum https://community.fabric.microsoft.com/t5/Issues/Direct-Query-refresh-failures-after-upgrading-Gateway-3000-238/idi-p/4235334#M109713
Usually one would say "What if you downgrade the gateways to a well known good version like 226.5". But that would be cruel, as we all know that you cannot downgrade gateways.
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .Confirming I have this exact issue - PowerBI live service is failing to refresh seemingly at random due to a "
ServerError_DM_GWPipeline_Gateway_MonitoredDbConnectionError".If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
