Skip to Content
This question has been flagged
2 Replies
1880 Rodiniai
Portretas
Shiv Narayan

Installed Odoo 16 on Ubuntu 20.04 with external Accounting add on. All other modules work fine but I keep getting an error from any operation in the Accounting module (below is from trying to create a bill). New to Odoo and appreciate any help.


RPC_ERROR
Odoo Server Error
Traceback (most recent call last):
File "/opt/odoo/odoo16/odoo/http\.py",\ line\ 1584,\ in\ _serve_db
\ \ \ \ return\ service_model\.retrying\(self\._serve_ir_http,\ self\.env\)
\ \ File\ "/opt/odoo/odoo16/odoo/service/model\.py",\ line\ 133,\ in\ retrying
\ \ \ \ result\ =\ func\(\)
\ \ File\ "/opt/odoo/odoo16/odoo/http\.py",\ line\ 1611,\ in\ _serve_ir_http
\ \ \ \ response\ =\ self\.dispatcher\.dispatch\(rule\.endpoint,\ args\)
\ \ File\ "/opt/odoo/odoo16/odoo/http\.py",\ line\ 1815,\ in\ dispatch
\ \ \ \ result\ =\ self\.request\.registry\['ir\.http'\]\._dispatch\(endpoint\)
\ \ File\ "/opt/odoo/odoo16/odoo/addons/base/models/ir_http\.py",\ line\ 154,\ in\ _dispatch
\ \ \ \ result\ =\ endpoint\(\*\*request\.params\)
\ \ File\ "/opt/odoo/odoo16/odoo/http\.py",\ line\ 697,\ in\ route_wrapper
\ \ \ \ result\ =\ endpoint\(self,\ \*args,\ \*\*params_ok\)
\ \ File\ "/opt/odoo/odoo16/addons/web/controllers/dataset\.py",\ line\ 42,\ in\ call_kw
\ \ \ \ return\ self\._call_kw\(model,\ method,\ args,\ kwargs\)
\ \ File\ "/opt/odoo/odoo16/addons/web/controllers/dataset\.py",\ line\ 33,\ in\ _call_kw
\ \ \ \ return\ call_kw\(request\.env\[model\],\ method,\ args,\ kwargs\)
\ \ File\ "/opt/odoo/odoo16/odoo/api\.py",\ line\ 461,\ in\ call_kw
\ \ \ \ result\ =\ _call_kw_multi\(method,\ model,\ args,\ kwargs\)
\ \ File\ "/opt/odoo/odoo16/odoo/api\.py",\ line\ 448,\ in\ _call_kw_multi
\ \ \ \ result\ =\ method\(recs,\ \*args,\ \*\*kwargs\)
\ \ File\ "/opt/odoo/odoo16/addons/account/models/account_move\.py",\ line\ 2350,\ in\ onchange
\ \ \ \ return\ super\(\)\.onchange\(values,\ field_name,\ field_onchange\)
\ \ File\ "/opt/odoo/odoo16/odoo/models\.py",\ line\ 6502,\ in\ onchange
\ \ \ \ record\._onchange_eval\(name,\ field_onchange\[name\],\ result\)
\ \ File\ "/opt/odoo/odoo16/odoo/models\.py",\ line\ 6213,\ in\ _onchange_eval
\ \ \ \ method_res\ =\ method\(self\)
\ \ File\ "/opt/odoo/odoo16/addons/account/models/account_move\.py",\ line\ 1601,\ in\ _onchange_name_warning
\ \ \ \ if\ self\.name\ and\ self\.name\ !=\ '/'\ and\ self\.name\ <=\ \(self\.highest_name\ or\ ''\)\ and\ not\ self\.quick_edit_mode:
\ \ File\ "/opt/odoo/odoo16/odoo/fields\.py",\ line\ 1157,\ in\ __get__
\ \ \ \ self\.recompute\(record\)
\ \ File\ "/opt/odoo/odoo16/odoo/fields\.py",\ line\ 1365,\ in\ recompute
\ \ \ \ apply_except_missing\(self\.compute_value,\ recs\)
\ \ File\ "/opt/odoo/odoo16/odoo/fields\.py",\ line\ 1338,\ in\ apply_except_missing
\ \ \ \ func\(records\)
\ \ File\ "/opt/odoo/odoo16/odoo/fields\.py",\ line\ 1387,\ in\ compute_value
\ \ \ \ records\._compute_field_value\(self\)
\ \ File\ "/opt/odoo/odoo16/addons/mail/models/mail_thread\.py",\ line\ 403,\ in\ _compute_field_value
\ \ \ \ return\ super\(\)\._compute_field_value\(field\)
\ \ File\ "/opt/odoo/odoo16/odoo/models\.py",\ line\ 4203,\ in\ _compute_field_value
\ \ \ \ fields\.determine\(field\.compute,\ self\)
\ \ File\ "/opt/odoo/odoo16/odoo/fields\.py",\ line\ 97,\ in\ determine
\ \ \ \ return\ needle\(\*args\)
\ \ File\ "/opt/odoo/odoo16/addons/account/models/account_move\.py",\ line\ 695,\ in\ _compute_name
\ \ \ \ if\ move_has_name\ and\ move\.posted_before\ or\ not\ move_has_name\ and\ move\._get_last_sequence\(lock=False\):
\ \ File\ "/opt/odoo/odoo16/addons/account_sequence/models/sequence_mixin\.py",\ line\ 11,\ in\ _get_last_sequence
\ \ \ \ return\ super\(\)\._get_last_sequence\(relaxed,\ with_prefix,\ False\)
\ \ File\ "/opt/odoo/odoo16/addons/account/models/sequence_mixin\.py",\ line\ 207,\ in\ _get_last_sequence
\ \ \ \ self\.env\.cr\.execute\(query,\ param\)
\ \ File\ "/opt/odoo/odoo16/odoo/sql_db\.py",\ line\ 314,\ in\ execute
\ \ \ \ res\ =\ self\._obj\.execute\(query,\ params\)
psycopg2.errors.InvalidRegularExpression: invalid regular expression: quantifier operand invalid


The above server error caused the following client error:
null

Portretas
Atmesti
Portretas
Niyas Raphy (Walnut Software Solutions)
Best Answer

Hi,

Mostly the issue is coming from the third party app, because such an issue is not reported yet in odoo. You can do as follows:

* if the database is not relevant and if you are testing out things, create a new db and install only odoo modules

* see if everything works well


If yes, then the issue is from the third party app you have used. You can confirm the same and report it to the author of app with detailed steps to reproduce it in their own channel.

If you believe or confirm its a bug in odoo, you can report it here:  https://github.com/odoo/odoo/issues


Also make sure that you are using the updated/latest source code of odoo

Thanks

Portretas
Atmesti
Portretas
Apple Mahmud
Best Answer

To resolve this issue, you can try the following steps:

  1. Restart the Odoo server:

    sudo systemctl restart odoo

    Sometimes, restarting the server can resolve temporary issues.

  2. Check for any recent changes: Review any recent changes made to the Odoo installation, including modifications to the Accounting module or related configurations. If you made any changes recently, try reverting them to see if the error is resolved.

  3. Review customizations and third-party modules: If you have any customizations or third-party modules installed, they may be causing conflicts or using invalid regular expressions. Disable or remove any customizations or third-party modules related to the Accounting module and check if the error persists. You can disable them by renaming the respective module directories.

  4. Verify database integrity: Sometimes, database inconsistencies can cause such errors. You can verify the integrity of the database by running the following command:

    odoo-bin -d  --db-filter= --check-db

    Replace with the actual name of your Odoo database. If any issues are reported, follow the instructions provided to resolve them.

  5. Check Odoo logs: Examine the Odoo logs located at /var/log/odoo/ or the directory specified in your Odoo configuration file. Look for any relevant error messages or stack traces that provide more information about the cause of the error.


Portretas
Atmesti