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

DB2- Upgrade fails with UpgradeException

    Details

      Description

      Steps to reproduce:

      1. Configure bundles for upgrade
        portal-ext.properties
        jdbc.default.driverClassName=com.ibm.db2.jcc.DB2Driver
        jdbc.default.url=jdbc:db2://{IPAddressHere}:50000/lportal:deferPrepares=false;fullyMaterializeInputStreams=true;fullyMaterializeLobData=true;progresssiveLocators=2;progressiveStreaming=2;
        jdbc.default.username=administrator
        jdbc.default.password=password
        
        Create Database
        create database lportal pagesize 32768 temporary tablespace managed by automatic storage;
        
      2. Start Portal 6.1 EE GA3 SP5
      3. Shut down Portal 6.1 EE GA3 SP5
      4. Upgrade to ee-6.2.x
        portal-ext.properties
        jdbc.default.driverClassName=com.ibm.db2.jcc.DB2Driver
        jdbc.default.url=jdbc:db2://{IPAddressHere}:50000/lportal:deferPrepares=false;fullyMaterializeInputStreams=true;fullyMaterializeLobData=true;progresssiveLocators=2;progressiveStreaming=2;
        jdbc.default.username=administrator
        jdbc.default.password=password
        liferay.home=E:/release-bundles/liferay-portal-6.1.30-ee-sp5
        passwords.encryption.algorithm.legacy=SHA
        

      Expected result:
      Upgrade completes successfully.

      Actual result:
      Console throws the following exceptions and fails to start:

      05:11:50,200 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeMessageBoards
      05:11:50,208 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeMessageBoardsAttachments
      05:11:50,245 ERROR [localhost-startStop-1][MainServlet:267] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7;ADMINISTRATOR.MBMESSAGE, DRIVER=3.63.123
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7;ADMINISTRATOR.MBMESSAGE, DRIVER=3.63.123
      	at com.liferay.portal.events.StartupAction.run(StartupAction.java:83)
      	at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1290)
      	at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:264)
      	at javax.servlet.GenericServlet.init(GenericServlet.java:158)
      	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
      	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
      	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
      	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5266)
      	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5554)
      	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
      	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
      	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
      	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
      	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677)
      	at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1912)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
      	at java.util.concurrent.FutureTask.run(Unknown Source)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      	at java.lang.Thread.run(Unknown Source)
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7;ADMINISTRATOR.MBMESSAGE, DRIVER=3.63.123
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:170)
      	at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:167)
      	at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:115)
      	at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:95)
      	at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:132)
      	at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:61)
      	at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:143)
      	at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:184)
      	at com.liferay.portal.events.StartupAction.run(StartupAction.java:77)
      	... 19 more
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7;ADMINISTRATOR.MBMESSAGE, DRIVER=3.63.123
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:170)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:184)
      	at com.liferay.portal.upgrade.UpgradeProcess_6_2_0.doUpgrade(UpgradeProcess_6_2_0.java:82)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:167)
      	... 27 more
      Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7;ADMINISTRATOR.MBMESSAGE, DRIVER=3.63.123
      	at com.ibm.db2.jcc.am.fd.a(fd.java:682)
      	at com.ibm.db2.jcc.am.fd.a(fd.java:60)
      	at com.ibm.db2.jcc.am.fd.a(fd.java:127)
      	at com.ibm.db2.jcc.am.vn.b(vn.java:4031)
      	at com.ibm.db2.jcc.am.vn.a(vn.java:4013)
      	at com.ibm.db2.jcc.t4.cb.a(cb.java:835)
      	at com.ibm.db2.jcc.t4.cb.n(cb.java:801)
      	at com.ibm.db2.jcc.t4.cb.j(cb.java:253)
      	at com.ibm.db2.jcc.t4.cb.d(cb.java:55)
      	at com.ibm.db2.jcc.t4.q.c(q.java:44)
      	at com.ibm.db2.jcc.t4.sb.j(sb.java:147)
      	at com.ibm.db2.jcc.am.ho.ib(ho.java:2119)
      	at com.ibm.db2.jcc.am.io.b(io.java:4299)
      	at com.ibm.db2.jcc.am.io.cc(io.java:722)
      	at com.ibm.db2.jcc.am.io.executeQuery(io.java:696)
      	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1418)
      	at com.liferay.portal.upgrade.v6_2_0.UpgradeMessageBoardsAttachments.updateAttachments(UpgradeMessageBoardsAttachments.java:88)
      	at com.liferay.portal.kernel.upgrade.v6_2_0.BaseUpgradeAttachments.doUpgrade(BaseUpgradeAttachments.java:420)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:167)
      	... 30 more
      
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              lu.liu Lu Liu
              Reporter:
              lu.liu Lu Liu
              Participants of an Issue:
              Recent user:
              Nicole Mak
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                3 years, 24 weeks, 2 days ago

                  Packages

                  Version Package
                  6.2.X EE