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
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded 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