[6.0 Stable version]Related Picking Application Error

[Regina Tsui]

When trying the following steps , application error shown:
1. Go to Warehouse -> Product Moves ->
Receive Products -> Related Picking (Right hand menu)

Please kindly suggest when can it be fixed

[Amit Parik (amit-parik)]

Hello Regina,

I have tested your scenario with stable v6 at my end. But all are working fine.
Would you please elaborate with more or provide the proper steps to reproduce it.

Thanks.

[Regina Tsui (regina-tsui)]

Hello Amit,

Here attached the error code for your reference.
And for more information, I am using web-client for testing this processes.
------------------------------------------------------------------------------------------------------------------------

Traceback (most recent call last):
  File "/apps/openerp/openerp-server-6.0.1/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/apps/openerp/openerp-server-6.0.1/bin/service/web_services.py", line 599, in dispatch
    res = fn(db, uid, *params)
  File "/apps/openerp/openerp-server-6.0.1/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/apps/openerp/openerp-server-6.0.1/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/apps/openerp/openerp-server-6.0.1/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/apps/openerp/openerp-server-6.0.1/bin/osv/orm.py", line 1735, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/apps/openerp/openerp-server-6.0.1/bin/osv/orm.py", line 3968, in _search
    query = self._where_calc(cr, user, args, context=context)
  File "/apps/openerp/openerp-server-6.0.1/bin/osv/orm.py", line 3821, in _where_calc
    e.parse(cr, user, self, context)
  File "/apps/openerp/openerp-server-6.0.1/bin/osv/expression.py", line 220, in parse
    self.__exp[i] = ('id', o2m_op, self.__execute_recursive_in(cr, field._fields_id, field_obj._table, 'id', ids2, operator, field._type))
  File "/apps/openerp/openerp-server-6.0.1/bin/osv/expression.py", line 60, in __execute_recursive_in
    ' WHERE "%s" IN %%s' % (s, f, w),(tuple(subids),))
  File "/apps/openerp/openerp-server-6.0.1/bin/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/apps/openerp/openerp-server-6.0.1/bin/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
DataError: invalid input syntax for integer: "active_id"
LINE 1: ...T "picking_id" FROM "stock_move" WHERE "id" IN (E'active_i...

------------------------------------------------------------------------------------------------------------------------

[Azazahmed Saiyed (OpenERP) (saz-openerp)]

Hello Regina,

Thanks for your reply !

I have checked the issue in stable 6.0 and in the web-client and met with the same traceback while clicking on the act window of related picking in Warehouse/Product Moves/ Receive Products and Deliver Products. So I am confirming this bug.

Thanks.

[Rucha (Open ERP) (rpa-openerp)]

Hello Regina,
It has been fixed in lp:~openerp-dev/openobject-addons/rpa-dev-addons2
revision-id: <email address hidden>
revision: 4554
Thanks for reporting.

[Regina Tsui (regina-tsui)]

Hello Rucha,
Thanks for your reply, however the same error still shown after we modify the code according to revision 4554

Please kindly revise, thanks

[Regina Tsui (regina-tsui)]

Have tried the modification, however still have error

[Rucha (Open ERP) (rpa-openerp)]

Hello Regina,
I have checked for your problem, we don't have any error, so if you have changed code same as the fix, it must work,
May be you haven't upgrade the module,
thanks

[Amit Parik (amit-parik)]

Hello Regina,

Your reported problem has already fixed.

So you can try with the latest code as well as new version of OpenERP 6.1 is already released (you can try with latest version).

If you still faced the problem then you can report a new bug report.

Thanks for understanding!