If the database tables are "not populated". Then you have not connected to the database properly. Check your alfresco-global. properties. You will also need to delete the contents of alf data from your temporary install with Postgresql.
The quick and dirty way to upgrade is to just shutdown, backup, replace the alfresco and share war files and then restart.
I tried the above (on a lab sever, for sure) and it deployed, reindexed etc - but it got stuck running patches. So I went through with a fresh install of 4.0.c on Debian 6, MySQL. Started, it deploys and works. So I shut it down and pointed the alfresco-global.properties to the database of 3.4.d-installation, and copied over the contentstore. I started and got stuck on the same patch -
08:41:47,614 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.db-V3.4-AVM-rename-dupes' (Ensures that the database upgrade script has been run.).
08:41:47,618 ERROR [org.alfresco.repo.admin.patch.PatchExecuter] 10230000 The schema upgrade script, 'classpath:alfresco/dbscripts/upgrade/3.4/${db.script.dialect}/AVM-rename-dupes.sql', has not been run against this database.
08:41:47,631 ERROR [org.alfresco.repo.admin.patch.PatchExecuter]
=== Failed to apply patch ===
ID: patch.db-V3.4-AVM-rename-dupes
RESULT:
10230000 The schema upgrade script, 'classpath:alfresco/dbscripts/upgrade/3.4/${db.script.dialect}/AVM-rename-dupes.sql', has not been run against this database.Log file below
08:41:15,319 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
08:41:15,402 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
08:41:23,444 WARN [org.alfresco.util.AbstractTriggerBean] Job ehCacheTracerJob is not active/enabled
08:41:26,378 INFO [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Processor for extension ftl
08:41:26,380 INFO [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor for extension js
08:41:34,115 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
08:41:34,697 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
08:41:34,755 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] No reference schema file, expected: class path resource [org/alfresco/util/schemacomp/reference/MySQLInnoDBDialect-Reference.xml]
08:41:35,044 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'Search' subsystem, ID: [Search, managed, lucene]
08:41:35,384 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'Search' subsystem, ID: [Search, managed, lucene] complete
08:41:36,551 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'thirdparty' subsystem, ID: [thirdparty, default]
08:41:36,728 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [thirdparty, default] complete
08:41:36,729 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'OOoDirect' subsystem, ID: [OOoDirect, default]
08:41:37,048 WARN [org.alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
08:41:37,052 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'OOoDirect' subsystem, ID: [OOoDirect, default] complete
08:41:37,723 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery started: 84 transactions.
08:41:44,014 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 10 % complete.
08:41:44,014 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 20 % complete.
08:41:44,014 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 30 % complete.
08:41:44,014 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 40 % complete.
08:41:44,014 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 50 % complete.
08:41:44,014 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 60 % complete.
08:41:44,014 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 70 % complete.
08:41:44,014 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 80 % complete.
08:41:44,014 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 90 % complete.
08:41:46,465 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 100 % complete.
08:41:46,869 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Index recovery completed.
08:41:46,881 INFO [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Rebuilding indexes for 1 AVM Stores
08:41:46,881 INFO [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Rebuilding index for sitestore
08:41:46,930 INFO [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Reindex 100% complete
08:41:46,930 INFO [org.alfresco.repo.node.index.AVMFullIndexRecoveryComponent] Finished rebuilding indexes for AVM Stores
08:41:47,117 INFO [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /srv/www/alfresco/alf_data
08:41:47,122 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Checking for patches to apply …
08:41:47,614 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.db-V3.4-AVM-rename-dupes' (Ensures that the database upgrade script has been run.).
08:41:47,618 ERROR [org.alfresco.repo.admin.patch.PatchExecuter] 10230000 The schema upgrade script, 'classpath:alfresco/dbscripts/upgrade/3.4/${db.script.dialect}/AVM-rename-dupes.sql', has not been run against this database.
08:41:47,631 ERROR [org.alfresco.repo.admin.patch.PatchExecuter]
=== Failed to apply patch ===
ID: patch.db-V3.4-AVM-rename-dupes
RESULT:
10230000 The schema upgrade script, 'classpath:alfresco/dbscripts/upgrade/3.4/${db.script.dialect}/AVM-rename-dupes.sql', has not been run against this database.
=====================================
08:41:47,633 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 10230001 Not all patches could be applied
at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:111)
at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:124)
at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:120)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
at org.alfresco.repo.admin.patch.PatchExecuter.onBootstrap(PatchExecuter.java:128)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
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:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
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:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
08:41:57,990 INFO [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
08:41:58,271 INFO [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
08:41:58,271 INFO [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
08:41:58,276 INFO [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
08:42:00,287 INFO [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 312 Web Scripts (+0 failed), 322 URLs
08:42:00,289 INFO [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed)
08:42:00,289 INFO [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed)
08:42:00,378 INFO [org.springframework.extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 2087.2498ms)
08:42:00,385 INFO [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
08:42:00,389 INFO [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension jsUpdate 2011-11-23 I applied the patch, as outlined in JIRA https://issues.alfresco.com/jira/browse/ALF-11646. System starts, all indexing and patches went through. Thanks all for help and patience. You rock!
