Hi,
Indeed some customers also experienced some issues with certain version of Oracle. Some problems were already fixed in the CVS. Thanks for having reported your issue, we will also try to fix it.
BTW: There is also a problem when migrating certain wevbdav files located under /users or /groups (and not under /shared) which suddently do not appear in the File Manager GUI.
Some quick fixes will be soon released in a 4.1b release and the migration script adjusted consequently. The migration script was temporarily removed from Jahia.org. The ones who already upgraded to 4.1 without experiencing problems will be also able to re-apply the new migration script once available. This will simply migrate them from 4.1 to 4.1b. All the others will be directly migrated from 4.0.6 to 4.1b.
Regards,
St�phane
At 11:24 23/05/2005, you wrote:
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
