← Back to team overview

openerp-india team mailing list archive

[Bug 1111049] [NEW] MRP error when processing a procurement order with large message

 

Public bug reported:

Hello Guys,


I'm using OpenERP Addons revision #8616, when I try process a procurement order this error happens:

  File "/opt/openerp/prod/addons/procurement/procurement.py", line 370, in _check_make_to_stock_product
    cr.execute('update procurement_order set message=%s where id=%s', (message, procurement.id))
  File "/opt/openerp/prod/server/openerp/sql_db.py", line 162, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/openerp/prod/server/openerp/sql_db.py", line 227, in execute
    res = self._obj.execute(query, params)
DataError: value too long for type character varying(124)

You can reproduce this error while trying to process any procurement
order with a product with a long name, because product name is copied to
name field in procurement order, if you look
/opt/openerp/prod/addons/procurement/procurement.py, lines 369, 370:

message = _("Procurement '%s' is in exception: ") % (procurement.name) + message
cr.execute('update procurement_order set message=%s where id=%s', (message, procurement.id))

** 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/1111049

Title:
  MRP error when processing a procurement order with large message

Status in OpenERP Addons (modules):
  New

Bug description:
  Hello Guys,

  
  I'm using OpenERP Addons revision #8616, when I try process a procurement order this error happens:

    File "/opt/openerp/prod/addons/procurement/procurement.py", line 370, in _check_make_to_stock_product
      cr.execute('update procurement_order set message=%s where id=%s', (message, procurement.id))
    File "/opt/openerp/prod/server/openerp/sql_db.py", line 162, in wrapper
      return f(self, *args, **kwargs)
    File "/opt/openerp/prod/server/openerp/sql_db.py", line 227, in execute
      res = self._obj.execute(query, params)
  DataError: value too long for type character varying(124)

  You can reproduce this error while trying to process any procurement
  order with a product with a long name, because product name is copied
  to name field in procurement order, if you look
  /opt/openerp/prod/addons/procurement/procurement.py, lines 369, 370:

  message = _("Procurement '%s' is in exception: ") % (procurement.name) + message
  cr.execute('update procurement_order set message=%s where id=%s', (message, procurement.id))

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


Follow ups

References