Direct Query refresh failures after upgrading Gateway (3000.238.11) with MonitoredDbConnectionError

[aaronhaviland]

Following on from this Forum post https://community.fabric.microsoft.com/t5/Service/ServerError-DM-GWPipeline-Gateway-MonitoredDbConne... (Please see that post for relevant logfile snippets)

After upgrading the gateway to the latest version, roughly 1/3 of all Direct Query queries are reporting error ServerError_DM_GWPipeline_Gateway_MonitoredDbConnectionError in BI Service. From what I've been able to determine, it happens to all reports that use Direct Query, regardless of the direct query data source.

The only connection we can find is that all the errors are using Direct Query. Import Refreshes don't seem to experience this issue.

Additionally, this error message isn't documented anywhere that I've been able to find.

[v-xiaoyan-msft]

Hi @aaronhaviland ,

Can you provide detailed version information so we can reproduce the issue? We'll get back to the product team as soon as it's acknowledged as an issue!
Thanks in advance!

Best regards.
Community Support Team_Caitlyn

[malarkey99]

Hi,

I'm not @aaronhaviland but during a dataset refresh I get the following error

{"error":{"code":"DM_GWPipeline_Gateway_MonitoredDbConnectionError","pbi.error":{"code":"DM_GWPipeline_Gateway_MonitoredDbConnectionError","parameters":{},"details":[]}}}

Also when a report with direct query connection is opened I get a "MonitoredDbConnectionError".

After pressing the refresh button the data is loaded correctly. It hapens sporadically and only

some of the queries are affected.

In my case it started at night cet between 7th and 8th oh October, the gateway 3000.238.11

was installed some days before.

here is what I've found in the gateway error log

4C1EF73E [DM.GatewayCore] Error processing request: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineMonitoredDbConnectionException: Failed to retrieve connection: no connection with ID exists.

[gautampruthi]

Hi @v-xiaoyan-msft , The version number is 3000.238.11

[aaronhaviland]

@v-xiaoyan-msft Sure, what additional version information do you need?

The gateway is running Gateway release 3000.238.11.

[MattP2019]

Good afternoon,

We have experienced the same issues over the last 48 hours since updating the On Premise Gateway (also 3000.238.11 September 2024).

Some guidance or bug fix would be really useful at this point having run from various DQs.

Matt

[Tomato0023]

Good day,
I've also recently noticed problems with refreshing data. The problem code is the same.

Gateway series 3000.238.11 (September 2024).

Best regards.

[lttluan]

Hi

We also have the same issue. Please help fix this.

[annmariee_pro]

Feedback Type:
Frown (Error)

Timestamp:
2024-10-12T13:43:06.4898935Z

Local Time:
2024-10-12T13:43:06.4898935+00:00

Session ID:
dde7bbfb-83b6-42ba-b0a6-675201941050

Release:
August 2024

Product Version:
2.135.7627.0 (24.08) (x64)

Stack Trace:
System.Runtime.InteropServices.SEHException
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass7_0.<RunApplicationLegacy>b__0()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Error Code:
-2147467259 (0x80004005)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.135.7627.0","ModuleName":"Microsoft.Mashup.Client.UI.dll","Component":"Microsoft.Mashup.Client.UI.Shared.WindowManager","Error":"System.Runtime.InteropServices.SEHException","MethodDef":"ShowModal","ErrorOffset":"70","ErrorCode":""}

OS Version:
Microsoft Windows NT 10.0.19045.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 533325]

Peak Virtual Memory:
70.6 GB

Private Memory:
739 MB

Peak Working Set:
723 MB

IE Version:
11.3636.19041.0

User ID:
1071a395-5d3f-48a1-a52b-30c6639e8ef0

Telemetry Enabled:
True

DPI Scale:
100%

Supported Services:
Power BI

[Eric_Dommisse]

Same issue appears after last Gateway update

Please fix it.

[BarSi1986]

Also the same issue, since last week, don;t know exact date, sometimes when you refresh website is suddently starts working fine.... till next crash....