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

nicolasraoul — Fri, 28 Jan 2011 08:12:28 GMT

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.12) Backup contentstore, contentstore.deleted, audit.contentstore from Alfresco 2.2.13) Install Alfresco 2.2.2 and start/stop it once4) Replace tables an

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

mrogers — Fri, 28 Jan 2011 08:57:16 GMT

I suggest you contact A;fresco support.

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

muralie39 — Fri, 28 Jan 2011 14:51:28 GMT

Hi,

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

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

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

nicolasraoul — Wed, 09 Feb 2011 06:27:40 GMT

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;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

topic Error: Can't create table 'alfresco_222.#sql-52f_97 in Alfresco Archive

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

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

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

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