Erro ao criar fatura - Odoo 14

[brunobronks]

Boa tarde,

Quando tento criar uma fatura, ocorre o seguinte erro:

Odoo Server Error

Traceback (most recent call last):
File "/home/bruno/odoo/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
result = request.dispatch()
File "/home/bruno/odoo/odoo/http.py", line 683, in dispatch
result = self._call_function(**self.params)
File "/home/bruno/odoo/odoo/http.py", line 359, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/home/bruno/odoo/odoo/service/model.py", line 94, in wrapper
return f(dbname, *args, **kwargs)
File "/home/bruno/odoo/odoo/http.py", line 347, in checked_call
result = self.endpoint(*a, **kw)
File "/home/bruno/odoo/odoo/http.py", line 912, in call
return self.method(*args, **kw)
File "/home/bruno/odoo/odoo/http.py", line 531, in response_wrap
response = f(*args, **kw)
File "/home/bruno/odoo/addons/web/controllers/main.py", line 1393, in call_button
action = self._call_kw(model, method, args, kwargs)
File "/home/bruno/odoo/addons/web/controllers/main.py", line 1381, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/home/bruno/odoo/odoo/api.py", line 396, in call_kw
result = _call_kw_multi(method, model, args, kwargs)
File "/home/bruno/odoo/odoo/api.py", line 383, in _call_kw_multi
result = method(recs, *args, **kwargs)
File "/home/bruno/odoo/addons/sale/wizard/sale_make_invoice_advance.py", line 183, in create_invoices
self._create_invoice(order, so_line, amount)
File "/home/bruno/odoo/addons/sale/wizard/sale_make_invoice_advance.py", line 131, in _create_invoice
invoice = self.env['account.move'].sudo().create(invoice_vals).with_user(self.env.uid)
File "/usr/local/lib/python3.6/dist-packages/decorator.py", line 232, in fun
return caller(func, *(extras + args), **kw)
File "/home/bruno/odoo/odoo/api.py", line 344, in _model_create_multi
return create(self, [arg])
File "/home/bruno/odoo/addons/purchase/models/account_invoice.py", line 102, in create
moves = super(AccountMove, self).create(vals_list)
File "/usr/local/lib/python3.6/dist-packages/decorator.py", line 232, in fun
return caller(func, *(extras + args), **kw)
File "/home/bruno/odoo/odoo/api.py", line 345, in _model_create_multi
return create(self, arg)
File "/home/bruno/odoo/addons/account/models/account_move.py", line 1846, in create
rslt = super(AccountMove, self).create(vals_list)
File "/usr/local/lib/python3.6/dist-packages/decorator.py", line 232, in fun
return caller(func, *(extras + args), **kw)
File "/home/bruno/odoo/odoo/api.py", line 345, in _model_create_multi
return create(self, arg)
File "/home/bruno/odoo/addons/mail/models/mail_thread.py", line 264, in create
threads = super(MailThread, self).create(vals_list)
File "/usr/local/lib/python3.6/dist-packages/decorator.py", line 232, in fun
return caller(func, *(extras + args), **kw)
File "/home/bruno/odoo/odoo/api.py", line 345, in _model_create_multi
return create(self, arg)
File "/home/bruno/odoo/odoo/addons/base/models/ir_fields.py", line 533, in create
recs = super().create(vals_list)
File "/usr/local/lib/python3.6/dist-packages/decorator.py", line 232, in fun
return caller(func, *(extras + args), **kw)
File "/home/bruno/odoo/odoo/api.py", line 345, in _model_create_multi
return create(self, arg)
File "/home/bruno/odoo/odoo/models.py", line 3868, in create
records = self._create(data_list)
File "/home/bruno/odoo/odoo/models.py", line 4028, in _create
for other, data in zip(others, data_list)
File "/home/bruno/odoo/odoo/fields.py", line 3038, in create
self.write_batch(record_values, True)
File "/home/bruno/odoo/odoo/fields.py", line 3064, in write_batch
return self.write_real(records_commands_list, create)
File "/home/bruno/odoo/odoo/fields.py", line 3236, in write_real
flush()
File "/home/bruno/odoo/odoo/fields.py", line 3200, in flush
comodel.create(to_create)
File "/usr/local/lib/python3.6/dist-packages/decorator.py", line 232, in fun
return caller(func, *(extras + args), **kw)
File "/home/bruno/odoo/odoo/api.py", line 345, in _model_create_multi
return create(self, arg)
File "/home/bruno/odoo/addons/account/models/account_move.py", line 3862, in create
moves._check_balanced()
File "/home/bruno/odoo/addons/account/models/account_move.py", line 1674, in _check_balanced
self.env['account.move.line'].flush(self.env['account.move.line']._fields)
File "/home/bruno/odoo/odoo/models.py", line 5442, in flush
self.recompute(fnames, records=records)
File "/home/bruno/odoo/odoo/models.py", line 5908, in recompute
process(field)
File "/home/bruno/odoo/odoo/models.py", line 5879, in process
field.recompute(recs)
File "/home/bruno/odoo/odoo/fields.py", line 1153, in recompute
self.compute_value(recs)
File "/home/bruno/odoo/odoo/fields.py", line 1175, in compute_value
records._compute_field_value(self)
File "/home/bruno/odoo/odoo/models.py", line 4063, in _compute_field_value
field.compute(self)
File "/home/bruno/odoo/odoo/fields.py", line 553, in _compute_related
record[self.name] = self._process_related(value[self.related_field.name])
File "/home/bruno/odoo/odoo/models.py", line 5666, in getitem
return self._fields[key].get(self, type(self))
File "/home/bruno/odoo/odoo/fields.py", line 967, in get
self.recompute(record)
File "/home/bruno/odoo/odoo/fields.py", line 1153, in recompute
self.compute_value(recs)
File "/home/bruno/odoo/odoo/fields.py", line 1175, in compute_value
records._compute_field_value(self)
File "/home/bruno/odoo/addons/mail/models/mail_thread.py", line 410, in _compute_field_value
return super()._compute_field_value(field)
File "/home/bruno/odoo/odoo/models.py", line 4061, in _compute_field_value
getattr(self, field.compute)()
File "/home/bruno/odoo/addons/account/models/account_move.py", line 1088, in _compute_name
highest_name = self[0]._get_last_sequence() if self else False
File "/home/bruno/odoo/addons/account/models/sequence_mixin.py", line 179, in _get_last_sequence
self.env.cr.execute(query, param)
File "/usr/local/lib/python3.6/dist-packages/decorator.py", line 232, in fun
return caller(func, *(extras + args), **kw)
File "/home/bruno/odoo/odoo/sql_db.py", line 101, in check
return f(self, *args, **kwargs)
File "/home/bruno/odoo/odoo/sql_db.py", line 298, in execute
res = self._obj.execute(query, params)
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/home/bruno/odoo/odoo/http.py", line 639, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/home/bruno/odoo/odoo/http.py", line 315, in _handle_exception
raise exception.with_traceback(None) from new_cause
psycopg2.errors.InvalidRegularExpression: invalid regular expression: quantifier operand invalid

[danimaribeiro]

Talvez você tenha que atualizar a versão do postgres, notei que em versões antigas esse erro acontece.