Hello,

When I did NXQL with Nuxeo Automation I got some documents with : path:null and uid:uid:null

This documents got an ID, a title, and some data files and a lifecycle state.

But why did I got that documents in my database, because this documents doesn't exist in the interface and doesn't have a path ?

To be sure, i cleaned all my binaries and doesn't got any binaries orphans.

Moreover, this is all versions documents, but in database, their versions.versionableid doesn't exist in hierarchy table… This is all documents like that :

select * from hierarchy where id in (select v.id from versions v left join hierarchy h on h.id=v.versionableid where h.id is null) order by name;

I don't understand anything about that.. if you know what are this zombies, please tell me.

thank you