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

Unable to export all leads on user login.

By
divya
on 6/16/15, 5:34 AM 644 views

When i login through Admin all leads are exporting but, through user login when Export All Data of leads iam getting this error, please do the needful. i gave the sale/ manager rights to this user but no use,


2015-06-16 09:33:25,897 12031 INFO 12-june-2015 werkzeug: 127.0.0.1 - - [16/Jun/2015 09:33:25] "POST /web/export/namelist HTTP/1.1" 200 -

2015-06-16 09:33:27,686 12031 WARNING 12-june-2015 openerp.osv.orm: Access Denied by record rules for operation: read, uid: 33, model: res.users

2015-06-16 09:33:27,687 12031 INFO 12-june-2015 openerp.osv.orm: Prefetching attempt for fields ['menu_id', 'alias_id', 'share', 'default_section_id', 'active', 'password', 'partner_id', 'id', 'login_date', 'company_id', 'signature', 'login', 'action_id', 'ean13', 'alias_defaults', 'x_technical_person', 'x_comment', 'display_name', 'opt_out', 'title', 'company_id', 'supdate', 'parent_id', 'last_reconciliation_date', 'employee', 'fax', 'lastname', 'x_other_phone', 'x_location', 'name', 'debit_limit', 'signup_token', 'db_server', 'additional_notes', 'street', 'payment_next_action_date', 'alias_name', u'x_nickname', 'country_id', 'notification_email_send', 'supplier', 'ref', 'email', 'picking_warn', 'street2', 'active', 'tz', 'signup_expiration', 'vat_subjected', 'zip', 'alias_user_id', 'x_sale_repo', 'payment_next_action', 'alias_model_id', 'payment_note', 'comment', 'sale_warn', 'purchase_warn', 'color', 'city', 'user_id', 'alias_force_thread_id', 'type', 'function', 'picking_warn_msg', 'phone', 'payment_responsible_id', 'customer', 'pacs', 'birthdate', 'cust_status', 'vat', 'state_id', 'invoice_warn_msg', 'website', 'remote_conn', 'use_parent_address', 'sale_warn_msg', 'signup_type', 'invoice_warn', 'x_department', 'is_company', 'sitelic', 'firstname', 'section_id', 'date', 'lang', 'credit_limit', 'purchase_warn_msg', 'mobile', 'x_location_name', 'x_work_phone'] on res.users failed for ids [1, 36, 37, 6, 33, 40, 39, 14, 22, 279, 25, 252], re-trying just for id 279

2015-06-16 09:33:27,891 12031 WARNING 12-june-2015 openerp.osv.orm: Access Denied by record rules for operation: read, uid: 33, model: res.partner

2015-06-16 09:33:27,891 12031 INFO 12-june-2015 openerp.osv.orm: Prefetching attempt for fields ['ean13', 'x_technical_person', 'x_comment', 'tz', 'opt_out', 'title', 'company_id', 'supdate', 'parent_id', 'last_reconciliation_date', u'x_nickname', 'employee', 'fax', 'lastname', 'supplier', 'name', 'debit_limit', 'signup_token', 'db_server', 'additional_notes', 'street', 'payment_next_action_date', 'firstname', 'country_id', 'notification_email_send', 'x_other_phone', 'x_location', 'ref', 'email', 'picking_warn', 'street2', 'mobile', 'active', 'display_name', 'signup_expiration', 'x_sale_repo', 'payment_next_action', 'payment_note', 'comment', 'sale_warn', 'purchase_warn', 'color', 'city', 'user_id', 'zip', 'type', 'function', 'picking_warn_msg', 'vat', 'phone', 'payment_responsible_id', 'customer', 'pacs', 'birthdate', 'cust_status', 'state_id', 'invoice_warn_msg', 'website', 'remote_conn', 'use_parent_address', 'signup_type', 'date', 'invoice_warn', 'x_department', 'is_company', 'sitelic', 'vat_subjected', 'section_id', 'lang', 'credit_limit', 'purchase_warn_msg', 'x_location_name', 'x_work_phone', 'sale_warn_msg'] on res.partner failed for ids [17888, 15936, 3, 1046, 5287, 5290, 5291, 12, 1005, 93, 5293, 15915, 16054, 15069], re-trying just for id 17888

2015-06-16 09:33:27,939 12031 WARNING 12-june-2015 openerp.osv.orm: Access Denied by record rules for operation: read, uid: 33, model: res.users

2015-06-16 09:33:27,940 12031 INFO 12-june-2015 openerp.osv.orm: Prefetching attempt for fields ['menu_id', 'alias_id', 'share', 'default_section_id', 'active', 'password', 'partner_id', 'id', 'login_date', 'company_id', 'signature', 'login', 'action_id', 'ean13', 'alias_defaults', 'x_technical_person', 'x_comment', 'display_name', 'opt_out', 'title', 'company_id', 'supdate', 'parent_id', 'last_reconciliation_date', 'employee', 'fax', 'lastname', 'x_other_phone', 'x_location', 'name', 'debit_limit', 'signup_token', 'db_server', 'additional_notes', 'street', 'payment_next_action_date', 'alias_name', u'x_nickname', 'country_id', 'notification_email_send', 'supplier', 'ref', 'email', 'picking_warn', 'street2', 'active', 'tz', 'signup_expiration', 'vat_subjected', 'zip', 'alias_user_id', 'x_sale_repo', 'payment_next_action', 'alias_model_id', 'payment_note', 'comment', 'sale_warn', 'purchase_warn', 'color', 'city', 'user_id', 'alias_force_thread_id', 'type', 'function', 'picking_warn_msg', 'phone', 'payment_responsible_id', 'customer', 'pacs', 'birthdate', 'cust_status', 'vat', 'state_id', 'invoice_warn_msg', 'website', 'remote_conn', 'use_parent_address', 'sale_warn_msg', 'signup_type', 'invoice_warn', 'x_department', 'is_company', 'sitelic', 'firstname', 'section_id', 'date', 'lang', 'credit_limit', 'purchase_warn_msg', 'mobile', 'x_location_name', 'x_work_phone'] on res.users failed for ids [1, 36, 37, 6, 33, 40, 39, 14, 22, 25, 252], re-trying just for id 252

2015-06-16 09:33:27,946 12031 WARNING 12-june-2015 openerp.osv.orm: Access Denied by record rules for operation: read, uid: 33, model: res.users

2015-06-16 09:33:27,948 12031 ERROR 12-june-2015 openerp.netsvc: Access Denied

The requested operation cannot be completed due to security restrictions. Please contact your system administrator.

(Document type: Users, Operation: read)

Traceback (most recent call last):

File "/home/endo/Openerp_v7/openerp/netsvc.py", line 296, in dispatch_rpc

result = ExportService.getService(service_name).dispatch(method, params)

File "/home/endo/Openerp_v7/openerp/service/web_services.py", line 626, in dispatch

res = fn(db, uid, *params)

File "/home/endo/Openerp_v7/openerp/osv/osv.py", line 190, in execute_kw

return self.execute(db, uid, obj, method, *args, **kw or {})

File "/home/endo/Openerp_v7/openerp/osv/osv.py", line 132, in wrapper

return f(self, dbname, *args, **kwargs)

File "/home/endo/Openerp_v7/openerp/osv/osv.py", line 199, in execute

res = self.execute_cr(cr, uid, obj, method, *args, **kw)

File "/home/endo/Openerp_v7/openerp/osv/osv.py", line 187, in execute_cr

return getattr(object, method)(cr, uid, *args, **kw)

File "/home/endo/Openerp_v7/openerp/osv/orm.py", line 1248, in export_data

datas += self.__export_row(cr, uid, row, fields_to_export, context)

File "/home/endo/Openerp_v7/openerp/osv/orm.py", line 1165, in __export_row

r = r[f[i]]

File "/home/endo/Openerp_v7/openerp/osv/orm.py", line 412, in __getitem__

field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")

File "/home/endo/Openerp_v7/openerp/addons/base/res/res_users.py", line 831, in read

res = super(users_view, self).read(cr, uid, ids, fields, context=context, load=load)

File "/home/endo/Openerp_v7/openerp/addons/base/res/res_users.py", line 292, in read

result = super(res_users, self).read(cr, uid, ids, fields=fields, context=context, load=load)

File "/home/endo/Openerp_v7/openerp/osv/orm.py", line 3679, in read

result = self._read_flat(cr, user, select, fields, context, load)

File "/home/endo/Openerp_v7/openerp/osv/orm.py", line 3734, in _read_flat

self._check_record_rules_result_count(cr, user, sub_ids, result_ids, 'read', context=context)

File "/home/endo/Openerp_v7/openerp/osv/orm.py", line 3938, in _check_record_rules_result_count

(self._description, operation))

except_osv: (u'Access Denied', u'The requested operation cannot be completed due to security restrictions. Please contact your system administrator.\n\n(Document type: Users, Operation: read)')

2015-06-16 09:33:27,950 12031 INFO 12-june-2015 werkzeug: 127.0.0.1 - - [16/Jun/2015 09:33:27] "POST /web/export/csv HTTP/1.1" 500 -



0
matt crouch
On 3/23/16, 1:12 PM

Your user does not have permission to access certain models. In particular, I notice an inability to read: 

res.users

res.partner

You can correct this by increasing the permissions level of the user in at least two ways. First, you can add the user to a pre-made group which has the ability to read those models. In stock Odoo, this will be most groups - if you have the sale and crm modules installed, the group would be 'Sales: See all leads.' Second, you can find what groups the user is already in, and increase the permission level at the model level (worse approach). To do do, AS THE ADMINISTRATOR, go to settings -> technical -> database structure -> models, and search for res.partner and res.users (I am also assuming you have already enabled viewing the technical settings) .

Once you are looking at each model, there is a tab named 'access rights.'  Here you can add new groups, or change permissions of existing groups so that they can read it. You will need to add a group that the user in question is already a member of in order for this to be effective. 

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

1 follower(s)

Stats

Asked: 6/16/15, 5:34 AM
Seen: 644 times
Last updated: 3/23/16, 1:12 PM