Public bug reported:
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.
** Affects: openobject-addons
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1285362
Title:
Warehouse Scheduler breaks and never works again (even after
reset/restart)
Status in OpenERP Addons (modules):
New
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.
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1285362/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~openerp-india
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openerp-india
More help : https://help.launchpad.net/ListHelp
