hi all
I'm constantly getting into the event monitor the following message:
SQL query failed (Query = "INSERT INTO object_custom_attributes (object_id,attr_name,attr_value) VALUES (?,?,?)"): columns object_id, attr_name are not unique
the table object_custom_attributes is empty.
Does anyone know that I have to do to fix it?
thanks.
Hi!
Did you try to configure any custom attributes for some object?
Best regards,
Victor
not sure....
i have installed a new netxms server from scratch into the same network. later i will know if this behavior is reproducible in the new server
thanks for your very fast response
starting from scratch here is the findings.
the message
SQL query failed (Query = "INSERT INTO object_custom_attributes (object_id,attr_name,attr_value) VALUES (?,?,?)"): columns object_id, attr_name are not unique
does not appear anymore but every time I try to add a third element to a pair of objects that are already attached with the function 'link selected object (Ctrl+L)' this message appears:
SYS_DB_QUERY_FAILED Database query failed (Query: INSERT INTO network_map_links (map_id,element1,element2,link_type,link_name,connector_name1,connector_name2,color,status_object,routing,bend_points) VALUES (?,?,?,?,?,?,?,?,?,?,?); Error: columns map_id, element1, element2 are not unique)
I get a same problem
25.09.2013 11:31:08 MYConsole Critical SYS_DB_QUERY_FAILED Database query failed (Query: INSERT INTO network_map_links (map_id,element1,element2,link_type,link_name,connector_name1,connector_name2,color,status_object,routing,bend_points) VALUES (?,?,?,?,?,?,?,?,?,?,?); Error: columns map_id, element1, element2 are not unique).
Does anyone know How can I fix it?
Thanks.