NetXMS Support Forum

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.