| Date |
Level |
Type |
Message |
|
2024-11-21 16:57:39
|
INFO
|
runbot
|
Init build environment with config Adhoc Conf for demo (y personalizaciones) 17+
|
|
2024-11-21 16:57:39
|
|
|
Starting step all_no_test from config Adhoc Conf for demo (y personalizaciones) 17+
|
|
2024-11-21 16:57:39
|
INFO
|
runbot
|
Using Dockerfile Tag odoo:adhoc-odoo-17
|
|
2024-11-21 16:58:06
|
INFO
|
server
|
odoo.modules.loading:303
1 modules loaded in 11.05s, 9049 queries (+9049 extra)
|
|
2024-11-21 17:03:52
|
INFO
|
server
|
odoo.addons.l10n_ar_edi.models.res_company:216
Setting demo certificate from to OdooCert10 in (AR) Responsable Inscripto company
|
|
2024-11-21 17:03:52
|
INFO
|
server
|
odoo.addons.l10n_ar_edi.models.res_company:216
Setting demo certificate from to OdooCert7 in (AR) Monotributista company
|
|
2024-11-21 17:03:52
|
INFO
|
server
|
odoo.addons.l10n_ar_edi.models.res_company:216
Setting demo certificate from to OdooCert7 in (AR) Exento company
|
|
2024-11-21 17:04:48
|
INFO
|
server
|
odoo.addons.l10n_ar_currency_update.models.res_company:46
Currency Provider configured as AFIP for next companies: (AR) Exento, (AR) Monotributista, (AR) Responsable Inscripto
|
|
2024-11-21 17:06:57
|
WARNING
|
server
|
odoo.modules.loading:93
Module demo_base_minimal demo data failed to install, installed without demo data
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/convert.py", line 556, in _tag_root
f(rec)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/convert.py", line 280, in _tag_function
_eval_xml(self, rec, env)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/convert.py", line 205, in _eval_xml
return odoo.api.call_kw(model, method_name, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 464, in call_kw
result = _call_kw_model(method, model, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 435, in _call_kw_model
result = method(recs, *args, **kwargs)
File "/data/build/ingadhoc-demo-demo/demo_base_minimal/demo_py/sale_order.py", line 109, in _init_demo_base
invoices = sale_a._create_invoices(final=True)
File "/data/build/ingadhoc-sale/sale_ux/models/sale_order.py", line 211, in _create_invoices
invoices = super()._create_invoices(grouped=grouped, final=final, date=date)
File "/data/build/ingadhoc-argentina-sale/l10n_ar_sale/models/sale_order.py", line 130, in _create_invoices
invoices = super()._create_invoices(grouped=grouped, final=final, date=date)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order.py", line 1326, in _create_invoices
raise UserError(self._nothing_to_invoice_error_message())
odoo.exceptions.UserError: Cannot create an invoice. No items are available to invoice.
To resolve this issue, please ensure that:
• The products have been delivered before attempting to invoice them.
• The invoicing policy of the product is configured correctly.
If you want to invoice based on ordered quantities instead:
• For consumable or storable products, open the product, go to the 'General Information' tab and change the 'Invoicing Policy' from 'Delivered Quantities' to 'Ordered Quantities'.
• For services (and other products), change the 'Invoicing Policy' to 'Prepaid/Fixed Price'.
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/modules/loading.py", line 89, in load_demo
load_data(env(su=True), idref, mode, kind='demo', package=package)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/modules/loading.py", line 71, in load_data
tools.convert_file(env, package.name, filename, idref, mode, noupdate, kind)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/convert.py", line 627, in convert_file
convert_xml_import(env, module, fp, idref, mode, noupdate)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/convert.py", line 693, in convert_xml_import
obj.parse(doc.getroot())
File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/convert.py", line 613, in parse
self._tag_root(de)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/convert.py", line 569, in _tag_root
raise ParseError('while parsing %s:%s, somewhere inside\n%s' % (
odoo.tools.convert.ParseError: while parsing /data/build/ingadhoc-demo-demo/demo_base_minimal/demo/init_demo_py.xml:6, somewhere inside
<function model="sale.order" name="_init_demo_base"/>
|
|
2024-11-21 17:06:57
|
ERROR
|
server
|
odoo.sql_db:335
bad query: INSERT INTO "account_tax_sale_order_line_rel" ("sale_order_line_id", "account_tax_id") VALUES (222, 318) ON CONFLICT DO NOTHING
ERROR: insert or update on table "account_tax_sale_order_line_rel" violates foreign key constraint "account_tax_sale_order_line_rel_sale_order_line_id_fkey"
DETAIL: Key (sale_order_line_id)=(222) is not present in table "sale_order_line".
|
|
2024-11-21 17:06:57
|
WARNING
|
server
|
odoo.modules.loading:632
Transient module states were reset
|
| | |
This error is already known.
|
|
2024-11-21 17:06:57
|
ERROR
|
server
|
odoo.modules.registry:119
Failed to load registry
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/modules/registry.py", line 114, in new
odoo.modules.load_modules(registry, force_demo, status, update_module)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/modules/loading.py", line 480, in load_modules
processed_modules += load_marked_modules(env, graph,
File "/data/build/adhoc-cicd-odoo-odoo/odoo/modules/loading.py", line 364, in load_marked_modules
loaded, processed = load_module_graph(
File "/data/build/adhoc-cicd-odoo-odoo/odoo/modules/loading.py", line 236, in load_module_graph
module._update_translations(overwrite=overwrite)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_module.py", line 847, in _update_translations
self.env['ir.module.module']._load_module_terms(mod_names, filter_lang, overwrite)
File "/data/build/adhoc-cicd-odoo-odoo/addons/website/models/ir_module_module.py", line 498, in _load_module_terms
self.env.cr.flush()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 137, in flush
self.transaction.flush()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 863, in flush
env_to_flush.flush_all()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 721, in flush_all
self._recompute_all()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 717, in _recompute_all
self[field.model_name]._recompute_field(field)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 6930, in _recompute_field
field.recompute(records)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1367, in recompute
apply_except_missing(self.compute_value, recs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1340, in apply_except_missing
func(records)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1389, in compute_value
records._compute_field_value(self)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order.py", line 1715, in _compute_field_value
return super()._compute_field_value(field)
File "/data/build/adhoc-cicd-odoo-odoo/addons/mail/models/mail_thread.py", line 424, in _compute_field_value
return super()._compute_field_value(field)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 4894, in _compute_field_value
fields.determine(field.compute, self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 102, in determine
return needle(*args)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order.py", line 647, in _compute_amount_to_invoice
order.amount_to_invoice = order.amount_total - invoices._get_sale_order_invoiced_amount(order)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1152, in __get__
self.recompute(record)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1367, in recompute
apply_except_missing(self.compute_value, recs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1340, in apply_except_missing
func(records)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1389, in compute_value
records._compute_field_value(self)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order.py", line 1715, in _compute_field_value
return super()._compute_field_value(field)
File "/data/build/adhoc-cicd-odoo-odoo/addons/mail/models/mail_thread.py", line 424, in _compute_field_value
return super()._compute_field_value(field)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 4894, in _compute_field_value
fields.determine(field.compute, self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 102, in determine
return needle(*args)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order.py", line 466, in _compute_amounts
tax_results = order.env['account.tax']._compute_taxes([
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order.py", line 467, in <listcomp>
line._convert_to_tax_base_line_dict()
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order_line.py", line 612, in _convert_to_tax_base_line_dict
price_subtotal=self.price_subtotal,
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1152, in __get__
self.recompute(record)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1367, in recompute
apply_except_missing(self.compute_value, recs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1340, in apply_except_missing
func(records)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1389, in compute_value
records._compute_field_value(self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 4894, in _compute_field_value
fields.determine(field.compute, self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 102, in determine
return needle(*args)
File "/data/build/ingadhoc-argentina-sale/l10n_ar_sale/models/sale_order_line.py", line 142, in _compute_amount
super(SaleOrderLine, line)._compute_amount()
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order_line.py", line 623, in _compute_amount
line._convert_to_tax_base_line_dict()
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order_line.py", line 608, in _convert_to_tax_base_line_dict
taxes=self.tax_id,
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 2907, in __get__
return super().__get__(records, owner)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1152, in __get__
self.recompute(record)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1367, in recompute
apply_except_missing(self.compute_value, recs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1340, in apply_except_missing
func(records)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1389, in compute_value
records._compute_field_value(self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 4894, in _compute_field_value
fields.determine(field.compute, self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 102, in determine
return needle(*args)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale_loyalty/models/sale_order_line.py", line 32, in _compute_tax_id
super(SaleOrderLine, self - reward_lines)._compute_tax_id()
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order_line.py", line 443, in _compute_tax_id
line.tax_id = result
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1302, in __set__
self.write(protected_records, value)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 4337, in write
self.write_batch([(records, value)])
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 4358, in write_batch
self.write_real(records_commands_list, create)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 4945, in write_real
cr.execute(SQL(
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 332, in execute
res = self._obj.execute(query, params)
psycopg2.errors.ForeignKeyViolation: insert or update on table "account_tax_sale_order_line_rel" violates foreign key constraint "account_tax_sale_order_line_rel_sale_order_line_id_fkey"
DETAIL: Key (sale_order_line_id)=(222) is not present in table "sale_order_line".
|
|
2024-11-21 17:06:57
|
CRITICAL
|
server
|
odoo.service.server:1350
Failed to initialize database `93733-17-0-all`.
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/server.py", line 1313, in preload_registries
registry = Registry.new(dbname, update_module=update_module)
File "<decorator-gen-16>", line 2, in new
File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/func.py", line 87, in locked
return func(inst, *args, **kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/modules/registry.py", line 114, in new
odoo.modules.load_modules(registry, force_demo, status, update_module)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/modules/loading.py", line 480, in load_modules
processed_modules += load_marked_modules(env, graph,
File "/data/build/adhoc-cicd-odoo-odoo/odoo/modules/loading.py", line 364, in load_marked_modules
loaded, processed = load_module_graph(
File "/data/build/adhoc-cicd-odoo-odoo/odoo/modules/loading.py", line 236, in load_module_graph
module._update_translations(overwrite=overwrite)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_module.py", line 847, in _update_translations
self.env['ir.module.module']._load_module_terms(mod_names, filter_lang, overwrite)
File "/data/build/adhoc-cicd-odoo-odoo/addons/website/models/ir_module_module.py", line 498, in _load_module_terms
self.env.cr.flush()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 137, in flush
self.transaction.flush()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 863, in flush
env_to_flush.flush_all()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 721, in flush_all
self._recompute_all()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 717, in _recompute_all
self[field.model_name]._recompute_field(field)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 6930, in _recompute_field
field.recompute(records)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1367, in recompute
apply_except_missing(self.compute_value, recs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1340, in apply_except_missing
func(records)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1389, in compute_value
records._compute_field_value(self)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order.py", line 1715, in _compute_field_value
return super()._compute_field_value(field)
File "/data/build/adhoc-cicd-odoo-odoo/addons/mail/models/mail_thread.py", line 424, in _compute_field_value
return super()._compute_field_value(field)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 4894, in _compute_field_value
fields.determine(field.compute, self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 102, in determine
return needle(*args)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order.py", line 647, in _compute_amount_to_invoice
order.amount_to_invoice = order.amount_total - invoices._get_sale_order_invoiced_amount(order)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1152, in __get__
self.recompute(record)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1367, in recompute
apply_except_missing(self.compute_value, recs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1340, in apply_except_missing
func(records)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1389, in compute_value
records._compute_field_value(self)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order.py", line 1715, in _compute_field_value
return super()._compute_field_value(field)
File "/data/build/adhoc-cicd-odoo-odoo/addons/mail/models/mail_thread.py", line 424, in _compute_field_value
return super()._compute_field_value(field)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 4894, in _compute_field_value
fields.determine(field.compute, self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 102, in determine
return needle(*args)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order.py", line 466, in _compute_amounts
tax_results = order.env['account.tax']._compute_taxes([
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order.py", line 467, in <listcomp>
line._convert_to_tax_base_line_dict()
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order_line.py", line 612, in _convert_to_tax_base_line_dict
price_subtotal=self.price_subtotal,
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1152, in __get__
self.recompute(record)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1367, in recompute
apply_except_missing(self.compute_value, recs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1340, in apply_except_missing
func(records)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1389, in compute_value
records._compute_field_value(self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 4894, in _compute_field_value
fields.determine(field.compute, self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 102, in determine
return needle(*args)
File "/data/build/ingadhoc-argentina-sale/l10n_ar_sale/models/sale_order_line.py", line 142, in _compute_amount
super(SaleOrderLine, line)._compute_amount()
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order_line.py", line 623, in _compute_amount
line._convert_to_tax_base_line_dict()
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order_line.py", line 608, in _convert_to_tax_base_line_dict
taxes=self.tax_id,
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 2907, in __get__
return super().__get__(records, owner)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1152, in __get__
self.recompute(record)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1367, in recompute
apply_except_missing(self.compute_value, recs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1340, in apply_except_missing
func(records)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1389, in compute_value
records._compute_field_value(self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 4894, in _compute_field_value
fields.determine(field.compute, self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 102, in determine
return needle(*args)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale_loyalty/models/sale_order_line.py", line 32, in _compute_tax_id
super(SaleOrderLine, self - reward_lines)._compute_tax_id()
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order_line.py", line 443, in _compute_tax_id
line.tax_id = result
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1302, in __set__
self.write(protected_records, value)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 4337, in write
self.write_batch([(records, value)])
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 4358, in write_batch
self.write_real(records_commands_list, create)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 4945, in write_real
cr.execute(SQL(
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 332, in execute
res = self._obj.execute(query, params)
psycopg2.errors.ForeignKeyViolation: insert or update on table "account_tax_sale_order_line_rel" violates foreign key constraint "account_tax_sale_order_line_rel_sale_order_line_id_fkey"
DETAIL: Key (sale_order_line_id)=(222) is not present in table "sale_order_line".
|
|
2024-11-21 17:07:04
|
|
|
Step all_no_test finished in 9m
|
|
2024-11-21 17:07:04
|
|
|
Starting step setup from config Adhoc Conf for demo (y personalizaciones) 17+
|
|
2024-11-21 17:07:04
|
INFO
|
runbot
|
Using Dockerfile Tag odoo:adhoc-odoo-17
|
|
2024-11-21 17:07:05
|
INFO
|
runbot
|
Step setup finished in 1s
|
|
2024-11-21 17:07:05
|
|
|
Starting step run from config Adhoc Conf for demo (y personalizaciones) 17+
|
|
2024-11-21 17:07:05
|
INFO
|
runbot
|
Start running build 93733-17-0
|
|
2024-11-21 17:07:06
|
INFO
|
runbot
|
Using Dockerfile Tag odoo:adhoc-odoo-17
|
|
2024-11-21 17:07:13
|
INFO
|
server
|
odoo.modules.loading:303
1 modules loaded in 0.01s, 0 queries (+0 extra)
|
|
2024-11-21 17:07:19
|
INFO
|
server
|
odoo.modules.loading:303
292 modules loaded in 4.87s, 0 queries (+0 extra)
|
|
2024-11-21 17:08:37
|
ERROR
|
server
|
odoo.addons.saas_client_adhoc.wizards.db_configuration:26
Error Updating ADHOC Modules Data. Error:
Not Provider url or saas database uuid configured
|
|
2024-11-21 17:08:43
|
INFO
|
server
|
odoo.modules.loading:303
1 modules loaded in 0.01s, 0 queries (+0 extra)
|
|
2024-11-21 17:08:49
|
INFO
|
server
|
odoo.modules.loading:303
292 modules loaded in 0.17s, 0 queries (+0 extra)
|
|
2024-11-21 17:08:50
|
INFO
|
server
|
odoo.modules.loading:303
296 modules loaded in 5.15s, 2475 queries (+2475 extra)
|
|
2024-11-21 17:08:58
|
ERROR
|
server
|
odoo.sql_db:335
bad query: CREATE TABLE IF NOT EXISTS account_move_line_in_currency_0 AS
WITH currency_rate AS MATERIALIZED (
SELECT
c.currency_id,
COALESCE(r.company_id, c.company_id) as company_id,
r.rate,
r.name AS date_start,
c.currency_group,
(SELECT name FROM res_currency_rate r2
WHERE r2.name > r.name AND
r2.currency_id = r.currency_id AND
(r2.company_id is null or r2.company_id = c.company_id)
ORDER BY r2.name ASC
LIMIT 1) AS date_end
FROM res_currency_rate r
RIGHT JOIN currency_group_line c ON (r.company_id is null or (r.company_id = c.company_id and r.currency_id = c.currency_id))
where c.currency_group = False
)
select "aml"."id", "aml"."move_id", "aml"."journal_id", "aml"."company_id", "aml"."company_currency_id", "aml"."sequence", "aml"."account_id", "aml"."partner_id", "aml"."reconcile_model_id", "aml"."payment_id", "aml"."statement_line_id", "aml"."statement_id", "aml"."group_tax_id", "aml"."tax_line_id", "aml"."tax_group_id", "aml"."tax_repartition_line_id", "aml"."full_reconcile_id", "aml"."account_root_id", "aml"."product_id", "aml"."product_uom_id", "aml"."create_uid", "aml"."write_uid", "aml"."move_name", "aml"."parent_state", "aml"."ref", "aml"."name", "aml"."matching_number", "aml"."display_type", "aml"."date", "aml"."invoice_date", "aml"."date_maturity", "aml"."discount_date", "aml"."analytic_distribution", "aml"."amount_currency", "aml"."tax_base_amount", "aml"."amount_residual", "aml"."amount_residual_currency", "aml"."quantity", "aml"."price_unit", "aml"."price_subtotal", "aml"."price_total", "aml"."discount", "aml"."discount_amount_currency", "aml"."discount_balance", "aml"."tax_tag_invert", "aml"."reconciled", "aml"."blocked", "aml"."create_date", "aml"."write_date", "aml"."deferred_start_date", "aml"."deferred_end_date", "aml"."purchase_line_id", "aml"."cogs_origin_id", "aml"."expected_pay_date", "aml"."user_id", "aml"."l10n_latam_document_type_id", "aml"."is_downpayment", "aml"."followup_line_id", "aml"."last_followup_date", "aml"."next_action_date", "aml"."l10n_pe_group_id", "aml"."tax_settlement_move_id", "aml"."tax_state", "aml"."l10n_pe_edi_allowance_charge_reason_code", "aml"."l10n_pe_edi_affectation_reason",
CASE WHEN cr.rate is null or cr.currency_id = c.currency_id THEN aml.balance ELSE aml.balance * cr.rate END as balance,
CASE WHEN cr.rate is null or cr.currency_id = c.currency_id THEN aml.credit ELSE aml.credit * cr.rate END as credit,
CASE WHEN cr.rate is null or cr.currency_id = c.currency_id THEN aml.debit ELSE aml.debit * cr.rate END as debit,
cr.currency_id,
(case when cr.rate is null or cr.currency_id = c.currency_id then 1.0 else cr.rate end) as aml_rate
from account_move_line aml
left join currency_rate cr on
(cr.currency_id in () and
cr.company_id = aml.company_id and
(cr.date_start <= COALESCE(aml.date, NOW()) or cr.date_start is null) and
(cr.date_end IS NULL OR cr.date_end > COALESCE(aml.date, NOW())))
join res_company as c on c.id=cr.company_id
ERROR: syntax error at or near ")"
LINE 27: (cr.currency_id in () and
^
|
|
2024-11-21 17:08:58
|
ERROR
|
server
|
odoo.addons.base.models.ir_cron:406
Call from cron Update AML in currency for server action #852 failed in Job #46
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/safe_eval.py", line 391, in safe_eval
return unsafe_eval(c, globals_dict, locals_dict)
File "ir.actions.server(852,)", line 1, in <module>
File "/data/build/ingadhoc-enterprise-extensions/account_reports_multicurrency/models/currency_group.py", line 22, in cron_recreate_aml_materialized
to_update.action_currency_aml_materialized()
File "/data/build/ingadhoc-enterprise-extensions/account_reports_multicurrency/models/currency_group.py", line 46, in action_currency_aml_materialized
self._cr.execute("""CREATE TABLE IF NOT EXISTS %s AS
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 332, in execute
res = self._obj.execute(query, params)
psycopg2.errors.SyntaxError: syntax error at or near ")"
LINE 27: (cr.currency_id in () and
^
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_cron.py", line 397, in _callback
self.env['ir.actions.server'].browse(server_action_id).run()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_actions.py", line 939, in run
res = runner(run_self, eval_context=eval_context)
File "/data/build/adhoc-cicd-odoo-odoo/addons/website/models/ir_actions_server.py", line 61, in _run_action_code_multi
res = super(ServerAction, self)._run_action_code_multi(eval_context)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_actions.py", line 771, in _run_action_code_multi
safe_eval(self.code.strip(), eval_context, mode="exec", nocopy=True, filename=str(self)) # nocopy allows to return 'action'
File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/safe_eval.py", line 405, in safe_eval
raise ValueError('%s: "%s" while evaluating\n%r' % (ustr(type(e)), ustr(e), expr))
ValueError: <class 'psycopg2.errors.SyntaxError'>: "syntax error at or near ")"
LINE 27: (cr.currency_id in () and
^
" while evaluating
'model.cron_recreate_aml_materialized()'
|
|
2024-11-21 20:37:04
|
INFO
|
runbot
|
Kill build 93733-17-0
|