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
会員限定記事
Liferay エンタープライズ サブスクリプションをお持ちのお客様は1500件を超えるベストプラクティス、トラブルシューティング、その他のソリューション記事を閲覧できます。ログインすると、記事全体をお読みいただけます。
ログイン