NetXMS Support Forum

English Support => General Support => Topic started by: haryt on April 04, 2020, 08:26:29 AM

Title: Netxms Grafana Error parse date
Post by: haryt on April 04, 2020, 08:26:29 AM
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
Title: Re: Netxms Grafana Error parse date
Post by: haryt on April 12, 2020, 10:23:00 AM
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"
    }
          ]
        }
Title: Re: Netxms Grafana Error parse date
Post by: haryt on April 13, 2020, 09:52:13 AM
SOLVED
Found out that since 4 days there is a new Version of the datasource on Git (but nor message About this..)