cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Debugging custom 2.0 extension with sqlOracle datasource

sivart_89
Mentor

I've created a custom db extension but am noticing the below for an endpoint. I can connect to the database through something like dbeaver and run the query fine (the same connection string and account used in the extension). When ran through the extension it seems to not work. Is there any debugging I can do here to help determine what is going on? All of my other queries are working, just not this one query connecting to this other database.

Side note, this works fine in the old extension running from the same ActiveGate. Even so, based off the message below the connection does seem valid, there just isn't metrics being collected. I've seen a different message if the connection is invalid and the datasource cannot connect to the database.

Connection exists but no metrics have been produced for endpoints

3 REPLIES 3

Mike_L
Dynatrace Guru
Dynatrace Guru

Hi,

This tool is helpful when investigating connectivity issues:

https://github.com/Dynatrace/db-connection-check

Mike

Mike

Julius_Loman
DynaMight Legend
DynaMight Legend

It may sound dirty, but unless you use SSL, sometimes it's worth doing a tcpdump/wireshare packet capture and see what's going on. I'm not aware of any user setting to set the extension to debug mode. With Wireshark I was able to see the error almost immediately. In my case it was short name instead of fqdn retrieved from the SCAN name outside of my DNS domain resolutions.

Certified Dynatrace Master | Alanata a.s., Slovakia, Dynatrace Master Partner

sivart_89
Mentor

Thank you all for your input here. Got pulled away from this a bit but looking now I no longer see the issue. I will keep these things in mind for the future.

Featured Posts