-
Type:
Regression Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: Master
-
Fix Version/s: Master
-
Component/s: User Management > Business Accounts
-
Labels:
-
Story Points:5
-
Fix Priority:4
-
Git Pull Request:
-
QA Test Name:
- LocalFile.OrganizationUpgrade#AddOrganizationAfterUpgrade621015
- LocalFile.OrganizationUpgrade#AddOrganizationAfterUpgrade621021
- LocalFile.OrganizationUpgrade#AddOrganizationAfterUpgrade625
- LocalFile.OrganizationUpgrade#AddOrganizationAfterUpgrade70106
- LocalFile.OrganizationUpgrade#AddOrganizationAfterUpgrade704
- LocalFile.OrganizationUpgrade#AddOrganizationAfterUpgrade7110
- LocalFile.OrganizationUpgrade#AddOrganizationAfterUpgrade713
- LocalFile.OrganizationUpgrade#AddOrganizationAfterUpgrade720
- LocalFile.OrganizationUpgrade#AddOrganizationAfterUpgrade721
- LocalFile.OrganizationUpgrade#AddOrganizationAfterUpgrade7210
- LocalFile.OrganizationUpgrade#AddOrganizationAfterUpgrade72101
- LocalFile.OrganizationUpgrade#AddOrganizationAfterUpgrade730
- LocalFile.OrganizationUpgrade#AddUserandSuborganizationAfterUpgrade621015
- LocalFile.OrganizationUpgrade#AddUserandSuborganizationAfterUpgrade621021
- LocalFile.OrganizationUpgrade#AddUserandSuborganizationAfterUpgrade70106
- LocalFile.OrganizationUpgrade#AddUserandSuborganizationAfterUpgrade704
- LocalFile.OrganizationUpgrade#AddUserandSuborganizationAfterUpgrade7110
- LocalFile.OrganizationUpgrade#AddUserandSuborganizationAfterUpgrade713
- LocalFile.OrganizationUpgrade#AddUserandSuborganizationAfterUpgrade720
- LocalFile.OrganizationUpgrade#AddUserandSuborganizationAfterUpgrade721
- LocalFile.OrganizationUpgrade#AddUserandSuborganizationAfterUpgrade7210
- LocalFile.OrganizationUpgrade#AddUserandSuborganizationAfterUpgrade72101
- LocalFile.OrganizationUpgrade#AddUserandSuborganizationAfterUpgrade730
- LocalFile.PortalConfigurationUpgrade#ViewPortalConfigurationAfterUpgrade621015
- LocalFile.PortalConfigurationUpgrade#ViewPortalConfigurationAfterUpgrade621021
- LocalFile.PortalConfigurationUpgrade#ViewPortalConfigurationAfterUpgrade70106
- LocalFile.PortalConfigurationUpgrade#ViewPortalConfigurationAfterUpgrade704
- LocalFile.PortalConfigurationUpgrade#ViewPortalConfigurationAfterUpgrade7110
- LocalFile.PortalConfigurationUpgrade#ViewPortalConfigurationAfterUpgrade713
- LocalFile.PortalConfigurationUpgrade#ViewPortalConfigurationAfterUpgrade720
- LocalFile.PortalConfigurationUpgrade#ViewPortalConfigurationAfterUpgrade721
- LocalFile.PortalConfigurationUpgrade#ViewPortalConfigurationAfterUpgrade7210
- LocalFile.PortalConfigurationUpgrade#ViewPortalConfigurationAfterUpgrade72101
- LocalFile.PortalConfigurationUpgrade#ViewPortalConfigurationAfterUpgrade730
- LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive7210
- LocalFile.StagingUpgrade#ViewStagingDefaultSettingAfterUpgrade621021
- LocalFile.StagingUpgrade#ViewStagingDefaultSettingAfterUpgrade70106
- LocalFile.StagingUpgrade#ViewStagingDefaultSettingAfterUpgrade704
- LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade621015
- LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade621021
- LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade625
- LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade70106
- LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade704
- LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade7110
- LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade713
- LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade720
- LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade721
- LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade7210
- LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade72101
- LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade730
- LocalFile.UserUpgrade#ViewAndEditUserAfterUpgrade621015
- LocalFile.UserUpgrade#ViewAndEditUserAfterUpgrade621021
- LocalFile.UserUpgrade#ViewAndEditUserAfterUpgrade70106
- LocalFile.UserUpgrade#ViewAndEditUserAfterUpgrade704
- LocalFile.UserUpgrade#ViewAndEditUserAfterUpgrade7110
- LocalFile.UserUpgrade#ViewAndEditUserAfterUpgrade713
-
QA Test Score:280
Steps to Reproduce:
- Import attached database (7.2.10 GA1) into Oracle.
- Upgrade the database to master.
Expected Result:
Portal upgrades database and starts successfully during startup
Actual Result:
SQLSyntaxErrorException occurs during the upgrading process in the console:
[java] 12:48:13,394 INFO [main][UpgradeProcess:115] Failed upgrade process com.liferay.portal.upgrade.PortalUpgradeProcess in 7770 ms [java] com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLSyntaxErrorException: ORA-00904: "liferay.com": invalid identifier [java] [java] at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:109) [java] at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:156) [java] at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:119) [java] at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:182) [java] at com.liferay.portal.tools.DBUpgrader._upgradePortal(DBUpgrader.java:334) [java] at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:151) [java] at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:143) [java] at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:123) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [java] at java.lang.reflect.Method.invoke(Method.java:498) [java] at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:54) [java] Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLSyntaxErrorException: ORA-00904: "liferay.com": invalid identifier [java] [java] at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:109) [java] at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:131) [java] at com.liferay.portal.upgrade.PortalUpgradeProcess.doUpgrade(PortalUpgradeProcess.java:130) [java] at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:104) [java] ... 12 more [java] Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "liferay.com": invalid identifier [java] [java] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) [java] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807) [java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713) [java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167) [java] at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) [java] at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) [java] at com.liferay.portal.upgrade.v7_4_x.UpgradeRegion.doUpgrade(UpgradeRegion.java:48) [java] at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:104) [java] ... 15 more [java] Caused by: Error : 904, Position : 151, Sql = select User_.companyId, User_.userId from User_ join Company on User_.companyId = Company.companyId where User_.defaultUser = true and Company.webId = "liferay.com", OriginalSql = select User_.companyId, User_.userId from User_ join Company on User_.companyId = Company.companyId where User_.defaultUser = true and Company.webId = "liferay.com", Error Msg = ORA-00904: "liferay.com": invalid identifier [java] [java] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) [java] ... 33 more
Startup fails:
[parallel] 12:48:57,365 INFO [main][StartupHelperUtil:109] There are no patches installed [parallel] You must first upgrade the portal to the required schema version 10.0.0 [parallel] 12:48:57,539 ERROR [main][MainServlet:299] java.lang.RuntimeException: You must first upgrade the portal to the required schema version 10.0.0 [parallel] java.lang.RuntimeException: You must first upgrade the portal to the required schema version 10.0.0 [parallel] at com.liferay.portal.events.StartupHelperUtil.verifyRequiredSchemaVersion(StartupHelperUtil.java:224) [parallel] at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:104) [parallel] at com.liferay.portal.events.StartupAction.run(StartupAction.java:56) [parallel] at com.liferay.portal.internal.servlet.MainServlet.init(MainServlet.java:296) [parallel] at javax.servlet.GenericServlet.init(GenericServlet.java:158) [parallel] at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1134) [parallel] at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1089) [parallel] at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:983) [parallel] at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4864) [parallel] at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5173) [parallel] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [parallel] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717) [parallel] at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690) [parallel] at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705) [parallel] at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:631) [parallel] at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1830) [parallel] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [parallel] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [parallel] at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [parallel] at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:112) [parallel] at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:526) [parallel] at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:425) [parallel] at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1576) [parallel] at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:309) [parallel] at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123) [parallel] at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423) [parallel] at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366) [parallel] at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:936) [parallel] at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841) [parallel] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [parallel] at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384) [parallel] at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374) [parallel] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [parallel] at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [parallel] at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134) [parallel] at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909) [parallel] at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262) [parallel] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [parallel] at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421) [parallel] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [parallel] at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:930) [parallel] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [parallel] at org.apache.catalina.startup.Catalina.start(Catalina.java:738) [parallel] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [parallel] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [parallel] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [parallel] at java.lang.reflect.Method.invoke(Method.java:498) [parallel] at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:342) [parallel] at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:473)