BonjourJ'ai voulu tester alfresco 2.1 en win2003...

[etivant]

Bonjour

J'ai voulu tester alfresco 2.1 en win2003 avec une base de donnée sql server 2000. Des tables ce sont bien crees dans ma base alfresco, les tables ont ete alimentées, mais j'ai des erreurs au demarage d'alfresco:

15:15:34,820 INFO  [org.alfresco.util.AbstractTriggerBean] Job ldapGroupTrigger is active15:15:39,648 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.15:15:46,055 ERROR [org.springframework.web.context.ContextLoader] Context initialization failedorg.alfresco.error.AlfrescoRuntimeException: Bootstrap failed   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:444)   at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:666)   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)   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(LifecycleSupport.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:448)   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(DelegatingMethodAccessorImpl.java:25)   at java.lang.reflect.Method.invoke(Method.java:585)   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)Caused by: org.alfresco.repo.search.SearcherException: More than one root node in index: 2   at org.alfresco.repo.search.impl.lucene.query.LeafScorer.initialise(LeafScorer.java:252)   at org.alfresco.repo.search.impl.lucene.query.LeafScorer.<init>(LeafScorer.java:164)   at org.alfresco.repo.search.impl.lucene.query.PathScorer.createPathScorer(PathScorer.java:167)   at org.alfresco.repo.search.impl.lucene.query.PathQuery$StructuredFieldWeight.scorer(PathQuery.java:258)   at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:130)   at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:100)   at org.apache.lucene.search.Hits.getMoreDocs(Hits.java:66)   at org.apache.lucene.search.Hits.<init>(Hits.java:45)   at org.apache.lucene.search.Searcher.search(Searcher.java:45)   at org.apache.lucene.search.Searcher.search(Searcher.java:37)   at org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.query(ADMLuceneSearcherImpl.java:272)   at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:85)   at org.alfresco.repo.importer.ImporterComponent$NodeImporter.resolveImportedNodeRef(ImporterComponent.java:1026)   at org.alfresco.repo.importer.ImporterComponent$NodeImporter.end(ImporterComponent.java:746)   at org.alfresco.repo.importer.ImporterComponent.parserImport(ImporterComponent.java:361)   at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:224)   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:426)   … 35 more15:15:46,102 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception lors de l'envoi de l'évènement contexte initialisé (context initialized) à l'instance de classe d'écoute (listener) org.springframework.web.context.ContextLoaderListenerorg.alfresco.error.AlfrescoRuntimeException: Bootstrap failed   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:444)   at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:666)   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)   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(LifecycleSupport.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:448)   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(DelegatingMethodAccessorImpl.java:25)   at java.lang.reflect.Method.invoke(Method.java:585)   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)Caused by: org.alfresco.repo.search.SearcherException: More than one root node in index: 2   at org.alfresco.repo.search.impl.lucene.query.LeafScorer.initialise(LeafScorer.java:252)   at org.alfresco.repo.search.impl.lucene.query.LeafScorer.<init>(LeafScorer.java:164)   at org.alfresco.repo.search.impl.lucene.query.PathScorer.createPathScorer(PathScorer.java:167)   at org.alfresco.repo.search.impl.lucene.query.PathQuery$StructuredFieldWeight.scorer(PathQuery.java:258)   at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:130)   at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:100)   at org.apache.lucene.search.Hits.getMoreDocs(Hits.java:66)   at org.apache.lucene.search.Hits.<init>(Hits.java:45)   at org.apache.lucene.search.Searcher.search(Searcher.java:45)   at org.apache.lucene.search.Searcher.search(Searcher.java:37)   at org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.query(ADMLuceneSearcherImpl.java:272)   at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:85)   at org.alfresco.repo.importer.ImporterComponent$NodeImporter.resolveImportedNodeRef(ImporterComponent.java:1026)   at org.alfresco.repo.importer.ImporterComponent$NodeImporter.end(ImporterComponent.java:746)   at org.alfresco.repo.importer.ImporterComponent.parserImport(ImporterComponent.java:361)   at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:224)   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:426)   … 35 more15:15:46,148 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception lors de l'envoi de l'évènement contexte initialisé (context initialized) à l'instance de classe d'écoute (listener) org.alfresco.web.app.ContextListenerorg.alfresco.error.AlfrescoRuntimeException: Bootstrap failed   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:444)   at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:666)   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)   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(LifecycleSupport.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:448)   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(DelegatingMethodAccessorImpl.java:25)   at java.lang.reflect.Method.invoke(Method.java:585)   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)Caused by: org.alfresco.repo.search.SearcherException: More than one root node in index: 2   at org.alfresco.repo.search.impl.lucene.query.LeafScorer.initialise(LeafScorer.java:252)   at org.alfresco.repo.search.impl.lucene.query.LeafScorer.<init>(LeafScorer.java:164)   at org.alfresco.repo.search.impl.lucene.query.PathScorer.createPathScorer(PathScorer.java:167)   at org.alfresco.repo.search.impl.lucene.query.PathQuery$StructuredFieldWeight.scorer(PathQuery.java:258)   at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:130)   at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:100)   at org.apache.lucene.search.Hits.getMoreDocs(Hits.java:66)   at org.apache.lucene.search.Hits.<init>(Hits.java:45)   at org.apache.lucene.search.Searcher.search(Searcher.java:45)   at org.apache.lucene.search.Searcher.search(Searcher.java:37)   at org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.query(ADMLuceneSearcherImpl.java:272)   at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:85)   at org.alfresco.repo.importer.ImporterComponent$NodeImporter.resolveImportedNodeRef(ImporterComponent.java:1026)   at org.alfresco.repo.importer.ImporterComponent$NodeImporter.end(ImporterComponent.java:746)   at org.alfresco.repo.importer.ImporterComponent.parserImport(ImporterComponent.java:361)   at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:224)   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:426)   … 35 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Quelqu'un aurai une idée sur ce probleme ? je séche.

Les fichiers de config sont les suivants:
custom-repository.properties

############################### ## Common Alfresco Properties # ###############################  # # Sample custom content and index data location # dir.root=D:/alfresco3/alf_data dir.indexes=D:/alfresco3/alf_data/lucene-indexes  # # Sample database connection properties # #db.username=alfresco #db.password=alfresco #db.pool.initial=10 #db.pool.max=100  # # Property to control whether schema updates are performed automatically. # Updates must be enabled during upgrades as, apart from the static upgrade scripts, # there are also auto-generated update scripts that will need to be executed.  After # upgrading to a new version, this can be disabled. # #db.schema.update=true  # # HSQL connection # #db.driver=org.hsqldb.jdbcDriver #db.url=jdbc:hsqldb:file:alf_data/hsql_data/alfresco;ifexists=true;shutdown=true;  # # MySQL connection (This is default and requires mysql-connector-java-5.0.3-bin.jar, which ships with the Alfresco server) # #mysql#db.driver=org.gjt.mm.mysql.Driver #mysql#db.url=jdbc:mysql://localhost/alfresco  # # Oracle connection (requires ojdbc14_g.jar or equivalent jar in shared libraries location) # #oracle#db.driver=oracle.jdbc.OracleDriver #oracle#db.url=jdbc:oracle:thin:@localhost:1521:alfresco  # # Sybase connection (requires jconn2d.jar or equivalent jar in shared libraries location) # #sybase#db.driver=com.sybase.jdbc2.jdbc.SybDriver #sybase#db.url=jdbc:sybase:Tds:localhost:2638/alfresco  # # SQLServer connection (requires jdts-1.2.jar or equivalent - http://jtds.sourceforge.net/) # #sqlserver#db.driver=net.sourceforge.jtds.jdbc.Driver #sqlserver#db.url=jdbc:jtds:sqlserver://localhost/alfresco  # # SQLServer connection using Microsoft JDDB driver # db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver db.url=jdbc:sqlserver://localhost:1433;DatabaseName=alfresco db.username=alfresco db.password=alfresco db.pool.initial=1 db.pool.max=100 db.pool.maxIdleTime=120 # # PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent) # #postgresql#db.driver=org.postgresql.Driver #postgresql#db.url=jdbc:postgresql://localhost:5432/alfresco‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

custom-hibernate-dialect.properties

## Sample Hibernate configuration for changing Database dialect# For a full list: http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#configuration-optional-dialects### HSQL dialect##hibernate.dialect=org.hibernate.dialect.HSQLDialect## MySQL dialect (default)##hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect## Oracle dialect##hibernate.dialect=org.hibernate.dialect.Oracle9Dialect## Sybase dialect##hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoSybaseAnywhereDialect## SQLServer dialect#hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect## PostgreSQL dialect##hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect#hibernate.query.substitutions=true TRUE, false FALSE‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

hibernate-cfg.properties

## Hibernate configuration#hibernate.dialect=org.hibernate.dialect.SQLServerDialecthibernate.jdbc.use_streams_for_binary=truehibernate.show_sql=falsehibernate.cache.use_query_cache=truehibernate.max_fetch_depth=10hibernate.cache.provider_class=org.alfresco.repo.cache.InternalEhCacheManagerFactoryBeanhibernate.cache.use_second_level_cache=truehibernate.default_batch_fetch_size=1hibernate.jdbc.batch_size=32hibernate.connection.release_mode=autohibernate.connection.isolation=2#hibernate.jdbc.use_get_generated_keys=true‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Cordialement.

Jerome

[lme]

More than one root node in index: 2‍

Tu as dû repasser par le bootstrap d'alfresco une 2nd fois sans supprimer le contenu du dossier alf_data.

- arrête alfresco
- supprime le contenu du dossier alf_data
- supprime les tables de la base de données alfresco
- redémarre alfresco

[etivant]

Merci Laurent ca marche impecablement !!!