we have activated with DPA ver. 2020.2 the monitoring of some Postgres instances, anyway we've noticed in Postgres daily logs that there is a query of DPA returning syntax error:
STATEMENT: SELECT sysdate FROM dual
ERROR: relation "dual" does not exist at character 21
That is because there is no DUAL in Postgres, seems an Oracle query this one, in effect in Postgres should be used one of these:
I think we hit a bug of DPA, any ideas how to solve it?
Logispin Austria GmbH