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

HR Expense module set up failed : I can't login anymore

By
Philippe LAURENCE
on 3/1/14, 12:19 AM 2,633 views

Hello,

I was trying to install de HR Expense module but the installation failed.

Now I can't connect to the database anymore.

The HR Expense module works fine on my other database. I restart the server, try to connect with several users and navigators.

I don't know how I can create a mail.group_all_employees item without being able to connect.

This is the error I get when I try to login :

    Client Traceback (most recent call last):
  File "/opt/openerp/server/openerp/addons/web/http.py", line 195, in dispatch
    response["result"] = method(self, **self.params)
  File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 818, in authenticate
    req.session.authenticate(db, login, password, env)
  File "/opt/openerp/server/openerp/addons/web/session.py", line 116, in authenticate
    uid = self.proxy('common').authenticate(db, login, password, env)
  File "/opt/openerp/server/openerp/addons/web/session.py", line 31, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/opt/openerp/server/openerp/addons/web/session.py", line 104, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)


Server Traceback (most recent call last):
  File "/opt/openerp/server/openerp/addons/web/session.py", line 90, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/opt/openerp/server/openerp/netsvc.py", line 295, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/openerp/server/openerp/service/web_services.py", line 425, in dispatch
    return fn(*params)
  File "/opt/openerp/server/openerp/service/web_services.py", line 436, in exp_authenticate
    res_users = pooler.get_pool(db).get('res.users')
  File "/opt/openerp/server/openerp/pooler.py", line 49, in get_pool
    return get_db_and_pool(db_name, force_demo, status, update_module)[1]
  File "/opt/openerp/server/openerp/pooler.py", line 33, in get_db_and_pool
    registry = RegistryManager.get(db_name, force_demo, status, update_module)
  File "/opt/openerp/server/openerp/modules/registry.py", line 192, in get
    update_module)
  File "/opt/openerp/server/openerp/modules/registry.py", line 214, in new
    openerp.modules.load_modules(registry.db, force_demo, status, update_module)
  File "/opt/openerp/server/openerp/modules/loading.py", line 343, in load_modules
    processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules, update_module)
  File "/opt/openerp/server/openerp/modules/loading.py", line 258, in load_marked_modules
    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
  File "/opt/openerp/server/openerp/modules/loading.py", line 190, in load_module_graph
    load_data(module_name, idref, mode)
  File "/opt/openerp/server/openerp/modules/loading.py", line 75, in <lambda>
    load_data = lambda *args: _load_data(cr, *args, kind='data')
  File "/opt/openerp/server/openerp/modules/loading.py", line 126, in _load_data
    tools.convert_xml_import(cr, module_name, fp, idref, mode, noupdate, report)
  File "/opt/openerp/server/openerp/tools/convert.py", line 954, in convert_xml_import
    obj.parse(doc.getroot())
  File "/opt/openerp/server/openerp/tools/convert.py", line 847, in parse
    self._tags[rec.tag](self.cr, rec, n)
  File "/opt/openerp/server/openerp/tools/convert.py", line 805, in _tag_record
    f_val = self.id_get(cr, f_ref)
  File "/opt/openerp/server/openerp/tools/convert.py", line 824, in id_get
    res = self.model_id_get(cr, id_str)
  File "/opt/openerp/server/openerp/tools/convert.py", line 833, in model_id_get
    return model_data_obj.get_object_reference(cr, self.uid, mod, id_str)
  File "/opt/openerp/server/openerp/tools/cache.py", line 18, in lookup
    r = self.lookup(self2, cr, *args)
  File "/opt/openerp/server/openerp/tools/cache.py", line 46, in lookup
    value = d[key] = self.method(self2, cr, *args)
  File "/opt/openerp/server/openerp/addons/base/ir/ir_model.py", line 861, in get_object_reference
    data_id = self._get_id(cr, uid, module, xml_id)
  File "/opt/openerp/server/openerp/tools/cache.py", line 18, in lookup
    r = self.lookup(self2, cr, *args)
  File "/opt/openerp/server/openerp/tools/cache.py", line 46, in lookup
    value = d[key] = self.method(self2, cr, *args)
  File "/opt/openerp/server/openerp/addons/base/ir/ir_model.py", line 854, in _get_id
    raise ValueError('No such external ID currently defined in the system: %s.%s' % (module, xml_id))
ValueError: No such external ID currently defined in the system: mail.group_all_employees

Thanks for your help.

Best,

Philippe.

Please check the log file of openerp. So that you can easily know, which file shows error.

Remya
on 3/1/14, 3:40 AM
0
Mariusz Mizgier
On 3/1/14, 8:51 AM

Comment out that record so that restarting server will not try to send out that message to whole company group.

Thanks. It worked. I was able to login but the CRM module and HR modules were not available.

At least we could continue without the HR modules.

Philippe LAURENCE
on 3/1/14, 6:42 PM
0

Serpent Consulting Services Pvt. Ltd.

--Serpent Consulting Services Pvt. Ltd.--
4341
| 6 6 8
Gandhinagar, India
--Serpent Consulting Services Pvt. Ltd.--

Serpent Consulting Services Pvt. Ltd. Your Odoo/OpenERP Solution, just an email away!

Serpent Consulting Services Pvt. Ltd.
On 3/7/14, 12:38 PM

It seems that you have removed the group from the system and hence the xml record exists but the real DB reference does not exist.

In order to solve, please upgrade the mail/ base module.

Thanks.

Hello, thanks for your answer. I try to upgrade the plugin but I had a new error :

File "/opt/openerp/server/openerp/addons/mail/mail_message.py", line 81, in _get_record_name result[message['id']] = self.pool.get(message['model']).name_get(cr, SUPERUSER_ID, [message['res_id']], context=context)[0][1] IndexError: list index out of range

Philippe LAURENCE
on 3/7/14, 4:46 PM

Hi Philippe LAURENCE, did you solve this error.

sridhar
on 4/17/14, 3:57 AM

Hello,

It's solved indeed.

I updated manually OpenERP, but when I updated the database, I had errors with the xml part of every addons which call mail.group_all_employee. I deleted the few lines in every xml report and the databse was updated sucessfully. When I restart the openERP server, the HR plugin was correctly set up.

Since I updated manually and there were no errors during the database update.

Philippe LAURENCE
on 4/17/14, 10:03 AM

Ok, I got this error, now only i solved.

sridhar
on 4/17/14, 10:12 AM
0

Med Said BARA

--Med Said BARA--
2664
| 5 5 7
Algeria
--Med Said BARA--
Med Said BARA
On 3/1/14, 9:56 AM

Hi;

You say "I don't understand why it's the CRM module and not the HR_Expense which is reported. But how can I solve this without login ?:

This is because, after installation " a message will be send to all employees Announcing that a New Module HR_EXPENSE" has been installed .... this is stated in he_expense_data.xml

We can find the same operation in many others modules (e.g crm file crm_data.xml , event file event_data.xml , hr_evaluation file hr_evaluation_data.xml ......)

Restore the deleted group " Whole company".

Question: From where did you delete this group ? I will show you how to restore it.

Here after the steps to recreate the "whole company" group:

  1. Click on " Join Group"

  2. Click on "Create" button

  3. Edit The Group Name as "Whole Company"

    As lias put "group+whole-company"

    and for Topics Discussed in this Group .... "General announces for all employees."

  4. For Privacy choose " selected Group Only"

  5. For Authorized group choose "Human Resources/Emplyee"

  6. For Autosubscriptions choose "Human resources/Employee"

SAVE and that's all.

Hi,

Thanks for you answer.

I deleted it from the web interface, in the group management tab.

Philippe LAURENCE
on 3/1/14, 11:23 AM

I really can't see where. Give us more details "Which Menu" or "Submenu" or "View" ...

Med Said BARA
on 3/1/14, 1:47 PM

I was in the Join group submenu in kanban view, I selected the whole company group and in the form view I deleted it thank of options menu.

Philippe LAURENCE
on 3/1/14, 2:28 PM

I created the whole Company Group but no change. But I went in the technical part of the admin panel and external ID, Then I created a group_all_employee with a mail module to have a mail.group_all_employee.

Now the CRM works like before but OpenERP didn't manage to install the HR modules with a new error. I will try to set up manually what the modules need

Philippe LAURENCE
on 3/1/14, 6:41 PM

Don't do that. the "mail.group" already exist it's in the " Access control List".

Med Said BARA
on 3/1/14, 7:25 PM

I didn't have a mail.group_all_employee in Acces Control List.

There is : mail.group_all and mail.group_user

Philippe LAURENCE
on 3/3/14, 5:47 AM
0
Philippe LAURENCE
On 3/1/14, 8:40 AM

I updated manually OpenERP, but when I updated the database, I had errors with the xml part of every addons which call mail.group_all_employee.

I deleted the few lines in every xml report and the databse was updated sucessfully. When I restart the openERP server, the HR plugin was correctly set up.

Since I updated manually and there were no errors during the database update.

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)

Stats

Asked: 3/1/14, 12:19 AM
Seen: 2633 times
Last updated: 3/16/15, 8:10 AM