PagePropertyDB.isKeyAlreadyUsedInSiteWithID : ORA-00911: invalid character

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