Odoo Help


This community 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.


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

on 3/3/13, 6:42 PM 2,299 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
  File "/home/openerp/server/openerp/modules/registry.py", line 232, in new
  File "/home/openerp/server/openerp/addons/base/ir/ir_actions.py", line 105, in register_all
  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

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 |

on 3/5/13, 7:51 AM

how could i fix it ?

on 3/5/13, 7:52 AM

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

on 3/5/13, 9:42 AM


| 5 6 9
Lisse, Netherlands
End-User. Installed 6.1.1 on a DS412+, DS211+ and DS113J Synology NAS. Reference installation on Ubuntu 12.04/Samsung Notebook. 12-03-2013 In production for Suppliers and Customers, adresbook. 7 small companies. Testing accounting, document management, import and export. Too much showstoppers I haven't fixed at this moment. 06-05-2013 little progress. Migration to v7 impossible because of missing Dutch localisation modules. What I see working is nice, so further testing and asking. Start testing products and warehouse. Happy with this forum and the community.
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.)

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)


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