Cannot import LAR with layoutId greater than the maximum integer size

• Type: Regression Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.X EE, Master
• Fix Version/s: 6.2.X EE, 7.0.0 DXP FP2, 7.0.0 DXP SP1, 7.0.3 CE GA4, 7.1.X, Master
• Component/s: Staging, Staging > Export/Import
• Labels:
  • 62-ee-sp20
  • QA-NA
  • liferay-digital-enterprise-70-sp1
  • liferay-fixpack-de-2-7010
  • liferay-fixpack-portal-154-6210
• Branch Version/s:
  7.0.x, 6.2.x
• Backported to Branch:
  Committed
• Story Points: 1.25
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/42122

Steps to Reproduce

1. On a clean liferay 6.2 with hotfix 17083 (Client used a postgreSQL database to reproduce the issue, I reproduced with Mysql 5.6)
2. Update the COUNTER table to increase their currentId over an integer length eg: 4611686018427387900
update COUNTER set currentid=4611686018427387900 where name='com.liferay.portal.model.ResourcePermission';
update COUNTER set currentid=4611686018427387900 where name='com.liferay.counter.model.Counter';
3. In the control panel -> server administration -> resources do "Clear the database cache."
4. Create a new blank site with the default options
5. Add a new page to the site created
6. Update the new layout counter in database (the id between the two '#' is the groupid from the created site):
update COUNTER set currentid=4611686018427387900 where name='com.liferay.portal.model.Layout#4611686018427415369#false';
It easier to find the right name with "select * from COUNTER;"
7. In the control panel -> server administration -> resources do "Clear the database cache."
8. Add another new page to the site created
9. Go to that page on the frontend and add a new web content:
1. Add -> content -> add new -> web content article
2. Fill in the required fields
3. Publish
10. Back to the site admin -> Site pages
11. Do export
12. keep default option -> export
13. download the lar
14. Create another new blank site with the default options
15. Go to the Site admin -> Site pages section
16. Do import
17. Select the downloaded lar -> continue -> keep the default oprtion -> continue -> keep the default oprtion -> import
18. The error message is shown:

An unexpected error occurred with the publication process. Please check your portal and publising configuration.
      com.liferay.portal.NoSuchLayoutException: No Layout exists with the primary key 0
    and the stacktrace (full stack in attachement):
      com.liferay.portal.kernel.lar.PortletDataException: com.liferay.portal.NoSuchLayoutException: No Layout exists with the primary key 0
          at com.liferay.portal.kernel.lar.BasePortletDataHandler.processImportPortletPreferences(BasePortletDataHandler.java:599)
          at com.liferay.portal.lar.PortletImporter.importPortletPreferences(PortletImporter.java:1173)
          at com.liferay.portal.lar.LayoutImporter.doImportLayouts(LayoutImporter.java:778)
          at com.liferay.portal.lar.LayoutImporter.importLayouts(LayoutImporter.java:249)

Please note that these steps are just an example of how to reproduce the issue more easily.