Trying to pay a supplier – the same way we pay all suppliers. Yet this one fails, can't see any difference in the pattern

[Stephane Wirtel (OpenERP)]

Trying to pay a supplier – the same way we pay all suppliers. Yet this one fails, can't see any difference in the pattern

-----
Traceback (most recent call last):
  File "/mnt/openerp/server/bin/netsvc.py", line 244, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/mnt/openerp/server/bin/netsvc.py", line 73, in __call__
    return getattr(self, method)(*params)
  File "/mnt/openerp/server/bin/service/web_services.py", line 632, in execute
    return self._execute(db, uid, wiz_id, datas, action, context)
  File "/mnt/openerp/server/bin/service/web_services.py", line 612, in _execute
    return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
  File "/mnt/openerp/server/bin/wizard/__init__.py", line 178, in execute
    res = self.execute_cr(cr, uid, data, state, context)
  File "/mnt/openerp/server/bin/wizard/__init__.py", line 154, in execute_cr
    return self.execute_cr(cr, uid, data, next_state, context)
  File "/mnt/openerp/server/bin/wizard/__init__.py", line 73, in execute_cr
    action_res = action(self, cr, uid, data, context)
  File "/mnt/openerp/server/bin/addons/account/wizard/wizard_pay_invoice.py", line 88, in _pay_and_reconcile
    period_id, writeoff_journal_id, context, data['form']['name'])
  File "/mnt/openerp/server/bin/addons/account/invoice.py", line 942, in pay_and_reconcile
    move_id = self.pool.get('account.move').create(cr, uid, move, context=context)
  File "/mnt/openerp/server/bin/addons/account/account.py", line 914, in create
    result = super(account_move, self).create(cr, uid, vals, c)
  File "/mnt/openerp/server/bin/osv/orm.py", line 2854, in create
    result += self._columns[field].set(cr, self, id_new, field, vals[field], user, rel_context) or []
  File "/mnt/openerp/server/bin/osv/fields.py", line 448, in set
    id_new = obj.create(cr, user, act[2], context=context)
  File "/mnt/openerp/server/bin/addons/account/account_move_line.py", line 882, in create
    result = super(osv.osv, self).create(cr, uid, vals, context)
  File "/mnt/openerp/server/bin/osv/orm.py", line 2819, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  File "/mnt/openerp/server/bin/sql_db.py", line 77, in wrapper
    return f(self, *args, **kwargs)
  File "/mnt/openerp/server/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
DataError: value too long for type character varying(32)

[JMA(Open ERP) (jma-openerp)]

Hello Stephane,
This clearly looks like a problem of storing the larger set of characters for any limited size field.
I mean, would you please check whether the supplier invoice has any char field which contains more data and it is passing to Account-Move-Line and its field accepts less size of data.

Thanks.

[Numérigraphe (numerigraphe)]

I think you should not mark this "incomplete". "incomplete" bugs are those you can't investigate, and Launchpad wipes them when they get old.

[Jay Vora (Serpent Consulting Services) (jayvora)]

It has been marked incomplete as we do not have perfect information to reproduce this one.
However, I'll take a look at this after few hours and will post my opinion here.

Thanks.

[Stephane Wirtel (OpenERP) (stephane-openerp)]

I invalid this bug because the framework make a truncation of the string.