AnsweredAssumed Answered

Problème configuration Alfresco - Oracle

Question asked by inho69 on Jun 10, 2008
Latest reply on May 9, 2011 by michaelh
Bonjour à tous,

Je suis en train d'industrialiser la solution Alfresco pour mon entreprise, et du coup nous allons interfaçé Alfresco avec une base Oracle plutôt que la base MySQL(qui ne m'a servi que pour des tests + démo).
Alors j'ai suivi les instructions que j'ai pu trouver ici http://wiki.alfresco.com/wiki/Database_Configuration et ici http://wiki.alfresco.com/fr/index.php/Documentation:Choix_de_la_base_de_donn%C3%A9es. J'ai donc importé les drivers Oracle dans le répertoire lib, et modifié les 3 fichiers de conf adéquats.
Coté Oracle, j'ai créé une base de donnée vide (il me semble bien qu'Alfresco s'occupe de la remplir), mon listener est démarré donc a priori tous les voyants sont au verts…MAIS car il y a bien un mais, ça ne fonctionne pas… Voici l'erreur affichée:

6 juin 2008 10:03:08 org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initialisation de Coyote HTTP/1.1 sur http-8080
6 juin 2008 10:03:08 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 938 ms
6 juin 2008 10:03:08 org.apache.catalina.core.StandardService start
INFO: Démarrage du service Catalina
6 juin 2008 10:03:08 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
6 juin 2008 10:03:08 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
6 juin 2008 10:03:09 org.apache.catalina.startup.HostConfig deployWAR
INFO: Déploiement de l'archive alfresco.war de l'application web
6 juin 2008 10:03:40 org.apache.catalina.core.StandardContext start
GRAVE: Error listenerStart
6 juin 2008 10:03:40 org.apache.catalina.core.StandardContext start
GRAVE: Erreur de démarrage du contexte [/alfresco] suite aux erreurs précédentes
6 juin 2008 10:03:41 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Démarrage de Coyote HTTP/1.1 sur http-8080
6 juin 2008 10:03:41 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
6 juin 2008 10:03:41 org.apache.catalina.startup.Catalina start
INFO: Server startup in 33156 ms

La première erreur parle de Listener, mais je ne comprends pas car il tourne bien. Est ce un problème dans la conf d'Alfresco? Pourtant j'ai bien inséré le   db.url=jdbc:oracle:thin:@<Nom Hote>:1521:<SID de la base>.
Etant donné que j'avais déjà manipulé l'outil avec une base mysql pour réaliser une démo, est ce que cela pourrait poser problèmes de bosser avec Oracle? (Faut-il que je réinstalle Alfresco ou peut-il switcher d'une base à une autre?)

Pour info, Alfresco ET Oracle tournent sur une machine virtuelle XP SP2.
Version alfresco : 2.1.0 Community
Version Oracle: 10g / 10.2.0.1

La liste complète du log à l'affichage:

        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:120)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)

        at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)

        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
        at org.apache.catalina.core.StandardService.start(StandardService.java:4
48)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:700
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
11:13:19,015 ERROR [[Catalina].[localhost].[/alfresco]] Exception lors de l'envo
i de l'ÚvÞnement contexte initialisÚ (context initialized) Ó l'instance de class
e d'Úcoute (listener) org.springframework.web.context.ContextLoaderListener
org.alfresco.error.AlfrescoRuntimeException: The store 'archive://SpacesStore' h
as a duplicate root node entry.
        at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationCheck
er.java:268)
        at org.alfresco.repo.admin.ConfigurationChecker.access$000(Configuration
Checker.java:72)
        at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationC
hecker.java:178)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransacti
on(RetryingTransactionHelper.java:225)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransacti
on(RetryingTransactionHelper.java:155)
        at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(Configuratio
nChecker.java:182)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLi
fecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1
.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecut
or.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.m
ulticastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publis
hEvent(AbstractApplicationContext.java:241)
        at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:349)
        at org.springframework.web.context.support.AbstractRefreshableWebApplica
tionContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
        at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3764)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
216)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:760)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:74
0)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)

        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714
)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490
)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:120)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)

        at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)

        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
        at org.apache.catalina.core.StandardService.start(StandardService.java:4
48)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:700
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
11:13:19,093 ERROR [[Catalina].[localhost].[/alfresco]] Exception lors de l'envo
i de l'ÚvÞnement contexte initialisÚ (context initialized) Ó l'instance de class
e d'Úcoute (listener) org.alfresco.web.app.ContextListener
org.alfresco.error.AlfrescoRuntimeException: The store 'archive://SpacesStore' h
as a duplicate root node entry.
        at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationCheck
er.java:268)
        at org.alfresco.repo.admin.ConfigurationChecker.access$000(Configuration
Checker.java:72)
        at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationC
hecker.java:178)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransacti
on(RetryingTransactionHelper.java:225)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransacti
on(RetryingTransactionHelper.java:155)
        at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(Configuratio
nChecker.java:182)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLi
fecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1
.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecut
or.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.m
ulticastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publis
hEvent(AbstractApplicationContext.java:241)
        at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:349)
        at org.springframework.web.context.support.AbstractRefreshableWebApplica
tionContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
        at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3764)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
216)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:760)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:74
0)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)

        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714
)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490
)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:120)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)

        at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)

        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
        at org.apache.catalina.core.StandardService.start(StandardService.java:4
48)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:700
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
6 juin 2008 11:13:19 org.apache.catalina.core.StandardContext start
GRAVE: Error listenerStart
6 juin 2008 11:13:19 org.apache.catalina.core.StandardContext start
GRAVE: Erreur de dÚmarrage du contexte [/alfresco] suite aux erreurs prÚcÚdentes

log4j:ERROR Error occured while converting date.
java.lang.NullPointerException
        at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:485
)
        at java.lang.StringBuffer.append(StringBuffer.java:301)
        at org.apache.log4j.helpers.AbsoluteTimeDateFormat.format(AbsoluteTimeDa
teFormat.java:113)
        at java.text.DateFormat.format(DateFormat.java:316)
        at org.apache.log4j.helpers.PatternParser$DatePatternConverter.convert(P
atternParser.java:436)
        at org.apache.log4j.helpers.PatternConverter.format(PatternConverter.jav
a:56)
        at org.apache.log4j.PatternLayout.format(PatternLayout.java:495)
        at org.apache.log4j.WriterAppender.subAppend(WriterAppender.java:292)
        at org.apache.log4j.WriterAppender.append(WriterAppender.java:150)
        at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:221)

        at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders
(AppenderAttachableImpl.java:57)
        at org.apache.log4j.Category.callAppenders(Category.java:187)
        at org.apache.log4j.Category.forcedLog(Category.java:372)
        at org.apache.log4j.Category.log(Category.java:864)
        at org.apache.commons.logging.impl.Log4JLogger.error(Log4JLogger.java:19
3)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo$Merger.run(Index
Info.java:2468)
        at java.lang.Thread.run(Thread.java:619)
ERROR [lucene.index.IndexInfo] ??
java.lang.NullPointerException
        at org.alfresco.repo.search.impl.lucene.index.ReferenceCountingReadOnlyI
ndexReaderFactory$ReferenceCountingReadOnlyIndexReader.doClose(ReferenceCounting
ReadOnlyIndexReaderFactory.java:178)
        at org.apache.lucene.index.IndexReader.close(IndexReader.java:722)
        at org.apache.lucene.index.MultiReader.doClose(MultiReader.java:249)
        at org.apache.lucene.index.IndexReader.close(IndexReader.java:722)
        at org.apache.lucene.index.FilterIndexReader.doClose(FilterIndexReader.j
ava:137)
        at org.apache.lucene.index.IndexReader.close(IndexReader.java:722)
        at org.apache.lucene.index.MultiReader.doClose(MultiReader.java:249)
        at org.apache.lucene.index.IndexReader.close(IndexReader.java:722)
        at org.apache.lucene.index.FilterIndexReader.doClose(FilterIndexReader.j
ava:137)
        at org.apache.lucene.index.IndexReader.close(IndexReader.java:722)
        at org.apache.lucene.index.MultiReader.doClose(MultiReader.java:249)
        at org.apache.lucene.index.IndexReader.close(IndexReader.java:722)
        at org.apache.lucene.index.FilterIndexReader.doClose(FilterIndexReader.j
ava:137)
        at org.apache.lucene.index.IndexReader.close(IndexReader.java:722)
        at org.apache.lucene.index.MultiReader.doClose(MultiReader.java:249)
        at org.apache.lucene.index.IndexReader.close(IndexReader.java:722)
        at org.apache.lucene.index.FilterIndexReader.doClose(FilterIndexReader.j
ava:137)
        at org.apache.lucene.index.IndexReader.close(IndexReader.java:722)
        at org.apache.lucene.index.MultiReader.doClose(MultiReader.java:249)
        at org.apache.lucene.index.IndexReader.close(IndexReader.java:722)
        at org.alfresco.repo.search.impl.lucene.index.ReferenceCountingReadOnlyI
ndexReaderFactory$ReferenceCountingReadOnlyIndexReader.closeIfRequired(Reference
CountingReadOnlyIndexReaderFactory.java:137)
        at org.alfresco.repo.search.impl.lucene.index.ReferenceCountingReadOnlyI
ndexReaderFactory$ReferenceCountingReadOnlyIndexReader.setInvalidForReuse(Refere
nceCountingReadOnlyIndexReaderFactory.java:172)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo$Merger$3.doWork(
IndexInfo.java:2753)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(I
ndexInfo.java:2077)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo.access$3700(Inde
xInfo.java:115)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo$Merger.mergeDele
tions(IndexInfo.java:2703)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo$Merger.run(Index
Info.java:2444)
        at java.lang.Thread.run(Thread.java:619)
log4j:ERROR Error occured while converting date.
java.lang.NullPointerException
        at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:485
)
        at java.lang.StringBuffer.append(StringBuffer.java:301)
        at org.apache.log4j.helpers.AbsoluteTimeDateFormat.format(AbsoluteTimeDa
teFormat.java:113)
        at java.text.DateFormat.format(DateFormat.java:316)
        at org.apache.log4j.helpers.PatternParser$DatePatternConverter.convert(P
atternParser.java:436)
        at org.apache.log4j.helpers.PatternConverter.format(PatternConverter.jav
a:56)
        at org.apache.log4j.PatternLayout.format(PatternLayout.java:495)
        at org.apache.log4j.WriterAppender.subAppend(WriterAppender.java:292)
        at org.apache.log4j.DailyRollingFileAppender.subAppend(DailyRollingFileA
ppender.java:349)
        at org.apache.log4j.WriterAppender.append(WriterAppender.java:150)
        at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:221)

        at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders
(AppenderAttachableImpl.java:57)
        at org.apache.log4j.Category.callAppenders(Category.java:187)
        at org.apache.log4j.Category.forcedLog(Category.java:372)
        at org.apache.log4j.Category.log(Category.java:864)
        at org.apache.commons.logging.impl.Log4JLogger.error(Log4JLogger.java:19
3)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo$Merger.run(Index
Info.java:2468)
        at java.lang.Thread.run(Thread.java:619)
Exception in thread "Index merger thread E:\alfresco v2.1.0\alf_data\lucene-inde
xes\system\system" java.lang.NullPointerException
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo$Merger.run(Index
Info.java:2468)
        at java.lang.Thread.run(Thread.java:619)
6 juin 2008 11:13:20 org.apache.coyote.http11.Http11BaseProtocol start
INFO: DÚmarrage de Coyote HTTP/1.1 sur http-8080
6 juin 2008 11:13:20 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
6 juin 2008 11:13:20 org.apache.catalina.startup.Catalina start
INFO: Server startup in 31063 ms

Merci d'avance pour votre aide.

Outcomes