News:

We really need your input in this questionnaire

Main Menu

Netxms Grafana Error parse date

Started by haryt, April 04, 2020, 08:26:29 AM

Previous topic - Next topic

haryt

I got this error on Grafana since some week when I try to Access my Netxms Data, everything i tryed was witout success (delete datasource and recreate, Change tomcat on Netxms site, update Grafana, Netxms and both Debian OS....)
status:500
statusText:"Internal Server Error"
data:Object
description:"Unparseable date: "ri Apr 03 2020 19:14:26 GMT+020""
error:46
message:46

When testing the Datasource i got: Function expected sometimes the Error is different and says someting About the Http Header

And now the realy strange Thing: it happens on Edge all the time, on Chrome it is only the first minutes after rebooting the Server...... On mobilphone (Android with Chrome and Edge) it is aso not working, same Error as on Edge on Windows (just that both browser have this error)........
Any Ideas? I´m not sure if it is related to Grafana or Netxms.
Greetings
Hary from Vienna

haryt

#1
Found some strage Thing, the Datasource NETXMS trys to sort with the Settings from a complete different Datasource (a MySQL source that is local), found no way to Change this, even reinstalling NETXMS Datasource did not help%u2026. When I try to make a new Dashboard, also no success (can not choose any DCI from list, List is empty) Any ideas?

This is the string from JSON Model:

"targets": [   
{
          "dci": {
            "id": "670",
            "name": "CPU: usage"
          },
          "dciTarget": {
            "id": "184",
            "name": "mail.event-log.com"
          },
"format": "time_series",
          "group": [],
          "hide": false,
          "legend": "",
          "metricColumn": "none",
          "rawQuery": false,
          "rawSql": "SELECT\n  timeco1h AS \"time\",\n  id\nFROM co1h\nWHERE\n  $__timeFilter(timeco1h)\nORDER BY timeco1h",              I think this is the Problem!
          "refId": "A",
          "select": [
  [
              {
                "params": [
                  "id"
                ],
                "type": "column"
              }
            ]
          ],
          "table": "co1h",
          "timeColumn": "timeco1h",
          "timeColumnType": "timestamp",
          "type": "DCI",
          "where": [
            {
              "name": "$__timeFilter",
              "params": [],
              "type": "macro"
    }
          ]
        }

haryt

SOLVED
Found out that since 4 days there is a new Version of the datasource on Git (but nor message About this..)