Grafana dashboard not showing more than 100 rows

Grafana Configuration
1

  • What Grafana version and what operating system are you using? - v8.3.2 (afb9e8e5f3)

  • What are you trying to achieve?- One of my query setup in Grafana is not returning more than 100 rows.

  • How are you trying to achieve it?

  • What happened?

  • What did you expect to happen?- The table in DB does have more than 100 records but its not showing in Grafana.

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?- I checked for limit parameter, rows limit parameter but did not find any to resolve this issue. Dont have URL handy now.

I need this issue to be resolved.

2

What datasource are you using, and what query options are configured?

3

Dashboard is not configured from backend.

4

oracle OEM (oracle-emcc-app) datasource,

5

Looks like this is not a Grafana issue, but you are reaching the limit specified by oracle.sysman.db.restfulapi.grafana.throttle.nontimeseries.maxnumrows property of your datasource.

From EMCC help:

Property Name Data Type Default Value Purpose
oracle.sysman.db.restfulapi.grafana.throttle.nontimeseries.maxnumrows number 100 Data Limit Determines the maximum number of rows to return when any query is executed for Grafana Plugin’s Non-timeseries Query Type option.

Try changing this property by emctl set command and see if it helps:

emctl set property -name oracle.sysman.db.restfulapi.grafana.throttle.nontimeseries.maxnumrows -value 1000

1 Like