odoo 12 - no puedo sacar mayor ni balance de sumas y saldos

[Fernando Garcia Hansen - Humanoide]

Hola a todos:

En un odoo 12 con SII , no puedo sacar mayor ni balance de sumas y saldos

odoo 12 - no puedo sacar mayor ni balance de sumas y saldos

Error:

Odoo Server Error

Traceback (most recent call last):

  File "/opt/odoo/odoo-server/odoo/http.py", line 656, in _handle_exception

    return super(JsonRequest, self)._handle_exception(exception)

  File "/opt/odoo/odoo-server/odoo/http.py", line 314, in _handle_exception

    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])

  File "/opt/odoo/odoo-server/odoo/tools/pycompat.py", line 87, in reraise

    raise value

  File "/opt/odoo/odoo-server/odoo/http.py", line 698, in dispatch

    result = self._call_function(**self.params)

  File "/opt/odoo/odoo-server/odoo/http.py", line 346, in _call_function

    return checked_call(self.db, *args, **kwargs)

  File "/opt/odoo/odoo-server/odoo/service/model.py", line 98, in wrapper

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

  File "/opt/odoo/odoo-server/odoo/http.py", line 339, in checked_call

    result = self.endpoint(*a, **kw)

  File "/opt/odoo/odoo-server/odoo/http.py", line 941, in __call__

    return self.method(*args, **kw)

  File "/opt/odoo/odoo-server/odoo/http.py", line 519, in response_wrap

    response = f(*args, **kw)

  File "/opt/odoo/odoo-server/addons/web/controllers/main.py", line 967, in call_button

    action = self._call_kw(model, method, args, {})

  File "/opt/odoo/odoo-server/addons/web/controllers/main.py", line 955, in _call_kw

    return call_kw(request.env[model], method, args, kwargs)

  File "/opt/odoo/odoo-server/odoo/api.py", line 759, in call_kw

    return _call_kw_multi(method, model, args, kwargs)

  File "/opt/odoo/odoo-server/odoo/api.py", line 746, in _call_kw_multi

    result = method(recs, *args, **kwargs)

  File "/opt/odoo/account-financial-reporting/account_financial_report/wizard/trial_balance_wizard.py", line 199, in button_export_html

    report.compute_data_for_report()

  File "/opt/odoo/account-financial-reporting/account_financial_report/report/trial_balance.py", line 262, in compute_data_for_report

    self._prepare_report_general_ledger(account_ids)

  File "<decorator-gen-3>", line 2, in create

  File "/opt/odoo/odoo-server/odoo/api.py", line 461, in _model_create_multi

    return create(self, [arg])

  File "/opt/odoo/odoo-server/odoo/models.py", line 3603, in create

    records = self._create(data_list)

  File "/opt/odoo/odoo-server/odoo/models.py", line 3703, in _create

    cr.execute(query, params)

  File "/opt/odoo/odoo-server/odoo/sql_db.py", line 148, in wrapper

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

  File "/opt/odoo/odoo-server/odoo/sql_db.py", line 225, in execute

    res = self._obj.execute(query, params)

psycopg2.ProgrammingError: column "partner_ungrouped" of relation "report_general_ledger" does not exist

LINE 1: ..._date", "hide_account_at_0", "only_posted_moves", "partner_u...

                                                             ^

[Gonzalo Borras]

Tienes un módulo sin actualizar. Prueba un update all y debería de funcionar sin problemas.

--
Has recibido este mensaje porque estás suscrito al grupo "Usuarios Odoo / OpenERP en España" de Grupos de Google.
Para cancelar la suscripción a este grupo y dejar de recibir sus mensajes, envía un correo electrónico a openerp-spain-u...@googlegroups.com.
Para ver esta conversación en el sitio web, visita https://groups.google.com/d/msgid/openerp-spain-users/32ee8a53-66ae-4756-88a9-bfcda7019bdan%40googlegroups.com.

[Fernando Garcia Hansen - Humanoide]

Hola, gracias por contestar.

Al hacer update all me da estos errores, no se que quiere decir

2021-02-05 17:34:11,833 1151 ERROR pescanovahoreca odoo.http: Exception during JSON request handling. 

2021-02-05 18:07:03,126 2498 ERROR pescanovahoreca odoo.sql_db: bad query: INSERT INTO "ir_config_parameter" ("id", "create_uid", "create_date", "write_uid", "write_date", "key", "value") VALUES (nextval('ir_config_parameter_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), 'mail.catchall.alias', 'catchall') RETURNING id

ERROR: duplicate key value violates unique constraint "ir_config_parameter_key_uniq"

2021-02-05 18:07:03,145 2498 ERROR pescanovahoreca odoo.modules.registry: Failed to load registry 

psycopg2.IntegrityError: duplicate key value violates unique constraint "ir_config_parameter_key_uniq"

odoo.tools.convert.ParseError: "duplicate key value violates unique constraint "ir_config_parameter_key_uniq"

psycopg2.IntegrityError: duplicate key value violates unique constraint "ir_config_parameter_key_uniq"

odoo.tools.convert.ParseError: "duplicate key value violates unique constraint "ir_config_parameter_key_uniq"

[Fernando Garcia Hansen - Humanoide]

Y al arrancar y pulsar el menu de contabilidad para acutalizar el plan de cuentas, se rompe todo y no puedes actualizar el plan de cuentas

Odoo Server ErrorTraceback (most recent call last): File "/opt/odoo/odoo-server/odoo/tools/cache.py", line 88, in lookup r = d[key] File "/opt/odoo/odoo-server/odoo/tools/func.py", line 69, in wrapper return func(self, *args, **kwargs) File "/opt/odoo/odoo-server/odoo/tools/lru.py", line 44, in __getitem__ a = self.d[obj].me KeyError: ('ir.actions.actions', <function IrActions.get_bindings at 0x7f3550c08ea0>, frozenset({1, 2, 3, 6, 7, 8, 11, 12, 14, 16, 17, 18, 19, 20, 21, 27, 28, 29, 30, 34, 35, 42, 43, 45, 46, 48, 49, 53, 54, 55, 56, 59, 60, 61, 62, 65, 66, 68, 70, 71, 76, 77, 78, 79}), 'account.journal') During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/opt/odoo/odoo-server/odoo/api.py", line 1049, in get value = self._data[key][field][record._ids[0]] KeyError: 344 During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/opt/odoo/odoo-server/odoo/fields.py", line 1063, in __get__ value = record.env.cache.get(record, self) File "/opt/odoo/odoo-server/odoo/api.py", line 1051, in get raise CacheMiss(record, field) odoo.exceptions.CacheMiss: ('ir.actions.act_window(344,).search_view', None) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/opt/odoo/odoo-server/odoo/http.py", line 656, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/opt/odoo/odoo-server/odoo/http.py", line 314, in _handle_exception raise pycompat.reraise(type(exception), exception, sys.exc_info()[2]) File "/opt/odoo/odoo-server/odoo/tools/pycompat.py", line 87, in reraise raise value File "/opt/odoo/odoo-server/odoo/http.py", line 698, in dispatch result = self._call_function(**self.params) File "/opt/odoo/odoo-server/odoo/http.py", line 346, in _call_function return checked_call(self.db, *args, **kwargs) File "/opt/odoo/odoo-server/odoo/service/model.py", line 98, in wrapper return f(dbname, *args, **kwargs) File "/opt/odoo/odoo-server/odoo/http.py", line 339, in checked_call result = self.endpoint(*a, **kw) File "/opt/odoo/odoo-server/odoo/http.py", line 941, in __call__ return self.method(*args, **kw) File "/opt/odoo/odoo-server/odoo/http.py", line 519, in response_wrap response = f(*args, **kw) File "/opt/odoo/odoo-server/addons/web/controllers/main.py", line 963, in call_kw return self._call_kw(model, method, args, kwargs) File "/opt/odoo/odoo-server/addons/web/controllers/main.py", line 955, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/opt/odoo/odoo-server/odoo/api.py", line 755, in call_kw return _call_kw_model(method, model, args, kwargs) File "/opt/odoo/odoo-server/odoo/api.py", line 728, in _call_kw_model result = method(recs, *args, **kwargs) File "/opt/odoo/odoo-server/odoo/models.py", line 1396, in load_views for [v_id, v_type] in views File "/opt/odoo/odoo-server/odoo/models.py", line 1396, in <dictcomp> for [v_id, v_type] in views File "/opt/odoo/odoo-server/odoo/models.py", line 1488, in fields_view_get bindings = self.env['ir.actions.actions'].get_bindings(self._name) File "<decorator-gen-36>", line 2, in get_bindings File "/opt/odoo/odoo-server/odoo/tools/cache.py", line 93, in lookup value = d[key] = self.method(*args, **kwargs) File "/opt/odoo/odoo-server/odoo/addons/base/models/ir_actions.py", line 112, in get_bindings result[binding_type].append(action.read()[0]) File "/opt/odoo/odoo-server/odoo/addons/base/models/ir_actions.py", line 200, in read result = super(IrActionsActWindow, self).read(fields, load=load) File "/opt/odoo/odoo-server/odoo/models.py", line 2835, in read vals[name] = convert(record[name], record, use_name_get) File "/opt/odoo/odoo-server/odoo/models.py", line 5167, in __getitem__ return self._fields[key].__get__(self, type(self)) File "/opt/odoo/odoo-server/odoo/fields.py", line 1067, in __get__ self.determine_value(record) File "/opt/odoo/odoo-server/odoo/fields.py", line 1180, in determine_value self.compute_value(recs) File "/opt/odoo/odoo-server/odoo/fields.py", line 1134, in compute_value self._compute_value(records) File "/opt/odoo/odoo-server/odoo/fields.py", line 1125, in _compute_value getattr(records, self.compute)() File "/opt/odoo/odoo-server/odoo/addons/base/models/ir_actions.py", line 160, in _compute_search_view fvg = self.env[act.res_model].fields_view_get(act.search_view_id.id, 'search') File "/opt/odoo/bank-payment/account_payment_order/models/account_move_line.py", line 102, in fields_view_get submenu=submenu) File "/opt/odoo/account-payment/account_due_list/models/account_move_line.py", line 62, in fields_view_get view_id, view_type, toolbar=toolbar, submenu=submenu) File "/opt/odoo/odoo-server/odoo/models.py", line 1482, in fields_view_get xarch, xfields = View.postprocess_and_fields(self._name, etree.fromstring(result['arch']), view_id) File "/opt/odoo/odoo-server/odoo/addons/base/models/ir_ui_view.py", line 1138, in postprocess_and_fields self.raise_view_error(message, view_id) File "/opt/odoo/odoo-server/odoo/addons/base/models/ir_ui_view.py", line 568, in raise_view_error raise ValueError(message) ValueError: El campo `asset_id` no existe Contexto del error: Vista `n/a` [view_id: n/a, xml_id: n/a, model: n/a, parent_id: n/a]  

[Fernando Garcia Hansen - Humanoide]

Se arregló volviendo a la copia, y actualizando el modulo  financial reports pero sin hacer git pull. Gracias gborr