topic Re: Problem wih CUSTOM DB Queries in Open Q&A

Problem wih CUSTOM DB Queries

gustavodutra — Thu, 06 Jul 2023 19:18:02 GMT

Hey, guys.

I recently tried to set up custom database queries in my environment.

But, I am getting this "FATAL dynatrace-jdbc-connector(main)" error. I tested my query in PL SQL and it runs normally.

Could someone help me resolve this error or point me to a way to resolve it?

Re: Problem wih CUSTOM DB Queries

michiel_otten — Thu, 06 Jul 2023 16:38:59 GMT

Hi,

I've experienced something simular. It ended up having something to do with my configuration in the plugin.

Could you perhaps share your configuration?

Kr.

Michiel

Re: Problem wih CUSTOM DB Queries

gustavodutra — Thu, 06 Jul 2023 19:18:38 GMT

Hello friend how are you?

I didn't quite understand the request, would the plugin configuration be the one in the path Settings > Monitoring > Monitored technologies > Generic DB Query Plugin?

If yes, I will attach it in PDF. I count on your help!

Re: Problem wih CUSTOM DB Queries

michiel_otten — Thu, 06 Jul 2023 17:34:39 GMT

Hi there,

So how this plugin works: you'll need to get a numeric value, f.e. Count(*)

Why? Because you're pushing metrics, so we would need an number. Could you try editing the query to Select COUNT(*) FROM [TABLENAME] ?

see if we get any results?

Re: Problem wih CUSTOM DB Queries

gustavodutra — Thu, 06 Jul 2023 19:19:18 GMT

Hello, I tried to change as requested and still got no response. Here's a print and the query change.

Re: Problem wih CUSTOM DB Queries

michiel_otten — Thu, 06 Jul 2023 18:17:28 GMT

Do you know for sure that the PORT connecting towards is correct? Also, since this is an activegate plug-in, could you see what's in that LOG?

I'm curious if the JDBC connection is actually set up?

Re: Problem wih CUSTOM DB Queries

gustavodutra — Thu, 06 Jul 2023 19:19:55 GMT

OK let's go.

My port is configured on port 1521, according to a TNSNAMES I have in my SQL PL that can call that same query.

I don't have access to the server where Active Gate is installed, but I see some logs through Dynatrace that I'm not sure if they are related, because I disabled this plugin to test and it kept collecting that same log.

Does JDBC need to be installed on the host that is Active Gate? Not sure about that as I don't have access.

Detail, I get these logs all day long. I don't think it's related to the plugin.

Re: Problem wih CUSTOM DB Queries

michiel_otten — Thu, 06 Jul 2023 20:15:08 GMT

Don't think is necessary to install extra stuff looking at the installation requirements.

Probably it's not the right log if it keeps logging whilst disabled. Could we just try: select count(*)
from [table]?

Just to see if the problem is in the query?

For the logging, a plug-in probably generates its own log file on the activegate. Could you check var/lib/dynatrace/remotepluginmodule/log/remoteplugin? Should also be able to import this.

Re: Problem wih CUSTOM DB Queries

gustavodutra — Thu, 06 Jul 2023 19:05:40 GMT

Okay, I'll change the query to test.

About the logs, I don't have access to the host where ActiveGate is hosted, I'll need to ask someone who has access.

Re: Problem wih CUSTOM DB Queries

gustavodutra — Thu, 06 Jul 2023 19:33:24 GMT

I took a look at the logs and noticed the return of error ORA-01858. Any idea how to resolve?

Re: Problem wih CUSTOM DB Queries

michiel_otten — Thu, 06 Jul 2023 19:35:45 GMT

ORA-01858: a non-numeric character was found where a numeric was expected

Is this with the old or the new query?

Re: Problem wih CUSTOM DB Queries

gustavodutra — Thu, 06 Jul 2023 19:37:20 GMT

With any one query.

I think the problem is in the date, I'll change it to numbers and run again.

Re: Problem wih CUSTOM DB Queries

gustavodutra — Thu, 06 Jul 2023 20:07:27 GMT

Hey, friend.

Based on the logs, I changed the date query parameter for the model: XX/Month Number/XXXX instead of XX/Month/XXXX.

I would like to thank you for your help, and if possible edit your comment sent at 11:45 am where you have some information about my query and delete it.

I am very happy if you can do this, thank you very much and have a nice day.

Re: Problem wih CUSTOM DB Queries

michiel_otten — Thu, 06 Jul 2023 20:15:43 GMT

Done! Good luck with it 🙂