Print Page - 3.2/3.3 DCI items not tied to nodes

Title: 3.2/3.3 DCI items not tied to nodes
Post by: jermudgeon on May 06, 2020, 01:02:26 AM

I have 82421 collectible DCIs and an additional 25552 that are missing a corresponding node.

nxdbmgr check does not find and purge these.

There do not appear to be any leftover data in the corresponding idata tables.

select
   count(*)
   from items i
   left join object_properties p on i.node_id = p.object_id
   where p.name is null

Title: Re: 3.2/3.3 DCI items not tied to nodes
Post by: Filipp Sudanov on May 08, 2020, 01:08:08 PM

We will add checking for this situation to nxdbmgr. You can track the progress in this issue: https://track.radensolutions.com/issue/NX-1851

Title: Re: 3.2/3.3 DCI items not tied to nodes
Post by: jermudgeon on May 11, 2020, 06:10:03 PM

Thanks Filipp.

NetXMS Support Forum

English Support => General Support => Topic started by: jermudgeon on May 06, 2020, 01:02:26 AM