Text only | Text with Images

NetXMS Support Forum

English Support => General Support => Topic started by: lhpaladin on July 16, 2023, 06:24:07 PM

Title: SYS_DB_QUERY_FAILED in object_properties
Post by: lhpaladin on July 16, 2023, 06:24:07 PM
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!
Title: Re: SYS_DB_QUERY_FAILED in object_properties
Post by: lhpaladin on August 01, 2023, 08:04:04 PM
Solved in 4.4.1!
Title: Re: SYS_DB_QUERY_FAILED in object_properties
Post by: lhpaladin on October 26, 2023, 01:16:24 AM
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.
Text only | Text with Images