openerp-india team mailing list archive

["Twinkle Christian\(OpenERP\)" <tch@xxxxxxxxxxx>]

Public bug reported:

Reporting -> Warehouse ->Inventory analysis,

When I am trying to open the Inventory analysis page it throws a
Traceback like :

OpenERP Server Error

Client Traceback (most recent call last):
  File "/home/tch/openerp-tools/web/trunk/addons/web/common/http.py", line 180, in dispatch
    response["result"] = method(controller, self, **self.params)
  File "/home/tch/openerp-tools/web/trunk/addons/web/controllers/main.py", line 914, in search_read
    return self.do_search_read(req, model, fields, offset, limit, domain, sort)
  File "/home/tch/openerp-tools/web/trunk/addons/web/controllers/main.py", line 951, in do_search_read
    records = Model.read(ids, fields or False, context)
  File "/home/tch/openerp-tools/web/trunk/addons/web/common/openerplib/main.py", line 250, in proxy
    args, kw)
  File "/home/tch/openerp-tools/web/trunk/addons/web/common/openerplib/main.py", line 117, in proxy
    result = self.connector.send(self.service_name, method, *args)
  File "/home/tch/openerp-tools/web/trunk/addons/web/common/http.py", line 608, in send
    raise xmlrpclib.Fault(openerp.tools.exception_to_unicode(e), formatted_info)

Server Traceback (most recent call last):
  File "/home/tch/openerp-tools/web/trunk/addons/web/common/http.py", line 593, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/home/tch/openerp-tools/server/trunk/openerp/netsvc.py", line 362, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/tch/openerp-tools/server/trunk/openerp/service/web_services.py", line 586, in dispatch
    res = fn(db, uid, *params)
  File "/home/tch/openerp-tools/server/trunk/openerp/osv/osv.py", line 167, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/home/tch/openerp-tools/server/trunk/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/tch/openerp-tools/server/trunk/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/tch/openerp-tools/server/trunk/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/tch/openerp-tools/server/trunk/openerp/osv/orm.py", line 3436, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/tch/openerp-tools/server/trunk/openerp/osv/orm.py", line 3492, in _read_flat
    cr.execute(query, (tuple(sub_ids),))
  File "/home/tch/openerp-tools/server/trunk/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/home/tch/openerp-tools/server/trunk/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column report_stock_inventory.year does not exist
LINE 1: SELECT report_stock_inventory."date",report_stock_inventory....


Thanks,
Twinkle Christian

** Affects: openobject-addons
     Importance: Undecided
         Status: New

** Description changed:

  Reporting -> Warehouse ->Inventory analysis,
  
  When I am trying to open the Inventory analysis page it throws a
  Traceback like :
  
  OpenERP Server Error
  
  Client Traceback (most recent call last):
-   File "/home/tch/openerp-tools/web/trunk/addons/web/common/http.py", line 180, in dispatch
-     response["result"] = method(controller, self, **self.params)
-   File "/home/tch/openerp-tools/web/trunk/addons/web/controllers/main.py", line 914, in search_read
-     return self.do_search_read(req, model, fields, offset, limit, domain, sort)
-   File "/home/tch/openerp-tools/web/trunk/addons/web/controllers/main.py", line 951, in do_search_read
-     records = Model.read(ids, fields or False, context)
-   File "/home/tch/openerp-tools/web/trunk/addons/web/common/openerplib/main.py", line 250, in proxy
-     args, kw)
-   File "/home/tch/openerp-tools/web/trunk/addons/web/common/openerplib/main.py", line 117, in proxy
-     result = self.connector.send(self.service_name, method, *args)
-   File "/home/tch/openerp-tools/web/trunk/addons/web/common/http.py", line 608, in send
-     raise xmlrpclib.Fault(openerp.tools.exception_to_unicode(e), formatted_info)
+   File "/home/tch/openerp-tools/web/trunk/addons/web/common/http.py", line 180, in dispatch
+     response["result"] = method(controller, self, **self.params)
+   File "/home/tch/openerp-tools/web/trunk/addons/web/controllers/main.py", line 914, in search_read
+     return self.do_search_read(req, model, fields, offset, limit, domain, sort)
+   File "/home/tch/openerp-tools/web/trunk/addons/web/controllers/main.py", line 951, in do_search_read
+     records = Model.read(ids, fields or False, context)
+   File "/home/tch/openerp-tools/web/trunk/addons/web/common/openerplib/main.py", line 250, in proxy
+     args, kw)
+   File "/home/tch/openerp-tools/web/trunk/addons/web/common/openerplib/main.py", line 117, in proxy
+     result = self.connector.send(self.service_name, method, *args)
+   File "/home/tch/openerp-tools/web/trunk/addons/web/common/http.py", line 608, in send
+     raise xmlrpclib.Fault(openerp.tools.exception_to_unicode(e), formatted_info)
+ 
+ Server Traceback (most recent call last):
+   File "/home/tch/openerp-tools/web/trunk/addons/web/common/http.py", line 593, in send
+     return openerp.netsvc.dispatch_rpc(service_name, method, args)
+   File "/home/tch/openerp-tools/server/trunk/openerp/netsvc.py", line 362, in dispatch_rpc
+     result = ExportService.getService(service_name).dispatch(method, params)
+   File "/home/tch/openerp-tools/server/trunk/openerp/service/web_services.py", line 586, in dispatch
+     res = fn(db, uid, *params)
+   File "/home/tch/openerp-tools/server/trunk/openerp/osv/osv.py", line 167, in execute_kw
+     return self.execute(db, uid, obj, method, *args, **kw or {})
+   File "/home/tch/openerp-tools/server/trunk/openerp/osv/osv.py", line 121, in wrapper
+     return f(self, dbname, *args, **kwargs)
+   File "/home/tch/openerp-tools/server/trunk/openerp/osv/osv.py", line 176, in execute
+     res = self.execute_cr(cr, uid, obj, method, *args, **kw)
+   File "/home/tch/openerp-tools/server/trunk/openerp/osv/osv.py", line 164, in execute_cr
+     return getattr(object, method)(cr, uid, *args, **kw)
+   File "/home/tch/openerp-tools/server/trunk/openerp/osv/orm.py", line 3436, in read
+     result = self._read_flat(cr, user, select, fields, context, load)
+   File "/home/tch/openerp-tools/server/trunk/openerp/osv/orm.py", line 3492, in _read_flat
+     cr.execute(query, (tuple(sub_ids),))
+   File "/home/tch/openerp-tools/server/trunk/openerp/sql_db.py", line 152, in wrapper
+     return f(self, *args, **kwargs)
+   File "/home/tch/openerp-tools/server/trunk/openerp/sql_db.py", line 212, in execute
+     res = self._obj.execute(query, params)
+ ProgrammingError: column report_stock_inventory.year does not exist
+ LINE 1: SELECT report_stock_inventory."date",report_stock_inventory....
  
  
- Server Traceback (most recent call last):
-   File "/home/tch/openerp-tools/web/trunk/addons/web/common/http.py", line 593, in send
-     return openerp.netsvc.dispatch_rpc(service_name, method, args)
-   File "/home/tch/openerp-tools/server/trunk/openerp/netsvc.py", line 362, in dispatch_rpc
-     result = ExportService.getService(service_name).dispatch(method, params)
-   File "/home/tch/openerp-tools/server/trunk/openerp/service/web_services.py", line 586, in dispatch
-     res = fn(db, uid, *params)
-   File "/home/tch/openerp-tools/server/trunk/openerp/osv/osv.py", line 167, in execute_kw
-     return self.execute(db, uid, obj, method, *args, **kw or {})
-   File "/home/tch/openerp-tools/server/trunk/openerp/osv/osv.py", line 121, in wrapper
-     return f(self, dbname, *args, **kwargs)
-   File "/home/tch/openerp-tools/server/trunk/openerp/osv/osv.py", line 176, in execute
-     res = self.execute_cr(cr, uid, obj, method, *args, **kw)
-   File "/home/tch/openerp-tools/server/trunk/openerp/osv/osv.py", line 164, in execute_cr
-     return getattr(object, method)(cr, uid, *args, **kw)
-   File "/home/tch/openerp-tools/server/trunk/openerp/osv/orm.py", line 3436, in read
-     result = self._read_flat(cr, user, select, fields, context, load)
-   File "/home/tch/openerp-tools/server/trunk/openerp/osv/orm.py", line 3492, in _read_flat
-     cr.execute(query, (tuple(sub_ids),))
-   File "/home/tch/openerp-tools/server/trunk/openerp/sql_db.py", line 152, in wrapper
-     return f(self, *args, **kwargs)
-   File "/home/tch/openerp-tools/server/trunk/openerp/sql_db.py", line 212, in execute
-     res = self._obj.execute(query, params)
- ProgrammingError: column report_stock_inventory.year does not exist
- LINE 1: SELECT report_stock_inventory."date",report_stock_inventory....
+ Thanks,
+ Twinkle Christian

-- 
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/1018254

Title:
  Hello, When I am trying to open Inventory analysis from the reporting
  menu ,it throws error

Status in OpenERP Addons (modules):
  New

Bug description:
  Reporting -> Warehouse ->Inventory analysis,

  When I am trying to open the Inventory analysis page it throws a
  Traceback like :

  OpenERP Server Error

  Client Traceback (most recent call last):
    File "/home/tch/openerp-tools/web/trunk/addons/web/common/http.py", line 180, in dispatch
      response["result"] = method(controller, self, **self.params)
    File "/home/tch/openerp-tools/web/trunk/addons/web/controllers/main.py", line 914, in search_read
      return self.do_search_read(req, model, fields, offset, limit, domain, sort)
    File "/home/tch/openerp-tools/web/trunk/addons/web/controllers/main.py", line 951, in do_search_read
      records = Model.read(ids, fields or False, context)
    File "/home/tch/openerp-tools/web/trunk/addons/web/common/openerplib/main.py", line 250, in proxy
      args, kw)
    File "/home/tch/openerp-tools/web/trunk/addons/web/common/openerplib/main.py", line 117, in proxy
      result = self.connector.send(self.service_name, method, *args)
    File "/home/tch/openerp-tools/web/trunk/addons/web/common/http.py", line 608, in send
      raise xmlrpclib.Fault(openerp.tools.exception_to_unicode(e), formatted_info)

  Server Traceback (most recent call last):
    File "/home/tch/openerp-tools/web/trunk/addons/web/common/http.py", line 593, in send
      return openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/home/tch/openerp-tools/server/trunk/openerp/netsvc.py", line 362, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/home/tch/openerp-tools/server/trunk/openerp/service/web_services.py", line 586, in dispatch
      res = fn(db, uid, *params)
    File "/home/tch/openerp-tools/server/trunk/openerp/osv/osv.py", line 167, in execute_kw
      return self.execute(db, uid, obj, method, *args, **kw or {})
    File "/home/tch/openerp-tools/server/trunk/openerp/osv/osv.py", line 121, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/tch/openerp-tools/server/trunk/openerp/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/tch/openerp-tools/server/trunk/openerp/osv/osv.py", line 164, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/tch/openerp-tools/server/trunk/openerp/osv/orm.py", line 3436, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/home/tch/openerp-tools/server/trunk/openerp/osv/orm.py", line 3492, in _read_flat
      cr.execute(query, (tuple(sub_ids),))
    File "/home/tch/openerp-tools/server/trunk/openerp/sql_db.py", line 152, in wrapper
      return f(self, *args, **kwargs)
    File "/home/tch/openerp-tools/server/trunk/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: column report_stock_inventory.year does not exist
  LINE 1: SELECT report_stock_inventory."date",report_stock_inventory....

  
  Thanks,
  Twinkle Christian

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