Re: [xwiki-users] Manage wikis : error while deleting

Looks like : 1) you don't have right to delete the schema "testsicap" in Oracle 2) xwiki core does not use the correct query to delete the schema. Currently it's using : DROP SCHEMA testsicap If it's 2) it would be great that you add a issue in http://jira.xwiki.org/jira/browse/XWIKI indication that xwiki does not remove properly Oracle schemas and make a suggestion of what is better for Oracle. On Fri, Jun 13, 2008 at 10:54 AM, Gaëtan GUYODO <gaetan.guyodo(a)lrb.aphp.fr> wrote: > Hi, > I have successfully created a wiki from XEM (Manager 1.2 installed on XE > 1.4.1, Tomcat 6, Oracle 10.2, Java 6). > After that, I tried to delete that wiki and I got that message : > > Error number 4001 in 4: Error while parsing velocity page > WikiManager.WebHome Wrapped Exception: Failed to evaluate content with > id Web Home > > Error number 4001 in 4: Error while parsing velocity page > WikiManager.WebHome > Wrapped Exception: Failed to evaluate content with id Web Home > com.xpn.xwiki.XWikiException: Error number 4001 in 4: Error while > parsing velocity page WikiManager.WebHome > Wrapped Exception: Failed to evaluate content with id Web Home > at > com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:231) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:93) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:258) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:182) > at com.xpn.xwiki.XWiki.include(XWiki.java:3512) > at com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:1372) > at com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:1338) > at sun.reflect.GeneratedMethodAccessor134.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.invoke(UberspectImpl.java:295) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:203) > at > org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:294) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) > at > org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:194) > at > org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:170) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:88) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:88) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) > at > org.xwiki.velocity.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:145) > at > org.xwiki.velocity.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:117) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:226) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:93) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:258) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:182) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:151) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderDocument(DefaultXWikiRenderingEngine.java:140) > at > com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:423) > at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:371) > at sun.reflect.GeneratedMethodAccessor223.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.invoke(UberspectImpl.java:295) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:203) > at > org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:294) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) > at > org.xwiki.velocity.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:145) > at > org.xwiki.velocity.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:117) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:226) > at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1504) > at com.xpn.xwiki.api.XWiki.parseTemplate(XWiki.java:608) > at sun.reflect.GeneratedMethodAccessor126.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.invoke(UberspectImpl.java:295) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:203) > at > org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:294) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) > at > org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:194) > at > org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:170) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:88) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:107) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) > at > org.xwiki.velocity.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:145) > at > org.xwiki.velocity.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:117) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:226) > at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1504) > at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:109) > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:225) > 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:690) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > 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:175) > 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:263) > at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) > at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) > at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) > at > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) > at > org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) > at java.lang.Thread.run(Unknown Source) > Wrapped Exception: > org.apache.velocity.exception.MethodInvocationException: Invocation of > method 'deleteWiki' in class > com.xpn.xwiki.plugin.wikimanager.WikiManagerPluginApi threw exception > com.xpn.xwiki.XWikiException: Error number 3402 in 3: Exception while > delete wiki database testsicap > @ WikiManager.WebHome3,33? > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:286) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:203) > at > org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:419) > at > org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:73) > at > org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:125) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:88) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:88) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) > at > org.xwiki.velocity.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:145) > at > org.xwiki.velocity.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:117) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:226) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:93) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:258) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:182) > at com.xpn.xwiki.XWiki.include(XWiki.java:3512) > at com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:1372) > at com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:1338) > at sun.reflect.GeneratedMethodAccessor134.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.invoke(UberspectImpl.java:295) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:203) > at > org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:294) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) > at > org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:194) > at > org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:170) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:88) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:88) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) > at > org.xwiki.velocity.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:145) > at > org.xwiki.velocity.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:117) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:226) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:93) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:258) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:182) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderText(DefaultXWikiRenderingEngine.java:151) > at > com.xpn.xwiki.render.DefaultXWikiRenderingEngine.renderDocument(DefaultXWikiRenderingEngine.java:140) > at > com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:423) > at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:371) > at sun.reflect.GeneratedMethodAccessor223.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.invoke(UberspectImpl.java:295) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:203) > at > org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:294) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) > at > org.xwiki.velocity.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:145) > at > org.xwiki.velocity.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:117) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:226) > at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1504) > at com.xpn.xwiki.api.XWiki.parseTemplate(XWiki.java:608) > at sun.reflect.GeneratedMethodAccessor126.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.invoke(UberspectImpl.java:295) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245) > at > org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:203) > at > org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:294) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) > at > org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:194) > at > org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:170) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:88) > at > org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) > at > org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:107) > at > org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318) > at > org.xwiki.velocity.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:145) > at > org.xwiki.velocity.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:117) > at > com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:226) > at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1504) > at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:109) > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:225) > 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:690) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > 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:175) > 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:263) > at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) > at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) > at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) > at > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) > at > org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) > at java.lang.Thread.run(Unknown Source) > Caused by: com.xpn.xwiki.XWikiException: Error number 3402 in 3: > Exception while delete wiki database testsicap > at > com.xpn.xwiki.store.XWikiHibernateStore.deleteWiki(XWikiHibernateStore.java:280) > at com.xpn.xwiki.store.XWikiCacheStore.deleteWiki(XWikiCacheStore.java:498) > at com.xpn.xwiki.plugin.wikimanager.doc.Wiki.delete(Wiki.java:63) > at > com.xpn.xwiki.plugin.wikimanager.WikiManager.deleteWiki(WikiManager.java:772) > at > com.xpn.xwiki.plugin.wikimanager.WikiManagerPluginApi.deleteWiki(WikiManagerPluginApi.java:229) > at > com.xpn.xwiki.plugin.wikimanager.WikiManagerPluginApi.deleteWiki(WikiManagerPluginApi.java:261) > 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.invoke(UberspectImpl.java:295) > at > org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245) > … 102 more > > > Any idea ? > -- > __________________________________________ > Gaëtan GUYODO > Chargé de mission > Centre Antipoison - Hôpital Fernand WIDAL > 200, rue du faubourg St Denis > 75475 PARIS Cedex 10 > Tél: 01 40 05 49 63 / Fax: 01 40 05 48 56 > __________________________________________ > > _______________________________________________ > users mailing list > users(a)xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > -- Thomas Mortagne