Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (Flatly)
  • No Skin
Collapse
Brand Logo

NetXMS Forum

  1. Home
  2. Support
  3. Netxms Grafana Error parse date

Netxms Grafana Error parse date

Scheduled Pinned Locked Moved Support
3 Posts 1 Posters 20.5k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • H
    H
    haryt
    wrote on last edited by
    #1

    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

    1 Reply Last reply
    0
    • H
      H
      haryt
      wrote on last edited by
      #2

      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"
          }
                ]
              }

      1 Reply Last reply
      0
      • H
        H
        haryt
        wrote on last edited by
        #3

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

        1 Reply Last reply
        0

        Hello! It looks like you're interested in this conversation, but you don't have an account yet.

        Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

        With your input, this post could be even better 💗

        Register Login
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        Powered by NodeBB Contributors
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • Users
        • Groups