API tools faq
paste
Advertisement
mugs

openupgrade migrate 7.0 -> 8.0 stock module errors

mugs
Dec 5th, 2014
501
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 10.16 KB | None | 0 0
raw download clone embed print report
  1. 2014-12-01 13:02:08,925 32121 INFO springFresh_migrated openerp.modules.module: module stock: creating or updating database tables
  2. 2014-12-01 13:02:09,314 32121 ERROR springFresh_migrated openerp.sql_db: bad query: ALTER TABLE "stock_picking" ALTER COLUMN "picking_type_id" SET NOT NULL
  3. Traceback (most recent call last):
  4.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 234, in execute
  5.     res = self._obj.execute(query, params)
  6. IntegrityError: column "picking_type_id" contains null values
  7.  
  8. 2014-12-01 13:02:09,315 32121 WARNING springFresh_migrated openerp.models: WARNING: unable to set column picking_type_id of table stock_picking not null !
  9. Try to re-run: openerp-server --update=module
  10. If it doesn''t work, update records and execute manually:
  11. ALTER TABLE stock_picking ALTER COLUMN picking_type_id SET NOT NULL
  12. Traceback (most recent call last):
  13.   File "/var/tmp/openupgrade/8.0/server/openerp/models.py", line 2702, in _auto_init
  14.     cr.execute('ALTER TABLE "%s" ALTER COLUMN "%s" SET NOT NULL' % (self._table, k))
  15.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 158, in wrapper
  16.     return f(self, *args, **kwargs)
  17.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 234, in execute
  18.     res = self._obj.execute(query, params)
  19. IntegrityError: column "picking_type_id" contains null values
  20.  
  21. 2014-12-01 13:02:09,322 32121 INFO springFresh_migrated openerp.models: column location_id (Location) converted to a function, removed from table stock_picking
  22. 2014-12-01 13:02:09,518 32121 INFO springFresh_migrated openerp.models: column location_dest_id (Destination Location) converted to a function, removed from table stock_picking
  23. 2014-12-01 13:02:14,513 32121 ERROR springFresh_migrated openerp.sql_db: Programming error: column stock_warehouse.code does not exist
  24. LINE 1:  SELECT stock_warehouse."code",stock_warehouse."create_date"...
  25.                 ^
  26. , in query  SELECT stock_warehouse."code",stock_warehouse."create_date",stock_warehouse."lot_stock_id",stock_warehouse."wh_pack_stock_loc_id",stock_warehouse."write_uid",stock_warehouse."pick_type_id",stock_warehouse."crossdock_route_id",stock_warehouse."partner_id",stock_warehouse."id",stock_warehouse."create_uid",stock_warehouse."mto_pull_id",stock_warehouse."company_id",stock_warehouse."wh_input_stock_loc_id",stock_warehouse."wh_qc_stock_loc_id",stock_warehouse."default_resupply_wh_id",stock_warehouse."view_location_id",stock_warehouse."reception_steps",stock_warehouse."resupply_from_wh",stock_warehouse."pack_type_id",stock_warehouse."wh_output_stock_loc_id",stock_warehouse."reception_route_id",stock_warehouse."write_date",stock_warehouse."delivery_route_id",stock_warehouse."name",stock_warehouse."in_type_id",stock_warehouse."out_type_id",stock_warehouse."delivery_steps",stock_warehouse."int_type_id" FROM "stock_warehouse"
  27.                     WHERE stock_warehouse.id IN %s AND (TRUE)
  28.                     ORDER BY id
  29.                
  30. 2014-12-01 13:02:14,513 32121 ERROR springFresh_migrated openerp.sql_db: bad query: SAVEPOINT add_constraint
  31. Traceback (most recent call last):
  32.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 234, in execute
  33.     res = self._obj.execute(query, params)
  34. InternalError: current transaction is aborted, commands ignored until end of transaction block
  35.  
  36. 2014-12-01 13:02:14,514 32121 WARNING springFresh_migrated openerp.models: WARNING: unable to set column location_id of table stock_inventory not null !
  37. Try to re-run: openerp-server --update=module
  38. If it doesn''t work, update records and execute manually:
  39. ALTER TABLE stock_inventory ALTER COLUMN location_id SET NOT NULL
  40. Traceback (most recent call last):
  41.   File "/var/tmp/openupgrade/8.0/server/openerp/models.py", line 2701, in _auto_init
  42.     cr.execute('SAVEPOINT add_constraint');
  43.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 158, in wrapper
  44.     return f(self, *args, **kwargs)
  45.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 234, in execute
  46.     res = self._obj.execute(query, params)
  47. InternalError: current transaction is aborted, commands ignored until end of transaction block
  48.  
  49. 2014-12-01 13:02:14,557 32121 ERROR springFresh_migrated openerp.sql_db: bad query: ALTER TABLE "stock_inventory_line" ALTER COLUMN "product_uom_id" SET NOT NULL
  50. Traceback (most recent call last):
  51.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 234, in execute
  52.     res = self._obj.execute(query, params)
  53. IntegrityError: column "product_uom_id" contains null values
  54.  
  55. 2014-12-01 13:02:14,557 32121 WARNING springFresh_migrated openerp.models: WARNING: unable to set column product_uom_id of table stock_inventory_line not null !
  56. Try to re-run: openerp-server --update=module
  57. If it doesn''t work, update records and execute manually:
  58. ALTER TABLE stock_inventory_line ALTER COLUMN product_uom_id SET NOT NULL
  59. Traceback (most recent call last):
  60.   File "/var/tmp/openupgrade/8.0/server/openerp/models.py", line 2702, in _auto_init
  61.     cr.execute('ALTER TABLE "%s" ALTER COLUMN "%s" SET NOT NULL' % (self._table, k))
  62.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 158, in wrapper
  63.     return f(self, *args, **kwargs)
  64.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 234, in execute
  65.     res = self._obj.execute(query, params)
  66. IntegrityError: column "product_uom_id" contains null values
  67.  
  68. 2014-12-01 13:02:14,594 32121 ERROR springFresh_migrated openerp.sql_db: bad query: ALTER TABLE "stock_warehouse" ALTER COLUMN "code" SET NOT NULL
  69. Traceback (most recent call last):
  70.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 234, in execute
  71.     res = self._obj.execute(query, params)
  72. IntegrityError: column "code" contains null values
  73.  
  74. 2014-12-01 13:02:14,594 32121 WARNING springFresh_migrated openerp.models: WARNING: unable to set column code of table stock_warehouse not null !
  75. Try to re-run: openerp-server --update=module
  76. If it doesn''t work, update records and execute manually:
  77. ALTER TABLE stock_warehouse ALTER COLUMN code SET NOT NULL
  78. Traceback (most recent call last):
  79.   File "/var/tmp/openupgrade/8.0/server/openerp/models.py", line 2702, in _auto_init
  80.     cr.execute('ALTER TABLE "%s" ALTER COLUMN "%s" SET NOT NULL' % (self._table, k))
  81.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 158, in wrapper
  82.     return f(self, *args, **kwargs)
  83.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 234, in execute
  84.     res = self._obj.execute(query, params)
  85. IntegrityError: column "code" contains null values
  86.  
  87. 2014-12-01 13:02:14,671 32121 ERROR springFresh_migrated openerp.sql_db: bad query: ALTER TABLE "stock_warehouse" ALTER COLUMN "view_location_id" SET NOT NULL
  88. Traceback (most recent call last):
  89.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 234, in execute
  90.     res = self._obj.execute(query, params)
  91. IntegrityError: column "view_location_id" contains null values
  92.  
  93. 2014-12-01 13:02:14,671 32121 WARNING springFresh_migrated openerp.models: WARNING: unable to set column view_location_id of table stock_warehouse not null !
  94. Try to re-run: openerp-server --update=module
  95. If it doesn''t work, update records and execute manually:
  96. ALTER TABLE stock_warehouse ALTER COLUMN view_location_id SET NOT NULL
  97. Traceback (most recent call last):
  98.   File "/var/tmp/openupgrade/8.0/server/openerp/models.py", line 2702, in _auto_init
  99.     cr.execute('ALTER TABLE "%s" ALTER COLUMN "%s" SET NOT NULL' % (self._table, k))
  100.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 158, in wrapper
  101.     return f(self, *args, **kwargs)
  102.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 234, in execute
  103.     res = self._obj.execute(query, params)
  104. IntegrityError: column "view_location_id" contains null values
  105.  
  106. 2014-12-01 13:02:14,818 32121 INFO springFresh_migrated openerp.models: Computing parent left and right for table stock_quant_package...
  107. 2014-12-01 13:02:14,895 32121 INFO springFresh_migrated openerp.models: column product_uom (Product Unit of Measure) converted to a function, removed from table stock_warehouse_orderpoint
  108. 2014-12-01 13:02:15,766 32121 ERROR springFresh_migrated openerp.sql_db: Programming error: column "restrict_partner_id" referenced in foreign key constraint does not exist
  109. , in query ALTER TABLE "stock_move" ADD FOREIGN KEY ("restrict_partner_id") REFERENCES "res_partner" ON DELETE set null
  110. 2014-12-01 13:02:15,774 32121 CRITICAL springFresh_migrated openerp.service.server: Failed to initialize database `springFresh_migrated`.
  111. Traceback (most recent call last):
  112.   File "/var/tmp/openupgrade/8.0/server/openerp/service/server.py", line 901, in preload_registries
  113.     registry = RegistryManager.new(dbname, update_module=update_module)
  114.   File "/var/tmp/openupgrade/8.0/server/openerp/modules/registry.py", line 324, in new
  115.     openerp.modules.load_modules(registry._db, force_demo, status, update_module)
  116.   File "/var/tmp/openupgrade/8.0/server/openerp/modules/loading.py", line 387, in load_modules
  117.     force, status, report, loaded_modules, update_module, upg_registry)
  118.   File "/var/tmp/openupgrade/8.0/server/openerp/modules/loading.py", line 295, in load_marked_modules
  119.     loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks, upg_registry=upg_registry)
  120.   File "/var/tmp/openupgrade/8.0/server/openerp/modules/loading.py", line 186, in load_module_graph
  121.     init_module_models(cr, package.name, models)
  122.   File "/var/tmp/openupgrade/8.0/server/openerp/modules/module.py", line 290, in init_module_models
  123.     obj._auto_end(cr, {'module': module_name})
  124.   File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 237, in wrapper
  125.     return old_api(self, *args, **kwargs)
  126.   File "/var/tmp/openupgrade/8.0/server/openerp/models.py", line 2749, in _auto_end
  127.     cr.execute('ALTER TABLE "%s" ADD FOREIGN KEY ("%s") REFERENCES "%s" ON DELETE %s' % (t, k, r, d))
  128.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 158, in wrapper
  129.     return f(self, *args, **kwargs)
  130.   File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 234, in execute
  131.     res = self._obj.execute(query, params)
  132. ProgrammingError: column "restrict_partner_id" referenced in foreign key constraint does not exist
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!