> Wrapped Exception: ORA-00950: option DROP non valide

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
<[EMAIL PROTECTED]> 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
> Wrapped Exception: ORA-00950: option DROP non valide
>  @ 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
> Wrapped Exception: ORA-00950: option DROP non valide
>        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@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>



-- 
Thomas Mortagne
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Reply via email to