openerp-india team mailing list archive

["Amit Parik \(OpenERP\)" <amp@xxxxxxxxxxx>]

Hello Folks,

I have again tried this issue with latest trunk, but amazing faced the
another problem.

I tried same steps which I was given on comment#4, If the purchase module has not installed then it's give the following  warning message 
2012-08-27 06:01:15,500 2775 WARNING ? openerp.osv.orm.browse_record.procurement.order: Field 'purchase_id' does not exist in object 'browse_record(procurement.order, 11)'
2012-08-27 06:01:15,525 2775 WARNING ? openerp.osv.orm.browse_record.procurement.order: Field 'purchase_id' does not exist in object 'browse_record(procurement.order, 12)'

And even if I have installed the purchase module then It gives the
traceback as follow.

2012-08-27 06:40:05,224 5367 ERROR ? openerp.sql_db: bad query: update stock_warehouse_orderpoint set "procurement_id"=8,write_uid=1,write_date=(now() at time zone 'UTC') where id IN (1)
Traceback (most recent call last):
  File "/home/amp/workspace/rdtools/server/trunk/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
TransactionRollbackError: could not serialize access due to concurrent update

Exception in thread Thread-292:
Traceback (most recent call last):
  File "/usr/lib/python2.6/threading.py", line 532, in __bootstrap_inner
    self.run()
  File "/usr/lib/python2.6/threading.py", line 484, in run
    self.__target(*self.__args, **self.__kwargs)
  File "/home/amp/workspace/rdtools/addons/trunk/procurement/wizard/schedulers_all.py", line 52, in _procure_calculation_all
    context=context)
  File "/home/amp/workspace/rdtools/addons/trunk/procurement/schedulers.py", line 41, in run_scheduler
    use_new_cursor=use_new_cursor, context=context)
  File "/home/amp/workspace/rdtools/addons/trunk/procurement/schedulers.py", line 286, in _procure_orderpoint_confirm
    {'procurement_id': proc_id}, context=context)
  File "/home/amp/workspace/rdtools/server/trunk/openerp/osv/orm.py", line 4012, in write
    'where id IN %s', upd1 + [sub_ids])
  File "/home/amp/workspace/rdtools/server/trunk/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/home/amp/workspace/rdtools/server/trunk/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
TransactionRollbackError: could not serialize access due to concurrent update


2012-08-27 06:40:05,459 5367 WARNING ? openerp.sql_db: Cursor not closed explicitly
Please enable sql debugging to trace the caller.

I am again confirming this issue because the bug still doesn't fixed yet
as well the the related ashvin's branch is rejected.

Thank you!

** Changed in: openobject-addons
       Status: Fix Committed => Confirmed

-- 
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/708595

Title:
  Scheduler error

Status in OpenERP Addons (modules):
  Confirmed

Bug description:
  Server is running Ubuntu 10.04.
  OpenERP is the 6.0.1 deb from the OpenERP website.

  Have been trying to make a demo for a prospect.

  Using the "Invoice from Picking" option of a Sales Order with Partial
  Delivery and Invoice on Shipped Quantities... I have been trying to
  get Invoices to be created when each part of the sales order is picked
  and shipped (or at least show in the Sales->Invoices->Lines to Invoice
  list). But it doesn't seem to work...

  I set the mrp scheduler to run every 5 minutes. This is what I'm
  seeing in the logs, and I'm getting the item I'm picking/delivering
  being flagged as State "Exception."

  ** This is in the openerp-server log file when the mrp scheduler runs
  automatically every 5 minutes **

  [2011-01-27 11:45:28,593][demo_01] WARNING:browse_record:[01]: Field 'purchase_id' does not exist in object 'browse_record(procurement.order, 35)': 
  [2011-01-27 11:45:28,593][demo_01] WARNING:browse_record:[02]: None
  [2011-01-27 11:45:28,594][demo_01] ERROR:netsvc.agent:Job call of self.pool.get('procurement.order').run_scheduler(cr, uid, *(False,)) failed
  Traceback (most recent call last):
    File "/usr/share/pyshared/openerp-server/addons/base/ir/ir_cron.py", line 94, in _callback
      f(cr, uid, *args)
    File "/usr/share/pyshared/openerp-server/addons/procurement/procurement.py", line 469, in run_scheduler
      use_new_cursor=use_new_cursor, context=context)
    File "/usr/share/pyshared/openerp-server/addons/procurement/schedulers.py", line 223, in _procure_orderpoint_confirm
      if op.procurement_id and op.procurement_id.purchase_id and op.procurement_id.purchase_id.state in ('draft', 'confirmed'):
    File "/usr/share/pyshared/openerp-server/osv/orm.py", line 287, in __getattr__
      raise AttributeError(e)
  AttributeError: "Field 'purchase_id' does not exist in object 'browse_record(procurement.order, 35)'"

  ** Here I manually ran the scheduler from the
  Warehouse->Schedulers->Compute Schedulers menu **

  [2011-01-27 11:46:52,232][demo_01] WARNING:browse_record:[01]: Field 'purchase_id' does not exist in object 'browse_record(procurement.order, 35)': 
  [2011-01-27 11:46:52,233][demo_01] WARNING:browse_record:[02]: None
  [2011-01-27 11:47:18,830][demo_01] WARNING:db.cursor:Cursor not closed explicitly
  Please enable sql debugging to trace the caller.
  [2011-01-27 11:47:27,516][demo_01] WARNING:db.connection_pool:ConnectionPool(used=0/count=2/max=64): Free leaked connection to 'user=openerp dbname=demo_01'

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