java.sql.SQLException: ORA-00942: table or view does not exist

Atlassian JIRA | Dave Loeng [Atlassian] | 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

    Setting up Confluence against databases that are sensitive to the case of table names will result in the following error during setup: 2005-04-29 02:25:29,777 FATAL [atlassian.confluence.setup.DefaultBootstrapManager] attachments: could not be queried successfully: java.sql.SQLException: ORA-00942: table or view does not exist 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 com.atlassian.confluence.setup.DefaultBootstrapManager.confirmDBTableExistence(DefaultBootstrapManager.java:643) at com.atlassian.confluence.setup.DefaultBootstrapManager.bootstrapDatasource(DefaultBootstrapManager.java:486)

    Atlassian JIRA | 1 decade ago | Dave Loeng [Atlassian]
    java.sql.SQLException: ORA-00942: table or view does not exist
  2. 0

    Setting up Confluence against databases that are sensitive to the case of table names will result in the following error during setup: 2005-04-29 02:25:29,777 FATAL [atlassian.confluence.setup.DefaultBootstrapManager] attachments: could not be queried successfully: java.sql.SQLException: ORA-00942: table or view does not exist 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 com.atlassian.confluence.setup.DefaultBootstrapManager.confirmDBTableExistence(DefaultBootstrapManager.java:643) at com.atlassian.confluence.setup.DefaultBootstrapManager.bootstrapDatasource(DefaultBootstrapManager.java:486)

    Atlassian JIRA | 1 decade ago | Dave Loeng [Atlassian]
    java.sql.SQLException: ORA-00942: table or view does not exist
  3. 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
    java.sql.SQLException: ORA-00911: invalid character
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
    java.sql.SQLException: ORA-00911: invalid character
  6. 0

    Liquibase with Oracle ORA-00904: "HISTOGRAM": invalid identifier on second changelog

    Stack Overflow | 1 year ago | Sam
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in com.yell.connect.publisher.database.PublisherDbConfig: Invocation of init method failed; nested exception is liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: java.sql.SQLException: ORA-00904: "HISTOGRAM": invalid identifier

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-00942: table or view does not exist

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OracleStatement.executeQuery
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
      5. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
      6. oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:351)
      7. oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896)
      8. oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:383)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)
      10. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1125)
      10 frames
    3. Commons DBCP
      DelegatingStatement.executeQuery
      1. org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
      1 frame
    4. com.atlassian.confluence
      DefaultBootstrapManager.bootstrapDatasource
      1. com.atlassian.confluence.setup.DefaultBootstrapManager.confirmDBTableExistence(DefaultBootstrapManager.java:643)
      2. com.atlassian.confluence.setup.DefaultBootstrapManager.bootstrapDatasource(DefaultBootstrapManager.java:486)
      2 frames