Problem installing sample report

[Nicola Riolini - Micronaet]

Hi, this is my error trying an installation of aeroo sample (ubu 11.4, openerp 6.0.2)
(in 10.4 updated regularly it works fine, also with my own sample report)

Traceback (most recent call last):
  File "/home/administrator/lp/openerp/server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/home/administrator/lp/openerp/server/bin/service/web_services.py", line 599, in dispatch
    res = fn(db, uid, *params)
  File "/home/administrator/lp/openerp/server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/administrator/lp/openerp/server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/administrator/lp/openerp/server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/administrator/lp/openerp/server/bin/osv/orm.py", line 1980, in write
    self.datas[object_id].update(vals2)
KeyError: 1

[Nicola Riolini - Micronaet (nicolariolini)]

On IRC channel there are also the same error with 10.4, so, maybe, the problem is on new installation instead of bzr pull updating...

[sraps (Alistek) (erpsraps)]

This is due to new Active field feature.

[Nicola Riolini - Micronaet (nicolariolini)]

Hi sraps, I see, in IRC chat I see that there is also problem in restoring an old dump (after RC4) and in update=all crash with:
b.cursor:Programming error: column ir_act_report_xml.active does not exist
(HTH fo find the problem :) )

[sraps (Alistek) (erpsraps)]

Hi,
do you mean that there is such field in your dump file, in opposite to the database where there is none?

[Nicola Riolini - Micronaet (nicolariolini)]

Hi sraps,
this is what we "understand" about the problem:
1. sample report installed on RC3 updated with bzr pull + update=all works with RC4
2. new installation openerp + RC4, sample report doesn't install (bug description)
3. Installation updated from RC3 to RC4 where i try to restore a DB backed up from RC3, when update=all there the #3 error and server doesn't start
Hope that our test are clear :)

[sraps (Alistek) (erpsraps)]

More or less, clear.

[Davide Corio (enlightx-deactivatedaccount)]

here is what i get trying to install the sample package:

http://paste.ubuntu.com/617315/

[Nicola Riolini - Micronaet (nicolariolini)]

sraps, thanks on 11.04 seems to be work with bzr pull lp:aeroo and update=all of DB. Thanks again for fast bugfix :)

[Alan Lord (theopensourcerer)]

Hmm, Is this really fixed?

I am trying to install RC5 on Ubuntu 10.04.3 and OpenERP 6.0.2 and am seeing this error when trying to install the report_aeroo module.

  File "/opt/openerp/server/bin/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/opt/openerp/server/bin/service/web_services.py", line 599, in dispatch
    res = fn(db, uid, *params)
  File "/opt/openerp/server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/server/bin/addons/base/module/wizard/base_module_upgrade.py", line 98, in upgrade_module
    _db, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/opt/openerp/server/bin/pooler.py", line 60, in restart_pool
    return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
  File "/opt/openerp/server/bin/pooler.py", line 39, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
  File "/opt/openerp/server/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 "/opt/openerp/server/bin/addons/__init__.py", line 748, in load_module_graph
    load_init_update_xml(cr, m, idref, mode, kind)
  File "/opt/openerp/server/bin/addons/__init__.py", line 641, in load_init_update_xml
    tools.convert_xml_import(cr, m, fp, idref, mode=mode, **kwargs)
  File "/opt/openerp/server/bin/tools/convert.py", line 975, in convert_xml_import
    obj.parse(doc.getroot())
  File "/opt/openerp/server/bin/tools/convert.py", line 865, in parse
    self._tags[rec.tag](self.cr, rec, n)
  File "/opt/openerp/server/bin/tools/convert.py", line 367, in _tag_function
    _eval_xml(self,rec, self.pool, cr, uid, self.idref, context=context)
  File "/opt/openerp/server/bin/tools/convert.py", line 192, in _eval_xml
    res = getattr(model, method)(cr, uid, *args)
AttributeError: 'ir.actions.report.xml' object has no attribute '_set_auto_false'

What was the fix? How does one workaround this?

Thanks

[Steeve (stvchllx)]

I confirm, the bug is not fixed, for a database with RC3, trying to update to RC6 result the folowing error:

INFO:report_aeroo:registering report.printscreen.list (ir.ui.view)
[2012-02-27 17:14:03,215][tiny2012] ERROR:db.cursor:Programming error: column ir_act_report_xml.active does not exist
LINE 1: ...ct_report_xml".id FROM "ir_act_report_xml" WHERE (ir_act_rep...
                                                             ^
, in query SELECT "ir_act_report_xml".id FROM "ir_act_report_xml" WHERE (ir_act_report_xml.active = %s) AND (ir_act_report_xml.report_name = %s) ORDER BY name
[2012-02-27 17:14:03,216][tiny2012] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/data/openerp/prod/server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/data/openerp/prod/server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/data/openerp/prod/server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/data/openerp/test/server/bin/addons/base/module/wizard/base_module_upgrade.py", line 98, in upgrade_module
    _db, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/data/openerp/prod/server/bin/pooler.py", line 60, in restart_pool
    return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
  File "/data/openerp/prod/server/bin/pooler.py", line 47, in get_db_and_pool
    pool.get('ir.actions.report.xml').register_all(cr)
  File "/data/openerp/test/addons/report_aeroo/report_xml.py", line 185, in register_all
    self.register_report(cr, record['report_name'], record['model'], record['report_rml'], parser)
  File "/data/openerp/test/addons/report_aeroo/report_xml.py", line 147, in register_report
    Aeroo_report(cr, name, model, tmpl_path, parser=parser)
  File "/data/openerp/test/addons/report_aeroo/report_aeroo.py", line 113, in __init__
    report_xml_ids = ir_obj.search(cr, 1, [('report_name', '=', name)])
  File "/data/openerp/test/addons/marketing_campaign/marketing_campaign.py", line 796, in search
    return super(report_xml, self).search(cr, uid, args, offset, limit, order, context, count)
  File "/data/openerp/prod/server/bin/osv/orm.py", line 1748, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/data/openerp/prod/server/bin/osv/orm.py", line 4035, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/data/openerp/prod/server/bin/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/data/openerp/prod/server/bin/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column ir_act_report_xml.active does not exist
LINE 1: ...ct_report_xml".id FROM "ir_act_report_xml" WHERE (ir_act_rep..

thanks