Issue
- If Document Library files are missing after performing a File Store Migration, can the missing files be identified?
Environment
- Liferay 7.4
Resolution
- The following Query may be able to check for what is missing from the Document Library
- The logic is that the the
path_
column in DLContent will always be the same as thename
column in DLFileEntry
- The logic is that the the
-
select DLFileEntry.fileEntryId, DLFileEntry.groupId, DLFileEntry.title, DLFileVersion.version
from DLFileVersion
inner join DLFileEntry on DLFileVersion.fileEntryId = DLFileEntry.fileEntryId
left outer join DLContent on DLFileEntry.name = DLContent.path_ and CONCAT(CONCAT(DLFileVersion.version, '~'), DLFileVersion.storeUUID) = DLContent.version
where DLContent.path_ is null;
Additional Information
Contenido exclusivo para suscriptores.
Una Suscripción Enterprise de Liferay proporciona acceso a más de 1.500 artículos que incluyen las mejores practicas, diagnóstico de problemas y otras soluciones útiles. Inicia sesión para tener un acceso completo.
Inicia sesión