openupgrade-drivers team mailing list archive

[Luis Vilar <question238096@xxxxxxxxxxxxxxxxxxxxx>]

New question #238096 on OpenUpgrade Addons:
https://answers.launchpad.net/openupgrade-addons/+question/238096

Hello All

I am trying to upgrade a V6 database to V7 and am getting the following integrity error.
IntegrityError: insert or update on table "sale_order" violates foreign key constraint "sale_order_partner_invoice_id_fkey"
DETAIL:  Key (partner_invoice_id)=(103) is not present in table "res_partner".

Has anyone experience this error, and what is the fix for this.

Thanks

Here is the relevant logs:
2013-10-26 11:10:42,799 4298 INFO upgrade_test openerp.modules.loading: module procurement: loading process/procurement_process.xml
2013-10-26 11:10:42,853 4298 INFO upgrade_test openerp.modules.loading: module procurement: loading company_view.xml
2013-10-26 11:10:42,931 4298 ERROR upgrade_test openerp.osv.orm: Can't find field 'property_reserve_and_surplus_account' in the following view parts composing the view of object model 'res.company':
 * res.company.form.inherit

Either you wrongly customized this view, or some modules bringing those views are not compatible with your current data model
2013-10-26 11:10:42,943 4298 INFO upgrade_test openerp.modules.loading: module procurement: loading board_mrp_procurement_view.xml
2013-10-26 11:10:43,064 4298 INFO upgrade_test openerp.modules.module: module sale: creating or updating database tables
2013-10-26 11:10:44,220 4298 WARNING upgrade_test openerp.osv.orm.schema: Table 'sale_order_line': Adding (b-tree) index for text column 'name'.This is probably useless (does not work for fulltext search) and prevents INSERTs of long texts because there is a length limit for indexable btree values!
Use a search view instead if you simply want to make the field searchable.
2013-10-26 11:10:45,094 4298 ERROR upgrade_test openerp.sql_db: bad query: ALTER TABLE "sale_order" ADD FOREIGN KEY ("partner_invoice_id") REFERENCES "res_partner" ON DELETE set null
Traceback (most recent call last):
  File "/opt/openerp/UPGRADE/openupgrade-server/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
IntegrityError: insert or update on table "sale_order" violates foreign key constraint "sale_order_partner_invoice_id_fkey"
DETAIL:  Key (partner_invoice_id)=(103) is not present in table "res_partner".

2013-10-26 11:10:45,147 4298 ERROR upgrade_test openerp: Failed to initialize database `upgrade_test`.
Traceback (most recent call last):
  File "/opt/openerp/UPGRADE/openupgrade-server/openerp/cli/server.py", line 98, in preload_registry
    db, registry = openerp.pooler.get_db_and_pool(dbname,update_module=update_module)
  File "/opt/openerp/UPGRADE/openupgrade-server/openerp/pooler.py", line 33, in get_db_and_pool
    registry = RegistryManager.get(db_name, force_demo, status, update_module)
  File "/opt/openerp/UPGRADE/openupgrade-server/openerp/modules/registry.py", line 192, in get
    update_module)
  File "/opt/openerp/UPGRADE/openupgrade-server/openerp/modules/registry.py", line 218, in new
    openerp.modules.load_modules(registry.db, force_demo, status, update_module)
  File "/opt/openerp/UPGRADE/openupgrade-server/openerp/modules/loading.py", line 379, in load_modules
    processed_upgrade = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules, update_module, registry)
  File "/opt/openerp/UPGRADE/openupgrade-server/openerp/modules/loading.py", line 286, in load_marked_modules
    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks, registry=registry)
  File "/opt/openerp/UPGRADE/openupgrade-server/openerp/modules/loading.py", line 186, in load_module_graph
    init_module_models(cr, package.name, models)
  File "/opt/openerp/UPGRADE/openupgrade-server/openerp/modules/module.py", line 381, in init_module_models
    obj._auto_end(cr, {'module': module_name})
  File "/opt/openerp/UPGRADE/openupgrade-server/openerp/osv/orm.py", line 3243, in _auto_end
    cr.execute('ALTER TABLE "%s" ADD FOREIGN KEY ("%s") REFERENCES "%s" ON DELETE %s' % (t, k, r, d))
  File "/opt/openerp/UPGRADE/openupgrade-server/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/openerp/UPGRADE/openupgrade-server/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
IntegrityError: insert or update on table "sale_order" violates foreign key constraint "sale_order_partner_invoice_id_fkey"
DETAIL:  Key (partner_invoice_id)=(103) is not present in table "res_partner".

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