openerp-india team mailing list archive

[gonssal <gonssal@xxxxxxxxx>]

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