Odoo Help

Welcome!

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.

0

KeyError: "Field 'commercial_partner_id' does not exist in object 'browse_record(res.partner, 5)'"

By
JUAN CARLOS SANCHEZ GARCIA
on 5/13/13, 7:19 PM 4,888 views

Does anybody knows about the solve of this problem??, please help

6

Sandeep

--Sandeep--
6083
| 6 5 8
Delhi, India
--Sandeep--
Python OpenERP Developer http://in.linkedin.com/pub/sandeep-rana/3b/a16/786/
Sandeep
On 6/11/13, 7:17 AM

Hi

Try to upgrade base

module again for solving such issue

Thanks

0
Aarne Salminen
On 6/11/13, 7:10 AM

I had the same issue, this happened when demo data was installed. When I installed a clean database every module included with core installed without any problems.

I retested and created a new database importing the demo data again and this issue reproduces itself. So it seems the demo data breaks the database somehow. This error prevents the installation of most default modules so they won't work as they should even if the module shows installed status. For example installing Sales management doesn't bring sales orders under sales and there's a lot of broken data around.

So when you are building a new database do not import the demo data! If you want to see what is where and how it works use Openerps' own demo at Openerp website.

This is the case at least with Windows All-In-One installation. I haven't yet tested serving the software on our own Linux server so I don't know if this same issue is there as well.

0
Harry Cordero
On 5/16/13, 4:08 AM

This is the error that I get charged only basic modules that come with the application associated instalndo the module passes the error but it says it changed to 6 costumber_partner_id and I made a clean installation on but the error remains when I try to convert order in invoice

**OpenERP Server Error

Client Traceback (most recent call last): File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server\openerp\addons\web\http.py", line 203, in dispatch File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server\openerp\addons\web\controllers\main.py", line 1133, in call_button

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server\openerp\addons\web\controllers\main.py", line 1121, in _call_kw

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server\openerp\addons\web\session.py", line 43, in proxy

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server\openerp\addons\web\session.py", line 31, in proxy_method

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\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-20130408-232357\Server\server\openerp\addons\web\session.py", line 90, in send

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\netsvc.py", line 293, in dispatch_rpc

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\service\web_services.py", line 626, in dispatch

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\osv\osv.py", line 188, in execute_kw

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\osv\osv.py", line 131, in wrapper

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\osv\osv.py", line 197, in execute

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\osv\osv.py", line 185, in execute_cr

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server\openerp\addons\sale\wizard\sale_make_invoice_advance.py", line 170, in create_invoices

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server\openerp\addons\sale\sale.py", line 435, in manual_invoice

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\workflow\wkf_service.py", line 119, in trg_validate

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\workflow\instance.py", line 43, in validate

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\workflow\workitem.py", line 60, in process

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\workflow\workitem.py", line 175, in _split_test

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\workflow\workitem.py", line 183, in _join_test

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\workflow\workitem.py", line 40, in create

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\workflow\workitem.py", line 52, in process

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\workflow\workitem.py", line 127, in _execute

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\workflow\wkf_expr.py", line 67, in execute

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\workflow\wkf_expr.py", line 57, in _eval_expr

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\tools\safe_eval.py", line 241, in safe_eval

File "", line 1, in <module>

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\osv\orm.py", line 374, in function_proxy

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server\openerp\addons\sale_stock\sale_stock.py", line 192, in action_invoice_create

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server\openerp\addons\sale\sale.py", line 536, in action_invoice_create

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server\openerp\addons\sale\sale.py", line 404, in _make_invoice

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server\openerp\addons\mail\mail_thread.py", line 242, in create

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\osv\orm.py", line 4478, in create

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\osv\orm.py", line 4627, in _store_set_values

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\osv\fields.py", line 1131, in get

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\osv\fields.py", line 1197, in _fnct_read

File "C:\Program Files (x86)\OpenERP 7.0-20130408-232357\Server\server.\openerp\osv\orm.py", line 383, in __getitem__ KeyError: "Field 'commercial_partner_id' does not exist in object 'browse_record(res.partner, 5)'"**

0

patrick

--patrick--
1958
| 5 4 7
Baarn, Netherlands
--patrick--
patrick
On 5/13/13, 8:28 PM

The error indicates that in the table res.partner the field commercial_partner_id is missing.

Mising fields in a table usually indicates the installation of a downloaded module, which is not complete correctly; or the installation of a custom module made by the user.

When you create a module, and install it, and then modify your module, you have to take some steps to let openERP know the updated module.

Can you tell us, what you have installed, and how you did it? Than we are able to give more help.

Another thing you might want to do is to search in this forum how to upgrade an existing module.

Than you....but I only install the default modules by OpenERP¡¡...I don´t know why suddenly can´t transfer sales order to invoices.

JUAN CARLOS SANCHEZ GARCIA
on 5/13/13, 9:11 PM

I have the same issue. i also installed the default module.

Remya
on 5/14/13, 2:05 AM

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

3 follower(s)

Stats

Asked: 5/13/13, 7:19 PM
Seen: 4888 times
Last updated: 3/16/15, 8:10 AM