org.jahia.exceptions.JahiaException: Cannot check for url key uniqueness from the database, Error in PagePropertyDB.isKeyAlreadyUsedInSiteWithID : ORA-00911: invalid character , root cause:ORA-00911: invalid character root cause=java.sql.SQLException: ORA-00911: invalid character

JIRA | Madani Benghia | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    When I click on the "Page Poperties" link on the admin menu ,and then edit the properties and submit the form i get the following exception: -The exception is thrown by the method PagePropertyDB.isKeyAlreadyUsedInSiteWithID -This happens only with oracle (Sql Server does not throw this exception). Here is the exception text: Exception StackTrace: Cause level : 0 (level 0 is the most precise exception) java.sql.SQLException: ORA-00911: invalid character at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112) at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:351) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896) at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:383) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1125) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205) at org.jahia.services.database.StatementWrapper.executeQuery(StatementWrapper.java:96) at org.jahia.services.pages.PagePropertyDB.isKeyAlreadyUsedInSiteWithID(PagePropertyDB.java:651) at org.jahia.services.pages.JahiaPageBaseService.isKeyAlreadyUsedInSiteWithID(JahiaPageBaseService.java:2118) at org.jahia.engines.pages.PageProperties_Engine.isURLKeyAlreadyUsed(PageProperties_Engine.java:908) at org.jahia.engines.pages.PageProperties_Engine.setPageURLKeyIfValidAndNotEmpty(PageProperties_Engine.java:846) at org.jahia.engines.pages.PageProperties_Engine.updatePageData(PageProperties_Engine.java:772) at org.jahia.engines.pages.PageProperties_Engine.processLastScreen(PageProperties_Engine.java:239) at org.jahia.engines.pages.PageProperties_Engine.handleActions(PageProperties_Engine.java:179) at org.jahia.operations.OperationManager.handleOperations(OperationManager.java:302) at org.jahia.bin.JahiaAction.execute(JahiaAction.java:50) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.jahia.bin.Jahia.process(Jahia.java:1547) at org.jahia.bin.Jahia.service(Jahia.java:862) at javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) Cause level : 1 org.jahia.exceptions.JahiaException: Cannot check for url key uniqueness from the database, Error in PagePropertyDB.isKeyAlreadyUsedInSiteWithID : ORA-00911: invalid character , root cause:ORA-00911: invalid character root cause=java.sql.SQLException: ORA-00911: invalid character at org.jahia.services.pages.PagePropertyDB.isKeyAlreadyUsedInSiteWithID(PagePropertyDB.java:659) at org.jahia.services.pages.JahiaPageBaseService.isKeyAlreadyUsedInSiteWithID(JahiaPageBaseService.java:2118) at org.jahia.engines.pages.PageProperties_Engine.isURLKeyAlreadyUsed(PageProperties_Engine.java:908) at org.jahia.engines.pages.PageProperties_Engine.setPageURLKeyIfValidAndNotEmpty(PageProperties_Engine.java:846) at org.jahia.engines.pages.PageProperties_Engine.updatePageData(PageProperties_Engine.java:772) at org.jahia.engines.pages.PageProperties_Engine.processLastScreen(PageProperties_Engine.java:239) at org.jahia.engines.pages.PageProperties_Engine.handleActions(PageProperties_Engine.java:179) at org.jahia.operations.OperationManager.handleOperations(OperationManager.java:302) at org.jahia.bin.JahiaAction.execute(JahiaAction.java:50) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.jahia.bin.Jahia.process(Jahia.java:1547) at org.jahia.bin.Jahia.service(Jahia.java:862) at javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) Cause level : 2 org.jahia.exceptions.JahiaException: Error during handle of operation, Error during handle of operation, root cause:Cannot check for url key uniqueness from the database, Error in PagePropertyDB.isKeyAlreadyUsedInSiteWithID : ORA-00911: invalid character , root cause:ORA-00911: invalid character root cause=org.jahia.exceptions.JahiaException: Cannot check for url key uniqueness from the database, Error in PagePropertyDB.isKeyAlreadyUsedInSiteWithID : ORA-00911: invalid character , root cause:ORA-00911: invalid character root cause=java.sql.SQLException: ORA-00911: invalid character at org.jahia.operations.OperationManager.handleOperations(OperationManager.java:318) at org.jahia.bin.JahiaAction.execute(JahiaAction.java:50) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.jahia.bin.Jahia.process(Jahia.java:1547) at org.jahia.bin.Jahia.service(Jahia.java:862) at javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534)

    JIRA | 1 decade ago | Madani Benghia
    org.jahia.exceptions.JahiaException: Cannot check for url key uniqueness from the database, Error in PagePropertyDB.isKeyAlreadyUsedInSiteWithID : ORA-00911: invalid character , root cause:ORA-00911: invalid character root cause=java.sql.SQLException: ORA-00911: invalid character

    Root Cause Analysis

    1. org.jahia.exceptions.JahiaException

      Cannot check for url key uniqueness from the database, Error in PagePropertyDB.isKeyAlreadyUsedInSiteWithID : ORA-00911: invalid character , root cause:ORA-00911: invalid character root cause=java.sql.SQLException: ORA-00911: invalid character

      at org.jahia.services.pages.PagePropertyDB.isKeyAlreadyUsedInSiteWithID()
    2. org.jahia.services
      JahiaPageBaseService.isKeyAlreadyUsedInSiteWithID
      1. org.jahia.services.pages.PagePropertyDB.isKeyAlreadyUsedInSiteWithID(PagePropertyDB.java:659)
      2. org.jahia.services.pages.JahiaPageBaseService.isKeyAlreadyUsedInSiteWithID(JahiaPageBaseService.java:2118)
      2 frames
    3. org.jahia.engines
      PageProperties_Engine.handleActions
      1. org.jahia.engines.pages.PageProperties_Engine.isURLKeyAlreadyUsed(PageProperties_Engine.java:908)
      2. org.jahia.engines.pages.PageProperties_Engine.setPageURLKeyIfValidAndNotEmpty(PageProperties_Engine.java:846)
      3. org.jahia.engines.pages.PageProperties_Engine.updatePageData(PageProperties_Engine.java:772)
      4. org.jahia.engines.pages.PageProperties_Engine.processLastScreen(PageProperties_Engine.java:239)
      5. org.jahia.engines.pages.PageProperties_Engine.handleActions(PageProperties_Engine.java:179)
      5 frames
    4. org.jahia.operations
      OperationManager.handleOperations
      1. org.jahia.operations.OperationManager.handleOperations(OperationManager.java:302)
      1 frame
    5. org.jahia.bin
      JahiaAction.execute
      1. org.jahia.bin.JahiaAction.execute(JahiaAction.java:50)
      1 frame
    6. struts
      ActionServlet.process
      1. org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
      2. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
      3. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
      3 frames
    7. org.jahia.bin
      Jahia.service
      1. org.jahia.bin.Jahia.process(Jahia.java:1547)
      2. org.jahia.bin.Jahia.service(Jahia.java:862)
      2 frames
    8. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
      1 frame
    9. Glassfish Core
      ContainerBase.invoke
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
      4. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
      5. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
      6. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
      7. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)
      8. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
      9. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
      10. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
      11. org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)
      12. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)
      13. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
      14. org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
      15. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
      16. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
      17. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
      18. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
      19. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
      20. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)
      21. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
      22. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
      23. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
      23 frames
    10. org.apache.coyote
      CoyoteAdapter.service
      1. org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
      1 frame
    11. Grizzly HTTP
      TcpWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
      3. org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
      3 frames
    12. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
      1 frame
    13. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame