openerp-india team mailing list archive

["Cristian Salamea \(Gnuthink\)" <ovnicraft@xxxxxxxxx>]

On Thu, Dec 15, 2011 at 6:50 AM, Ferdinand @ Camptocamp <
746620@xxxxxxxxxxxxxxxxxx> wrote:

> IMHO a main problem of gap-less  is not solved :
>
> for some documents (SO,PO,PICK, ...) the number is generated pressing
> "New".
> Hence the number is "used" even if the user decides to abort / delete the
> document
>
> workarounds
> * the number should only be assigned in the workflow from state draft to
> anything but cancel
> * prohibit deletion of numbered documents. not nice, but at least this
> would conform to accounting and audit  standards.
>

Hello but here the issue can solve don't calling *get* from sequence in
init workflow and dont allow deletion from records needs implement unlink
method and check states.

Regards,

>
> --
> You received this bug notification because you are a member of OpenERP
> Committers, which is subscribed to OpenERP Server.
> https://bugs.launchpad.net/bugs/746620
>
> Title:
>  Implementation of faster gap-tolerant sequences
>
> Status in OpenERP Server:
>  Fix Released
>
> Bug description:
>  OpenERP is classified as an Enterprise class software package. Meaning
>  that more than one person, at least 2 should be able to use the system
>  simultaneously. Like packers shipping products, taking orders,
>  reserving products. I find that in fact, it is not possible for
>  creation of stock moves simultaneously.
>
>   Say I am importing orders from a shop. It is creating stock moves
>  because the order is paid.
>  At the same time I am shipping products which is normal for an ERP system.
>  I might also import orders from a separate shop say a POS system.
>  It is not possible!
>  [2011-03-31 13:10:47,657][midwestsupplies] WARNING:stock.location:Failed
> attempt to reserve 1.0 x product 1669, li
>  kely due to another transaction already in progress. Next attempt is
> likely to work. Detailed error available at D
>  EBUG level.
>  OperationalError: could not obtain lock on row in relation "ir_sequence"
>  Two different errors.
>  I  can only perform one action at a time!
>  What happens is that any time the program calls for a stock_move it will
> lock the stock_move table so no other process can access it which means
> that you cant do hardly anything unless its done individually. Now say with
> a MS system, or any Enterprise system would be able to handle many
> simultaneous actions but this program has a serious architecture flaw to
> not be able to support this.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/openobject-server/+bug/746620/+subscriptions
>


-- 
Cristian Salamea
@ovnicraft

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/746620

Title:
  Implementation of faster gap-tolerant sequences

Status in OpenERP Server:
  Fix Released

Bug description:
  OpenERP is classified as an Enterprise class software package. Meaning
  that more than one person, at least 2 should be able to use the system
  simultaneously. Like packers shipping products, taking orders,
  reserving products. I find that in fact, it is not possible for
  creation of stock moves simultaneously.

   Say I am importing orders from a shop. It is creating stock moves  because the order is paid. 
  At the same time I am shipping products which is normal for an ERP system.
  I might also import orders from a separate shop say a POS system.
  It is not possible!
  [2011-03-31 13:10:47,657][midwestsupplies] WARNING:stock.location:Failed attempt to reserve 1.0 x product 1669, li
  kely due to another transaction already in progress. Next attempt is likely to work. Detailed error available at D
  EBUG level.  
  OperationalError: could not obtain lock on row in relation "ir_sequence"
  Two different errors.
  I  can only perform one action at a time!
  What happens is that any time the program calls for a stock_move it will lock the stock_move table so no other process can access it which means that you cant do hardly anything unless its done individually. Now say with a MS system, or any Enterprise system would be able to handle many simultaneous actions but this program has a serious architecture flaw to not be able to support this.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/746620/+subscriptions