Purchases Application Config fails (Server 6.0.3)

[ThinkingTree Consulting]

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.

[Jignesh Rathod(OpenERP) (jir-openerp)]

Hello sunny,

I have tested your scenario at my end.
I did not faced any Traceback with configuration "Purchase Requisition".
so would you please provide more information regarding this issue.

I have checked with following revision :

Stable 6 :

     Server : 3517
     Gtk -Client : 1902
     addons : 4878
   Web Client : 4714
Trunk :

   New web Client : 1184
     Server : 3744
     addons : 5322
     Gtk-Client : 1968

Thanks & waiting for your replay.

[Launchpad Janitor (janitor)]

[Expired for OpenERP Server because there has been no activity for 60 days.]

[Amit Parik (amit-parik)]

Hello,

Would you please try with the latest updated code.

If you still face the problem then you can reopen this with more information.

Thanks.