This question has been flagged
2 Replies
6510 Views
databaserecover
Avatar
Lars

I have a production version of the ERP system on a Linux palatform and am trying to make a test enviroment on my Windows machine.

After the install I made sure that all my modules are installed and have the latest revison on both platforms. I dump the datatabase from my Linux platform an import it to my windows platform.

At a first glimpse everything looks good but... 1. I can see All my quotes but when going into a quote I get the following error. View error It should note thtat this is a clean install with no modifications on this view. When doing a line to line comparison of the production and the test enviroment the views are identical.

"Can't find field 'carrier_id' in the following view parts composing the view of object model 'sale.order': * delivery.sale.order_withcarrier.form.view

Either you wrongly customized this view, or some modules bringing those views are not compatible with your current data mode"

  1. When i try to open an existing customer I get the following error Client Traceback (most recent call last): File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server\openerp\addons\web\http.py", line 204, in dispatch File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server\openerp\addons\web\controllers\main.py", line 1129, in call_kw File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server\openerp\addons\web\controllers\main.py", line 1121, in _call_kw File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server\openerp\addons\web\session.py", line 43, in proxy File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server\openerp\addons\web\session.py", line 31, in proxy_method File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server\openerp\addons\web\session.py", line 104, in send

Server Traceback (most recent call last): File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server\openerp\addons\web\session.py", line 90, in send File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server.\openerp\netsvc.py", line 293, in dispatch_rpc File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server.\openerp\service\web_services.py", line 626, in dispatch File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server.\openerp\osv\osv.py", line 188, in execute_kw File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server.\openerp\osv\osv.py", line 131, in wrapper File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server.\openerp\osv\osv.py", line 197, in execute File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server.\openerp\osv\osv.py", line 185, in execute_cr File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server\openerp\addons\account_followup\account_followup.py", line 120, in fields_view_get File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server\openerp\addons\base\res\res_partner.py", line 311, in fields_view_get File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server.\openerp\osv\orm.py", line 2260, in fields_view_get File "C:\Program Files (x86)\OpenERP 7.0-20130424-232422\Server\server.\openerp\osv\orm.py", line 1932, in __view_look_dom_arch IndexError: list index out of range.

Can someone point me in the right direction on how to best get the test environment up and running?

Avatar
Discard
Avatar
Gustavo
Best Answer

It looks like there are different versions in your modules. If the installed modules are different, you will not be able to run OpenERP from your backup.

You could run a virtual machine in your Windows box and run Linux inside it. That will make it easier to create your development environment

Avatar
Discard
Lars
Author

The methodology that I started to use is to save the files needed for the installation and a list of all installed modules and customer fields. When installing the same version of OpenERP adding all the custom field checking that all versions are identical the back up restore works fine cross platform. The only drawback is that the backup is much more complex that I initially was hoping for.

Avatar
Lars
Author Best Answer

Thank you for the suggestion. Do you have a proposal on what virtual machine I should install for best result?

My big concern is the following. My plan was to make a backup of the database once a year for legal purpouse (10 year storage requirement). Assume that I get audited after 5 years and I want to recover the 5 year old database backup. Reading the text above it sounds unlikely that I will be able recoever and run the database from Open ERP.

Also, Is there a risk that all my backups will be useless if I find out that I need to install a new module?

What do i need to backup to be able to recover several years old database?

Isn't it a weakness of the open ERP that the installation needs to be totally unchanged to be able to run openERP from the backup?

My expectation was that some fields would be unpopulated or replaced but that the accounting and anccounting transaction should be possible to recover from within OpenERP.

I would hate to print out all infromation that I need to store for 10 years due to legal reason.

Thanks for all your help.

Avatar
Discard
Sean Samborski

Did you ever resolve this? I'm running into the exact same situation on my end where I expected to backup the database (modules and all) and just be able to dump, them restore from the backup and everything works. This is how every single other platform I have ever used works and it's totally unacceptable if the process of backup requires you try and mimic the exact settings of a different time. these settings hould be stored in your backup.

Lars
Author

It was never solved. I managed to make a work around by never changing my system and exporting critical data to excel and testing my backups. This solution have worked up to now when suddenly none of my back ups work any more and I do not know why. I think that this is the weakest point with the system and I think it calls for an urgent action.