Countries and regions are not properly upgraded to master

• Type: Regression Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: Master
• Fix Version/s: Master
• Component/s: User Management
• Labels:
  • QA-AUTOMATION
  • pt-upgrade-review
• Fix Priority: 5
• Last Working Version:
  7.3.10 DXP GA1
• Sprint: U&SM| S04 Sprint 4|11.24-12.15
• Git Pull Request: https://github.com/drewbrokke/liferay-portal/pull/1249
• QA Test Name:
  • LocalFile.UserUpgrade#ViewAndEditUserAfterUpgrade621015
  • LocalFile.UserUpgrade#ViewAndEditUserAfterUpgrade621021
  • LocalFile.UserUpgrade#ViewAndEditUserAfterUpgrade625
  • LocalFile.UserUpgrade#ViewAndEditUserAfterUpgrade70106
  • LocalFile.UserUpgrade#ViewAndEditUserAfterUpgrade704
  • LocalFile.UserUpgrade#ViewAndEditUserAfterUpgrade7110
  • LocalFile.UserUpgrade#ViewAndEditUserAfterUpgrade713
• QA Test Score: 35

Steps to reproduce:

1. Start 7.3 portal or below
2. Create a user
3. Edit user's address
4. Upgrade to master
5. Go to user

Expected results: Countries and regions added in previous version still exist. User can still successfully add an address in Users and Organizations.

Actual results:

• The following errors display after starting up:

  2020-12-04 22:02:38.235 ERROR [http-nio-8080-exec-2][JDBCExceptionReporter:234] Unknown column 'countryimp0_.defaultLanguageId' in 'field list'
  2020-12-04 22:02:38.237 ERROR [http-nio-8080-exec-2][JSONWebServiceServiceAction:126] com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not load an entity: [com.liferay.portal.model.impl.CountryImpl#19]
  

• Country does not display for existing users or organizations
• Countries and Region fields are not responsive
• Adding or editing address after upgrade result to console errors

Reproduced on:
Tomcat 9.0.33 + MySQL 5.7
Portal master GIT ID: f674c566d1d9ac9a2e33ac2e38b66af3b294e572