Re: PagePropertyDB.isKeyAlreadyUsedInSiteWithID : ORA-00911: invalid character

Indeed this fix has been committed to CVS end of last week.

Regards,
  Serge Huber.

Stéphane Croisier wrote:

>
> 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
>