Re: Upload de fichier impossible

Stéphane Croisier <[email protected]> Tue, 16 Jan 2007 10:21:22 +0100
Newsgroups gmane.comp.cms.jahia.devel
Message-ID <[email protected]>
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.performExecutions(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.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransact 
>
>ionManager.java:564)
>         at 
> org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.ja 
>
>va:424)
>         at 
> org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionAfterReturning(TransactionAspec 
>
>tSupport.java:258)
>         at 
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(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 
><mailto:org.jahia.services.webdav.stores.JahiaDescriptorsStore@3f67e0>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
>
><http://www.onepoint.fr/>
>[]
>
>Nicolas DRAPIER
>Directeur de Projets Groupe
>
><mailto:[email protected]>[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