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
[EMAIL PROTECTED]
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
