Details

    • Type: Bug
    • Status: Closed
    • Resolution: Duplicate
    • Affects Version/s: 6.0.6 GA
    • Fix Version/s: 6.0.6 GA
    • Labels:
      None
    • Environment:
      Windows XP / Tomcat 7 / Oracle 10g / JRE 1.6

      Description

      With the tomcat bundle, when Oracle DB is configured, there are multiple errors at startup :

      16:27:19,428 ERROR [JDBCExceptionReporter:234] La taille des données est supérieure à la taille max. pour ce type: 4162
      16:27:19,444 ERROR [PortalInstances:468] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not insert: [com.liferay.portlet.dynamicdatamapping.model.impl.DDMStructureImpl]
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not insert: [com.liferay.portlet.dynamicdatamapping.model.impl.DDMStructureImpl]
      	at com.liferay.portal.events.AddDefaultDocumentLibraryStructuresAction.run(AddDefaultDocumentLibraryStructuresAction.java:61)
      	at com.liferay.portal.events.AddDefaultDataAction.run(AddDefaultDataAction.java:30)
      	at com.liferay.portal.events.EventsProcessorImpl.processEvent(EventsProcessorImpl.java:106)
      	at com.liferay.portal.events.EventsProcessorImpl.process(EventsProcessorImpl.java:58)
      	at com.liferay.portal.events.EventsProcessorUtil.process(EventsProcessorUtil.java:38)
      	at com.liferay.portal.util.PortalInstances._initCompany(PortalInstances.java:462)
      	at com.liferay.portal.util.PortalInstances.initCompany(PortalInstances.java:92)
      	at com.liferay.portal.servlet.MainServlet.initCompanies(MainServlet.java:793)
      	at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:355)
      	at javax.servlet.GenericServlet.init(GenericServlet.java:160)
      	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1228)
      	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1147)
      	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1043)
      	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4957)
      	at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5284)
      	at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5279)
      	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.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not insert: [com.liferay.portlet.dynamicdatamapping.model.impl.DDMStructureImpl]
      	at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:190)
      	at com.liferay.portlet.dynamicdatamapping.service.persistence.DDMStructurePersistenceImpl.updateImpl(DDMStructurePersistenceImpl.java:442)
      	at com.liferay.portlet.dynamicdatamapping.service.persistence.DDMStructurePersistenceImpl.updateImpl(DDMStructurePersistenceImpl.java:1)
      	at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.update(BasePersistenceImpl.java:254)
      	at com.liferay.portlet.dynamicdatamapping.service.impl.DDMStructureLocalServiceImpl.addStructure(DDMStructureLocalServiceImpl.java:98)
      	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.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:112)
      	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:59)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:59)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:59)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
      	at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
      	at $Proxy205.addStructure(Unknown Source)
      	at com.liferay.portlet.dynamicdatamapping.service.DDMStructureLocalServiceUtil.addStructure(DDMStructureLocalServiceUtil.java:284)
      	at com.liferay.portal.events.BaseDefaultDDMStructureAction.addDDMStructures(BaseDefaultDDMStructureAction.java:82)
      	at com.liferay.portal.events.AddDefaultDocumentLibraryStructuresAction.doRun(AddDefaultDocumentLibraryStructuresAction.java:225)
      	at com.liferay.portal.events.AddDefaultDocumentLibraryStructuresAction.run(AddDefaultDocumentLibraryStructuresAction.java:58)
      	... 20 more
      Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not insert: [com.liferay.portlet.dynamicdatamapping.model.impl.DDMStructureImpl]
      	at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
      	at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:122)
      	at com.liferay.portal.kernel.dao.orm.ClassLoaderSession.flush(ClassLoaderSession.java:218)
      	at com.liferay.portal.service.persistence.BatchSessionImpl.update(BatchSessionImpl.java:95)
      	at com.liferay.portal.service.persistence.BatchSessionUtil.update(BatchSessionUtil.java:49)
      	at com.liferay.portlet.dynamicdatamapping.service.persistence.DDMStructurePersistenceImpl.updateImpl(DDMStructurePersistenceImpl.java:437)
      	... 42 more
      Caused by: org.hibernate.exception.GenericJDBCException: could not insert: [com.liferay.portlet.dynamicdatamapping.model.impl.DDMStructureImpl]
      	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.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2454)
      	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2874)
      	at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
      	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
      	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
      	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
      	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
      	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
      	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
      	at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:119)
      

      and

      Loading file:/C:/DEV/LIFERAY/liferay-portal-tomcat-6.1.0-b3-20111020-1/liferay-portal-6.1.0/tomcat-7.0.21/temp/2-kaleo-web/WEB-INF/classes/service.properties
      16:27:38,231 ERROR [JDBCExceptionReporter:234] La taille des données est supérieure à la taille max. pour ce type: 12298
      16:27:38,231 ERROR [HotDeployUtil:114] com.liferay.portal.kernel.deploy.hot.HotDeployException: Error registering plugins for kaleo-web
      com.liferay.portal.kernel.deploy.hot.HotDeployException: Error registering plugins for kaleo-web
      	at com.liferay.portal.kernel.deploy.hot.BaseHotDeployListener.throwHotDeployException(BaseHotDeployListener.java:46)
      	at com.liferay.portal.deploy.hot.PluginPackageHotDeployListener.invokeDeploy(PluginPackageHotDeployListener.java:58)
      	at com.liferay.portal.kernel.deploy.hot.HotDeployUtil._doFireDeployEvent(HotDeployUtil.java:111)
      	at com.liferay.portal.kernel.deploy.hot.HotDeployUtil._fireDeployEvent(HotDeployUtil.java:188)
      	at com.liferay.portal.kernel.deploy.hot.HotDeployUtil.fireDeployEvent(HotDeployUtil.java:40)
      	at com.liferay.portal.kernel.servlet.WebContextListener.contextInitialized(WebContextListener.java:36)
      	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4723)
      	at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5226)
      	at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5221)
      	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.exception.SystemException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not insert: [com.liferay.portal.model.impl.ServiceComponentImpl]
      	at com.liferay.portal.service.impl.ServiceComponentLocalServiceImpl.initServiceComponent(ServiceComponentLocalServiceImpl.java:169)
      	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.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:112)
      	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:59)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:59)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
      	at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
      	at $Proxy86.initServiceComponent(Unknown Source)
      	at com.liferay.portal.service.ServiceComponentLocalServiceUtil.initServiceComponent(ServiceComponentLocalServiceUtil.java:272)
      	at com.liferay.portal.deploy.hot.PluginPackageHotDeployListener.initServiceComponent(PluginPackageHotDeployListener.java:218)
      	at com.liferay.portal.deploy.hot.PluginPackageHotDeployListener.doInvokeDeploy(PluginPackageHotDeployListener.java:120)
      	at com.liferay.portal.deploy.hot.PluginPackageHotDeployListener.invokeDeploy(PluginPackageHotDeployListener.java:55)
      	... 12 more
      Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not insert: [com.liferay.portal.model.impl.ServiceComponentImpl]
      	at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:190)
      	at com.liferay.portal.service.persistence.ServiceComponentPersistenceImpl.updateImpl(ServiceComponentPersistenceImpl.java:338)
      	at com.liferay.portal.service.persistence.ServiceComponentPersistenceImpl.updateImpl(ServiceComponentPersistenceImpl.java:1)
      	at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.update(BasePersistenceImpl.java:254)
      	at com.liferay.portal.service.impl.ServiceComponentLocalServiceImpl.initServiceComponent(ServiceComponentLocalServiceImpl.java:158)
      	... 29 more
      Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not insert: [com.liferay.portal.model.impl.ServiceComponentImpl]
      	at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
      	at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:122)
      	at com.liferay.portal.kernel.dao.orm.ClassLoaderSession.flush(ClassLoaderSession.java:218)
      	at com.liferay.portal.service.persistence.BatchSessionImpl.update(BatchSessionImpl.java:95)
      	at com.liferay.portal.service.persistence.BatchSessionUtil.update(BatchSessionUtil.java:49)
      	at com.liferay.portal.service.persistence.ServiceComponentPersistenceImpl.updateImpl(ServiceComponentPersistenceImpl.java:333)
      	... 32 more
      Caused by: org.hibernate.exception.GenericJDBCException: could not insert: [com.liferay.portal.model.impl.ServiceComponentImpl]
      	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.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2454)
      	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2874)
      	at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
      	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
      	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
      	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
      	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
      	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
      	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
      	at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:119)
      	... 36 more
      Caused by: java.sql.SQLException: La taille des données est supérieure à la taille max. pour ce type: 12298
      	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
      	at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:155)
      	at oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2531)
      	at oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1248)
      	at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:1690)
      	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setString(NewProxyPreparedStatement.java:963)
      	at org.hibernate.type.descriptor.sql.VarcharTypeDescriptor$1.doBind(VarcharTypeDescriptor.java:52)
      	at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:91)
      	at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:282)
      	at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:277)
      	at com.liferay.portal.dao.orm.hibernate.StringType.nullSafeSet(StringType.java:97)
      	at org.hibernate.type.CompositeCustomType.nullSafeSet(CompositeCustomType.java:235)
      	at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2184)
      	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2430)
      	... 45 more
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mika.koivisto Mika Koivisto
                Reporter:
                soncio69 michele soncini (Inactive)
                Participants of an Issue:
                Recent user:
                Brian Wulbern
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  7 years, 28 weeks, 2 days ago

                  Packages

                  Version Package
                  6.0.6 GA