Hi,
I am installing Jahia 4.1 (lastest release ) for a customer with Oracle
9i.
when i try to call the versioning module , i get following Error Message:
ORA-00911: invalid character : Error in
PagePropertyDB.isKeyAlreadyUsedInSiteWithID
The problem seems to be that a wrong field type is defined in the update sql
statement for Oracle.
I changed the DB to HypersonicDB and the error does not happen there, but the
final installation must run under Oracle.
The CMS and the portlets are working perfectly.
How can i solve this Error?
Where do i find an ERD-Diagramm for the DB?
Thx in Advance
Gustavo von Goetzen S�nchez
Baluna GmbH
Kaiserstr. 9
D - 63065 Offenbach am
Main
Tel.: +49 (069) 800
6060-1
Fax: +49 (069) 800
6060-3
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
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.T4CTTIo! er.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(PageP!
ropertyDB.java:651)
at org.jahia.services.pages.JahiaPageBase
Service.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.apa!
che.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.Stand!
ardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.j
ava: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.jav! a:534)
Cause level :
1
org.jahia.exceptions.JahiaException: Cann ot 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
