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. SYS_DB_QUERY_FAILED in object_properties

SYS_DB_QUERY_FAILED in object_properties

Scheduled Pinned Locked Moved Support
3 Posts 1 Posters 19.0k 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.
  • L
    L
    lhpaladin
    wrote on last edited by
    #1

    Hello everybody:

    Netxms is showing an error in the INSERT of the object_properties table with the following message:
    22P02 ERROR: invalid input syntax for type integer: \"-(\"

    Is there any way to find the object that is generating this error?

    Thanks!

    1 Reply Last reply
    0
    • L
      L
      lhpaladin
      wrote on last edited by
      #2

      Solved in 4.4.1!

      1 Reply Last reply
      0
      • L
        L
        lhpaladin
        wrote on last edited by
        #3

        Hi,

        I noticed that the error appeared again, but observing the repetition of the event I understood that when NetXMS adds a new node through network discovery, this node would later generate the error in the database.
        I'm not sure what the reason is, but it seems to me that if the node is not compatible with the agent, simply check the option to disable the use of the NetXMS agent in the status poll and the error would disappear.

        It seems to be some bug.

        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