Hi Ludovic, It's the query ... #set($sql = "select max(prop.value)+1 from BaseObject as obj, IntegerProperty as prop where obj.className='ITSClasses.IssueClass' and obj.id=prop.id.id and prop.id.name='id'")
$xwiki.search($sql) It returns always an empty string. Even there are tasks already defined. I've spend some time using $xwiki.searchDocuments(...) to count the task pages ... but I couldn't fix it (It returns either no or all pages) Thanks mb -----Original Message----- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Ludovic Dubost Sent: Friday, October 02, 2009 9:44 AM To: XWiki Users Subject: Re: [xwiki-users] FW: xwiki 2.0, task manager application, Error number 4001 in 4: Error while parsing velocity page TasksCode.NewTask Hi Michael, I suspect it is the counter that retrieves the lastest task number. It is running a "search" query with a "select max() and we have seen some differences based on the MySQL/hibernate combination on the way this unique result is returned (as a number directly or as a 1 item list). It could be also because in your case it does not return anything (your need a first task) You should look at this call to "search" and check what it returns exactly and how to retrieve this max number This is the code #set($sql = "select max(prop.value)+1 from BaseObject as obj, IntegerProperty as prop where obj.className='ITSClasses.IssueClass' and obj.id=prop.id.id and prop.id.name='id'") #set($id = $xwiki.search($sql).get(0)) Maybe in your case #set($id = $xwiki.search($sql)) or #set($res = $xwiki.search($sql)) #if($res && $res.size()>0) #set($id = $xwiki.search($sql).get(0)) #else #set($id = 0) #end will work. Ludovic Michael Beetz wrote: > Hi Community, > > I am sorry bothering you. However I am using the task manager application in > a production environment, therefore I have to decide about staying on several > single wikis or consolidating them in a farm. > > Is there anybody available instructing me to find that bug? > > I am quite familiar writing code in general; however I haven't done something > in Java, eclipse or xwiki yet. Therefore I would appreciate a link to some > useful code snippet as well. > > Thanks for now and in advance > mb > > > > ________________________________ > From: Michael Beetz > Sent: Wednesday, September 30, 2009 10:06 PM > To: 'XWiki Users' > Subject: xwiki 2.0, task manager application,Error number 4001 in 4: Error > while parsing velocity page TasksCode.NewTask > > Hi all, > > I am running xwiki 2.0 in a farm. The Task Manager Application fails > creating a new task. Any hints? > > Thanks > mb > > Error number 4001 in 4: Error while parsing velocity page TasksCode.NewTask > Wrapped Exception: Failed to evaluate content with id New Task > > Error number 4001 in 4: Error while parsing velocity page TasksCode.NewTask > Wrapped Exception: Failed to evaluate content with id New Task > com.xpn.xwiki.XWikiException: Error number 4001 in 4: Error while parsing > velocity page TasksCode.NewTask > Wrapped Exception: Failed to evaluate content with id New Task > at > com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:114) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:85) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:272) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:202) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:170) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderDocument(DefaultXWikiRenderingEngine.java:159) > at > com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:547) > at > com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:564) > at > com.xpn.xwiki.api.Document.getRenderedContent(Document.java:475) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > at java.lang.reflect.Method.invoke(Unknown Source) > at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:389) > at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:378) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:270) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:252) > at > org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:493) > at > org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:71) > at > org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:142) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:106) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:191) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:156) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:108) > at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1694) > at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1615) > at com.xpn.xwiki.api.XWiki.parseTemplate(XWiki.java:657) > at sun.reflect.GeneratedMethodAccessor173.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > at java.lang.reflect.Method.invoke(Unknown Source) > at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:389) > at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:378) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:270) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:252) > at > org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:332) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) > at > org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:212) > at > org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:247) > at > org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:175) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:106) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:191) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:156) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:108) > at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1694) > at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1615) > at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:124) > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:224) > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) > at > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) > at > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) > at > org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:155) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:117) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:295) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) > at > org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) > at > org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:574) > at > org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1527) > at java.lang.Thread.run(Unknown Source) > > Wrapped Exception: > > org.apache.velocity.exception.MethodInvocationException: Invocation of method > 'get' in class java.util.Collections$EmptyList threw exception > java.lang.IndexOutOfBoundsException: Index: 0 at TasksCode.NewTaskline 2, > column 32? at > org.apache.velocity.runtime.parser.node.ASTMethod.handleInvocationException(ASTMethod.java:337) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:284) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:252) > at > org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:493) > at > org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:71) > at > org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:142) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:191) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:156) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:108) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:85) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:272) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:202) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:170) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderDocument(DefaultXWikiRenderingEngine.java:159) > at > com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:547) at > com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:564) at > com.xpn.xwiki.api.Document.getRenderedContent(Document.java:475) at > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at > sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at > sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at > java.lang.reflect.Method.invoke(Unknown Source) at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:389) > at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:378) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:270) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:252) > at > org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:493) > at > org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:71) > at > org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:142) > at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:106) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:191) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:156) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:108) > at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1694) at > com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1615) at > com.xpn.xwiki.api.XWiki.parseTemplate(XWiki.java:657) at > sun.reflect.GeneratedMethodAccessor173.invoke(Unknown Source) at > sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at > java.lang.reflect.Method.invoke(Unknown Source) at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:389) > at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:378) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:270) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:252) > at > org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:332) > at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) > at > org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:212) > at > org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:247) > at > org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:175) > at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87) > at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:106) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:191) > at > org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:156) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:108) > at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1694) at > com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1615) at > com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:124) at > com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:224) at > com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) at > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) > at > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) > at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at > org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at > javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at > javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:155) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:117) at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:295) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) > at > org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) > at > org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:574) > at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1527) > at java.lang.Thread.run(Unknown Source) Caused by: > java.lang.IndexOutOfBoundsException: Index: 0 at > java.util.Collections$EmptyList.get(Unknown Source) at > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at > sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at > sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at > java.lang.reflect.Method.invoke(Unknown Source) at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:389) > at > org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:378) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:270) > ... 96 more > > > _______________________________________________ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > > -- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users