topic Re: Problems with fresh Alfesco 3.2 CE Installation on Windows in Alfresco Archive

Problems with fresh Alfesco 3.2 CE Installation on Windows

arash_kaffamane — Tue, 07 Jul 2009 16:01:01 GMT

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.Declarati

Re: Problems with fresh Alfesco 3.2 CE Installation on Windows

mrogers — Tue, 07 Jul 2009 22:13:24 GMT

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.

Re: Problems with fresh Alfesco 3.2 CE Installation on Windows

arash_kaffamane — Wed, 08 Jul 2009 13:25:44 GMT

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).

Re: Problems with fresh Alfesco 3.2 CE Installation on Windows

arash_kaffamane — Wed, 08 Jul 2009 14:31:56 GMT

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

Re: Problems with fresh Alfesco 3.2 CE Installation on Windows

mrogers — Wed, 08 Jul 2009 14:35:00 GMT

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?

Re: Problems with fresh Alfesco 3.2 CE Installation on Windows

arash_kaffamane — Wed, 08 Jul 2009 14:38:51 GMT

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

Re: Problems with fresh Alfesco 3.2 CE Installation on Windows

arash_kaffamane — Wed, 08 Jul 2009 15:12:10 GMT

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)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Problems with fresh Alfesco 3.2 CE Installation on Windows

mrogers — Wed, 08 Jul 2009 15:14:28 GMT

The recovery mode may be case sensitive. Try AUTO.

Re: Problems with fresh Alfesco 3.2 CE Installation on Windows

arash_kaffamane — Thu, 09 Jul 2009 09:00:54 GMT

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)