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

SQL Server 2005/2008 DB upgrade - 6.0.11 to 6.1.x causes UpgradeException

    Details

      Description

      Verify exceptions during the SQL Server 2005 and 2008 DB upgrade process from 6.0.11 to 6.1.x.

      SQL Server 2005 - 6.0.11 to 6.1.x

      22:56:11,807 INFO  [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_0_12.UpgradeScheduler
      22:56:11,815 ERROR [MainServlet:213] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.reflect.UndeclaredThrowableException
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.reflect.UndeclaredThrowableException
              at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
              at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1286)
              at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:210)
              at javax.servlet.GenericServlet.init(GenericServlet.java:160)
              at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
              at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
              at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
              at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
              at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
              at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
              at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
              at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
              at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
              at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
              at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1585)
              at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
              at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
              at java.util.concurrent.FutureTask.run(FutureTask.java:138)
              at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
              at java.lang.Thread.run(Thread.java:662)
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.reflect.UndeclaredThrowableException
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:213)
              at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:103)
              at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:56)
              at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:36)
              at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:130)
              at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:48)
              at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:129)
              at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144)
              at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
              ... 20 more
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.reflect.UndeclaredThrowableException
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:213)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:227)
              at com.liferay.portal.upgrade.UpgradeProcess_6_0_12.doUpgrade(UpgradeProcess_6_0_12.java:57)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
              ... 28 more
      Caused by: java.lang.reflect.UndeclaredThrowableException
              at $Proxy284.next(Unknown Source)
              at com.liferay.portal.upgrade.v6_0_12.UpgradeScheduler.getUpgradeQuartzData(UpgradeScheduler.java:107)
              at com.liferay.portal.upgrade.v6_0_12.UpgradeScheduler.doUpgrade(UpgradeScheduler.java:72)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
              ... 31 more
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: Upgrade code using unsupported class type 2004
              at com.liferay.portal.kernel.upgrade.dao.orm.UpgradeOptimizedResultSetHandler._getValue(UpgradeOptimizedResultSetHandler.java:159)
              at com.liferay.portal.kernel.upgrade.dao.orm.UpgradeOptimizedResultSetHandler._cacheColumnValues(UpgradeOptimizedResultSetHandler.java:115)
              at com.liferay.portal.kernel.upgrade.dao.orm.UpgradeOptimizedResultSetHandler.invoke(UpgradeOptimizedResultSetHandler.java:80)
              ... 35 more

      SQL Server 2008 - 6.0.11 to 6.1.x

      23:09:08,135 INFO  [UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_0_12.UpgradeScheduler
      23:09:08,144 ERROR [MainServlet:213] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.reflect.UndeclaredThrowableException
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.reflect.UndeclaredThrowableException
              at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
              at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1286)
              at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:210)
              at javax.servlet.GenericServlet.init(GenericServlet.java:160)
              at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
              at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
              at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
              at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
              at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
              at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
              at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
              at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
              at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
              at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
              at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1585)
              at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
              at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
              at java.util.concurrent.FutureTask.run(FutureTask.java:138)
              at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
              at java.lang.Thread.run(Thread.java:662)
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.reflect.UndeclaredThrowableException
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:213)
              at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:103)
              at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:56)
              at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:36)
              at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:130)
              at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:48)
              at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:129)
              at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144)
              at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
              ... 20 more
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.reflect.UndeclaredThrowableException
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:213)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:227)
              at com.liferay.portal.upgrade.UpgradeProcess_6_0_12.doUpgrade(UpgradeProcess_6_0_12.java:57)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
              ... 28 more
      Caused by: java.lang.reflect.UndeclaredThrowableException
              at $Proxy284.next(Unknown Source)
              at com.liferay.portal.upgrade.v6_0_12.UpgradeScheduler.getUpgradeQuartzData(UpgradeScheduler.java:107)
              at com.liferay.portal.upgrade.v6_0_12.UpgradeScheduler.doUpgrade(UpgradeScheduler.java:72)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
              ... 31 more
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: Upgrade code using unsupported class type 2004
              at com.liferay.portal.kernel.upgrade.dao.orm.UpgradeOptimizedResultSetHandler._getValue(UpgradeOptimizedResultSetHandler.java:159)
              at com.liferay.portal.kernel.upgrade.dao.orm.UpgradeOptimizedResultSetHandler._cacheColumnValues(UpgradeOptimizedResultSetHandler.java:115)
              at com.liferay.portal.kernel.upgrade.dao.orm.UpgradeOptimizedResultSetHandler.invoke(UpgradeOptimizedResultSetHandler.java:80)
              ... 35 more

        Attachments

          Activity

            People

            Assignee:
            catherine.lui Catherine Lui (Inactive)
            Reporter:
            albert.lee Albert Lee
            Participants of an Issue:
            Recent user:
            Marta Elicegui
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              9 years, 2 weeks, 6 days ago

                Packages

                Version Package
                6.1.1 CE GA2
                6.1.20 EE GA2
                --Sprint 11/12
                6.2.0 CE M2