Oracle data is not returning results, when the query ran on DB runs fine

1

Hi,

Do you know if I’m missing anything. When I run a query it returns results in SQL developer. when I try to execute the Grafana it seems returns nothing and no error message as well.

SELECT
RecordDateStart AS time,
CHANNELNAME AS metric,
TRANSACTIONSCOMPLETED AS value
FROM transactions

Here is a simple query. where
RecordDateStart - Date type,
TRANSACTIONSCOMPLETED - Number (10,0)
CHANNELNAME - Varchar(45)

any inputs are appreciated.

Thanks.

2

How many rows does this query return?

Are there any messages in the grafana server log indicating a problem?

Can you enable debug output on your grafana server and see if anything else shows up?

With debug enabled we can diagnose it further.