Re: Upload de fichier impossible

Ce probleme apparait apres un passage de 5.0.0 a 5.0 sp1 sur oracle  
et postgres (mais pas sur une nouvelle installation). Certaines  
contraintes ont ete supprimees de la sp - il faut passer le script  
suivant pour les effacer d'une base cree en 5.0.0 :

alter table jahia_sl2_binding drop constraint fkab79b8e923e1f4c2;
alter table jahia_sl2_binding drop constraint fkab79b8e94605c954;
alter table jahia_sl2_locks drop constraint fk53da340c22ea3034;
alter table jahia_sl2_locks drop constraint fk53da340c33924d02;
alter table jahia_sl2_locks drop constraint fk53da340c69f368a3;
alter table jahia_sl2_locks drop constraint fk53da340cfcf9e20f;
alter table jahia_sl2_parent_binding drop constraint fk21da510c23e1f4c2;
alter table jahia_sl2_parent_binding drop constraint fk21da510c603f6ee2;
alter table jahia_sl2_version_history drop constraint fkb5a4b691454fef2;
alter table jahia_sl2_version_history drop constraint  
fkb5a4b69123e1f4c2;

cordialement

Le 16 janv. 07 à 10:21, Stéphane Croisier a écrit :

>
> Bonjour,
>
> Il doit y avoir un problème avec le script Oracle sur la SP1. Ce  
> problème a déjà été reporté il y a qq jours. Malheureusement notre  
> DBA Oracle est en vacances. On va néanmoins quand même tenter de  
> regarder ASAP. D'ici là si vous pouvez utiliser MySQL ou Postgres,  
> ces problèmes n'apparaissent pas.
>
> Cordialement,
> Stéphane
>
> At 11:53 15.01.2007, you wrote:
>
>> Bonjour,
>>
>> Dans Jahia 5.0 SP1, installé sous Oracle avec Tomcat, le  
>> gestionnaire de fichier est totalement inactif. Impossible  
>> d'uploader de fichier.
>> L'accès au webdav fonctionne mais l'upload de fichier est  
>> impossible non plus. Une erreur est affichée
>>
>> Problème rencontré avec la r16138 et r16140.
>> Quelqu’un a-t-il une idée ?
>>
>> Merci d’avance,
>>
>> log:
>> 2359440 [2006-12-26 17:20:17,315]  
>> [org.apache.slide.webdav.JahiaWebdavServlet] INFO - Webdav request  
>> [HEAD /site/onepoint/users/o
>> padmin/public/groupe_onePoint.jpg] user=[opadmin]
>> 2359456 [2006-12-26 17:20:17,331]  
>> [org.apache.slide.webdav.JahiaWebdavServlet] INFO - Processed  
>> [HEAD /site/onepoint/users/opadmi
>> n/public/groupe_onePoint.jpg] in 16ms
>> 2359471 [2006-12-26 17:20:17,346]  
>> [org.apache.slide.webdav.JahiaWebdavServlet] INFO - Webdav request  
>> [PUT /site/onepoint/users/op
>> admin/public/groupe_onePoint.jpg] user=[opadmin]
>> org.springframework.dao.DataIntegrityViolationException:  
>> SessionSynchronization; ORA-02291: violation de contrainte  
>> d'intÚgritÚ (J
>> AHIA.FKAB79B8E923E1F4C2) - clÚ parent introuvable
>> ; nested exception is java.sql.BatchUpdateException: ORA-02291:  
>> violation de contrainte d'intÚgritÚ (JAHIA.FKAB79B8E923E1F4C2) - c
>> lÚ parent introuvable
>>
>> java.sql.BatchUpdateException: ORA-02291: violation de contrainte  
>> d'intÚgritÚ (JAHIA.FKAB79B8E923E1F4C2) - clÚ parent introuvable
>>
>>         at  
>> oracle.jdbc.driver.DatabaseError.throwBatchUpdateException 
>> (DatabaseError.java:343)
>>         at oracle.jdbc.driver.OraclePreparedStatement.executeBatch 
>> (OraclePreparedStatement.java:10656)
>>         at org.apache.commons.dbcp.DelegatingStatement.executeBatch 
>> (DelegatingStatement.java:294)
>>         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch 
>> (BatchingBatcher.java:57)
>>         at org.hibernate.jdbc.AbstractBatcher.executeBatch 
>> (AbstractBatcher.java:174)
>>         at org.hibernate.jdbc.AbstractBatcher.prepareStatement 
>> (AbstractBatcher.java:74)
>>         at org.hibernate.jdbc.AbstractBatcher.prepareStatement 
>> (AbstractBatcher.java:69)
>>         at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement 
>> (AbstractBatcher.java:150)
>>         at  
>> org.hibernate.persister.entity.BasicEntityPersister.insert 
>> (BasicEntityPersister.java:1839)
>>         at  
>> org.hibernate.persister.entity.BasicEntityPersister.insert 
>> (BasicEntityPersister.java:2200)
>>         at org.hibernate.action.EntityInsertAction.execute 
>> (EntityInsertAction.java:46)
>>         at org.hibernate.engine.ActionQueue.execute 
>> (ActionQueue.java:239)
>>         at org.hibernate.engine.ActionQueue.executeActions 
>> (ActionQueue.java:223)
>>         at org.hibernate.engine.ActionQueue.executeActions 
>> (ActionQueue.java:136)
>>         at  
>> org.hibernate.event.def.AbstractFlushingEventListener.performExecutio 
>> ns(AbstractFlushingEventListener.java:274)
>>         at  
>> org.hibernate.event.def.DefaultFlushEventListener.onFlush 
>> (DefaultFlushEventListener.java:27)
>>         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
>>         at org.springframework.orm.hibernate3.SessionFactoryUtils 
>> $SpringSessionSynchronization.beforeCommit(SessionFactoryUtils.ja
>> va:869)
>>         at  
>> org.springframework.transaction.support.AbstractPlatformTransactionMa 
>> nager.triggerBeforeCommit(AbstractPlatformTransact
>> ionManager.java:564)
>>         at  
>> org.springframework.transaction.support.AbstractPlatformTransactionMa 
>> nager.commit(AbstractPlatformTransactionManager.ja
>> va:424)
>>         at  
>> org.springframework.transaction.interceptor.TransactionAspectSupport. 
>> doCommitTransactionAfterReturning(TransactionAspec
>> tSupport.java:258)
>>         at  
>> org.springframework.transaction.interceptor.TransactionInterceptor.in 
>> voke(TransactionInterceptor.java:67)
>>         at  
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( 
>> ReflectiveMethodInvocation.java:144)
>>         at  
>> org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke 
>> (AbstractTraceInterceptor.java:80)
>>         at  
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( 
>> ReflectiveMethodInvocation.java:144)
>>         at org.springframework.aop.framework.Cglib2AopProxy 
>> $FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:546)
>>         at org.jahia.hibernate.manager.JahiaSlideUriManager$ 
>> $EnhancerByCGLIB$$54afe74a.createObject(<generated>)
>>         at  
>> org.jahia.services.webdav.stores.JahiaJDBCAdapter.createObject 
>> (JahiaJDBCAdapter.java:88)
>>         at  
>> org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.createObject 
>> (AbstractRDBMSStore.java:449)
>>         at  
>> org.jahia.services.webdav.stores.JahiaDescriptorsStore.storeObject 
>> (JahiaDescriptorsStore.java:650)
>>         at org.apache.slide.store.AbstractStore.storeObject 
>> (AbstractStore.java:729)
>>         at org.apache.slide.store.ExtendedStore.storeObject 
>> (ExtendedStore.java:631)
>>         at org.apache.slide.store.BindingStore.storeObject 
>> (BindingStore.java:98)
>>         at  
>> org.jahia.services.webdav.stores.JahiaBindingStore.storeObject 
>> (JahiaBindingStore.java:60)
>>         at org.apache.slide.store.BindingStore.storeObject 
>> (BindingStore.java:104)
>>         at  
>> org.jahia.services.webdav.stores.JahiaBindingStore.storeObject 
>> (JahiaBindingStore.java:60)
>>         at org.apache.slide.structure.StructureImpl.store 
>> (StructureImpl.java:508)
>>         at org.apache.slide.structure.StructureImpl.create 
>> (StructureImpl.java:390)
>>         at org.apache.slide.webdav.method.PutMethod.executeRequest 
>> (PutMethod.java:328)
>>         at  
>> org.apache.slide.webdav.method.AbstractWebdavMethod.executeRedirect 
>> (AbstractWebdavMethod.java:583)
>>         at org.apache.slide.webdav.method.AbstractWebdavMethod.run 
>> (AbstractWebdavMethod.java:416)
>>         at org.apache.slide.webdav.JahiaWebdavServlet.service 
>> (JahiaWebdavServlet.java:183)
>>         at javax.servlet.http.HttpServlet.service(HttpServlet.java: 
>> 802)
>>         at  
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter 
>> (ApplicationFilterChain.java:252)
>>         at org.apache.catalina.core.ApplicationFilterChain.doFilter 
>> (ApplicationFilterChain.java:173)
>>         at org.jahia.bin.filters.esi.ESIFilter.doFilter 
>> (ESIFilter.java:109)
>>         at  
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter 
>> (ApplicationFilterChain.java:202)
>>         at org.apache.catalina.core.ApplicationFilterChain.doFilter 
>> (ApplicationFilterChain.java:173)
>>         at org.apache.catalina.core.StandardWrapperValve.invoke 
>> (StandardWrapperValve.java:213)
>>         at org.apache.catalina.core.StandardContextValve.invoke 
>> (StandardContextValve.java:178)
>>         at  
>> org.apache.catalina.authenticator.AuthenticatorBase.invoke 
>> (AuthenticatorBase.java:432)
>>         at org.apache.catalina.core.StandardHostValve.invoke 
>> (StandardHostValve.java:126)
>>         at org.apache.catalina.valves.ErrorReportValve.invoke 
>> (ErrorReportValve.java:105)
>>         at org.apache.catalina.core.StandardEngineValve.invoke 
>> (StandardEngineValve.java:107)
>>         at org.apache.catalina.connector.CoyoteAdapter.service 
>> (CoyoteAdapter.java:148)
>>         at org.apache.coyote.http11.Http11Processor.process 
>> (Http11Processor.java:869)
>>         at org.apache.coyote.http11.Http11BaseProtocol 
>> $Http11ConnectionHandler.processConnection(Http11BaseProtocol.java: 
>> 664)
>>         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket 
>> (PoolTcpEndpoint.java:527)
>>         at  
>> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt 
>> (LeaderFollowerWorkerThread.java:80)
>>         at org.apache.tomcat.util.threads.ThreadPool 
>> $ControlRunnable.run(ThreadPool.java:684)
>>         at java.lang.Thread.run(Thread.java:595)
>> org.apache.slide.common.ServiceAccessException: Service  
>> org.jahia.services.webdav.stores.JahiaDescriptorsStore@3f67e0  
>> access error
>>  : SessionSynchronization; ORA-02291: violation de contrainte  
>> d'intÚgritÚ (JAHIA.FKAB79B8E923E1F4C2) - clÚ parent introuvable
>> ; nested exception is java.sql.BatchUpdateException: ORA-02291:  
>> violation de contrainte d'intÚgritÚ (JAHIA.FKAB79B8E923E1F4C2) - c
>> lÚ parent introuvable
>>
>>         at org.apache.slide.store.AbstractStore.storeObject 
>> (AbstractStore.java:742)
>>         at org.apache.slide.store.ExtendedStore.storeObject 
>> (ExtendedStore.java:631)
>>         at org.apache.slide.store.BindingStore.storeObject 
>> (BindingStore.java:98)
>>         at  
>> org.jahia.services.webdav.stores.JahiaBindingStore.storeObject 
>> (JahiaBindingStore.java:60)
>>         at org.apache.slide.store.BindingStore.storeObject 
>> (BindingStore.java:104)
>>         at  
>> org.jahia.services.webdav.stores.JahiaBindingStore.storeObject 
>> (JahiaBindingStore.java:60)
>>         at org.apache.slide.structure.StructureImpl.store 
>> (StructureImpl.java:508)
>>         at org.apache.slide.structure.StructureImpl.create 
>> (StructureImpl.java:390)
>>         at org.apache.slide.webdav.method.PutMethod.executeRequest 
>> (PutMethod.java:328)
>>         at  
>> org.apache.slide.webdav.method.AbstractWebdavMethod.executeRedirect 
>> (AbstractWebdavMethod.java:583)
>>         at org.apache.slide.webdav.method.AbstractWebdavMethod.run 
>> (AbstractWebdavMethod.java:416)
>>         at org.apache.slide.webdav.JahiaWebdavServlet.service 
>> (JahiaWebdavServlet.java:183)
>>         at javax.servlet.http.HttpServlet.service(HttpServlet.java: 
>> 802)
>>         at  
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter 
>> (ApplicationFilterChain.java:252)
>>         at org.apache.catalina.core.ApplicationFilterChain.doFilter 
>> (ApplicationFilterChain.java:173)
>>         at org.jahia.bin.filters.esi.ESIFilter.doFilter 
>> (ESIFilter.java:109)
>>         at  
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter 
>> (ApplicationFilterChain.java:202)
>>         at org.apache.catalina.core.ApplicationFilterChain.doFilter 
>> (ApplicationFilterChain.java:173)
>>         at org.apache.catalina.core.StandardWrapperValve.invoke 
>> (StandardWrapperValve.java:213)
>>         at org.apache.catalina.core.StandardContextValve.invoke 
>> (StandardContextValve.java:178)
>>         at  
>> org.apache.catalina.authenticator.AuthenticatorBase.invoke 
>> (AuthenticatorBase.java:432)
>>         at org.apache.catalina.core.StandardHostValve.invoke 
>> (StandardHostValve.java:126)
>>         at org.apache.catalina.valves.ErrorReportValve.invoke 
>> (ErrorReportValve.java:105)
>>         at org.apache.catalina.core.StandardEngineValve.invoke 
>> (StandardEngineValve.java:107)
>>         at org.apache.catalina.connector.CoyoteAdapter.service 
>> (CoyoteAdapter.java:148)
>>         at org.apache.coyote.http11.Http11Processor.process 
>> (Http11Processor.java:869)
>>         at org.apache.coyote.http11.Http11BaseProtocol 
>> $Http11ConnectionHandler.processConnection(Http11BaseProtocol.java: 
>> 664)
>>         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket 
>> (PoolTcpEndpoint.java:527)
>>         at  
>> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt 
>> (LeaderFollowerWorkerThread.java:80)
>>         at org.apache.tomcat.util.threads.ThreadPool 
>> $ControlRunnable.run(ThreadPool.java:684)
>>         at java.lang.Thread.run(Thread.java:595)
>> 2359768 [2006-12-26 17:20:17,643]  
>> [org.apache.slide.webdav.JahiaWebdavServlet] INFO - Processed  
>> [PUT /site/onepoint/users/opadmin
>> /public/groupe_onePoint.jpg] in 297ms
>>
>>
>> Nicolas DRAPIER
>> Directeur de Projets Groupe
>>
>> [email protected]
>> +33 (0)6 60 97 62 93
>> +33 (0)1 46 94 96 00
>> www.onepoint.fr
>>
>>
>>
>>
>>
>> No virus found in this incoming message.
>> Checked by AVG Free Edition.
>> Version: 7.1.410 / Virus Database: 268.16.10/626 - Release Date:  
>> 14.01.2007
> - -- --- -----=[ scroisier at jahia dot com ]=---- --- -- -
> Head of Products - Jahia Ltd, Route des Jeunes 9, 1227 Carouge  
> (Switzerland)
> Jahia : The Java Unified Web Platform
> www.jahia.org - The Product Web Site
> www.jahia.net - The Community Web Site
> www.jahia.com - The Commercial Services Company
>
>
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.410 / Virus Database: 268.16.12/630 - Release Date:  
> 15.01.2007