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
We will add checking for this situation to nxdbmgr. You can track the progress in this issue: https://track.radensolutions.com/issue/NX-1851
Thanks Filipp.