AnsweredAssumed Answered

upgrade to 5.1.f problem

Question asked by fiore.pisano on Jan 11, 2018

hello to everyone

I must upgrade alfresco 3.2.0 (based on mysql) to last versione 5.2.X . I following this link:

https://stackoverflow.com/questions/44709167/how-to-migrate-alfresco-community-database-from-3-2-to-5

to have a line guide.

 

when I try to upgrade from 4.2.f to 5.1.f the db upgrade schema process failed with error:

 

alter table ACT_HI_ATTACHMENT add TIME_ datetime;

Table 'alfresco.act_hi_attachment' doesn't exist

 

Any Idea?

Where is the script to create this table ?

very thanks in advance

 

 

 

2017-12-21 17:38:22,282 INFO  [org.alfresco.repo.admin] [localhost-startStop-1] Using database URL 'jdbc:mysql://localhost:3306/alfresco' with user 'alfresco'.
2017-12-21 17:38:22,298 INFO  [org.alfresco.repo.admin] [localhost-startStop-1] Connected to database MySQL version 5.6.38-log
2017-12-21 17:38:28,039 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V4.2-metadata-query-indexes
2017-12-21 17:38:28,039 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V5.1-metadata-query-indexes
2017-12-21 17:38:37,602 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor Repository Template Processor for extension ftl
2017-12-21 17:38:37,602 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor Repository Script Processor for extension js
2017-12-21 17:38:40,332 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]
2017-12-21 17:38:40,410 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted] complete
2017-12-21 17:38:40,488 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc:mysql://localhost:3306/alfresco, UserName=alfresco@localhost, MySQL-AB JDBC Driver
2017-12-21 17:38:40,503 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
2017-12-21 17:38:41,564 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 19 potential problems, results written to: C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-alf_-1233024072471753364.txt
2017-12-21 17:38:41,829 WARN  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 51 potential problems, results written to: C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-act_-1827554959896914260.txt
2017-12-21 17:38:42,874 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-alf_-7873247931144982682.xml.
2017-12-21 17:38:42,874 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-jbpm_-7181703581060364004.xml.
2017-12-21 17:38:42,890 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-act_-1442716061184614657.xml.
2017-12-21 17:38:42,937 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-3503301235268920697.sql (Copied from classpath:alfresco/dbscripts/upgrade/4.1/org.hibernate.dialect.MySQLInnoDBDialect/update-activiti-nullable-columns.sql).
2017-12-21 17:38:43,249 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-6997178558407226339.sql (Copied from classpath:alfresco/dbscripts/upgrade/4.1/org.hibernate.dialect.MySQLInnoDBDialect/createIdxAlfNodeTQN.sql).
2017-12-21 17:41:30,622 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-4382717435189469127.sql (Copied from classpath:alfresco/dbscripts/upgrade/4.2/org.hibernate.dialect.MySQLInnoDBDialect/restructure-idx_alf_nprop_s-MSSQL.sql).
2017-12-21 17:41:30,669 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-590789201368254678.sql (Copied from classpath:alfresco/dbscripts/upgrade/4.2/org.hibernate.dialect.MySQLInnoDBDialect/migrate-locale-multilingual.sql).
2017-12-21 17:41:30,903 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-9043950704262792363.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoCreate-AuthorizationTables.sql).
2017-12-21 17:41:30,950 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-6500834890138405544.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoCreate-ContentUrlEncryptionTables.sql).
2017-12-21 17:41:31,044 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-6359717841036878817.sql (Copied from classpath:alfresco/dbscripts/upgrade/4.2/org.hibernate.dialect.MySQLInnoDBDialect/migrate-activiti-workflows.sql).
2017-12-21 17:41:31,106 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-5426524715785919745.sql (Copied from classpath:alfresco/dbscripts/upgrade/4.2/org.hibernate.dialect.MySQLInnoDBDialect/remove-old-index-act.sql).
2017-12-21 17:41:31,122 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-3735038663934765548.sql (Copied from classpath:alfresco/dbscripts/upgrade/5.0/org.hibernate.dialect.MySQLInnoDBDialect/activiti-upgrade-5-16-2.sql).
2017-12-21 17:41:32,884 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-5299224157131106297.sql (Copied from classpath:alfresco/dbscripts/upgrade/5.0/org.hibernate.dialect.MySQLInnoDBDialect/activiti-upgrade-5-16-4.sql).
2017-12-21 17:41:32,931 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-6500854492715870688.sql (Copied from classpath:alfresco/dbscripts/upgrade/5.0/org.hibernate.dialect.MySQLInnoDBDialect/activiti-del-unused-after-5-16-2.sql).
2017-12-21 17:41:32,947 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-8836139176244113517.sql (Copied from classpath:alfresco/dbscripts/upgrade/5.0/org.hibernate.dialect.MySQLInnoDBDialect/update-activiti-default-timestamp-column.sql).
2017-12-21 17:41:33,072 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-7027377357750987997.sql (Copied from classpath:alfresco/dbscripts/upgrade/5.0/org.hibernate.dialect.MySQLInnoDBDialect/activiti-correct-tenant-id-MSSQL.sql).
2017-12-21 17:41:33,087 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-5433002180415647363.sql (Copied from classpath:alfresco/dbscripts/upgrade/5.1/org.hibernate.dialect.MySQLInnoDBDialect/activiti-upgrade-5-19-0.sql).
2017-12-21 17:41:33,352 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Statement execution failed:
   SQL: alter table ACT_HI_ATTACHMENT add TIME_ datetime
   Error: Table 'alfresco.act_hi_attachment' doesn't exist
   File: C:\migrateAlfresco\alfrescoVersion\alfresco5.1.f\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Update-5433002180415647363.sql
   Line: 20
2017-12-21 17:41:33,352 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'alfresco.act_hi_attachment' doesn't exist

Outcomes