Skip to Content
Menú
This question has been flagged
2 Respostes
321 Vistes

Have tried to set in USD $ in the currency rate. And get an error in the database. 
Its not possible. Is it a bug in the Odoo 17. 

Avatar
Descartar

Please post the error, as it probably contains information readers would find helpful when considering how to help you.

Best Answer

Hi,
From the shared message, it seems you have deleted the system generated USD currency and manually created a currency with name USD.

Now when you are trying to upgrade the base module, system trying to create the deleted currency which is USD, in order to solve the error, open the currency menu and search for USD currency and set its external ID as:  base.USD

By setting this external id for existing USD, you can solve the issue.

Other option is two delete the current usd currency (not sure if it is used in db or not), if no delete the currency and upgrade base.


Thanks

Avatar
Descartar
Autor Best Answer

It should be possible to upload pictures here. And the other hand databases is not working correctly. 

Picture create Odoo Error . PLease use copy button to report service. Is quiet stif and database is locked to 
I sent it into odoo aswell per e mail. Such is elementary in any erp system.  

Copy of rpc Erro

Traceback (most recent call last):
  File "/home/odoo/src/odoo/17.0/odoo/service/model.py", line 133, in retrying
    result = func()
  File "/home/odoo/src/odoo/17.0/odoo/http.py", line 1810, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "/home/odoo/src/odoo/17.0/odoo/http.py", line 2014, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "/home/odoo/src/odoo/17.0/addons/website/models/ir_http.py", line 235, in _dispatch
    response = super()._dispatch(endpoint)
  File "/home/odoo/src/odoo/17.0/odoo/addons/base/models/ir_http.py", line 221, in _dispatch
    result = endpoint(**request.params)
  File "/home/odoo/src/odoo/17.0/odoo/http.py", line 757, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "/home/odoo/src/odoo/17.0/addons/web/controllers/dataset.py", line 24, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/home/odoo/src/odoo/17.0/addons/web/controllers/dataset.py", line 20, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/home/odoo/src/odoo/17.0/odoo/api.py", line 468, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "/home/odoo/src/odoo/17.0/odoo/api.py", line 453, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "/home/odoo/src/odoo/17.0/addons/web/models/models.py", line 73, in web_save
    self = self.create(vals)
  File "<decorator-gen-104>", line 2, in create
  File "/home/odoo/src/odoo/17.0/odoo/api.py", line 414, in _model_create_multi
    return create(self, [arg])
  File "/home/odoo/src/odoo/17.0/odoo/addons/base/models/res_currency.py", line 57, in create
    res = super().create(vals_list)
  File "<decorator-gen-12>", line 2, in create
  File "/home/odoo/src/odoo/17.0/odoo/api.py", line 415, in _model_create_multi
    return create(self, arg)
  File "/home/odoo/src/odoo/17.0/odoo/models.py", line 4646, in create
    records = self._create(data_list)
  File "/home/odoo/src/odoo/17.0/odoo/models.py", line 4834, in _create
    cr.execute(SQL(
  File "/home/odoo/src/odoo/17.0/odoo/sql_db.py", line 332, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "res_currency_unique_name"
DETAIL:  Key (name)=(USD) already exists.


During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/odoo/src/odoo/17.0/odoo/http.py", line 1783, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "/home/odoo/src/odoo/17.0/odoo/service/model.py", line 152, in retrying
    raise _as_validation_error(env, exc) from exc
  File "/home/odoo/src/odoo/17.0/odoo/service/model.py", line 111, in _as_validation_error
    translate_sql_constraint(env.cr, exc.diag.constraint_name, env.context.get('lang', 'en_US'))
  File "/home/odoo/src/odoo/17.0/odoo/tools/translate.py", line 442, in translate_sql_constraint
    return cr.fetchone()[0]
TypeError: 'NoneType' object is not subscriptable

The above server error caused the following client error:
RPC_ERROR: Odoo Server Error
    RPC_ERROR
        at makeErrorFromResponse (https://green-iceberg-as-team.odoo.com/web/assets/468fcc3/web.assets_web.min.js:2910:163)
        at XMLHttpRequest.<anonymous> (https://green-iceberg-as-team.odoo.com/web/assets/468fcc3/web.assets_web.min.js:2914:13)


 I updated the data base aswell just now. To see if there are something wrong in the old database for Odoo. 

Avatar
Descartar