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

Unable to upgrade Image Gallery to 7 from 6.0.x: Missing IN or OUT parameter at index:: 1

    Details

      Description

      Steps to reproduce it:

      1. Startup a 6.0.x version
      2. Shutdown it
      3. Upgrade to 7

      You will get the following exception:

      15:17:10,250 INFO  [localhost-startStop-1][UpgradeProcess:175] Completed upgrade process com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery in 509ms
      15:17:10,250 INFO  [localhost-startStop-1][UpgradeProcess:175] Completed upgrade process com.liferay.portal.upgrade.UpgradeProcess_6_0_12_to_6_1_0 in 726436ms
      15:17:10,254 ERROR [localhost-startStop-1][MainServlet:238] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Missing IN or OUT parameter at index:: 1
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Missing IN or OUT parameter at index:: 1
              at com.liferay.portal.events.StartupAction.run(StartupAction.java:85)
              at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1317)
              at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:235)
              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(Executors.java:511)
              at java.util.concurrent.FutureTask.run(FutureTask.java:266)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
              at java.lang.Thread.run(Thread.java:745)
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Missing IN or OUT parameter at index:: 1
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:171)
              at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:179)
              at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:151)
              at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:133)
              at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:164)
              at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:81)
              at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:142)
              at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:176)
              at com.liferay.portal.events.StartupAction.run(StartupAction.java:79)
              ... 19 more
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Missing IN or OUT parameter at index:: 1
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:171)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:193)
              at com.liferay.portal.upgrade.UpgradeProcess_6_0_12_to_6_1_0.doUpgrade(UpgradeProcess_6_0_12_to_6_1_0.java:61)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:168)
              ... 27 more
      Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 1
              at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1821)
              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3579)
              at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
              at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
              at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:52)
              at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeQuery(HikariPreparedStatementProxy.java)
              at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.deleteConflictingIGPermissions(UpgradeImageGallery.java:345)
              at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.updateIGFolderPermissions(UpgradeImageGallery.java:842)
              at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.doUpgrade(UpgradeImageGallery.java:373)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:168)
              ... 30 more
      Stopping the server due to unexpected startup errors
       

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 44 weeks, 4 days ago

                  Packages

                  Version Package
                  7.0.0 Alpha 3