Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-124277

SQLSyntaxErrorException when upgrading from 7.2.10 to master

    Details

      Description

      Steps to Reproduce:

      1. Import attached database (7.2.10 GA1) into Oracle.
      2. 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)
      

        Attachments

          Activity

            People

            Assignee:
            sharry.shi Sharry Shi
            Reporter:
            joyce.wang Joyce Wang
            Participants of an Issue:
            Recent user:
            Brian Wulbern
            Engineering Assignee:
            Hai Yu
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              39 weeks, 3 days ago

                Packages

                Version Package
                Master