21 Mar 2024 03:41 PM - last edited on 10 May 2024 03:24 PM by Michal_Gebacki
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.
Solved! Go to Solution.
22 Mar 2024 01:53 PM
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
23 Mar 2024 11:35 AM
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.
20 Aug 2024 01:24 PM
Hi @tvannamuthu,
How you add database name ? it is using connection string ? because the prompt is showing only service name/SID
20 Aug 2024 01:55 PM
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.
30 Aug 2024 05:32 PM
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
25 Sep 2024 02:21 PM
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