Alfresco Migration

csvalavan — Thu, 22 Jan 2009 12:27:49 GMT

Hi:I am in the process of migrating MYSql of Alfresco 2.1 to MSSQL 2005. I have done the following steps and I get Null pointer Exception after I start alfresco.1. Migrated MYSQL data to SQL Server by creating linked server and executing query (insert select) for each table. This has worked without

Re: Alfresco Migration

csvalavan — Fri, 23 Jan 2009 04:07:12 GMT

Hi:

I have identified the root cause for this issue. That is the issue with bit column type. In MSSQL, the column type is tinyint and I am migrating data using the linkedserver method like this:
/*Data for the table alf_node_properties */

insert into alfresco.dbo.alf_node_properties(node_id,actual_type,multi_valued,persisted_type,boolean_value,long_value,float_value,double_value,string_value,attribute_value,serializable_value,qname) SELECT * FROM openquery(MYSQL, 'SELECT * FROM alfresco.alf_node_properties');

This query is screwing up data. It converts "True" for false bit data also. So, the code is looking for serializable properties and it is null.

I also have found that following tables => Columns are bit types. I need to manually analyze and set data properly. Is there any automated way available to convert this data effectively in the database migration?

alf_access_control_entry allowed
`alf_access_control_list` `inherits`
`alf_applied_patch` `was_executed`, `succeeded`
`alf_attributes` `bool_value`
`alf_audit_fact` `filtered`, `fail`
`alf_child_assoc` `is_primary`
`alf_node_properties` `multi_valued`, `boolean_value`,
`avm_node_properties` `multi_valued`, `boolean_value`
`avm_node_properties_new` `multi_valued`, `boolean_value`
`avm_nodes` `is_root`, `primary_indirection`, `opacity`
`avm_store_properties``multi_valued`, `boolean_value`,
`jbpm_action` `ISPROPAGATIONALLOWED_`, `ISASYNC_`,
`jbpm_job` `ISSUSPENDED_`, `ISEXCLUSIVE_`,

`jbpm_node` `ISASYNC_`, `ISASYNCEXCL_`, `CREATETASKS_`, `ENDTASKS_`,
`jbpm_processdefinition` `ISTERMINATIONIMPLICIT_`,

`jbpm_processinstance` `ISSUSPENDED_`,
`jbpm_task` `ISBLOCKING_`, `ISSIGNALLING_`,
`jbpm_taskinstance` `ISCANCELLED_`, `ISSUSPENDED_`, `ISOPEN_`, `ISSIGNALLING_`, `ISBLOCKING_`,

`jbpm_token` `ISABLETOREACTIVATEPARENT_`, `ISTERMINATIONIMPLICIT_`, `ISSUSPENDED_`,

Thanks,
Senthil.

topic Alfresco Migration in Alfresco Archive

Alfresco Migration

Re: Alfresco Migration