topic Query not working in custom Database query ActiveGate extension in Extensions

Query not working in custom Database query ActiveGate extension

sivart_89 — Tue, 20 Aug 2024 13:13:26 GMT

Our team is starting to do a POC on the Custom DB Query extension. I was told that if you could execute the query manually in something such as Toad then the extension should accept it as a valid query. However, that does not seem to be the case. I continue to get a 'ORA-00933: SQL command not properly ended' and have taken the same query I am using in the endpoint config (with same account) and executing in Toad and it works fine.

I have been able to get this extension to work with a different endpoint using a very basic query and on a different db.

Anyone face this issue? Or shall I send to the extensions team? Our extension version is 3.2.2

Re: Query not Working in Custom DB Query AG Extension

david_lopes — Thu, 25 Aug 2022 21:48:36 GMT

I am not sure how Toad works under the cover, but that error does seem to indicate that this query is not a valid SELECT statement. The extension is using a simple JDBC client to run the query with the executeQuery method.

Could you share the query string here for me to test?

If you don't want to share the query string here, please send it to extensions@dynatrace.com

Re: Query not Working in Custom DB Query AG Extension

sivart_89 — Thu, 25 Aug 2022 22:12:54 GMT

Thanks @david_lopes I have sent the query to the extensions email.

Re: Query not Working in Custom DB Query AG Extension

sivart_89 — Thu, 01 Sep 2022 21:54:51 GMT

@david_lopes quick update. I failed to remove the ; which I'm in the habit of using to terminate the query. Removing it fixed the issue. I then found out that null values are not accepted so I'm working with the app team to see if they can give me a query that will show a 0 rather than null