c2c-oerpscenario team mailing list archive

[sunny09 <871196@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Trying to configure "Purchase Requisition" and it gives error with
following details. Pls help

Traceback (most recent call last):
  File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/service/web_services.py", line 599, in dispatch
    res = fn(db, uid, *params)
  File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/addons/base/res/res_config.py", line 167, in action_next
    next = self.execute(cr, uid, ids, context=None)
  File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/addons/base/res/res_config.py", line 397, in execute
    new_db, self.pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/pooler.py", line 60, in restart_pool
    return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
  File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/pooler.py", line 39, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
  File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/addons/__init__.py", line 883, in load_modules
    processed_modules.extend(load_module_graph(cr, graph, status, report=report, skip_modules=processed_modules))
  File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/addons/__init__.py", line 719, in load_module_graph
    init_module_objects(cr, package.name, modules)
  File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/addons/__init__.py", line 420, in init_module_objects
    obj.init(cr)
  File "/home/sud/openerp6/addons/6.0/purchase_requisition/report/quotes_compare.py", line 31, in init
    """)
  File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
ProgrammingError: function generate_crosstab_sql(unknown, unknown, unknown, unknown, unknown, unknown, unknown) does not exist
LINE 2:                     select generate_crosstab_sql('purchase_o...
                                   ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

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

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

Title:
  Purchases Application Config fails (Server 6.0.3)

Status in OpenERP Server:
  New

Bug description:
  Trying to configure "Purchase Requisition" and it gives error with
  following details. Pls help

  Traceback (most recent call last):
    File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/netsvc.py", line 489, in dispatch
      result = ExportService.getService(service_name).dispatch(method, auth, params)
    File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/service/web_services.py", line 599, in dispatch
      res = fn(db, uid, *params)
    File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/addons/base/res/res_config.py", line 167, in action_next
      next = self.execute(cr, uid, ids, context=None)
    File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/addons/base/res/res_config.py", line 397, in execute
      new_db, self.pool = pooler.restart_pool(cr.dbname, update_module=True)
    File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/pooler.py", line 60, in restart_pool
      return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
    File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/pooler.py", line 39, in get_db_and_pool
      addons.load_modules(db, force_demo, status, update_module)
    File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/addons/__init__.py", line 883, in load_modules
      processed_modules.extend(load_module_graph(cr, graph, status, report=report, skip_modules=processed_modules))
    File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/addons/__init__.py", line 719, in load_module_graph
      init_module_objects(cr, package.name, modules)
    File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/addons/__init__.py", line 420, in init_module_objects
      obj.init(cr)
    File "/home/sud/openerp6/addons/6.0/purchase_requisition/report/quotes_compare.py", line 31, in init
      """)
    File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/home/sud/openerp6/server/openerp-server-6.0.3/bin/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: function generate_crosstab_sql(unknown, unknown, unknown, unknown, unknown, unknown, unknown) does not exist
  LINE 2:                     select generate_crosstab_sql('purchase_o...
                                     ^
  HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

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