Deleting records using livereports

Nutley_Roche_(rochenu_-_(deleted))

We're migrating documents into Livelink using an application that utilizes LAPI. During the migration process, a component of the server crashed and left us with over 3,000 documents that have an entry in the dtree table but nothing in the dversdata table. This results in these documents showing in the interface with a size of zero. We'd like to delete all these documents using livereports by running the following sql statement. Is this recommended or should we do this in another fashion?delete from dtree where subtype='144' and versionnum=0

Martin_Gäckler

a more robust statement is:delete from dtree where subtype=144 and not exist( select * from dversdata where dversdata.docid = dtree.dataid)