openupgrade-drivers team mailing list archive

Thread
Date
[Question #245482]: Error on Migrating a Db from 6.1 to 7.0

To: openupgrade-drivers@xxxxxxxxxxxxxxxxxxx
From: andrea_cg <question245482@xxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 14 Mar 2014 11:02:48 -0000
Reply-to: question245482@xxxxxxxxxxxxxxxxxxxxx
Sender: bounces@xxxxxxxxxxxxx
New question #245482 on OpenUpgrade Server:
https://answers.launchpad.net/openupgrade-server/+question/245482

Hello i try to migrate my db from version 6.1 to 7.0

Here the error in the log 

2014-03-14 10:50:10,222 9849 INFO ? openerp: OpenERP version 7.0
2014-03-14 10:50:10,223 9849 INFO ? openerp: addons paths: /home/openerp7/sviluppo/migrazioni/addons7
2014-03-14 10:50:10,224 9849 INFO ? openerp: database hostname: localhost
2014-03-14 10:50:10,225 9849 INFO ? openerp: database port: 5432
2014-03-14 10:50:10,225 9849 INFO ? openerp: database user: openerp
2014-03-14 10:50:10,317 9849 INFO omaf7 openerp.modules.loading: loading 1 modules...
2014-03-14 10:50:10,333 9849 INFO omaf7 openerp.modules.migration: module base: Running migration [>7.0.1.3] pre-migration
2014-03-14 10:50:10,557 9849 INFO omaf7 OpenUpgrade: base: pre-migration script called with version 6.1.1.3
2014-03-14 10:50:10,665 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module SET demo = false
2014-03-14 10:50:10,665 9849 DEBUG omaf7 OpenUpgrade: 340 rows affected
2014-03-14 10:50:10,705 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module SET name = l10n_be_coda WHERE name = account_coda
2014-03-14 10:50:10,705 9849 DEBUG omaf7 OpenUpgrade: 1 rows affected
2014-03-14 10:50:10,710 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_model_data SET module = l10n_be_coda WHERE module = account_coda 
2014-03-14 10:50:10,711 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,715 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module_dependency SET name = l10n_be_coda WHERE name = account_coda
2014-03-14 10:50:10,716 9849 DEBUG omaf7 OpenUpgrade: 2 rows affected
2014-03-14 10:50:10,719 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module SET name = auth_crypt WHERE name = base_crypt
2014-03-14 10:50:10,720 9849 DEBUG omaf7 OpenUpgrade: 1 rows affected
2014-03-14 10:50:10,722 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_model_data SET module = auth_crypt WHERE module = base_crypt 
2014-03-14 10:50:10,723 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,725 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module_dependency SET name = auth_crypt WHERE name = base_crypt
2014-03-14 10:50:10,726 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,729 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module SET name = mrp_byproduct WHERE name = mrp_subproduct
2014-03-14 10:50:10,730 9849 DEBUG omaf7 OpenUpgrade: 1 rows affected
2014-03-14 10:50:10,732 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_model_data SET module = mrp_byproduct WHERE module = mrp_subproduct 
2014-03-14 10:50:10,733 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,735 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module_dependency SET name = mrp_byproduct WHERE name = mrp_subproduct
2014-03-14 10:50:10,736 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,739 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module SET name = auth_ldap WHERE name = users_ldap
2014-03-14 10:50:10,739 9849 DEBUG omaf7 OpenUpgrade: 1 rows affected
2014-03-14 10:50:10,741 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_model_data SET module = auth_ldap WHERE module = users_ldap 
2014-03-14 10:50:10,742 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,744 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module_dependency SET name = auth_ldap WHERE name = users_ldap
2014-03-14 10:50:10,745 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,748 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module SET name = document_page WHERE name = wiki
2014-03-14 10:50:10,749 9849 DEBUG omaf7 OpenUpgrade: 1 rows affected
2014-03-14 10:50:10,751 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_model_data SET module = document_page WHERE module = wiki 
2014-03-14 10:50:10,752 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,755 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module_dependency SET name = document_page WHERE name = wiki
2014-03-14 10:50:10,756 9849 DEBUG omaf7 OpenUpgrade: 2 rows affected
2014-03-14 10:50:10,759 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module SET name = document_page_environment_manual WHERE name = wiki_environment_manual
2014-03-14 10:50:10,760 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,762 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_model_data SET module = document_page_environment_manual WHERE module = wiki_environment_manual 
2014-03-14 10:50:10,763 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,765 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module_dependency SET name = document_page_environment_manual WHERE name = wiki_environment_manual
2014-03-14 10:50:10,766 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,769 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module SET name = document_page_environmental_aspect WHERE name = wiki_environmental_aspect
2014-03-14 10:50:10,769 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,771 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_model_data SET module = document_page_environmental_aspect WHERE module = wiki_environmental_aspect 
2014-03-14 10:50:10,772 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,774 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module_dependency SET name = document_page_environmental_aspect WHERE name = wiki_environmental_aspect
2014-03-14 10:50:10,775 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,779 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module SET name = document_page_quality_manual WHERE name = wiki_quality_manual
2014-03-14 10:50:10,780 9849 DEBUG omaf7 OpenUpgrade: 1 rows affected
2014-03-14 10:50:10,783 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_model_data SET module = document_page_quality_manual WHERE module = wiki_quality_manual 
2014-03-14 10:50:10,783 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,786 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module_dependency SET name = document_page_quality_manual WHERE name = wiki_quality_manual
2014-03-14 10:50:10,786 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,789 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module SET name = document_page_health_safety_manual WHERE name = wiki_health_safety_manual
2014-03-14 10:50:10,790 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,792 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_model_data SET module = document_page_health_safety_manual WHERE module = wiki_health_safety_manual 
2014-03-14 10:50:10,793 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,796 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module_dependency SET name = document_page_health_safety_manual WHERE name = wiki_health_safety_manual
2014-03-14 10:50:10,797 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,800 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module SET name = document_page_procedure WHERE name = wiki_procedure
2014-03-14 10:50:10,801 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,803 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_model_data SET module = document_page_procedure WHERE module = wiki_procedure 
2014-03-14 10:50:10,804 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,806 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module_dependency SET name = document_page_procedure WHERE name = wiki_procedure
2014-03-14 10:50:10,808 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,810 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module SET name = document_page_work_instructions WHERE name = wiki_work_instructions
2014-03-14 10:50:10,811 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,814 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_model_data SET module = document_page_work_instructions WHERE module = wiki_work_instructions 
2014-03-14 10:50:10,815 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,817 9849 DEBUG omaf7 OpenUpgrade: Running UPDATE ir_module_module_dependency SET name = document_page_work_instructions WHERE name = wiki_work_instructions
2014-03-14 10:50:10,818 9849 DEBUG omaf7 OpenUpgrade: 0 rows affected
2014-03-14 10:50:10,819 9849 INFO omaf7 OpenUpgrade: table ir_actions_todo: drop column action_id
2014-03-14 10:50:10,830 9849 INFO omaf7 OpenUpgrade: table res_users, column date: renaming to login_date
2014-03-14 10:50:10,834 9849 INFO omaf7 OpenUpgrade: table res_users, column user_email: renaming to openupgrade_legacy_7_0_user_email
2014-03-14 10:50:10,849 9849 INFO omaf7 OpenUpgrade: table res_company, column logo: renaming to openupgrade_legacy_7_0_logo
2014-03-14 10:50:10,871 9849 INFO omaf7 OpenUpgrade: model ir.actions.url: renaming to ir.actions.act_url
2014-03-14 10:50:11,868 9849 INFO omaf7 openerp.modules.module: module base: creating or updating database tables
2014-03-14 10:50:13,077 9849 INFO omaf7 openerp.osv.orm: Computing parent left and right for table ir_ui_menu...
2014-03-14 10:50:15,515 9849 WARNING omaf7 openerp.osv.orm: WARNING: unable to set column action_id of table ir_actions_todo not null !
Try to re-run: openerp-server --update=module
If it doesn't work, update records and execute manually:
ALTER TABLE ir_actions_todo ALTER COLUMN action_id SET NOT NULL
2014-03-14 10:51:08,818 9849 WARNING omaf7 openerp.osv.orm.schema: Table 'res_partner_bank': unable to set a NOT NULL constraint on column 'acc_number' !
If you want to have it, you should update the records and execute manually:
ALTER TABLE res_partner_bank ALTER COLUMN acc_number SET NOT NULL
2014-03-14 10:51:10,937 9849 INFO omaf7 openerp.osv.orm: storing computed values of fields.function 'needaction_enabled'
2014-03-14 10:51:16,978 9849 ERROR omaf7 openerp: Failed to initialize database `omaf7`.
Traceback (most recent call last):
  File "/home/openerp7/sviluppo/migrazioni/7.0/openerp/cli/server.py", line 98, in preload_registry
    db, registry = openerp.pooler.get_db_and_pool(dbname,update_module=update_module)
  File "/home/openerp7/sviluppo/migrazioni/7.0/openerp/pooler.py", line 33, in get_db_and_pool
    registry = RegistryManager.get(db_name, force_demo, status, update_module)
  File "/home/openerp7/sviluppo/migrazioni/7.0/openerp/modules/registry.py", line 192, in get
    update_module)
  File "/home/openerp7/sviluppo/migrazioni/7.0/openerp/modules/registry.py", line 218, in new
    openerp.modules.load_modules(registry.db, force_demo, status, update_module)
  File "/home/openerp7/sviluppo/migrazioni/7.0/openerp/modules/loading.py", line 331, in load_modules
    loaded_modules, processed_modules = load_module_graph(cr, graph, status, perform_checks=update_module, report=report, registry=registry)
  File "/home/openerp7/sviluppo/migrazioni/7.0/openerp/modules/loading.py", line 186, in load_module_graph
    init_module_models(cr, package.name, models)
  File "/home/openerp7/sviluppo/migrazioni/7.0/openerp/modules/module.py", line 385, in init_module_models
    t[1](cr, *t[2])
  File "/home/openerp7/sviluppo/migrazioni/7.0/openerp/osv/orm.py", line 2805, in _update_store
    res = f.get(cr, self, iids, k, SUPERUSER_ID, {})
  File "/home/openerp7/sviluppo/migrazioni/7.0/openerp/osv/fields.py", line 1131, in get
    result = self._fnct(obj, cr, uid, ids, name, self._arg, context)
  File "/home/openerp7/sviluppo/migrazioni/7.0/openerp/addons/base/ir/ir_ui_menu.py", line 289, in _get_needaction_enabled
    if menu.action and menu.action.type in ('ir.actions.act_window', 'ir.actions.client') and menu.action.res_model:
  File "/home/openerp7/sviluppo/migrazioni/7.0/openerp/osv/orm.py", line 490, in __getattr__
    return self[name]
  File "/home/openerp7/sviluppo/migrazioni/7.0/openerp/osv/orm.py", line 472, in __getitem__
    new_data[field_name] = browse_record(self._cr, self._uid, ref_id, obj, self._cache, context=self._context, list_class=self._list_class, fields_process=self._fields_process)
  File "/home/openerp7/sviluppo/migrazioni/7.0/openerp/osv/orm.py", line 341, in __init__
    self._list_class = list_class
AttributeError: 'NoneType' object has no attribute '_name'

I use the last version of migration server and addons 

./openerp-server --update=base --stop-after-init --database=omaf7 --db_user=openerp --db_password=openerp --addons-path="/migration/addons7/"

in /migration/addons7/ there are the openUpgrade Addons

Can you help me??





-- 
You received this question notification because you are a member of
OpenUpgrade Drivers, which is an answer contact for OpenUpgrade Server.