Odoo Help


[SOLVED]Error while opening preferences

Jignesh Mehta
on 6/2/16, 5:59 AM 1,213 views


I have restore a database. and after upgrade all the modules.

But when i open any user's preferences, below error is occurred.

Error :-

Odoo Server Error
Traceback (most recent call last):
 [Errno 2] No such file or directory: 

Update :-

ProgrammingError: relation "ir_model_data_model_res_id_index" already exists

Solved :-

Delete all the attachment from database through pgadmin and upgrade all modules.

Thanks in advance.


Jérémy Kersten (jke)

--Jérémy Kersten (jke)--

| 3 3 5
Jodoigne, Belgium
--Jérémy Kersten (jke)--

Jérémy is a member of the core R&D team since september 2013. He developed several projects for OpenERP version 8 including the eCommerce, the Google Calendar synchronization and the new product variants/configurator. Now, he manages Odoo website and themes for saas.

Jérémy Kersten (jke)
On 6/2/16, 6:50 AM

It'is probably asset from web client,

You can also delete your attachment where name contains ".assets_"*.JS & *.css

There will be regenerated.

Hello jke, can't understand what are you saying. Can you please elaborate? Thanks,

Jignesh Mehta
on 6/2/16, 6:55 AM

After some reflexion, if it is only in preference and not in all the web client, that proabably not a problem of assets.
Assets are frequently regenerated, so it's not impossible that between your db dump and your filestore dump, the file is no more present. In this case, you can in the databse remove the ir_attachment with name .assets_ (eg: web.asset_frontend.js' ) to force Odoo to geneate a new assets...

Jérémy Kersten (jke)
on 6/2/16, 6:59 AM

Like suggest @bipin said, did you restore your filestore ?

Jérémy Kersten (jke)
on 6/2/16, 7:00 AM
Bipin rathod
On 6/2/16, 6:34 AM

Hello Jignesh,


you can see that, the error comes from filestore, it means you have restored the DB but didn't put your filestore directory in your odoo directory, please copy your filestore and put it on odoo directory it will works.

Hope, this will help you.


Hello Bipin, filestore folder is already in the odoo directory.

Jignesh Mehta
on 6/2/16, 6:56 AM

Is that, same odoo source ? because, if you are using the same source of odoo, filestore will be same, but if you changed the source, you need to copy your old filestore to new source.

Bipin rathod
on 6/2/16, 7:00 AM

Hello Bipin, All the filestore copy and paste in odoo directory. But when go for upgrade all, the error will occurred which is in my updated question.

Jignesh Mehta
on 6/2/16, 7:25 AM

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.


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

2 follower(s)


Asked: 6/2/16, 5:59 AM
Seen: 1213 times
Last updated: 6/2/16, 8:22 AM