topic Re: Custom Database extension - SQL Server Data source in Extensions

SQL Server Data source for Custom Database Extension

tvannamuthu — Fri, 10 May 2024 14:24:29 GMT

Trying to migrate queries from Custom DB queries to Custom Database Extension. Created an extension for a query.

During execution, the extension provides the following warning - Connection exists but no metrics have been produced for endpoints: But I know data is available at the endpoint as the same query when run separately provides the desired output. What might be causing this error? Appreciate any insights.

Re: Custom Database extension - SQL Server Data source

Miguel_RinconG — Fri, 22 Mar 2024 13:53:47 GMT

Hi @tvannamuthu ,

Please shared your extension code. This is a query example:

- group: User featureSet: User interval: minutes: 5 query: > SELECT count(CustomerID) as UserCount, Region FROM Customers where Region is not Null Group by Region dimensions: - key: custom.customquery.region value: col:Region metrics: - key: custom.customquery.sql.user value: col:UserCount

Re: Custom Database extension - SQL Server Data source

tvannamuthu — Sat, 23 Mar 2024 11:35:49 GMT

Hello Miguel_RinconG,

I was able to fix the issue by adding the database name in the monitoring configuration. It was mentioned as optional so did not add that initially but after adding the Database name extension started to fetch metrics.

Thanks for your reply.

Re: Custom Database extension - SQL Server Data source

ashafingilutfi — Tue, 20 Aug 2024 12:24:21 GMT

Hi @tvannamuthu,

How you add database name ? it is using connection string ? because the prompt is showing only service name/SID

Re: Custom Database extension - SQL Server Data source

tvannamuthu — Tue, 20 Aug 2024 12:55:55 GMT

Hi @ashafingilutfi ,

Please see the screen shot below. Here is where database name was added.

When you try to add monitoring configuration from an SQL Server extension you get this view.

Hope this helps.

Re: Custom Database extension - SQL Server Data source

chaitanya — Fri, 30 Aug 2024 16:32:27 GMT

Hi there,
I have added DB name correctly and syntax also correct but sometime queries throw same error as above.
do we have any other solutions?

thanks

Re: SQL Server Data source for Custom Database Extension

moin_DT1 — Wed, 25 Sep 2024 13:21:12 GMT

Hi All,

We are having the same error, even though we have added Database name and other fields correctly.

Does anyone have update? @tvannamuthu @chaitanya @ashafingilutfi @Miguel_RinconG

Thanks in advance,

Moin

Re: SQL Server Data source for Custom Database Extension

PDivya — Thu, 17 Oct 2024 14:56:08 GMT

Hi All,

We are also having same error, provided DB name and all details, as with the same details it is working extension 1.0.

Does anyone have update?

Thanks

Divya

Re: SQL Server Data source for Custom Database Extension

Mike_Kristofic — Tue, 04 Feb 2025 14:56:25 GMT

Hi,

my custom database extension suddenly stopped retrieving metrics with this very same message. Can't find any details in remote plugin module. Is there any way to troubleshoot? Like increase extension logging level? Database name is provided already.

Thanks

Mike

Re: SQL Server Data source for Custom Database Extension

moin_DT1 — Fri, 16 May 2025 17:04:02 GMT

Hi @Mike_Kristofic , Yes first you can enable the Debug toggle in the configuration. And also you can download the zip file of diagnostic logs of an ActiveGate.