Delete Engine: Problem when trying to delete a page from a non translated page

Problem when you try to delete a page from an untranslated lang:

2008-06-16 11:22:30,774: ERROR [org.jahia.bin.JahiaAction] - Error
java.sql.SQLException: Wrong data type: For input string: "9657590a-b886-4c56-9029-d43adcfe70e6" in statement [select distinct jahiaconta0_.id_jahia_c
tn_lists as col_0_0_ from jahia_ctn_lists jahiaconta0_, jahia_ctnlists_prop jahiaconta1_ where jahiaconta1_.ctnlistid_ctnlists_prop=jahiaconta0_.id_ja
hia_ctn_lists and (jahiaconta0_.pageid_jahia_ctn_lists in ) and (jahiaconta0_.rights_jahia_ctn_lists in (? , ?) or (jahiaconta1_.name_ctnlists_prop
like 'view_field_acl_%') and (cast(jahiaconta1_.value_ctnlists_prop as integer)in (? , ?))) and jahiaconta0_.workflow_state>=1 and jahiaconta0_.versi
on_id<>-1]
at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
at org.hibernate.loader.Loader.doQuery(Loader.java:391)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.jahia.hibernate.dao.JahiaContainerListDAO.getContainerListIDsOnPagesHavingAcls(JahiaContainerListDAO.java:893)
at org.jahia.hibernate.manager.JahiaContainerListManager.getContainerListIDsOnPagesHavingAcls(JahiaContainerListManager.java:782)
at org.jahia.hibernate.manager.JahiaContainerListManager$$FastClassByCGLIB$$d1aefcab.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:546)
at org.jahia.hibernate.manager.JahiaContainerListManager$$EnhancerByCGLIB$$d830f348.getContainerListIDsOnPagesHavingAcls(<generated>)
at org.jahia.services.containers.JahiaContainersBaseService.getContainerListIDsOnPagesHavingAcls(JahiaContainersBaseService.java:2726)
at org.jahia.services.containers.JahiaContainersBaseService$$FastClassByCGLIB$$bd246c24.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:606)
at org.jahia.services.containers.JahiaContainersBaseService$$EnhancerByCGLIB$$f8dae8fd.getContainerListIDsOnPagesHavingAcls(<generated>)
at org.jahia.services.pages.ContentPage.isNegativeAclInListsOrContainersOrFields(ContentPage.java:413)
at org.jahia.services.pages.ContentPage.checkAccess(ContentPage.java:379)
at org.jahia.services.fields.ContentField.checkAccess(ContentField.java:2133)
at org.jahia.content.ContentObject.checkAccess(ContentObject.java:877)
at org.jahia.content.ContentObject.checkWriteAccess(ContentObject.java:831)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.checkContainerAccessRights(DeleteContainer_Engine.java:550)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.composeWarningMessages(DeleteContainer_Engine.java:539)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.processScreen(DeleteContainer_Engine.java:234)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.handleActions(DeleteContainer_Engine.java:175)
at org.jahia.operations.valves.EngineValve.processEngineRequest(EngineValve.java:180)
at org.jahia.operations.valves.EngineValve.invoke(EngineValve.java:82)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.J2ProcessActionValve.invoke(J2ProcessActionValve.java:144)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.SkeletonAggregatorValve.invoke(SkeletonAggregatorValve.java:73)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.PageAccessCheckValve.invoke(PageAccessCheckValve.java:73)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.OperationModeCheckValve.invoke(OperationModeCheckValve.java:83)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.SiteCheckValve.invoke(SiteCheckValve.java:78)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.EsiFragmentCacheReadValve.invoke(EsiFragmentCacheReadValve.java:329)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.EsiUrlCookieCheckValve.invoke(EsiUrlCookieCheckValve.java:313)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.pipelines.impl.GenericPipeline.invoke(GenericPipeline.java:195)
at org.jahia.operations.OperationManager.handleOperations(OperationManager.java:100)
at org.jahia.bin.JahiaAction.execute(JahiaAction.java:76)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.jahia.bin.JahiaRequestProcessor.process(JahiaRequestProcessor.java:82)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.jahia.bin.Jahia.process(Jahia.java:1661)
at org.jahia.bin.Jahia.service(Jahia.java:864)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.jahia.bin.filters.esi.ESIFilter.doFilter(ESIFilter.java:110)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
2008-06-16 11:22:30,821: INFO [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/jahia]] - Your Jahia Server has generated an error. Pl
ease review the details below for additional information:
Severity : CRITICAL
Error : User message=Error while processing request, System message=Exception in processing pipeline, root cause:could not execute query
URL : http://localhost:8080/jahia/Jahia/engineName/deletecontainer/op/edit/home/section1 Method : GET
Remote host : 127.0.0.1 Remote Address : 127.0.0.1
Request headers :
accept:/
accept-language:fr,en;q=0.7,ru;q=0.3
ua-cpu:x86
accept-encoding:gzip, deflate
user-agent:Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; FDM; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)
host:localhost:8080
connection:Keep-Alive
cookie:CP=null*; JSESSIONID=091D5DF439A95C05BE79548A5D5C401B; Jesi_Template_Username=john
Stack trace :
Cause level : 0 (level 0 is the most precise exception)
java.sql.SQLException: Wrong data type: For input string: "9657590a-b886-4c56-9029-d43adcfe70e6" in statement [select distinct jahiaconta0_.id_jahia_c
tn_lists as col_0_0_ from jahia_ctn_lists jahiaconta0_, jahia_ctnlists_prop jahiaconta1_ where jahiaconta1_.ctnlistid_ctnlists_prop=jahiaconta0_.id_ja
hia_ctn_lists and (jahiaconta0_.pageid_jahia_ctn_lists in ) and (jahiaconta0_.rights_jahia_ctn_lists in (? , ?) or (jahiaconta1_.name_ctnlists_prop
like 'view_field_acl_%') and (cast(jahiaconta1_.value_ctnlists_prop as integer)in (? , ?))) and jahiaconta0_.workflow_state>=1 and jahiaconta0_.versi
on_id<>-1]
at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
at org.hibernate.loader.Loader.doQuery(Loader.java:391)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.jahia.hibernate.dao.JahiaContainerListDAO.getContainerListIDsOnPagesHavingAcls(JahiaContainerListDAO.java:893)
at org.jahia.hibernate.manager.JahiaContainerListManager.getContainerListIDsOnPagesHavingAcls(JahiaContainerListManager.java:782)
at org.jahia.hibernate.manager.JahiaContainerListManager$$FastClassByCGLIB$$d1aefcab.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:546)
at org.jahia.hibernate.manager.JahiaContainerListManager$$EnhancerByCGLIB$$d830f348.getContainerListIDsOnPagesHavingAcls(<generated>)
at org.jahia.services.containers.JahiaContainersBaseService.getContainerListIDsOnPagesHavingAcls(JahiaContainersBaseService.java:2726)
at org.jahia.services.containers.JahiaContainersBaseService$$FastClassByCGLIB$$bd246c24.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:606)
at org.jahia.services.containers.JahiaContainersBaseService$$EnhancerByCGLIB$$f8dae8fd.getContainerListIDsOnPagesHavingAcls(<generated>)
at org.jahia.services.pages.ContentPage.isNegativeAclInListsOrContainersOrFields(ContentPage.java:413)
at org.jahia.services.pages.ContentPage.checkAccess(ContentPage.java:379)
at org.jahia.services.fields.ContentField.checkAccess(ContentField.java:2133)
at org.jahia.content.ContentObject.checkAccess(ContentObject.java:877)
at org.jahia.content.ContentObject.checkWriteAccess(ContentObject.java:831)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.checkContainerAccessRights(DeleteContainer_Engine.java:550)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.composeWarningMessages(DeleteContainer_Engine.java:539)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.processScreen(DeleteContainer_Engine.java:234)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.handleActions(DeleteContainer_Engine.java:175)
at org.jahia.operations.valves.EngineValve.processEngineRequest(EngineValve.java:180)
at org.jahia.operations.valves.EngineValve.invoke(EngineValve.java:82)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.J2ProcessActionValve.invoke(J2ProcessActionValve.java:144)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.SkeletonAggregatorValve.invoke(SkeletonAggregatorValve.java:73)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.PageAccessCheckValve.invoke(PageAccessCheckValve.java:73)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.OperationModeCheckValve.invoke(OperationModeCheckValve.java:83)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.SiteCheckValve.invoke(SiteCheckValve.java:78)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.EsiFragmentCacheReadValve.invoke(EsiFragmentCacheReadValve.java:329)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.EsiUrlCookieCheckValve.invoke(EsiUrlCookieCheckValve.java:313)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.pipelines.impl.GenericPipeline.invoke(GenericPipeline.java:195)
at org.jahia.operations.OperationManager.handleOperations(OperationManager.java:100)
at org.jahia.bin.JahiaAction.execute(JahiaAction.java:76)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.jahia.bin.JahiaRequestProcessor.process(JahiaRequestProcessor.java:82)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.jahia.bin.Jahia.process(Jahia.java:1661)
at org.jahia.bin.Jahia.service(Jahia.java:864)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.jahia.bin.filters.esi.ESIFilter.doFilter(ESIFilter.java:110)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
Cause level : 1
org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:1596)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.jahia.hibernate.dao.JahiaContainerListDAO.getContainerListIDsOnPagesHavingAcls(JahiaContainerListDAO.java:893)
at org.jahia.hibernate.manager.JahiaContainerListManager.getContainerListIDsOnPagesHavingAcls(JahiaContainerListManager.java:782)
at org.jahia.hibernate.manager.JahiaContainerListManager$$FastClassByCGLIB$$d1aefcab.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:546)
at org.jahia.hibernate.manager.JahiaContainerListManager$$EnhancerByCGLIB$$d830f348.getContainerListIDsOnPagesHavingAcls(<generated>)
at org.jahia.services.containers.JahiaContainersBaseService.getContainerListIDsOnPagesHavingAcls(JahiaContainersBaseService.java:2726)
at org.jahia.services.containers.JahiaContainersBaseService$$FastClassByCGLIB$$bd246c24.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:606)
at org.jahia.services.containers.JahiaContainersBaseService$$EnhancerByCGLIB$$f8dae8fd.getContainerListIDsOnPagesHavingAcls(<generated>)
at org.jahia.services.pages.ContentPage.isNegativeAclInListsOrContainersOrFields(ContentPage.java:413)
at org.jahia.services.pages.ContentPage.checkAccess(ContentPage.java:379)
at org.jahia.services.fields.ContentField.checkAccess(ContentField.java:2133)
at org.jahia.content.ContentObject.checkAccess(ContentObject.java:877)
at org.jahia.content.ContentObject.checkWriteAccess(ContentObject.java:831)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.checkContainerAccessRights(DeleteContainer_Engine.java:550)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.composeWarningMessages(DeleteContainer_Engine.java:539)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.processScreen(DeleteContainer_Engine.java:234)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.handleActions(DeleteContainer_Engine.java:175)
at org.jahia.operations.valves.EngineValve.processEngineRequest(EngineValve.java:180)
at org.jahia.operations.valves.EngineValve.invoke(EngineValve.java:82)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.J2ProcessActionValve.invoke(J2ProcessActionValve.java:144)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.SkeletonAggregatorValve.invoke(SkeletonAggregatorValve.java:73)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.PageAccessCheckValve.invoke(PageAccessCheckValve.java:73)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.OperationModeCheckValve.invoke(OperationModeCheckValve.java:83)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.SiteCheckValve.invoke(SiteCheckValve.java:78)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.EsiFragmentCacheReadValve.invoke(EsiFragmentCacheReadValve.java:329)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.EsiUrlCookieCheckValve.invoke(EsiUrlCookieCheckValve.java:313)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.pipelines.impl.GenericPipeline.invoke(GenericPipeline.java:195)
at org.jahia.operations.OperationManager.handleOperations(OperationManager.java:100)
at org.jahia.bin.JahiaAction.execute(JahiaAction.java:76)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.jahia.bin.JahiaRequestProcessor.process(JahiaRequestProcessor.java:82)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.jahia.bin.Jahia.process(Jahia.java:1661)
at org.jahia.bin.Jahia.service(Jahia.java:864)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.jahia.bin.filters.esi.ESIFilter.doFilter(ESIFilter.java:110)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Wrong data type: For input string: "9657590a-b886-4c56-9029-d43adcfe70e6" in statement [select distinct jahiaconta0_
.id_jahia_ctn_lists as col_0_0_ from jahia_ctn_lists jahiaconta0_, jahia_ctnlists_prop jahiaconta1_ where jahiaconta1_.ctnlistid_ctnlists_prop=jahiaco
nta0_.id_jahia_ctn_lists and (jahiaconta0_.pageid_jahia_ctn_lists in ) and (jahiaconta0_.rights_jahia_ctn_lists in (? , ?) or (jahiaconta1_.name_ct
nlists_prop like 'view_field_acl_%') and (cast(jahiaconta1_.value_ctnlists_prop as integer)in (? , ?))) and jahiaconta0_.workflow_state>=1 and jahiaco
nta0_.version_id<>-1]
at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
at org.hibernate.loader.Loader.doQuery(Loader.java:391)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
... 80 more
Cause level : 2
org.jahia.exceptions.JahiaException: User message=Error while processing request, System message=Exception in processing pipeline, root cause:could no
t execute query root cause=org.hibernate.exception.GenericJDBCException: could not execute query
at org.jahia.operations.OperationManager.handleOperations(OperationManager.java:110)
at org.jahia.bin.JahiaAction.execute(JahiaAction.java:76)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.jahia.bin.JahiaRequestProcessor.process(JahiaRequestProcessor.java:82)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.jahia.bin.Jahia.process(Jahia.java:1661)
at org.jahia.bin.Jahia.service(Jahia.java:864)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.jahia.bin.filters.esi.ESIFilter.doFilter(ESIFilter.java:110)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:1596)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.jahia.hibernate.dao.JahiaContainerListDAO.getContainerListIDsOnPagesHavingAcls(JahiaContainerListDAO.java:893)
at org.jahia.hibernate.manager.JahiaContainerListManager.getContainerListIDsOnPagesHavingAcls(JahiaContainerListManager.java:782)
at org.jahia.hibernate.manager.JahiaContainerListManager$$FastClassByCGLIB$$d1aefcab.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:546)
at org.jahia.hibernate.manager.JahiaContainerListManager$$EnhancerByCGLIB$$d830f348.getContainerListIDsOnPagesHavingAcls(<generated>)
at org.jahia.services.containers.JahiaContainersBaseService.getContainerListIDsOnPagesHavingAcls(JahiaContainersBaseService.java:2726)
at org.jahia.services.containers.JahiaContainersBaseService$$FastClassByCGLIB$$bd246c24.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:606)
at org.jahia.services.containers.JahiaContainersBaseService$$EnhancerByCGLIB$$f8dae8fd.getContainerListIDsOnPagesHavingAcls(<generated>)
at org.jahia.services.pages.ContentPage.isNegativeAclInListsOrContainersOrFields(ContentPage.java:413)
at org.jahia.services.pages.ContentPage.checkAccess(ContentPage.java:379)
at org.jahia.services.fields.ContentField.checkAccess(ContentField.java:2133)
at org.jahia.content.ContentObject.checkAccess(ContentObject.java:877)
at org.jahia.content.ContentObject.checkWriteAccess(ContentObject.java:831)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.checkContainerAccessRights(DeleteContainer_Engine.java:550)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.composeWarningMessages(DeleteContainer_Engine.java:539)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.processScreen(DeleteContainer_Engine.java:234)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.handleActions(DeleteContainer_Engine.java:175)
at org.jahia.operations.valves.EngineValve.processEngineRequest(EngineValve.java:180)
at org.jahia.operations.valves.EngineValve.invoke(EngineValve.java:82)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.J2ProcessActionValve.invoke(J2ProcessActionValve.java:144)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.SkeletonAggregatorValve.invoke(SkeletonAggregatorValve.java:73)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.PageAccessCheckValve.invoke(PageAccessCheckValve.java:73)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.OperationModeCheckValve.invoke(OperationModeCheckValve.java:83)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.SiteCheckValve.invoke(SiteCheckValve.java:78)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.EsiFragmentCacheReadValve.invoke(EsiFragmentCacheReadValve.java:329)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.EsiUrlCookieCheckValve.invoke(EsiUrlCookieCheckValve.java:313)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.pipelines.impl.GenericPipeline.invoke(GenericPipeline.java:195)
at org.jahia.operations.OperationManager.handleOperations(OperationManager.java:100)
... 26 more
Caused by: java.sql.SQLException: Wrong data type: For input string: "9657590a-b886-4c56-9029-d43adcfe70e6" in statement [select distinct jahiaconta0_
.id_jahia_ctn_lists as col_0_0_ from jahia_ctn_lists jahiaconta0_, jahia_ctnlists_prop jahiaconta1_ where jahiaconta1_.ctnlistid_ctnlists_prop=jahiaco
nta0_.id_jahia_ctn_lists and (jahiaconta0_.pageid_jahia_ctn_lists in ) and (jahiaconta0_.rights_jahia_ctn_lists in (? , ?) or (jahiaconta1_.name_ct
nlists_prop like 'view_field_acl_%') and (cast(jahiaconta1_.value_ctnlists_prop as integer)in (? , ?))) and jahiaconta0_.workflow_state>=1 and jahiaco
nta0_.version_id<>-1]
at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
at org.hibernate.loader.Loader.doQuery(Loader.java:391)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
... 80 more
org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:1596)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.jahia.hibernate.dao.JahiaContainerListDAO.getContainerListIDsOnPagesHavingAcls(JahiaContainerListDAO.java:893)
at org.jahia.hibernate.manager.JahiaContainerListManager.getContainerListIDsOnPagesHavingAcls(JahiaContainerListManager.java:782)
at org.jahia.hibernate.manager.JahiaContainerListManager$$FastClassByCGLIB$$d1aefcab.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:546)
at org.jahia.hibernate.manager.JahiaContainerListManager$$EnhancerByCGLIB$$d830f348.getContainerListIDsOnPagesHavingAcls(<generated>)
at org.jahia.services.containers.JahiaContainersBaseService.getContainerListIDsOnPagesHavingAcls(JahiaContainersBaseService.java:2726)
at org.jahia.services.containers.JahiaContainersBaseService$$FastClassByCGLIB$$bd246c24.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:606)
at org.jahia.services.containers.JahiaContainersBaseService$$EnhancerByCGLIB$$f8dae8fd.getContainerListIDsOnPagesHavingAcls(<generated>)
at org.jahia.services.pages.ContentPage.isNegativeAclInListsOrContainersOrFields(ContentPage.java:413)
at org.jahia.services.pages.ContentPage.checkAccess(ContentPage.java:379)
at org.jahia.services.fields.ContentField.checkAccess(ContentField.java:2133)
at org.jahia.content.ContentObject.checkAccess(ContentObject.java:877)
at org.jahia.content.ContentObject.checkWriteAccess(ContentObject.java:831)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.checkContainerAccessRights(DeleteContainer_Engine.java:550)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.composeWarningMessages(DeleteContainer_Engine.java:539)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.processScreen(DeleteContainer_Engine.java:234)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.handleActions(DeleteContainer_Engine.java:175)
at org.jahia.operations.valves.EngineValve.processEngineRequest(EngineValve.java:180)
at org.jahia.operations.valves.EngineValve.invoke(EngineValve.java:82)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.J2ProcessActionValve.invoke(J2ProcessActionValve.java:144)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.SkeletonAggregatorValve.invoke(SkeletonAggregatorValve.java:73)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.PageAccessCheckValve.invoke(PageAccessCheckValve.java:73)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.OperationModeCheckValve.invoke(OperationModeCheckValve.java:83)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.SiteCheckValve.invoke(SiteCheckValve.java:78)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.EsiFragmentCacheReadValve.invoke(EsiFragmentCacheReadValve.java:329)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.EsiUrlCookieCheckValve.invoke(EsiUrlCookieCheckValve.java:313)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.pipelines.impl.GenericPipeline.invoke(GenericPipeline.java:195)
at org.jahia.operations.OperationManager.handleOperations(OperationManager.java:100)
at org.jahia.bin.JahiaAction.execute(JahiaAction.java:76)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.jahia.bin.JahiaRequestProcessor.process(JahiaRequestProcessor.java:82)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.jahia.bin.Jahia.process(Jahia.java:1661)
at org.jahia.bin.Jahia.service(Jahia.java:864)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.jahia.bin.filters.esi.ESIFilter.doFilter(ESIFilter.java:110)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Wrong data type: For input string: "9657590a-b886-4c56-9029-d43adcfe70e6" in statement [select distinct jahiaconta0_
.id_jahia_ctn_lists as col_0_0_ from jahia_ctn_lists jahiaconta0_, jahia_ctnlists_prop jahiaconta1_ where jahiaconta1_.ctnlistid_ctnlists_prop=jahiaco
nta0_.id_jahia_ctn_lists and (jahiaconta0_.pageid_jahia_ctn_lists in ) and (jahiaconta0_.rights_jahia_ctn_lists in (? , ?) or (jahiaconta1_.name_ct
nlists_prop like 'view_field_acl_%') and (cast(jahiaconta1_.value_ctnlists_prop as integer)in (? , ?))) and jahiaconta0_.workflow_state>=1 and jahiaco
nta0_.version_id<>-1]
at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
at org.hibernate.loader.Loader.doQuery(Loader.java:391)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
... 80 more

2008-06-16 11:22:30,821: ERROR [org.jahia.bin.JahiaErrorDisplay] - ERROR : Error while processing request, Exception in processing pipeline
java.sql.SQLException: Wrong data type: For input string: "9657590a-b886-4c56-9029-d43adcfe70e6" in statement [select distinct jahiaconta0_.id_jahia_c
tn_lists as col_0_0_ from jahia_ctn_lists jahiaconta0_, jahia_ctnlists_prop jahiaconta1_ where jahiaconta1_.ctnlistid_ctnlists_prop=jahiaconta0_.id_ja
hia_ctn_lists and (jahiaconta0_.pageid_jahia_ctn_lists in ) and (jahiaconta0_.rights_jahia_ctn_lists in (? , ?) or (jahiaconta1_.name_ctnlists_prop
like 'view_field_acl_%') and (cast(jahiaconta1_.value_ctnlists_prop as integer)in (? , ?))) and jahiaconta0_.workflow_state>=1 and jahiaconta0_.versi
on_id<>-1]
at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
at org.hibernate.loader.Loader.doQuery(Loader.java:391)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.jahia.hibernate.dao.JahiaContainerListDAO.getContainerListIDsOnPagesHavingAcls(JahiaContainerListDAO.java:893)
at org.jahia.hibernate.manager.JahiaContainerListManager.getContainerListIDsOnPagesHavingAcls(JahiaContainerListManager.java:782)
at org.jahia.hibernate.manager.JahiaContainerListManager$$FastClassByCGLIB$$d1aefcab.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:546)
at org.jahia.hibernate.manager.JahiaContainerListManager$$EnhancerByCGLIB$$d830f348.getContainerListIDsOnPagesHavingAcls(<generated>)
at org.jahia.services.containers.JahiaContainersBaseService.getContainerListIDsOnPagesHavingAcls(JahiaContainersBaseService.java:2726)
at org.jahia.services.containers.JahiaContainersBaseService$$FastClassByCGLIB$$bd246c24.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:606)
at org.jahia.services.containers.JahiaContainersBaseService$$EnhancerByCGLIB$$f8dae8fd.getContainerListIDsOnPagesHavingAcls(<generated>)
at org.jahia.services.pages.ContentPage.isNegativeAclInListsOrContainersOrFields(ContentPage.java:413)
at org.jahia.services.pages.ContentPage.checkAccess(ContentPage.java:379)
at org.jahia.services.fields.ContentField.checkAccess(ContentField.java:2133)
at org.jahia.content.ContentObject.checkAccess(ContentObject.java:877)
at org.jahia.content.ContentObject.checkWriteAccess(ContentObject.java:831)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.checkContainerAccessRights(DeleteContainer_Engine.java:550)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.composeWarningMessages(DeleteContainer_Engine.java:539)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.processScreen(DeleteContainer_Engine.java:234)
at org.jahia.engines.deletecontainer.DeleteContainer_Engine.handleActions(DeleteContainer_Engine.java:175)
at org.jahia.operations.valves.EngineValve.processEngineRequest(EngineValve.java:180)
at org.jahia.operations.valves.EngineValve.invoke(EngineValve.java:82)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.J2ProcessActionValve.invoke(J2ProcessActionValve.java:144)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.SkeletonAggregatorValve.invoke(SkeletonAggregatorValve.java:73)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.PageAccessCheckValve.invoke(PageAccessCheckValve.java:73)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.OperationModeCheckValve.invoke(OperationModeCheckValve.java:83)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.SiteCheckValve.invoke(SiteCheckValve.java:78)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.EsiFragmentCacheReadValve.invoke(EsiFragmentCacheReadValve.java:329)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.operations.valves.EsiUrlCookieCheckValve.invoke(EsiUrlCookieCheckValve.java:313)
at org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:208)
at org.jahia.pipelines.impl.GenericPipeline.invoke(GenericPipeline.java:195)
at org.jahia.operations.OperationManager.handleOperations(OperationManager.java:100)
at org.jahia.bin.JahiaAction.execute(JahiaAction.java:76)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.jahia.bin.JahiaRequestProcessor.process(JahiaRequestProcessor.java:82)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.jahia.bin.Jahia.process(Jahia.java:1661)
at org.jahia.bin.Jahia.service(Jahia.java:864)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.jahia.bin.filters.esi.ESIFilter.doFilter(ESIFilter.java:110)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
2008-06-16 11:22:30,837: WARN [org.apache.struts.action.RequestProcessor] - Unhandled Exception thrown: class java.lang.Exception
2008-06-16 11:22:30,837: ERROR [org.jahia.bin.Jahia] - Throwable Exception caught in Jahia servlet : javax.servlet.ServletException: org.jahia.excepti
ons.JahiaException: User message=Error while processing request, System message=Exception in processing pipeline, root cause:could not execute query r
oot cause=org.hibernate.exception.GenericJDBCException: could not execute query
javax.servlet.ServletException: org.jahia.exceptions.JahiaException: User message=Error while processing request, System message=Exception in processi
ng pipeline, root cause:could not execute query root cause=org.hibernate.exception.GenericJDBCException: could not execute query
at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.jahia.bin.JahiaRequestProcessor.process(JahiaRequestProcessor.java:82)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.jahia.bin.Jahia.process(Jahia.java:1661)
at org.jahia.bin.Jahia.service(Jahia.java:864)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.jahia.bin.filters.esi.ESIFilter.doFilter(ESIFilter.java:110)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
2008-06-16 11:22:33,368: INFO [org.jahia.bin.Jahia] - Processed [/jahia/Jahia/op/edit/lang/es/home/staging_url_key] user=[john] ip=[127.0.0.1] in [31
ms]