Quote from: Victor Kirhenshtein on May 11, 2024, 10:59:09 AMI just updated client application so that nodes without parent objects in infrastructure tree are not shown as root level objects. This change will be part of release 5.0.3.Thanks Victor, look forward to it.
Best regards,
Victor
Quote from: Filipp Sudanov on May 10, 2024, 08:47:24 PMNot sure why this is happening. Can you run the script I've shared manually (via Execute Script from context menu) on a couple of nodes which we bound to that container, but should not and share the output.
netxmsd[739160]: [db.drv ] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,map_image,drilldown_object_id,country,region,city,district,street_address,postcode,maint_event_id,state_before_maint,state,flags,creation_time,maint_initiator,alias,name_on_map,category,comments_source,asset_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON CONFLICT (object_id) DO UPDATE SET name=excluded.name,status=excluded.status,is_deleted=excluded.is_deleted,inherit_access_rights=excluded.inherit_access_rights,last_modified=excluded.last_modified,status_calc_alg=excluded.status_calc_alg,status_prop_alg=excluded.status_prop_alg,status_fixed_val=excluded.status_fixed_val,status_shift=excluded.status_shift,status_translation=excluded.status_translation,status_single_threshold=excluded.status_single_threshold,status_thresholds=excluded.status_thresholds,comments=excluded.comments,is_system=excluded.is_system,location_type=excluded.location_type,latitude=excluded.latitude,longitude=excluded.longitude,location_accuracy=excluded.location_accuracy,location_timestamp=excluded.location_timestamp,guid=excluded.guid,map_image=excluded.map_image,drilldown_object_id=excluded.drilldown_object_id,country=excluded.country,region=excluded.region,city=excluded.city,district=excluded.district,street_address=excluded.street_address,postcode=excluded.postcode,maint_event_id=excluded.maint_event_id,state_before_maint=excluded.state_before_maint,state=excluded.state,flags=excluded.flags,creation_time=excluded.creation_time,maint_initiator=excluded.maint_initiator,alias=excluded.alias,name_on_map=excluded.name_on_map,category=excluded.category,comments_source=excluded.comments_source,asset_id=excluded.asset_id"): 22P02 ERROR: invalid input syntax for type integer: "-("