DX Application Performance Management

Expand all | Collapse all

APMSQLServer and Simple JSON plugin…no data points

  • 1.  APMSQLServer and Simple JSON plugin…no data points

    Posted 09-10-2018 02:06 PM

    Hello, I am trying to connect Grafana Dashboard with APMSQL through the JSON Data Source and a Tomcat Server.

    I am new in Grafana, so I will try to explain well my problem:

    • I have defined the resource in the tomcat context.xml file, with all the connection info, jdbc url, user, password, etc…

    • I have deployed the grafanarest.war in the webapps tomcat folder.

    • I have succesfully installed the simple json plugin in grafana.

    • I have created a new DataSource, SimpleJson Type, pointing to “mytomcatip:10000/grafanarest”, tested the connection, and it works.

    • I try to create a new dashboard, using my json datasource, with just a simple metric like apmsql 'spcdsrvv3266|.*|.*'  'CPU:Processor Count'  agg_value exact defined as timeserie…but it never works, it only shows the text “no data points” in the graph.

    If I open the Query Inspector see the query is not being executed or is not returning any data.

     

    {
      "data": "",
      "status": 200,
      "statusText": "OK",
      "xhrStatus": "complete",
      "request": {
        "method": "POST",
        "url": "api/datasources/proxy/1/query",
        "data": {
          "timezone": "browser",
          "panelId": 2,
          "dashboardId": 2,
          "range": {
            "from": "2018-09-10T17:58:41.862Z",
            "to": "2018-09-10T18:03:41.863Z",
            "raw": {
              "from": "now-5m",
              "to": "now"
            }
          },
          "rangeRaw": {
            "from": "now-5m",
            "to": "now"
          },
          "interval": "500ms",
          "intervalMs": 500,
          "targets": [
            {
              "target": "apmsql 'spcdsrvv3266|.*|.*'  'CPU:Processor Count'  agg_value exact",
              "refId": "B",
              "hide": false,
              "type": "timeserie"
            }
          ],
          "maxDataPoints": 720,
          "scopedVars": {
            "__interval": {
              "text": "500ms",
              "value": "500ms"
            },
            "__interval_ms": {
              "text": "500",
              "value": "500"
            }
          },
          "adhocFilters": []
        }
      }
    }

     

     

     

    I can´t find what is wrong, as all the pieces seem to be well configured, the datasource is working, the credentials for the apmsql are the right ones, etc…What am I missing?

    ps: im running apm 10.7 SP1

    Thanks a lot in advance.



  • 2.  Re: APMSQLServer and Simple JSON plugin…no data points

    Posted 09-13-2018 08:44 AM

    Dear Community:

    Can someone respond to Felix?



  • 3.  Re: APMSQLServer and Simple JSON plugin…no data points

    Posted 10-03-2018 12:39 PM
    please, you can close this discussion,
    I have already updated my environment
    to 10.7_sp2 and managed to make integration
    work with grafana.