Found Error when "Upstream Traceability" and "Downstream Traceability" Perform

[Amit Bhavsar (Open ERP)]

Problem : Found Error when "Upstream Traceability" and "Downstream Traceability" Perform
            step 1 : Warehouse --> traceability --> production lots
            step 2 : In form view click on "Upstream Traceability" or "Downstream Traceability"

Error are found . . .
================================================================================
[2011-10-05 09:34:12,881][?] ERROR:db.cursor:Programming error: syntax error at or near ")"
LINE 7: ...0, 21, 25, 26, 11, 12, 19, 18) and prodlot_id IN () group by...
                                                             ^
, in query select
                    prodlot_id,
                    sum(qty)
                from
                    stock_report_prodlots
                where
                    location_id IN %s and prodlot_id IN %s group by prodlot_id
[2011-10-05 09:34:12,881][?] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/home/amb/source/server/trunk/openerp/osv/osv.py", line 120, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/amb/source/server/trunk/openerp/osv/osv.py", line 172, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/amb/source/server/trunk/openerp/osv/osv.py", line 163, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/amb/source/server/trunk/openerp/osv/orm.py", line 3219, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/amb/source/server/trunk/openerp/osv/orm.py", line 3342, in _read_flat
    res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
  File "/home/amb/source/server/trunk/openerp/osv/fields.py", line 1000, in get
    result = self._fnct(obj, cr, uid, ids, name, self._arg, context)
  File "/home/amb/source/addons/trunk/stock/stock.py", line 1379, in _get_stock
    location_id IN %s and prodlot_id IN %s group by prodlot_id''',(tuple(locations),tuple(ids),))
  File "/home/amb/source/server/trunk/openerp/sql_db.py", line 153, in wrapper
    return f(self, *args, **kwargs)
  File "/home/amb/source/server/trunk/openerp/sql_db.py", line 215, in execute
    res = self._obj.execute(query, params)
ProgrammingError: syntax error at or near ")"
LINE 7: ...0, 21, 25, 26, 11, 12, 19, 18) and prodlot_id IN () group by...

[Vishal Parmar(Open ERP) (vpa-openerp)]

Hello,

I have checked this issue. GTK is working normally but in web gives error message for view mode.

I think it should be fix from addons team, To add view mode in wizard .py.

Thanks.

[Kirti Savalia(OpenERP) (ksa-openerp)]

Hello,
 Thanks For Reporting,
 It has been Fixed in http://bazaar.launchpad.net/~openerp-dev/openobject-addons/trunk-bug-868271-ksa/
 revision-id: <email address hidden>
 revno: 5323
 It will be available in trunk soon.

Thanks.