Warehouse Scheduler breaks and never works again (even after reset/restart)

Bug #1285362 reported by gonssal
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Incomplete
Undecided
Unassigned

Bug Description

OpenERP v7.0-20140226-002804 on Ubuntu Server 12.04.04 with PostgreSQL 9.1. The module I believe is affected: procurement.

Steps to reproduce:
  - Create a new product and set Procure method to Make to Order, Supply method to Buy and Purchase requisition to True. Do not set stock.
  - Create a new Sell order, and sell, for example, 20 units of this product.
  - Go back to the product, and confirm that the Virtual stock is -20.
  - Go to Warehouse and Schedulers > Run schedulers, CHECK the automatic checkbox and run them.
  - A new corresponding entry will be created in Sales > Purchase requisitions so you can start ordering the products you need.
  - Go back to the product, and set Purchase requisition to False.
  - Delete the purchase requisition.
  - Go back to Warehouse and run the shcedulers again. The loading screen will appear and never disappear.
  - The purchase requisition won't be created again, even if the product still has a Virtual stock of -20.
  - Run the scheduler as many times as you want, the requistion won't be created.
  - Look at the openerp server log. The following message will appear for as many times as you've ran the scheduler: [date],502 2042 WARNING [db_name] openerp.sql_db: Cursor not closed explicitly

The scheduler won't work again, even if you restart OpenERP, PostgreSQL or even the system.

The only way I've found to make it work again, wait for it: dropping the database and starting from scratch.

Revision history for this message
Flames_in_Paradise (ellisistfroh-deactivatedaccount) wrote :

hi!

Possibly it's better to report down-/upstream since project moved to GitHub:

https://github.com/odoo/odoo/issues

If done so, it would be kind to reference the bugreport no. here.

Maybe it was already reported or the issue was fixed.

Changed in openobject-addons:
status: New → Incomplete
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.