Skip to Content
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
All Posts คน เหรียญรางวัล
แท็ก (View all)
odoo accounting v14 pos v15
เกี่ยวกับฟอรั่มนี้
คำถามนี้ถูกตั้งค่าสถานะ
2 ตอบกลับ
1866 มุมมอง
อวตาร
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

อวตาร
ละทิ้ง
อวตาร
Niyas Raphy (Walnut Software Solutions)
คำตอบที่ดีที่สุด

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

อวตาร
ละทิ้ง
อวตาร
Apple Mahmud
คำตอบที่ดีที่สุด

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.


อวตาร
ละทิ้ง