Problems with fresh Alfesco 3.2 CE Installation on Windows

[arash_kaffamane]

I installed the brand new full package of Alfresco 3.2 CE on my Windows XP with an existing database MySQL 5.0.51 server, droped the old alfresco database and now after installation there are no database tables created, the alfresco.log is clean:

17:49:04,914 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 24 Web Scripts (+0 failed), 26 URLs
17:49:05,074 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 2569.9329ms)
17:49:05,503 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 36 Web Scripts (+0 failed), 38 URLs
17:49:05,533 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 368.8642ms)
17:49:05,603 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
17:49:13,515 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
17:52:24,642 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework

changed also the db.username to "root" in C:\Alfresco\tomcat\shared\classes\alfresco-global.properties –> didn't help to create the tables by startup.

Another thin which is strange ist the facht that tomcat needs very long to start:

07.07.2009 17:49:13 org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive studio.war
17:52:24,642  INFO  [web.site.FrameworkHelper] Successfully Initialized Web Fram
ework
07.07.2009 17:52:25 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
07.07.2009 17:52:25 org.apache.catalina.startup.Catalina start
INFO: Server startup in 210700 ms

So now I'll move to my mac at home and will give it a try there 😉

[mrogers]

You have not shown any errors.  

What would be interesting is the database update part of the Alfresco log.

You shouldn't have needed to drop the database to upgrade.

[arash_kaffamane]

the logger doesn't write anything in alfresco.log, so now I'm going to restart the whole mashine and give it a last try on windows (on mac and linux it worked as a charme).

[arash_kaffamane]

so after restart, uninstall the whole package and deleting the C:/Alfresco folder and installing again using the custon install, where I only unchecked the MySQL checkbox, as I have my own mysql 5.0.51 on win xp, I'm getting now the follwoing error, which claims that the dir.root is incorrect, but in alfresco-gobal.properties file the dir.root ist set correctly as: "dir.root=C:/Alfresco/alf_data"

here is the full trace after a fresh installtion and start:

16:10:52,695 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
16:10:52,765 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
16:10:52,765 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/C:/Alfresco/tomcat/shared/classes/alfresco-global.properties]
16:10:53,506 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
16:11:43,018 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
16:11:43,759 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script C:\Alfresco\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-7506419589068650767.sql (Generated).
16:12:33,680 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script C:\Alfresco\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-4113894818356989553.sql (Copied from classpath:alfresco/dbscripts/create/2.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoPostCreate-2.2-MappedFKIndexes.sql).
16:12:33,690 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script C:\Alfresco\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-5871025208241036535.sql (Copied from classpath:alfresco/dbscripts/create/2.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoPostCreate-2.2-Extra.sql).
16:12:39,419 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script C:\Alfresco\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-4151638182774585339.sql (Copied from classpath:alfresco/dbscripts/create/2.2/org.hibernate.dialect.MySQLInnoDBDialect/post-create-indexes-04.sql).
16:12:39,619 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script C:\Alfresco\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-6981052566404993713.sql (Copied from classpath:alfresco/dbscripts/create/3.0/org.hibernate.dialect.MySQLInnoDBDialect/create-activities-extras.sql).
16:12:41,331 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script C:\Alfresco\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-8362090783475335284.sql (Copied from classpath:alfresco/dbscripts/create/3.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoPostCreate-3.2-LockTables.sql).
16:12:42,223 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script C:\Alfresco\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-6542388232377316051.sql (Copied from classpath:alfresco/dbscripts/create/3.2/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoPostCreate-3.2-ContentTables.sql).
16:12:42,884 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] All executed statements:  C:\Alfresco\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-All_Statements-1086695708436296355.sql.
16:12:45,808 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Normalized schema dumped to file C:\Alfresco\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-1598286823570693130.xml.
16:12:49,984 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'thirdparty' subsystem, ID: [default]
16:12:50,014 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
16:12:54,771 WARN  [org.alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
16:12:54,771 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [default] complete
16:13:49,820 INFO  [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: C:\Alfresco\alf_data
16:13:49,850 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 06080000 The store 'avm://sitestore' has a duplicate root node entry.
   at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:268)
   at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:72)
   at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:178)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:252)
   at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:182)
   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:246)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:516)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
   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:288)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
16:14:14,115 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 24 Web Scripts (+0 failed), 26 URLs
16:14:14,155 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 607.0235ms)
16:14:14,636 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 36 Web Scripts (+0 failed), 38 URLs
16:14:14,646 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 403.34625ms)
16:14:14,726 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
16:14:25,641 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
16:17:39,240 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework

[mrogers]

You deleted your content when you deleted c:\alfresco.

You now have a database out of line with the content store.   

Can you restore your c:\alfresco\alf_data from backup?

[arash_kaffamane]

I think I fould the problem of this type of installation (custom installation without mysql on an existing mysql serever), the alfresco user didn't have any grant privileges on the alfresco database, I da to grant by myself the right to alfresco user on alfresco database, now after a restart the tables are created in the alfresco db 😉

But I'm still facing the same error:

16:35:48,486 Userystem INFO  [repo.admin.ConfigurationChecker] The Alfresco ro
ot data directory ('dir.root') is: C:\Alfresco\alf_data
16:35:48,566 Userystem ERROR [web.context.ContextLoader] Context initializatio
n failed
org.alfresco.error.AlfrescoRuntimeException: 06080000 The store 'avm://sitestore
' has 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

[arash_kaffamane]

now copied the jaxb-api-2.1.jar from lib folder to endorsed folder an deleted the lucene index, as it was recomended in another post:

http://forums.alfresco.com/en/viewtopic.php?f=8&t=20228

To fix this:
1) Stop your server
2) Edit tomcat\shared\classes\alfresco-global.properties and set:
dir.root=C:/Alfresco/alf_data    (Note this uses forward / )
index.recovery.mode=AUTO
3) Delete the indexes directory: C:\Alfresco\alf_data\lucene-indexes
4) Start your server
‍‍‍‍‍‍‍‍‍

Now the ('dir.root') is: C:\Alfresco\alf_data ERROR is no more shown in the console and the logfile, but I've a new ERROR 😉 :

Caused by: org.springframework.beans.PropertyBatchUpdateException; nested Proper
tyAccessException details (1) are:
PropertyAccessException 1:
org.springframework.beans.MethodInvocationException: Property 'recoveryMode' thr
ew exception; nested exception is java.lang.IllegalArgumentException: No enum co
nst class org.alfresco.repo.node.index.FullIndexRecoveryComponent$RecoveryMode.A
uto
Caused by: java.lang.IllegalArgumentException: No enum const class org.alfresco.
repo.node.index.FullIndexRecoveryComponent$RecoveryMode.Auto
        at java.lang.Enum.valueOf(Enum.java:196)
        at org.alfresco.repo.node.index.FullIndexRecoveryComponent$RecoveryMode.
valueOf(FullIndexRecoveryComponent.java:69)
        at org.alfresco.repo.node.index.FullIndexRecoveryComponent.setRecoveryMo
de(FullIndexRecoveryComponent.java:121)
        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:585)
        at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrappe
rImpl.java:821)
        at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrappe
rImpl.java:645)
        at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(
AbstractPropertyAccessor.java:78)
        at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(
AbstractPropertyAccessor.java:59)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1127)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:862)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:423)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:249)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:155)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:246)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:160)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveReference(BeanDefinitionValueResolver.java:267)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver
.resolveValueIfNecessary(BeanDefinitionValueResolver.java:110)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1100)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.populateBean(AbstractAutowireCapableBeanFactory.java:862)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:423)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:249)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:155)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:246)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:160)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.
getBeansOfType(DefaultListableBeanFactory.java:248)
        at org.springframework.context.support.AbstractApplicationContext.getBea
nsOfType(AbstractApplicationContext.java:820)
        at org.springframework.context.support.AbstractApplicationContext.regist
erListeners(AbstractApplicationContext.java:597)
        at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:349)
        at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:189)
        at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:49)
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(Context
LoaderListener.java:69)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3843)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
342)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
1)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)

        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja
va:627)
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j
ava:553)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[mrogers]

The recovery mode may be case sensitive.   Try AUTO.

[arash_kaffamane]

That was ist! Thank you very much for your first class support.
Now I've Alfresco 3.2 CE running on Mac (tiger) at home, Ubuntu 8.0.4 LTS Server on internet as a demo platform for customers and and on Windows XP at my office.
Thanks again!

P.S: by the way the first start took about 7 minutes to start and I can't create any sample website in Web Studio (I'll post the trace to a new thread in WCM section of this nice forum)