c2c-oerpscenario team mailing list archive

["Kirti Savalia\(OpenERP\)" <ksa@xxxxxxxxxxx>]

** Changed in: openobject-addons
       Status: Confirmed => In Progress

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/868271

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

Status in OpenERP Addons (modules):
  In Progress

Bug description:
  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...

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