Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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

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.

Status: Delivered

Hi all,

 

This issue has been fixed, please try it again.

Thanks for your patience!

 

Best regards.
Community Support Team_Caitlyn

 

 

Comments
v-xiaoyan-msft
Community Support
Status changed to: Accepted

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
Regular Visitor

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
Helper II

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

aaronhaviland
Advocate II

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

 

The gateway is running Gateway release 3000.238.11.

MattP2019
New Member

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
New Member

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
New Member

Hi

 

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

annmariee_pro
New Member

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
Regular Visitor

Same issue appears after last Gateway update

Eric_Dommisse_0-1728896764381.png

Please fix it.

 

 

BarSi1986
Helper I

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....