Portal does not request new password for the admin if database changed by Setup Wizard

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.2.X, Master
• Fix Version/s: 7.4.3.33 CE GA33, 7.4.3.34 CE GA34, Master
• Component/s: Portal Services > Configuration Management > Setup Wizard
• Labels:
  • 7.3-known-issues
  • 7.4-known-issues
  • QA-AUTOMATION
  • QA-FP
  • backend_test
  • liferay-ga1-ce-740
  • liferay-ga1-dxp-7413
  • liferay-ga10-ce-743
  • liferay-ga11-ce-743
  • liferay-ga12-ce-743
  • liferay-ga2-ce-741
  • liferay-ga4-ce-733
  • liferay-ga4-ce-743
  • liferay-ga5-ce-734
  • liferay-ga5-ce-743
  • liferay-ga6-ce-735
  • liferay-ga6-ce-743
  • liferay-ga7-ce-736
  • liferay-ga7-ce-743
  • liferay-ga8-ce-737
  • liferay-ga8-ce-743
  • liferay-ga9-ce-743
  • liferay-u1-dxp-7413
  • liferay-u2-dxp-7413
  • liferay-update-dxp-9-7413
• Fix Priority: 3
• Sprint: Infra QA Sprint 46, Infra QA Sprint 47
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/113313
• QA Test Name:
  • LocalFile.SetupWizardHSQL#HSQLtoHSQLLportal1SampleDataDisabled
  • LocalFile.SetupWizardHSQL#HSQLtoHSQLLportal1SampleDataEnabled
  • LocalFile.SetupWizardHSQL#HSQLtoMariaDB
  • LocalFile.SetupWizardHSQL#HSQLtoMariaDBSampleDataEnabled
  • LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade621015
  • LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade621021
  • LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade625
  • LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade70106
  • LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade704
  • LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade7110
  • LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade713
• QA Test Score: 49

UPDATED
Reproduce this issue on both Tomcat and Wildfly

Steps to Reproduce:

1. Start portal with default properties
2. Change database to connect to an empty MySQL schema in Setup Wizard
3. Save configuration
4. Restart portal
5. Navigate to localhost:8080 and login,
6. Follow first login prompts (Terms of Use, Password Reminder)

Expected Result:
User is asked to change password.

Actual Result:
User is not required to update password.

ORIGINAL STEPS
Note: This is an issue for Wildfly 14.

Steps to Reproduce:

1. Set up mariaDB using data-archive-portal-mariadb.zip. (This issue can be reproduced not only upgrading from 7.0, but also from 6.2 and 7.1, we only use this dump for example)
2. Upgrade to 7.2.
3. Start up 7.2 and config setup wizard.
4. Restart the portal.

Expected result:
Portal should direct to "Change Password" page.

Actual result:
Portal is not direct to "Change Password" page.