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

Upgrade from 6.0.11 to 6.1.x fails on Oracle

    Details

    • Story Points:
      3
    • Fix Priority:
      5

      Description

      Steps to reproduce:

      1. Start 6.0.11 with oracle database.
      2. Sign in administrator.
      3. Shut down 6.0.11.
      4. Try to upgrade to 6.1.x.

      The upgrade fails and the following exception is thrown in the log.

      Error Messages:

      07:25:49,928 INFO  [localhost-startStop-1][BaseDB:96] create index IX_1E5B9905 on WorkflowDefinitionLink (groupId, companyId, classNameId, classPK);
      07:25:49,937 INFO  [localhost-startStop-1][BaseDB:96] create index IX_705B40EE on WorkflowDefinitionLink (groupId, companyId, classNameId, classPK, typePK);
      07:25:49,969 INFO  [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyProcessSuite
      07:25:49,972 INFO  [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyProperties
      07:25:49,983 INFO  [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyDB2
      07:25:49,985 INFO  [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyMySQL
      07:25:49,986 INFO  [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyOracle
      07:25:57,566 INFO  [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifySQLServer
      07:25:57,568 INFO  [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyCounter
      07:25:57,616 INFO  [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyUUID
      07:25:57,670 INFO  [localhost-startStop-1][VerifyProcess:55] Verifying com.liferay.portal.verify.VerifyPermission
      07:25:58,223 ERROR [localhost-startStop-1][JDBCExceptionReporter:76] 列名无效
      07:25:58,235 ERROR [localhost-startStop-1][MainServlet:216] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not execute query
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not execute query
              at com.liferay.portal.events.StartupAction.run(StartupAction.java:55)
              at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1293)
              at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:213)
              at javax.servlet.GenericServlet.init(GenericServlet.java:160)
              at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1267)
              at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1186)
              at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1081)
              at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5027)
              at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)
              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:633)
              at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:657)
              at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1637)
              at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
              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:895)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
              at java.lang.Thread.run(Thread.java:662)
      Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not execute query
              at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:61)
              at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:110)
              at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:76)
              at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:46)
              at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:144)
              at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:65)
              at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:246)
              at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:156)
              at com.liferay.portal.events.StartupAction.run(StartupAction.java:49)
              ... 20 more
      Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not execute query
              at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:61)
              at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:66)
              at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:34)
              at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:58)
              ... 28 more
      Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not execute query
              at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.addResourcePermissions(ResourcePermissionLocalServiceImpl.java:249)
              at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:112)
              at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:215)
              at com.liferay.portal.security.pacl.PACLInvocationHandler.doInvoke(PACLInvocationHandler.java:61)
              at com.liferay.portal.security.pacl.PACLInvocationHandler.invoke(PACLInvocationHandler.java:50)
              at sun.proxy.$Proxy321.addResourcePermissions(Unknown Source)
              at com.liferay.portal.service.impl.ResourceActionLocalServiceImpl.checkResourceActions(ResourceActionLocalServiceImpl.java:207)
              at com.liferay.portal.service.impl.ResourceActionLocalServiceImpl.checkResourceActions(ResourceActionLocalServiceImpl.java:80)
              at sun.reflect.GeneratedMethodAccessor155.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:112)
              at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:215)
              at com.liferay.portal.security.pacl.PACLInvocationHandler.doInvoke(PACLInvocationHandler.java:61)
              at com.liferay.portal.security.pacl.PACLInvocationHandler.invoke(PACLInvocationHandler.java:50)
              at sun.proxy.$Proxy315.checkResourceActions(Unknown Source)
              at sun.reflect.GeneratedMethodAccessor155.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
              at com.liferay.portal.security.pacl.PortalSecurityManagerImpl$DoBeanLocatorImplPACL$1.invoke(PortalSecurityManagerImpl.java:466)
              at com.liferay.portal.security.pacl.PACLInvocationHandler.doInvoke(PACLInvocationHandler.java:61)
              at com.liferay.portal.security.pacl.PACLInvocationHandler.invoke(PACLInvocationHandler.java:50)
              at sun.proxy.$Proxy611.checkResourceActions(Unknown Source)
              at com.liferay.portal.service.ResourceActionLocalServiceUtil.checkResourceActions(ResourceActionLocalServiceUtil.java:283)
              at com.liferay.portal.verify.VerifyPermission.checkPermissions(VerifyPermission.java:77)
              at com.liferay.portal.verify.VerifyPermission.doVerify(VerifyPermission.java:190)
              at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:58)
              ... 31 more
      Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not execute query
              at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
              at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:120)
              at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:100)
              at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.addResourcePermissions(ResourcePermissionLocalServiceImpl.java:222)
              ... 60 more
      Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
              at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
              at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
              at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
              at org.hibernate.loader.Loader.doList(Loader.java:2545)
              at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
              at org.hibernate.loader.Loader.list(Loader.java:2271)
              at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
              at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
              at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
              at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
              at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:108)
              ... 62 more
      Caused by: java.sql.SQLException: 列名无效
              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
              at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3319)
              at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1926)
              at oracle.jdbc.driver.OracleResultSet.getLong(OracleResultSet.java:1575)
              at com.mchange.v2.c3p0.impl.NewProxyResultSet.getLong(NewProxyResultSet.java:2625)
              at org.hibernate.type.descriptor.sql.BigIntTypeDescriptor$2.doExtract(BigIntTypeDescriptor.java:61)
              at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64)
              at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:254)
              at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:250)
              at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:235)
              at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.extract(CustomLoader.java:505)
              at org.hibernate.loader.custom.CustomLoader$ResultRowProcessor.buildResultRow(CustomLoader.java:451)
              at org.hibernate.loader.custom.CustomLoader.getResultColumnOrRow(CustomLoader.java:348)
              at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:639)
              at org.hibernate.loader.Loader.doQuery(Loader.java:829)
              at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
              at org.hibernate.loader.Loader.doList(Loader.java:2542)
              ... 69 more
      Stopping the server due to unexpected startup errors
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              pani.gui Pani Gui (Inactive)
              Reporter:
              pani.gui Pani Gui (Inactive)
              Participants of an Issue:
              Recent user:
              Esther Sanz
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                7 years, 31 weeks, 5 days ago

                  Packages

                  Version Package
                  6.1.30 EE GA3
                  6.2.0 CE M6