Tuesday, November 25, 2014

[Liferay] Data Migration Tab Loading Issue Fix

If you have many files in document library of Liferay portal, this problem will occur. Data migration tab will not get loaded. Each uploaded/updated file creates entries to DLFileEntry and DLFileVersion tables in database.

When we load data migration tab in Control Panel > Server Administration > Data Migration, Liferay tries to get all the ConvertProcess types which can be used to migrate data. One of which is com.liferay.portal.convert.ConvertDocumentLibraryExtraSettings for which the query below runs. This query takes a lot of time to complete and depends on number of rows in both tables. This query may take almost 10 minutes for just 10000+ documents in your document library.

Usually the result is zero and the method call convertProcess.isEnabled() returns false. And if it is false, ConvertDocumentLibraryExtraSettings is not going to appear in the dropdown which lists all available conversion process. In this case, it should be safe to use this hook.

We do not have opportunity to always change the db and optimize indexes and queries. This query is in Liferay core code and we can not modify this. The good thing is that we do not always load ConvertDocumentLibraryExtraSettings to migrate data and if you can skip that, you are free to use this hook.

Once the hook is deployed, it will always load properly the Data Migration tab.

Hope this helps someone in need :)

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.