Upgrade Failure 40d 'alfresco.jbpm_action' doesn't exist

[bicloud]

Hello,

Like others, I have spent many hours trying to upgrade with manual steps my Alfresco CE v3.4.0d to 4.0d with database mysql and lucene indexing and am still having an Alfresco failure. I have attached my logs and hope that I can have some advice how to move forward.

Here have been my steps to upgrade:

1) Advanced 4.0d install with
   1 - jdbc url: jdbc:mysql://localhost:3306/alfresco
   2 - jdbc driver: org.gjt.mm.mysql.Driver
   3 - No launch of Alfresco

2) Edit alfresco-global.properties
   1 - index.subsystem.name=lucene
   2 - index.recovery.mode=FULL

3) Increase memory in tomcat/bin/setenv.sh
   1 - JAVA_OPTS="-XX:MaxPermSize=256m -XX:NewSize=256m -Xms512m"
   2 - JAVA_OPTS="$JAVA_OPTS -Xmx1024m -Xss512K"

4) Copy over mysql library mysql-connector-java-5.x.x-bin.jar to tomcat/lib

5) Copy over alf_data/* directories from 3.4 to new alf_data directory

6) Copy over alfresco database from 3.4 to 4.0 system
   1 - mysql -u alfresco  < alfresco32.sql

7) Start alfresco

One of the errors is Schema auto-update failed with Table 'alfresco.jbpm_action' doesn't exist .

Here is my alfresco.log in full:

11:25:43,157 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]11:25:43,227 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete11:25:50,953 WARN  [org.alfresco.util.AbstractTriggerBean] Job ehCacheTracerJob is not active/enabled11:25:54,700 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Processor for extension ftl11:25:54,703 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor for extension js11:26:00,908 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.11:26:00,990 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failedorg.hibernate.exception.SQLGrammarException: could not get table metadata: JBPM_ACTION        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)        at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:105)        at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:954)        at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:814)        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1479)        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: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'alfresco.jbpm_action' doesn't exist        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.Util.getInstance(Util.java:381)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1383)        at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2471)        at com.mysql.jdbc.IterateBlock.doForAll(IterateBlock.java:50)        at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:2345)        at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getColumns(DelegatingDatabaseMetaData.java:218)        at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getColumns(DelegatingDatabaseMetaData.java:218)        at org.hibernate.tool.hbm2ddl.TableMetadata.initColumns(TableMetadata.java:146)        at org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:32)        at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:90)        … 37 more11:26:00,995 ERROR [org.springframework.web.context.ContextLoader] Context initialization failedorg.alfresco.error.AlfrescoRuntimeException: 07200000 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.hibernate.exception.SQLGrammarException: could not get table metadata: JBPM_ACTION        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)        at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:105)        at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:954)        at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:814)        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1479)        … 34 moreCaused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'alfresco.jbpm_action' doesn't exist        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.Util.getInstance(Util.java:381)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1383)        at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:2471)        at com.mysql.jdbc.IterateBlock.doForAll(IterateBlock.java:50)        at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:2345)        at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getColumns(DelegatingDatabaseMetaData.java:218)        at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getColumns(DelegatingDatabaseMetaData.java:218)        at org.hibernate.tool.hbm2ddl.TableMetadata.initColumns(TableMetadata.java:146)        at org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:32)        at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:90)        … 37 more11:26:13,812 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl11:26:13,906 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js11:26:13,906 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl11:26:13,911 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js11:26:15,612 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 314 Web Scripts (+0 failed), 324 URLs11:26:15,613 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed)11:26:15,613 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed)11:26:15,900 INFO  [org.springframework.extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 1983.6458ms)11:26:15,906 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl11:26:15,911 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Please advise as to my next steps.

Kind regards,

Nancy AKA BiCloud

[spider22]

Hello,

What is the version of mysql database?

You are installing version 4.0 Alfresco, does your current mysql version supports that?