After upgrading from 6.1.30 to 6.2 the treePaths will be null

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.10 EE GA1, 6.2.X EE
• Fix Version/s: 6.2.4 CE GA5, 6.2.X EE
• Component/s: Core Infrastructure, Documents & Media
• Labels:
  • liferay-fixpack-portal-76-6210
• Branch Version/s:
  6.2.x
• Backported to Branch:
  Committed
• Story Points: 12
• Fix Priority: 3
• Git Pull Request: https://github.com/hhuijser/liferay-portal-ee/pull/2712

Reproduction steps:
1.) Start a vanilla 6.1.30 bundle..
2.) Go to Control Panel --> Documents and Media
3.) Create a folder "test" and upload a 3 basic documents (titles: "test2" "test3" and "ert") to this folder.

4.) Copy the document_library folder to a 6.2 instance, connect it to the 6.1 database through portal-ext.properties and start the bundle.
5.) Search for test in the Documents and Media: the folder is found but the documents are not shown (even after performing a reindex on all search indexes)

Experienced behavior: The uploaded documents are not found

Expected behavior: The uploaded documents should be found

The cause of the behavior is that there's no treePath column in the dlfileentry table on 6.1.30 and when you upgrade to 6.2 the treePath's value will be null in case of those documents which were uploaded before the upgrade. If you search for the documents in the Search portlet the documents are found.

Same issue for DLFileShortcuts, DLFileVersions and BookmarkEntries.