Upgradation from 3.4d to 4.0d

[vamsi_8k]

Hi,

I am trying to upgrade from 3.4d to 4.0d. But i was not successful. As per the log there is some problem with MYSQL DB. Please find the log below.

2012-02-10 11:28:34,783  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: 01100000 A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again.
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1492)
   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)
2012-02-10 11:28:34,783  ERROR [web.context.ContextLoader] [Thread-1] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 01100001 Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1612)
   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)
Caused by: org.alfresco.error.AlfrescoRuntimeException: 01100000 A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again.
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1492)
   … 34 more
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.

Kindly let me know how to proceed further in this issue.

Regards

[rmacian]

Check if in the dabase exists a table named alf_bootstrap_lock an drop it. Which procedure have you followed to perform the upgrade ?

[vamsi_8k]

I copied alf_data directory to newly installed directory and imported MYSQL database. Earlier i used the same procedure to restore the backup as well as upgradation from 3.3 to 3.4

I'll try to execute your suggestion in DB tables.

Thanks…

[buster]

vamsi_8k,

Any luck so far? I'm in the same boat and followed the same procedure as you did. I have a stock, non-customized install of alfresco that is upgraded to version 3.4.d (upgraded months ago). I have about 40 sites setup with about 3 million docs.

My steps:
1. I installed a test copy of 3.4.d on a test server (I need MySQL).
2. Configured alfresco-global.properties for passthru, ldap sync with no errors in alfresco.log
3. Deleted alfresco and share folders/war files and replaced with 4.0.d war files.
4. Started alfresco service, only 1 WARN in log otherwise no errors… ldap sync works and can log into share:
          13:36:14,571 WARN  [org.alfresco.util.AbstractTriggerBean] Job ehCacheTracerJob is not active/enabled
5. Stopped alfresco service.
6. Dropped alfresco MySQL database.
7. Emptied alf_data folder
7. Created alfresco MySQL database.
8. Copied repository, lucene indexes,etc from backup to alf_data.
9. Restored backup database to alfresco.
10. Set index to lucene in alfresco-global.properties and restart alfresco tomcat.

Here is my alfresco.log with errors:

14:43:23,983 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
14:43:24,170 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
14:43:35,886 WARN  [org.alfresco.util.AbstractTriggerBean] Job ehCacheTracerJob is not active/enabled
14:43:39,693 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Processor for extension ftl
14:43:39,693 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor for extension js
14:43:48,663 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
14:44:05,480 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-5205451602502476208.txt
14:44:40,955 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-596413452891900051.txt
14:45:16,836 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-4619238384059415731.txt
14:45:57,787 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-2123970136843052996.txt
14:46:33,200 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-2116670108448051365.txt
14:47:08,504 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-3546300789461056204.txt
14:47:43,745 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-5992243836761601540.txt
14:48:27,224 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-2659726971274187587.txt
14:49:04,243 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-722248928761615728.txt
14:49:43,884 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-3122262414012245483.txt
14:50:28,891 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-7258276901084731655.txt
14:51:03,727 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-8201041826738430044.txt
14:51:40,653 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-258499544538910518.txt
14:52:17,392 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-9055203602970244816.txt
14:52:52,446 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-7526962703908661463.txt
14:53:33,615 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-4625704460620837839.txt
14:54:08,716 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-8339518804233670308.txt
14:54:42,990 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-2186315331779633136.txt
14:55:18,076 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-3971050120009304629.txt
14:55:52,568 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-2211256496919722306.txt
14:56:27,357 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-2803699016291947681.txt
14:57:02,193 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-5813665379661268232.txt
14:57:37,419 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-6817437249105380892.txt
14:58:11,958 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema validation found 20 potential problems, results written to: C:\Windows\TEMP\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-7576255291943607815.txt
14:58:31,599 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: 01200000 A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again.
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1492)
   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:3972)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
   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:443)
   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)
14:58:31,599 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 01200001 Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1612)
   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:3972)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
   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:443)
   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)
Caused by: org.alfresco.error.AlfrescoRuntimeException: 01200000 A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again.
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1492)
   … 34 more
14:59:03,330 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
14:59:03,829 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
14:59:03,829 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
14:59:03,829 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
14:59:08,540 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 312 Web Scripts (+0 failed), 322 URLs
14:59:08,540 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed) 
14:59:08,540 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed) 
14:59:08,899 INFO  [org.springframework.extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 5057.3164ms)
14:59:08,915 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
14:59:08,915 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
15:07:39,516 INFO  [org.alfresco.web.site.EditionInterceptor] Unable to retrieve License information from Alfresco: 404‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Any ideas/help would be appreciated!!

-Buster

[buster]

These are the potential problems, I've been digging around looking for solutions but found none:

Difference: missing column from database, expected at path: .alf_acl_change_set.commit_time_ms
Difference: unexpected column found in database with path: .alf_acl_change_set.version
Difference: missing index from database, expected at path: .alf_acl_change_set.idx_alf_acs_ctms
Difference: missing column from database, expected at path: .alf_node.locale_id
Difference: expected column .alf_node.acl_id.order="9", but was .alf_node.acl_id.order="8"
Difference: expected column .alf_node.audit_creator.order="10", but was .alf_node.audit_creator.order="9"
Difference: expected column .alf_node.audit_created.order="11", but was .alf_node.audit_created.order="10"
Difference: expected column .alf_node.audit_modifier.order="12", but was .alf_node.audit_modifier.order="11"
Difference: expected column .alf_node.audit_modified.order="13", but was .alf_node.audit_modified.order="12"
Difference: expected column .alf_node.audit_accessed.order="14", but was .alf_node.audit_accessed.order="13"
Difference: missing foreign key from database, expected at path: .alf_node.fk_alf_node_loc
Difference: missing index from database, expected at path: .alf_node.idx_alf_node_txn_del
Difference: missing index from database, expected at path: .alf_node.fk_alf_node_loc
Difference: missing column from database, expected at path: .alf_node_assoc.assoc_index
Difference: expected index .alf_node_assoc.fk_alf_nass_snode.columnNames[1]="type_qname_id", but was .alf_node_assoc.fk_alf_nass_snode.columnNames="[source_node_id]"
Difference: expected index .alf_node_assoc.fk_alf_nass_snode.columnNames[2]="assoc_index", but was .alf_node_assoc.fk_alf_nass_snode.columnNames="[source_node_id]"
Difference: expected index .alf_node_assoc.fk_alf_nass_tnode.columnNames[1]="type_qname_id", but was .alf_node_assoc.fk_alf_nass_tnode.columnNames="[target_node_id]"
Difference: missing table from database, expected at path: .alf_subscriptions
Difference: unexpected table found in database with path: .alf_attributes
Difference: unexpected table found in database with path: .alf_audit_config
Difference: unexpected table found in database with path: .alf_audit_date
Difference: unexpected table found in database with path: .alf_audit_fact
Difference: unexpected table found in database with path: .alf_audit_source
Difference: unexpected table found in database with path: .alf_global_attributes
Difference: unexpected table found in database with path: .alf_list_attribute_entries
Difference: unexpected table found in database with path: .alf_map_attribute_entries‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Are there any patches available for 4.0.d? Also, has anyone successfully upgraded from 3.4.d directly to 4.0.d?

-Buster

[buster]

Well, I've managed to get the potential problems down to 11 from 20 by applying the custom bean found here: https://issues.alfresco.com/jira/browse/ALF-11646

Add this to a custom-context.xml file in tomcat/shared/classes/alfresco/extension:

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE beans PUBLIC '-//SPRING//DTD BEAN//EN' 'http://www.springframework.org/dtd/spring-beans.dtd'>
 
<beans>
   <bean id="patch.db-V3.4-AVM-rename-dupes" class="org.alfresco.repo.admin.patch.impl.SchemaUpgradeScriptPatch" parent="basePatch"> 
        <property name="id"><value>patch.db-V3.4-AVM-rename-dupes</value></property> 
        <property name="description"><value>patch.schemaUpgradeScript.description</value></property> 
        <property name="fixesFromSchema"><value>0</value></property> 
        <property name="fixesToSchema"><value>5005</value></property> 
        <property name="targetSchema"><value>5006</value></property> 
        <property name="scriptUrl"> 
            <value>classpath:alfresco/dbscripts/upgrade/3.4/${db.script.dialect}/AVM-rename-dupes.sql</value> 
        </property> 
    </bean> 
</beans>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

This brings me down to 11 potential problems:

Difference: missing index from database, expected at path: .alf_node.idx_alf_node_txn_del
Difference: missing table from database, expected at path: .alf_subscriptions
Difference: unexpected table found in database with path: .alf_attributes
Difference: unexpected table found in database with path: .alf_audit_config
Difference: unexpected table found in database with path: .alf_audit_date
Difference: unexpected table found in database with path: .alf_audit_fact
Difference: unexpected table found in database with path: .alf_audit_source
Difference: unexpected table found in database with path: .alf_bootstrap_lock
Difference: unexpected table found in database with path: .alf_global_attributes
Difference: unexpected table found in database with path: .alf_list_attribute_entries
Difference: unexpected table found in database with path: .alf_map_attribute_entries‍‍‍‍‍‍‍‍‍‍‍

I checked in alfresco:repository properties and all patches are listed as successful.
I'm banging my head against the wall on this one…

-Buster

[sharifu]

I have managed to upgrade from 3.4d to 4.0d after trying many different options. it is now working but i did get the following


/opt/alfresco-4.0.d/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Post-Upgrade-8967606418168946101.txt

Difference: unexpected table found in database with path: .alf_attributes
Difference: unexpected table found in database with path: .alf_global_attributes
Difference: unexpected table found in database with path: .alf_list_attribute_entries
Difference: unexpected table found in database with path: .alf_map_attribute_entries
‍‍‍‍‍‍

/opt/alfresco-4.0.d/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-357214774627928554.txt

Difference: missing column from database, expected at path: .alf_acl_change_set.commit_time_ms
Difference: unexpected column found in database with path: .alf_acl_change_set.version
Difference: missing index from database, expected at path: .alf_acl_change_set.idx_alf_acs_ctms
Difference: missing column from database, expected at path: .alf_node.locale_id
Difference: expected column .alf_node.acl_id.order="9", but was .alf_node.acl_id.order="8"
Difference: expected column .alf_node.audit_creator.order="10", but was .alf_node.audit_creator.order="9"
Difference: expected column .alf_node.audit_created.order="11", but was .alf_node.audit_created.order="10"
Difference: expected column .alf_node.audit_modifier.order="12", but was .alf_node.audit_modifier.order="11"
Difference: expected column .alf_node.audit_modified.order="13", but was .alf_node.audit_modified.order="12"
Difference: expected column .alf_node.audit_accessed.order="14", but was .alf_node.audit_accessed.order="13"
Difference: missing foreign key from database, expected at path: .alf_node.fk_alf_node_loc
Difference: missing index from database, expected at path: .alf_node.idx_alf_node_txn_del
Difference: missing index from database, expected at path: .alf_node.fk_alf_node_loc
Difference: missing column from database, expected at path: .alf_node_assoc.assoc_index
Difference: expected index .alf_node_assoc.fk_alf_nass_snode.columnNames[1]="type_qname_id", but was .alf_node_assoc.fk_alf_nass_snode.columnNames="[source_node_$
Difference: expected index .alf_node_assoc.fk_alf_nass_snode.columnNames[2]="assoc_index", but was .alf_node_assoc.fk_alf_nass_snode.columnNames="[source_node_id$
Difference: expected index .alf_node_assoc.fk_alf_nass_tnode.columnNames[1]="type_qname_id", but was .alf_node_assoc.fk_alf_nass_tnode.columnNames="[target_node_$
Difference: missing table from database, expected at path: .alf_subscriptions
Difference: unexpected table found in database with path: .alf_attributes
Difference: unexpected table found in database with path: .alf_global_attributes
Difference: unexpected table found in database with path: .alf_list_attribute_entries
Difference: unexpected table found in database with path: .alf_map_attribute_entries
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

2012-05-21 12:27:11,661  WARN  [admin.patch.PatchExecuter] [main] Patch description is not available: Patch[ id=patch.activitiesEmailTemplate, description=patch.activitiesEmailTemplate.description, fixesFromSchema=0, fixesToSchema=5005, targetSchema=5006]


2012-05-21 12:28:19,685  WARN  [repo.module.ModuleServiceImpl] [main] A previously-installed module 'org.alfresco.extension.alfresco-bulk-filesystem-import' (version 0.11.34) is not present in your distribution.
 2012-05-21 12:28:19,686  INFO  [management.subsystems.ChildApplicationContextFactory] [main] Starting 'fileServers' subsystem, ID: [fileServers, default]
 2012-05-21 12:28:25,536  WARN  [org.alfresco.fileserver] [main] CIFS, Unable to get local domain/workgroup name, using default of WORKGROUP. This may be due to firewall settings or incorrect <broadcast> setting)

‍‍‍‍‍‍‍‍‍

Not sure if this is something important or not.