nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Error: Can't create table 'alfresco_222.#sql-52f_97

nicolasraoul

Hello all!

I am trying to upgrade from Alfresco 2.2.1 to 2.2.2 but receive an SQLException. Here is what I did:
1) Backup database from Alfresco 2.2.1
2) Backup contentstore, contentstore.deleted, audit.contentstore from Alfresco 2.2.1
3) Install Alfresco 2.2.2 and start/stop it once
4) Replace tables and alf_data with backup
5) Start Alfresco, I get:

16:42:16,994 WARN  [org.springframework.remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
16:42:17,389 DEBUG [org.alfresco.repo.model.filefolder.FileFolderPerformanceTester] preRegister called. Server=com.sun.jmx.mbeanserver.JmxMBeanServer@19b7dfa, name=log4j:logger=org.alfresco.repo.model.filefolder.FileFolderPerformanceTester
16:42:17,390 DEBUG [org.alfresco.repo.avm.TransactionalLookupCache.init] preRegister called. Server=com.sun.jmx.mbeanserver.JmxMBeanServer@19b7dfa, name=log4j:logger=org.alfresco.repo.avm.TransactionalLookupCache.init
16:42:19,960 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
16:42:20,479 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/nico/programs/Alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-8039251262533655706.sql (Generated).
16:42:24,468 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:
   SQL: alter table JBPM_ACTION add index FK_ACTION_REFACT (REFERENCEDACTION_), add constraint FK_ACTION_REFACT foreign key (REFERENCEDACTION_) references JBPM_ACTION (ID_)
   Error: Can't create table 'alfresco_222.#sql-52f_97' (errno: 121)
   File: /home/nico/programs/Alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-8039251262533655706.sql
   Line: 29
16:42:24,469 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
java.sql.SQLException: Can't create table 'alfresco_222.#sql-52f_97' (errno: 121)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)‍‍‍‍‍‍‍‍‍‍‍‍‍

Any idea what I did wrong?
If that matters, all tables use InnoDB, and Alfresco is Enterprise version.
Thanks a lot!
Nicolas Raoul

Find more posts tagged with

Comments

mrogers

I suggest you contact A;fresco support.

muralie39

Hi,

Create a schema name with capital letters.. & use db.schema.update=true

If you still facing the problem..write a mail to me ..

nicolasraoul

I solved the problem by renaming the JBPM-related MySQL table to capital letter just after restoring the backup, before starting Alfresco:

alter table jbpm_action rename to JBPM_ACTION;
alter table jbpm_bytearray rename to JBPM_BYTEARRAY;
alter table jbpm_byteblock rename to JBPM_BYTEBLOCK;
alter table jbpm_comment rename to JBPM_COMMENT;
alter table jbpm_decisionconditions rename to JBPM_DECISIONCONDITIONS;
alter table jbpm_delegation rename to JBPM_DELEGATION;
alter table jbpm_event rename to JBPM_EVENT;
alter table jbpm_exceptionhandler rename to JBPM_EXCEPTIONHANDLER;
alter table jbpm_job rename to JBPM_JOB;
alter table jbpm_log rename to JBPM_LOG;
alter table jbpm_moduledefinition rename to JBPM_MODULEDEFINITION;
alter table jbpm_moduleinstance rename to JBPM_MODULEINSTANCE;
alter table jbpm_node rename to JBPM_NODE;
alter table jbpm_pooledactor rename to JBPM_POOLEDACTOR;
alter table jbpm_processdefinition rename to JBPM_PROCESSDEFINITION;
alter table jbpm_processinstance rename to JBPM_PROCESSINSTANCE;
alter table jbpm_runtimeaction rename to JBPM_RUNTIMEACTION;
alter table jbpm_swimlane rename to JBPM_SWIMLANE;
alter table jbpm_swimlaneinstance rename to JBPM_SWIMLANEINSTANCE;
alter table jbpm_task rename to JBPM_TASK;
alter table jbpm_taskactorpool rename to JBPM_TASKACTORPOOL;
alter table jbpm_taskcontroller rename to JBPM_TASKCONTROLLER;
alter table jbpm_taskinstance rename to JBPM_TASKINSTANCE;
alter table jbpm_token rename to JBPM_TOKEN;
alter table jbpm_tokenvariablemap rename to JBPM_TOKENVARIABLEMAP;
alter table jbpm_transition rename to JBPM_TRANSITION;
alter table jbpm_variableaccess rename to JBPM_VARIABLEACCESS;
alter table jbpm_variableinstance rename to JBPM_VARIABLEINSTANCE;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍