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

During portal upgrade process from 6.0.2 to 6.0.4 the Oracle database tomcat - could not load an entity: [com.liferay.counter.model.impl.CounterImpl#com.liferay.counter.model.Counter]

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 6.0.4 GA
    • Fix Version/s: 6.0.5 GA
    • Component/s: None
    • Labels:
      None
    • Environment:
      Liferay 6.0.2 on Tomcat and Oracle Database, Windows Vista
    • Branch Version/s:
      6.0.x

      Description

      I am trying to upgrade portal with 6.0.4 , Previous version was 6.0.2
      It shows following error while upgrading.

      11:58:13,738 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeAsset
      11:58:15,112 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeAssetPublisher
      11:58:15,300 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeDocumentLibrary
      11:58:16,519 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradeLookAndFeel
      11:58:16,675 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_3.UpgradePermission
      11:58:16,722 ERROR [JDBCExceptionReporter:101] ORA-01453: SET TRANSACTION must be first statement of transaction

      11:58:16,737 ERROR [MainServlet:196] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryTimeoutException: could not load an entity: com.liferay.counter.model.impl.CounterImpl#com.liferay.counter.model.Counter
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryTimeoutException: could not load an entity: com.liferay.counter.model.impl.CounterImpl#com.liferay.counter.model.Counter
      at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
      at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1160)
      at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:193)
      at javax.servlet.GenericServlet.init(GenericServlet.java:212)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
      at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
      at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
      at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
      at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
      at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
      at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
      at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
      at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
      at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
      at org.apache.catalina.core.StandardService.start(StandardService.java:519)
      at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
      at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
      at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryTimeoutException: could not load an entity: com.liferay.counter.model.impl.CounterImpl#com.liferay.counter.model.Counter
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
      at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:80)
      at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:37)
      at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
      at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
      at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:94)
      at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:117)
      at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
      ... 29 more
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryTimeoutException: could not load an entity: com.liferay.counter.model.impl.CounterImpl#com.liferay.counter.model.Counter
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:130)
      at com.liferay.portal.upgrade.UpgradeProcess_6_0_3.doUpgrade(UpgradeProcess_6_0_3.java:43)
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
      ... 36 more
      Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryTimeoutException: could not load an entity: com.liferay.counter.model.impl.CounterImpl#com.liferay.counter.model.Counter
      at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:183)
      at com.liferay.counter.service.persistence.CounterFinderImpl._obtainIncrement(CounterFinderImpl.java:383)
      at com.liferay.counter.service.persistence.CounterFinderImpl.createCounterRegister(CounterFinderImpl.java:225)
      at com.liferay.counter.service.persistence.CounterFinderImpl.createCounterRegister(CounterFinderImpl.java:177)
      at com.liferay.counter.service.persistence.CounterFinderImpl.getCounterRegister(CounterFinderImpl.java:252)
      at com.liferay.counter.service.persistence.CounterFinderImpl.increment(CounterFinderImpl.java:96)
      at com.liferay.counter.service.persistence.CounterFinderImpl.increment(CounterFinderImpl.java:88)
      at com.liferay.counter.service.persistence.CounterFinderImpl.increment(CounterFinderImpl.java:84)
      at com.liferay.counter.service.impl.CounterLocalServiceImpl.increment(CounterLocalServiceImpl.java:41)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:65)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      at $Proxy96.increment(Unknown Source)
      at com.liferay.counter.service.CounterLocalServiceUtil.increment(CounterLocalServiceUtil.java:122)
      at com.liferay.portal.dao.db.BaseDB.increment(BaseDB.java:151)
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.increment(UpgradeProcess.java:50)
      at com.liferay.portal.upgrade.v6_0_3.UpgradePermission.addSingleApproverWorkflowRoles(UpgradePermission.java:81)
      at com.liferay.portal.upgrade.v6_0_3.UpgradePermission.addSingleApproverWorkflowRoles(UpgradePermission.java:73)
      at com.liferay.portal.upgrade.v6_0_3.UpgradePermission.doUpgrade(UpgradePermission.java:244)
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
      ... 39 more
      Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryTimeoutException: could not load an entity: com.liferay.counter.model.impl.CounterImpl#com.liferay.counter.model.Counter
      at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
      at com.liferay.portal.dao.orm.hibernate.SessionImpl.get(SessionImpl.java:135)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:54)
      at $Proxy231.get(Unknown Source)
      at com.liferay.counter.service.persistence.CounterFinderImpl._obtainIncrement(CounterFinderImpl.java:361)
      ... 70 more
      Caused by: org.hibernate.QueryTimeoutException: could not load an entity: com.liferay.counter.model.impl.CounterImpl#com.liferay.counter.model.Counter
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:124)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      at org.hibernate.loader.Loader.loadEntity(Loader.java:1937)
      at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
      at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
      at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3270)
      at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
      at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
      at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
      at org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad(DefaultLoadEventListener.java:403)
      at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:155)
      at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080)
      at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1065)
      at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1056)
      at com.liferay.portal.dao.orm.hibernate.SessionImpl.get(SessionImpl.java:131)
      ... 77 more
      Caused by: java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction

      at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
      at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035)
      at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
      at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1223)
      at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1775)
      at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1744)
      at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:299)
      at oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:4062)
      at com.mchange.v2.c3p0.impl.NewProxyConnection.setTransactionIsolation(NewProxyConnection.java:701)
      at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.getTargetConnection(LazyConnectionDataSourceProxy.java:404)
      at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:366)
      at $Proxy4.prepareStatement(Unknown Source)
      at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
      at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
      at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
      at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1596)
      at org.hibernate.loader.Loader.doQuery(Loader.java:717)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
      at org.hibernate.loader.Loader.loadEntity(Loader.java:1933)
      ... 89 more
      Stopping the server due to unexpected startup errors

        Attachments

          Activity

            People

            Assignee:
            support-lep@liferay.com SE Support
            Reporter:
            milanapatel Milan Patel (Inactive)
            Participants of an Issue:
            Recent user:
            Marta Elicegui
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              11 years, 6 weeks, 4 days ago

                Packages

                Version Package
                6.0.5 GA