Odoo Help

1

Failed to restore database after reinstall server v7. Any ideas .??!

By
ed
on 3/3/13, 6:42 PM 2,820 views

I've tried to restore my database after an my server got stuck on mrp procurement planner. I had to completely reinstall the server.

I also upgraded the postgresql to 9.2 to get better performance on debian.

Now i'm trying to restore the database but this doesn't work.

I'm getting teh following error:

OpenERP Server Error
Client Traceback (most recent call last):
  File "/home/openerp/web/addons/web/http.py", line 203, in dispatch
    response["result"] = method(self, **self.params)
  File "/home/openerp/web/addons/web/controllers/main.py", line 818, in authenticate
    req.session.authenticate(db, login, password, env)
  File "/home/openerp/web/addons/web/session.py", line 116, in authenticate
    uid = self.proxy('common').authenticate(db, login, password, env)
  File "/home/openerp/web/addons/web/session.py", line 31, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/home/openerp/web/addons/web/session.py", line 104, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)


Server Traceback (most recent call last):
  File "/home/openerp/web/addons/web/session.py", line 90, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/home/openerp/server/openerp/netsvc.py", line 293, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/openerp/server/openerp/service/web_services.py", line 425, in dispatch
    return fn(*params)
  File "/home/openerp/server/openerp/service/web_services.py", line 436, in exp_authenticate
    res_users = pooler.get_pool(db).get('res.users')
  File "/home/openerp/server/openerp/pooler.py", line 49, in get_pool
    return get_db_and_pool(db_name, force_demo, status, update_module)[1]
  File "/home/openerp/server/openerp/pooler.py", line 33, in get_db_and_pool
    registry = RegistryManager.get(db_name, force_demo, status, update_module)
  File "/home/openerp/server/openerp/modules/registry.py", line 192, in get
    update_module)
  File "/home/openerp/server/openerp/modules/registry.py", line 232, in new
    registry.get('ir.actions.report.xml').register_all(cr)
  File "/home/openerp/server/openerp/addons/base/ir/ir_actions.py", line 105, in register_all
    opj('addons',r['report_xml']),
  File "/usr/lib/python2.6/posixpath.py", line 65, in join
    if b.startswith('/'):
AttributeError: 'NoneType' object has no attribute 'startswith'

any help???

it seems that one or some of the xsl:rml report missed the data file: xxx.xml. try the following SQL query to find out: select name, report_name, model, report_xsl, report_xml from ir_act_report_xml where auto=True and report_xsl is not Null and report_xml is Null;

Shine IT Co.,Ltd., Tony Gu
on 3/4/13, 11:21 AM

it says that the xml from cost structure is missing

ed
on 3/5/13, 7:51 AM

name | report_name | model | report_xsl | report_xml ----------------+---------------+-----------------+----------------------+------------ Cost Structure | product.price | product.product | mrp/report/price.xsl |

ed
on 3/5/13, 7:51 AM

how could i fix it ?

ed
on 3/5/13, 7:52 AM

i've looked the file up and it's where it should be....

ed
on 3/5/13, 9:42 AM
2
ton123
On 3/31/13, 2:04 PM

For a restore you need an identical OpenERP installation including installed modules, the same versions of them, python, postgress database, versions of them, used python and other libraries and others and scripts, versions of them, etc. It is very important to document your installation in detail and also to have copies of all installed software etc. Apart from this I have always a hardware backup including a complete installed installation and also a complete installed virtual machine with OpenERP etc. And you need to test a restore every week.

If you do not have your precautions you are in serious trouble. You need an experienced OpenERP consultant to help you out. (I am not an experienced openERP consultant.)

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)

Stats

Asked: 3/3/13, 6:42 PM
Seen: 2820 times
Last updated: 3/16/15, 8:10 AM