| Date |
Level |
Type |
Message |
|
2025-01-31 17:50:17
|
INFO
|
runbot
|
Init build environment with config Adhoc Conf con tests 17+
|
|
2025-01-31 17:50:17
|
|
|
Starting step base from config Adhoc Conf con tests 17+
|
|
2025-01-31 17:50:17
|
INFO
|
runbot
|
Using Dockerfile Tag odoo:adhoc-odoo-18
|
|
2025-01-31 17:50:35
|
INFO
|
server
|
odoo.modules.loading:329
1 modules loaded in 9.48s, 9222 queries (+9222 extra)
|
|
2025-01-31 17:50:47
|
INFO
|
server
|
odoo.modules.loading:329
19 modules loaded in 7.77s, 7939 queries (+7939 extra)
|
|
2025-01-31 17:50:53
|
|
|
Step base finished in 30s
|
|
2025-01-31 17:50:53
|
|
|
Starting step all from config Adhoc Conf con tests 17+
|
|
2025-01-31 17:50:53
|
INFO
|
runbot
|
Using Dockerfile Tag odoo:adhoc-odoo-18
|
|
2025-01-31 17:51:20
|
INFO
|
server
|
odoo.modules.loading:329
1 modules loaded in 12.64s, 9222 queries (+9222 extra)
|
|
2025-01-31 18:01:13
|
INFO
|
server
|
odoo.addons.l10n_ar_edi.models.res_company:128
Setting demo certificate from False to AR demo certificate 4 in (AR) Responsable Inscripto company
|
|
2025-01-31 18:01:13
|
INFO
|
server
|
odoo.addons.l10n_ar_edi.models.res_company:128
Setting demo certificate from False to AR demo certificate 10 in (AR) Monotributista company
|
|
2025-01-31 18:01:13
|
INFO
|
server
|
odoo.addons.l10n_ar_edi.models.res_company:128
Setting demo certificate from False to AR demo certificate 7 in (AR) Exento company
|
|
2025-01-31 18:03:07
|
INFO
|
server
|
odoo.addons.l10n_ar_currency_update.models.res_company:36
Currency Provider configured as AFIP for next companies: (AR) Exento, (AR) Monotributista, (AR) Responsable Inscripto
|
|
2025-01-31 18:04:15
|
INFO
|
server
|
odoo.addons.l10n_ar_currency_update.models.res_company:36
Currency Provider configured as AFIP for next companies: (AR) Exento, (AR) Monotributista, (AR) Responsable Inscripto
|
|
2025-01-31 18:05:17
|
INFO
|
server
|
odoo.addons.l10n_ar_currency_update.models.res_company:36
Currency Provider configured as AFIP for next companies: (AR) Exento, (AR) Monotributista, Muebleria ARG
|
|
2025-01-31 18:06:21
|
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/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 608, in convert_file
convert_xml_import(env, module, fp, idref, mode, noupdate)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/convert.py", line 679, in convert_xml_import
obj.parse(doc.getroot())
File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/convert.py", line 594, in parse
self._tag_root(de)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/convert.py", line 548, in _tag_root
raise ParseError(msg) from None # Restart with "--log-handler odoo.tools.convert:DEBUG" for complete traceback
odoo.tools.convert.ParseError: while parsing /data/build/ingadhoc-ingadhoc-demo/demo_base_minimal/demo/init_demo_py.xml:6
No puede haber dos impuestos del mismo grupo vigentes en el mismo momento para la misma empresa. Tal vez tenga algun impuesto al que le tenga que definir una fecha hasta. Más información:
* Impuesto: P. IIBB CABA 3.0%
* Fecha Hasta: 2025-01-31
* Fecha Desde: 2025-01-01
* Otros impuestos: ['P. IIBB CABA 3.0%']
View error context:
'-no context-'
|
|
2025-01-31 18:06:21
|
WARNING
|
server
|
odoo.modules.loading:632
Transient module states were reset
|
| | |
This error is already known.
|
|
2025-01-31 18:06:21
|
ERROR
|
server
|
odoo.modules.registry:132
Failed to load registry
|
|
2025-01-31 18:06:21
|
CRITICAL
|
server
|
odoo.service.server:1356
Failed to initialize database `117794-18-0-all`.
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/server.py", line 1318, in preload_registries
registry = Registry.new(dbname, update_module=update_module)
File "<decorator-gen-13>", line 2, in new
File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/func.py", line 97, in locked
return func(inst, *args, **kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/modules/registry.py", line 127, 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 868, 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 494, in _load_module_terms
self.env.cr.flush()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 159, in flush
self.transaction.flush()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 1006, in flush
env_to_flush.flush_all()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 831, in flush_all
self._recompute_all()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 827, in _recompute_all
self[field.model_name]._recompute_field(field)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 7279, in _recompute_field
field.recompute(records)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1451, in recompute
apply_except_missing(self.compute_value, recs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1424, in apply_except_missing
func(records)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1473, in compute_value
records._compute_field_value(self)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale_timesheet/models/sale_order.py", line 51, in _compute_field_value
return super()._compute_field_value(field)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order.py", line 2006, in _compute_field_value
return super()._compute_field_value(field)
File "/data/build/adhoc-cicd-odoo-odoo/addons/mail/models/mail_thread.py", line 428, in _compute_field_value
return super()._compute_field_value(field)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 5238, in _compute_field_value
fields.determine(field.compute, self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 110, in determine
return needle(*args)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale_margin/models/sale_order.py", line 24, in _compute_margin
grouped_order_lines_data = self.env['sale.order.line']._read_group(
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 1989, in _read_group
row_values = self.env.execute_query(query.select(*groupby_terms.values(), *select_terms))
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 961, in execute_query
self.flush_query(query)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 953, in flush_query
self[model_name].flush_model(field_names)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 6696, in flush_model
self._recompute_model(fnames)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 7251, in _recompute_model
self._recompute_field(field)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 7279, in _recompute_field
field.recompute(records)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1451, in recompute
apply_except_missing(self.compute_value, recs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1424, in apply_except_missing
func(records)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1473, in compute_value
records._compute_field_value(self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 5238, in _compute_field_value
fields.determine(field.compute, self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 110, in determine
return needle(*args)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale_margin/models/sale_order_line.py", line 41, in _compute_margin
line.margin = line.price_subtotal - (line.purchase_price * line.product_uom_qty)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1236, in __get__
self.recompute(record)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1451, in recompute
apply_except_missing(self.compute_value, recs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1424, in apply_except_missing
func(records)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1473, in compute_value
records._compute_field_value(self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 5238, in _compute_field_value
fields.determine(field.compute, self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 110, in determine
return needle(*args)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order_line.py", line 768, in _compute_amount
base_line = line._prepare_base_line_for_taxes_computation()
File "/data/build/ingadhoc-sale/sale_gathering/models/sale_order_line.py", line 40, in _prepare_base_line_for_taxes_computation
return super()._prepare_base_line_for_taxes_computation(**kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/addons/sale/models/sale_order_line.py", line 756, in _prepare_base_line_for_taxes_computation
'tax_ids': self.tax_id,
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 3047, in __get__
return super().__get__(records, owner)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1236, in __get__
self.recompute(record)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1451, in recompute
apply_except_missing(self.compute_value, recs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1424, in apply_except_missing
func(records)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 1473, in compute_value
records._compute_field_value(self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 5238, in _compute_field_value
fields.determine(field.compute, self)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/fields.py", line 110, in determine
return needle(*args)
File "/data/build/ingadhoc-argentina-sale/l10n_ar_sale/models/sale_order_line.py", line 140, in _compute_tax_id
rec.tax_id += rec.order_id.fiscal_position_id._l10n_ar_add_taxes(rec.order_partner_id, rec.company_id, date, 'perception')
File "/data/build/ingadhoc-odoo-argentina/l10n_ar_tax/models/account_fiscal_position.py", line 32, in _l10n_ar_add_taxes
partner_tax = fp_tax._get_missing_taxes(partner, date)
File "/data/build/ingadhoc-odoo-argentina/l10n_ar_tax/models/account_fiscal_position_l10n_ar_tax.py", line 48, in _get_missing_taxes
taxes += rec._get_tax_from_ws(partner, date)
File "/data/build/ingadhoc-odoo-argentina/l10n_ar_tax/models/account_fiscal_position_l10n_ar_tax.py", line 108, in _get_tax_from_ws
self.env['l10n_ar.partner.tax'].create({
File "<decorator-gen-31>", line 2, in create
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 479, in _model_create_multi
return create(self, [arg])
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 4975, in create
records = self._create(data_list)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 5233, in _create
records._validate_fields(name for data in data_list for name in data['stored'])
File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 1599, in _validate_fields
check(self)
File "/data/build/ingadhoc-odoo-argentina/l10n_ar_tax/models/l10n_ar_partner_tax.py", line 30, in _check_tax_group_overlap
raise ValidationError(
odoo.exceptions.ValidationError: No puede haber dos impuestos del mismo grupo vigentes en el mismo momento para la misma empresa. Tal vez tenga algun impuesto al que le tenga que definir una fecha hasta. Más información:
* Impuesto: P. IIBB CABA 3.0%
* Fecha Hasta: 2025-01-31
* Fecha Desde: 2025-01-01
* Otros impuestos: ['P. IIBB CABA 3.0%']
|
|
2025-01-31 18:06:34
|
INFO
|
runbot
|
Getting results for build 117794-18-0
|
|
2025-01-31 18:06:34
|
|
|
Step all finished in 15m
|
|
2025-01-31 18:06:34
|
|
|
Starting step setup from config Adhoc Conf con tests 17+
|
|
2025-01-31 18:06:34
|
INFO
|
runbot
|
Using Dockerfile Tag odoo:adhoc-odoo-18
|
|
2025-01-31 18:06:34
|
INFO
|
runbot
|
Step setup finished in 0s
|
|
2025-01-31 18:06:34
|
|
|
Starting step run from config Adhoc Conf con tests 17+
|
|
2025-01-31 18:06:34
|
INFO
|
runbot
|
Start running build 117794-18-0
|
|
2025-01-31 18:06:35
|
INFO
|
runbot
|
Using Dockerfile Tag odoo:adhoc-odoo-18
|
|
2025-01-31 18:06:41
|
INFO
|
server
|
odoo.modules.loading:329
1 modules loaded in 0.01s, 0 queries (+0 extra)
|
|
2025-01-31 18:06:41
|
INFO
|
server
|
odoo.modules.loading:329
19 modules loaded in 0.51s, 0 queries (+0 extra)
|
|
2025-01-31 18:50:52
|
ERROR
|
server
|
odoo.sql_db:357
bad query: b'\n WITH period_table(date_start, date_stop, period_index) AS ((VALUES (NULL, \'2025-01-31\', 0),(\'2025-01-30\', \'2025-01-01\', 1),(\'2024-12-31\', \'2024-12-02\', 2),(\'2024-12-01\', \'2024-11-02\', 3),(\'2024-11-01\', \'2024-10-03\', 4),(\'2024-10-02\', NULL, 5)))\n\n SELECT\n \n 1 * (\n SUM(account_move_line.amount_currency)\n - COALESCE(SUM(part_debit.debit_amount_currency), 0)\n + COALESCE(SUM(part_credit.credit_amount_currency), 0)\n ) AS amount_currency,\n ARRAY_AGG(DISTINCT account_move_line.partner_id) AS partner_id,\n ARRAY_AGG(account_move_line.payment_id) AS payment_id,\n ARRAY_AGG(DISTINCT move.invoice_date) AS invoice_date,\n ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS report_date,\n ARRAY_AGG(DISTINCT ("account_move_line__account_id"."code_store"->\'1\'->>0)::VARCHAR) AS account_name,\n ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS due_date,\n ARRAY_AGG(DISTINCT account_move_line.currency_id) AS currency_id,\n COUNT(account_move_line.id) AS aml_count,\n ARRAY_AGG(("account_move_line__account_id"."code_store"->\'1\'->>0)::VARCHAR) AS account_code,\n \n CASE WHEN period_table.period_index = 0\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period0"\n ,\n CASE WHEN period_table.period_index = 1\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period1"\n ,\n CASE WHEN period_table.period_index = 2\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period2"\n ,\n CASE WHEN period_table.period_index = 3\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period3"\n ,\n CASE WHEN period_table.period_index = 4\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period4"\n ,\n CASE WHEN period_table.period_index = 5\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period5"\n \n\n FROM "account_move_line" LEFT JOIN "account_account" AS "account_move_line__account_id" ON ("account_move_line"."account_id" = "account_move_line__account_id"."id")\n\n JOIN account_journal journal ON journal.id = account_move_line.journal_id\n JOIN account_move move ON move.id = account_move_line.move_id\n \n JOIN account_account aml_ct_account\n ON aml_ct_account.id = account_move_line.account_id\n LEFT JOIN account_currency_table\n ON account_move_line.company_id = account_currency_table.company_id\n AND (\n account_currency_table.rate_type = CASE\n WHEN aml_ct_account.account_type LIKE \'equity%\' THEN \'historical\'\n WHEN aml_ct_account.account_type LIKE ANY (ARRAY[\'income%\', \'expense%\', \'equity_unaffected\']) THEN \'historical\'\n ELSE \'closing\'\n END\n )\n AND (account_currency_table.date_from IS NULL OR account_currency_table.date_from <= account_move_line.date)\n AND (account_currency_table.date_next IS NULL OR account_currency_table.date_next > account_move_line.date)\n AND (account_currency_table.period_key = \'None_2025-01-31\' OR account_currency_table.period_key IS NULL)\n \n\n LEFT JOIN LATERAL (\n SELECT\n SUM(part.amount) AS amount,\n SUM(part.debit_amount_currency) AS debit_amount_currency,\n part.debit_move_id\n FROM account_partial_reconcile part\n WHERE part.max_date <= \'2025-01-31\'::date AND part.debit_move_id = account_move_line.id\n GROUP BY part.debit_move_id\n ) part_debit ON TRUE\n\n LEFT JOIN LATERAL (\n SELECT\n SUM(part.amount) AS amount,\n SUM(part.credit_amount_currency) AS credit_amount_currency,\n part.credit_move_id\n FROM account_partial_reconcile part\n WHERE part.max_date <= \'2025-01-31\'::date AND part.credit_move_id = account_move_line.id\n GROUP BY part.credit_move_id\n ) part_credit ON TRUE\n\n JOIN period_table ON\n (\n period_table.date_start IS NULL\n OR COALESCE(account_move_line."date_maturity", account_move_line.date) <= DATE(period_table.date_start)\n )\n AND\n (\n period_table.date_stop IS NULL\n OR COALESCE(account_move_line."date_maturity", account_move_line.date) >= DATE(period_table.date_stop)\n )\n\n WHERE (((((("account_move_line"."display_type" NOT IN (\'line_section\', \'line_note\')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" IN (1, 7))) AND ("account_move_line"."date" <= \'2025-01-31\')) AND ("account_move_line"."parent_state" = \'posted\')) AND ((("account_move_line__account_id"."non_trade" IS NULL OR "account_move_line__account_id"."non_trade" = FALSE) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\')) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\'))) AND (("account_move_line"."company_id" IN (1, 7)) AND ("account_move_line"."journal_id" IS NULL OR ("account_move_line"."journal_id" IN (SELECT "account_journal"."id" FROM "account_journal" WHERE (NOT EXISTS (SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids" WHERE "account_journal__user_ids"."journal_id" = "account_journal"."id") OR FALSE)))))\n\n GROUP BY period_table.period_index\n\n HAVING\n ROUND(SUM((CASE WHEN account_move_line.balance > 0 THEN account_move_line.balance else 0 END - COALESCE(part_debit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n OR ROUND(SUM((CASE WHEN account_move_line.balance < 0 THEN -account_move_line.balance else 0 END - COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n\n ORDER BY period_table.period_index\n\n \n '
ERROR: function round(double precision, integer) does not exist
LINE 103: ROUND(SUM((CASE WHEN account_move_line.balan...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
2025-01-31 18:50:52
|
ERROR
|
server
|
odoo.http:2401
Exception during request handling.
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2366, in __call__
response = request._serve_db()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1894, in _serve_db
return self._transactioning(
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1957, in _transactioning
return service_model.retrying(func, env=self.env)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 137, in retrying
result = func()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1924, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2171, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 329, in _dispatch
result = endpoint(**request.params)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 727, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 35, in call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 517, in call_kw
result = getattr(recs, name)(*args, **kwargs)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5129, in get_report_information
all_column_groups_expression_totals = self._compute_expression_totals_for_each_column_group(self.line_ids.expression_ids, options, warnings=warnings)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3064, in _compute_expression_totals_for_each_column_group
current_group_expression_totals = self._compute_expression_totals_for_single_column_group(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3227, in _compute_expression_totals_for_single_column_group
formula_results = self._compute_formula_batch(column_group_options, engine, date_scope, formulas_dict, current_groupby, next_groupby,
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3577, in _compute_formula_batch
return getattr(self, engine_function_name)(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4107, in _compute_formula_batch_with_engine_custom
rslt[(formula, expressions)] = custom_engine_function(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 84, in _report_custom_engine_aged_receivable
return self._aged_partner_report_custom_engine_common(options, 'asset_receivable', current_groupby, next_groupby, offset=offset, limit=limit)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 272, in _aged_partner_report_custom_engine_common
self._cr.execute(query)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 354, in execute
res = self._obj.execute(query, params)
psycopg2.errors.UndefinedFunction: function round(double precision, integer) does not exist
LINE 103: ROUND(SUM((CASE WHEN account_move_line.balan...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
2025-01-31 18:59:56
|
ERROR
|
server
|
odoo.sql_db:357
bad query: b"\n WITH visitor AS (\n \n INSERT INTO website_visitor (\n partner_id, access_token, last_connection_datetime, visit_count, lang_id,\n website_id, timezone, write_uid, create_uid, write_date, create_date, country_id)\n VALUES (\n NULL, '04418d9b73b9817c37f31b384e21a536', now() at time zone 'UTC', 1, 1,\n 1, NULL, 4, 4,\n now() at time zone 'UTC', now() at time zone 'UTC', (\n SELECT id FROM res_country WHERE code = NULL\n )\n )\n ON CONFLICT (access_token)\n DO UPDATE SET\n last_connection_datetime=excluded.last_connection_datetime,\n visit_count = CASE WHEN website_visitor.last_connection_datetime < NOW() AT TIME ZONE 'UTC' - INTERVAL '8 hours'\n THEN website_visitor.visit_count + 1\n ELSE website_visitor.visit_count\n END\n RETURNING id, CASE WHEN create_date = now() at time zone 'UTC' THEN 'inserted' ELSE 'updated' END AS upsert\n , 'https://117794-18-0-all.runbot.adhoc.com.ar/' AS url, 4 AS page_id\n ), track AS (\n INSERT INTO website_track (visitor_id, url, page_id, visit_datetime)\n SELECT id, url, page_id::integer, now() at time zone 'UTC' FROM visitor\n )\n SELECT id, upsert from visitor;\n "
ERROR: could not serialize access due to concurrent update
|
|
2025-01-31 20:14:45
|
ERROR
|
server
|
odoo.sql_db:357
bad query: b'\n WITH period_table(date_start, date_stop, period_index) AS ((VALUES (NULL, \'2025-01-31\', 0),(\'2025-01-30\', \'2025-01-01\', 1),(\'2024-12-31\', \'2024-12-02\', 2),(\'2024-12-01\', \'2024-11-02\', 3),(\'2024-11-01\', \'2024-10-03\', 4),(\'2024-10-02\', NULL, 5)))\n\n SELECT\n \n -1 * (\n SUM(account_move_line.amount_currency)\n - COALESCE(SUM(part_debit.debit_amount_currency), 0)\n + COALESCE(SUM(part_credit.credit_amount_currency), 0)\n ) AS amount_currency,\n ARRAY_AGG(DISTINCT account_move_line.partner_id) AS partner_id,\n ARRAY_AGG(account_move_line.payment_id) AS payment_id,\n ARRAY_AGG(DISTINCT move.invoice_date) AS invoice_date,\n ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS report_date,\n ARRAY_AGG(DISTINCT ("account_move_line__account_id"."code_store"->\'7\'->>0)::VARCHAR) AS account_name,\n ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS due_date,\n ARRAY_AGG(DISTINCT account_move_line.currency_id) AS currency_id,\n COUNT(account_move_line.id) AS aml_count,\n ARRAY_AGG(("account_move_line__account_id"."code_store"->\'7\'->>0)::VARCHAR) AS account_code,\n \n CASE WHEN period_table.period_index = 0\n THEN -1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period0"\n ,\n CASE WHEN period_table.period_index = 1\n THEN -1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period1"\n ,\n CASE WHEN period_table.period_index = 2\n THEN -1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period2"\n ,\n CASE WHEN period_table.period_index = 3\n THEN -1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period3"\n ,\n CASE WHEN period_table.period_index = 4\n THEN -1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period4"\n ,\n CASE WHEN period_table.period_index = 5\n THEN -1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period5"\n \n\n FROM "account_move_line" LEFT JOIN "account_account" AS "account_move_line__account_id" ON ("account_move_line"."account_id" = "account_move_line__account_id"."id")\n\n JOIN account_journal journal ON journal.id = account_move_line.journal_id\n JOIN account_move move ON move.id = account_move_line.move_id\n \n JOIN account_account aml_ct_account\n ON aml_ct_account.id = account_move_line.account_id\n LEFT JOIN account_currency_table\n ON account_move_line.company_id = account_currency_table.company_id\n AND (\n account_currency_table.rate_type = CASE\n WHEN aml_ct_account.account_type LIKE \'equity%\' THEN \'historical\'\n WHEN aml_ct_account.account_type LIKE ANY (ARRAY[\'income%\', \'expense%\', \'equity_unaffected\']) THEN \'historical\'\n ELSE \'closing\'\n END\n )\n AND (account_currency_table.date_from IS NULL OR account_currency_table.date_from <= account_move_line.date)\n AND (account_currency_table.date_next IS NULL OR account_currency_table.date_next > account_move_line.date)\n AND (account_currency_table.period_key = \'None_2025-01-31\' OR account_currency_table.period_key IS NULL)\n \n\n LEFT JOIN LATERAL (\n SELECT\n SUM(part.amount) AS amount,\n SUM(part.debit_amount_currency) AS debit_amount_currency,\n part.debit_move_id\n FROM account_partial_reconcile part\n WHERE part.max_date <= \'2025-01-31\'::date AND part.debit_move_id = account_move_line.id\n GROUP BY part.debit_move_id\n ) part_debit ON TRUE\n\n LEFT JOIN LATERAL (\n SELECT\n SUM(part.amount) AS amount,\n SUM(part.credit_amount_currency) AS credit_amount_currency,\n part.credit_move_id\n FROM account_partial_reconcile part\n WHERE part.max_date <= \'2025-01-31\'::date AND part.credit_move_id = account_move_line.id\n GROUP BY part.credit_move_id\n ) part_credit ON TRUE\n\n JOIN period_table ON\n (\n period_table.date_start IS NULL\n OR COALESCE(account_move_line."date_maturity", account_move_line.date) <= DATE(period_table.date_start)\n )\n AND\n (\n period_table.date_stop IS NULL\n OR COALESCE(account_move_line."date_maturity", account_move_line.date) >= DATE(period_table.date_stop)\n )\n\n WHERE (((((("account_move_line"."display_type" NOT IN (\'line_section\', \'line_note\')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" IN (7, 6, 5, 1))) AND ("account_move_line"."date" <= \'2025-01-31\')) AND ("account_move_line"."parent_state" = \'posted\')) AND ((("account_move_line__account_id"."non_trade" IS NULL OR "account_move_line__account_id"."non_trade" = FALSE) AND ("account_move_line__account_id"."account_type" = \'liability_payable\')) AND ("account_move_line__account_id"."account_type" = \'liability_payable\'))) AND (("account_move_line"."company_id" IN (7, 6, 5, 1)) AND ("account_move_line"."journal_id" IS NULL OR ("account_move_line"."journal_id" IN (SELECT "account_journal"."id" FROM "account_journal" WHERE (NOT EXISTS (SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids" WHERE "account_journal__user_ids"."journal_id" = "account_journal"."id") OR FALSE)))))\n\n GROUP BY period_table.period_index\n\n HAVING\n ROUND(SUM((CASE WHEN account_move_line.balance > 0 THEN account_move_line.balance else 0 END - COALESCE(part_debit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n OR ROUND(SUM((CASE WHEN account_move_line.balance < 0 THEN -account_move_line.balance else 0 END - COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n\n ORDER BY period_table.period_index\n\n \n '
ERROR: function round(double precision, integer) does not exist
LINE 103: ROUND(SUM((CASE WHEN account_move_line.balan...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
2025-01-31 20:14:45
|
ERROR
|
server
|
odoo.http:2401
Exception during request handling.
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2366, in __call__
response = request._serve_db()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1894, in _serve_db
return self._transactioning(
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1957, in _transactioning
return service_model.retrying(func, env=self.env)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 137, in retrying
result = func()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1924, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2171, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 329, in _dispatch
result = endpoint(**request.params)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 727, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 35, in call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 517, in call_kw
result = getattr(recs, name)(*args, **kwargs)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5129, in get_report_information
all_column_groups_expression_totals = self._compute_expression_totals_for_each_column_group(self.line_ids.expression_ids, options, warnings=warnings)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3064, in _compute_expression_totals_for_each_column_group
current_group_expression_totals = self._compute_expression_totals_for_single_column_group(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3227, in _compute_expression_totals_for_single_column_group
formula_results = self._compute_formula_batch(column_group_options, engine, date_scope, formulas_dict, current_groupby, next_groupby,
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3577, in _compute_formula_batch
return getattr(self, engine_function_name)(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4107, in _compute_formula_batch_with_engine_custom
rslt[(formula, expressions)] = custom_engine_function(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 87, in _report_custom_engine_aged_payable
return self._aged_partner_report_custom_engine_common(options, 'liability_payable', current_groupby, next_groupby, offset=offset, limit=limit)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 272, in _aged_partner_report_custom_engine_common
self._cr.execute(query)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 354, in execute
res = self._obj.execute(query, params)
psycopg2.errors.UndefinedFunction: function round(double precision, integer) does not exist
LINE 103: ROUND(SUM((CASE WHEN account_move_line.balan...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
2025-01-31 20:16:03
|
ERROR
|
server
|
odoo.sql_db:357
bad query: b'\n WITH period_table(date_start, date_stop, period_index) AS ((VALUES (NULL, \'2025-01-31\', 0),(\'2025-01-30\', \'2025-01-01\', 1),(\'2024-12-31\', \'2024-12-02\', 2),(\'2024-12-01\', \'2024-11-02\', 3),(\'2024-11-01\', \'2024-10-03\', 4),(\'2024-10-02\', NULL, 5)))\n\n SELECT\n \n 1 * (\n SUM(account_move_line.amount_currency)\n - COALESCE(SUM(part_debit.debit_amount_currency), 0)\n + COALESCE(SUM(part_credit.credit_amount_currency), 0)\n ) AS amount_currency,\n ARRAY_AGG(DISTINCT account_move_line.partner_id) AS partner_id,\n ARRAY_AGG(account_move_line.payment_id) AS payment_id,\n ARRAY_AGG(DISTINCT move.invoice_date) AS invoice_date,\n ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS report_date,\n ARRAY_AGG(DISTINCT ("account_move_line__account_id"."code_store"->\'1\'->>0)::VARCHAR) AS account_name,\n ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS due_date,\n ARRAY_AGG(DISTINCT account_move_line.currency_id) AS currency_id,\n COUNT(account_move_line.id) AS aml_count,\n ARRAY_AGG(("account_move_line__account_id"."code_store"->\'1\'->>0)::VARCHAR) AS account_code,\n \n CASE WHEN period_table.period_index = 0\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period0"\n ,\n CASE WHEN period_table.period_index = 1\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period1"\n ,\n CASE WHEN period_table.period_index = 2\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period2"\n ,\n CASE WHEN period_table.period_index = 3\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period3"\n ,\n CASE WHEN period_table.period_index = 4\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period4"\n ,\n CASE WHEN period_table.period_index = 5\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period5"\n \n\n FROM "account_move_line" LEFT JOIN "account_account" AS "account_move_line__account_id" ON ("account_move_line"."account_id" = "account_move_line__account_id"."id")\n\n JOIN account_journal journal ON journal.id = account_move_line.journal_id\n JOIN account_move move ON move.id = account_move_line.move_id\n \n JOIN account_account aml_ct_account\n ON aml_ct_account.id = account_move_line.account_id\n LEFT JOIN account_currency_table\n ON account_move_line.company_id = account_currency_table.company_id\n AND (\n account_currency_table.rate_type = CASE\n WHEN aml_ct_account.account_type LIKE \'equity%\' THEN \'historical\'\n WHEN aml_ct_account.account_type LIKE ANY (ARRAY[\'income%\', \'expense%\', \'equity_unaffected\']) THEN \'historical\'\n ELSE \'closing\'\n END\n )\n AND (account_currency_table.date_from IS NULL OR account_currency_table.date_from <= account_move_line.date)\n AND (account_currency_table.date_next IS NULL OR account_currency_table.date_next > account_move_line.date)\n AND (account_currency_table.period_key = \'None_2025-01-31\' OR account_currency_table.period_key IS NULL)\n \n\n LEFT JOIN LATERAL (\n SELECT\n SUM(part.amount) AS amount,\n SUM(part.debit_amount_currency) AS debit_amount_currency,\n part.debit_move_id\n FROM account_partial_reconcile part\n WHERE part.max_date <= \'2025-01-31\'::date AND part.debit_move_id = account_move_line.id\n GROUP BY part.debit_move_id\n ) part_debit ON TRUE\n\n LEFT JOIN LATERAL (\n SELECT\n SUM(part.amount) AS amount,\n SUM(part.credit_amount_currency) AS credit_amount_currency,\n part.credit_move_id\n FROM account_partial_reconcile part\n WHERE part.max_date <= \'2025-01-31\'::date AND part.credit_move_id = account_move_line.id\n GROUP BY part.credit_move_id\n ) part_credit ON TRUE\n\n JOIN period_table ON\n (\n period_table.date_start IS NULL\n OR COALESCE(account_move_line."date_maturity", account_move_line.date) <= DATE(period_table.date_start)\n )\n AND\n (\n period_table.date_stop IS NULL\n OR COALESCE(account_move_line."date_maturity", account_move_line.date) >= DATE(period_table.date_stop)\n )\n\n WHERE (((((("account_move_line"."display_type" NOT IN (\'line_section\', \'line_note\')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" IN (1, 7))) AND ("account_move_line"."date" <= \'2025-01-31\')) AND ("account_move_line"."parent_state" = \'posted\')) AND ((("account_move_line__account_id"."non_trade" IS NULL OR "account_move_line__account_id"."non_trade" = FALSE) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\')) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\'))) AND (("account_move_line"."company_id" IN (1, 7)) AND ("account_move_line"."journal_id" IS NULL OR ("account_move_line"."journal_id" IN (SELECT "account_journal"."id" FROM "account_journal" WHERE (NOT EXISTS (SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids" WHERE "account_journal__user_ids"."journal_id" = "account_journal"."id") OR FALSE)))))\n\n GROUP BY period_table.period_index\n\n HAVING\n ROUND(SUM((CASE WHEN account_move_line.balance > 0 THEN account_move_line.balance else 0 END - COALESCE(part_debit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n OR ROUND(SUM((CASE WHEN account_move_line.balance < 0 THEN -account_move_line.balance else 0 END - COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n\n ORDER BY period_table.period_index\n\n \n '
ERROR: function round(double precision, integer) does not exist
LINE 103: ROUND(SUM((CASE WHEN account_move_line.balan...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
2025-01-31 20:16:03
|
ERROR
|
server
|
odoo.http:2401
Exception during request handling.
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2366, in __call__
response = request._serve_db()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1894, in _serve_db
return self._transactioning(
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1957, in _transactioning
return service_model.retrying(func, env=self.env)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 137, in retrying
result = func()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1924, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2171, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 329, in _dispatch
result = endpoint(**request.params)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 727, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 35, in call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 517, in call_kw
result = getattr(recs, name)(*args, **kwargs)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5129, in get_report_information
all_column_groups_expression_totals = self._compute_expression_totals_for_each_column_group(self.line_ids.expression_ids, options, warnings=warnings)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3064, in _compute_expression_totals_for_each_column_group
current_group_expression_totals = self._compute_expression_totals_for_single_column_group(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3227, in _compute_expression_totals_for_single_column_group
formula_results = self._compute_formula_batch(column_group_options, engine, date_scope, formulas_dict, current_groupby, next_groupby,
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3577, in _compute_formula_batch
return getattr(self, engine_function_name)(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4107, in _compute_formula_batch_with_engine_custom
rslt[(formula, expressions)] = custom_engine_function(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 84, in _report_custom_engine_aged_receivable
return self._aged_partner_report_custom_engine_common(options, 'asset_receivable', current_groupby, next_groupby, offset=offset, limit=limit)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 272, in _aged_partner_report_custom_engine_common
self._cr.execute(query)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 354, in execute
res = self._obj.execute(query, params)
psycopg2.errors.UndefinedFunction: function round(double precision, integer) does not exist
LINE 103: ROUND(SUM((CASE WHEN account_move_line.balan...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
2025-01-31 20:21:48
|
ERROR
|
server
|
odoo.sql_db:357
bad query: b'\n WITH period_table(date_start, date_stop, period_index) AS ((VALUES (NULL, \'2025-01-31\', 0),(\'2025-01-30\', \'2025-01-01\', 1),(\'2024-12-31\', \'2024-12-02\', 2),(\'2024-12-01\', \'2024-11-02\', 3),(\'2024-11-01\', \'2024-10-03\', 4),(\'2024-10-02\', NULL, 5)))\n\n SELECT\n \n 1 * (\n SUM(account_move_line.amount_currency)\n - COALESCE(SUM(part_debit.debit_amount_currency), 0)\n + COALESCE(SUM(part_credit.credit_amount_currency), 0)\n ) AS amount_currency,\n ARRAY_AGG(DISTINCT account_move_line.partner_id) AS partner_id,\n ARRAY_AGG(account_move_line.payment_id) AS payment_id,\n ARRAY_AGG(DISTINCT move.invoice_date) AS invoice_date,\n ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS report_date,\n ARRAY_AGG(DISTINCT ("account_move_line__account_id"."code_store"->\'7\'->>0)::VARCHAR) AS account_name,\n ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS due_date,\n ARRAY_AGG(DISTINCT account_move_line.currency_id) AS currency_id,\n COUNT(account_move_line.id) AS aml_count,\n ARRAY_AGG(("account_move_line__account_id"."code_store"->\'7\'->>0)::VARCHAR) AS account_code,\n \n CASE WHEN period_table.period_index = 0\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period0"\n ,\n CASE WHEN period_table.period_index = 1\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period1"\n ,\n CASE WHEN period_table.period_index = 2\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period2"\n ,\n CASE WHEN period_table.period_index = 3\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period3"\n ,\n CASE WHEN period_table.period_index = 4\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period4"\n ,\n CASE WHEN period_table.period_index = 5\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period5"\n \n\n FROM "account_move_line" LEFT JOIN "account_account" AS "account_move_line__account_id" ON ("account_move_line"."account_id" = "account_move_line__account_id"."id")\n\n JOIN account_journal journal ON journal.id = account_move_line.journal_id\n JOIN account_move move ON move.id = account_move_line.move_id\n \n JOIN account_account aml_ct_account\n ON aml_ct_account.id = account_move_line.account_id\n LEFT JOIN account_currency_table\n ON account_move_line.company_id = account_currency_table.company_id\n AND (\n account_currency_table.rate_type = CASE\n WHEN aml_ct_account.account_type LIKE \'equity%\' THEN \'historical\'\n WHEN aml_ct_account.account_type LIKE ANY (ARRAY[\'income%\', \'expense%\', \'equity_unaffected\']) THEN \'historical\'\n ELSE \'closing\'\n END\n )\n AND (account_currency_table.date_from IS NULL OR account_currency_table.date_from <= account_move_line.date)\n AND (account_currency_table.date_next IS NULL OR account_currency_table.date_next > account_move_line.date)\n AND (account_currency_table.period_key = \'None_2025-01-31\' OR account_currency_table.period_key IS NULL)\n \n\n LEFT JOIN LATERAL (\n SELECT\n SUM(part.amount) AS amount,\n SUM(part.debit_amount_currency) AS debit_amount_currency,\n part.debit_move_id\n FROM account_partial_reconcile part\n WHERE part.max_date <= \'2025-01-31\'::date AND part.debit_move_id = account_move_line.id\n GROUP BY part.debit_move_id\n ) part_debit ON TRUE\n\n LEFT JOIN LATERAL (\n SELECT\n SUM(part.amount) AS amount,\n SUM(part.credit_amount_currency) AS credit_amount_currency,\n part.credit_move_id\n FROM account_partial_reconcile part\n WHERE part.max_date <= \'2025-01-31\'::date AND part.credit_move_id = account_move_line.id\n GROUP BY part.credit_move_id\n ) part_credit ON TRUE\n\n JOIN period_table ON\n (\n period_table.date_start IS NULL\n OR COALESCE(account_move_line."date_maturity", account_move_line.date) <= DATE(period_table.date_start)\n )\n AND\n (\n period_table.date_stop IS NULL\n OR COALESCE(account_move_line."date_maturity", account_move_line.date) >= DATE(period_table.date_stop)\n )\n\n WHERE (((((("account_move_line"."display_type" NOT IN (\'line_section\', \'line_note\')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" IN (7, 1))) AND ("account_move_line"."date" <= \'2025-01-31\')) AND ("account_move_line"."parent_state" = \'posted\')) AND ((("account_move_line__account_id"."non_trade" IS NULL OR "account_move_line__account_id"."non_trade" = FALSE) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\')) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\'))) AND (("account_move_line"."company_id" IN (7, 1)) AND ("account_move_line"."journal_id" IS NULL OR ("account_move_line"."journal_id" IN (SELECT "account_journal"."id" FROM "account_journal" WHERE (NOT EXISTS (SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids" WHERE "account_journal__user_ids"."journal_id" = "account_journal"."id") OR FALSE)))))\n\n GROUP BY period_table.period_index\n\n HAVING\n ROUND(SUM((CASE WHEN account_move_line.balance > 0 THEN account_move_line.balance else 0 END - COALESCE(part_debit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n OR ROUND(SUM((CASE WHEN account_move_line.balance < 0 THEN -account_move_line.balance else 0 END - COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n\n ORDER BY period_table.period_index\n\n \n '
ERROR: function round(double precision, integer) does not exist
LINE 103: ROUND(SUM((CASE WHEN account_move_line.balan...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
2025-01-31 20:21:48
|
ERROR
|
server
|
odoo.http:2401
Exception during request handling.
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2366, in __call__
response = request._serve_db()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1894, in _serve_db
return self._transactioning(
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1957, in _transactioning
return service_model.retrying(func, env=self.env)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 137, in retrying
result = func()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1924, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2171, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 329, in _dispatch
result = endpoint(**request.params)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 727, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 35, in call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 517, in call_kw
result = getattr(recs, name)(*args, **kwargs)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5129, in get_report_information
all_column_groups_expression_totals = self._compute_expression_totals_for_each_column_group(self.line_ids.expression_ids, options, warnings=warnings)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3064, in _compute_expression_totals_for_each_column_group
current_group_expression_totals = self._compute_expression_totals_for_single_column_group(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3227, in _compute_expression_totals_for_single_column_group
formula_results = self._compute_formula_batch(column_group_options, engine, date_scope, formulas_dict, current_groupby, next_groupby,
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3577, in _compute_formula_batch
return getattr(self, engine_function_name)(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4107, in _compute_formula_batch_with_engine_custom
rslt[(formula, expressions)] = custom_engine_function(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 84, in _report_custom_engine_aged_receivable
return self._aged_partner_report_custom_engine_common(options, 'asset_receivable', current_groupby, next_groupby, offset=offset, limit=limit)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 272, in _aged_partner_report_custom_engine_common
self._cr.execute(query)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 354, in execute
res = self._obj.execute(query, params)
psycopg2.errors.UndefinedFunction: function round(double precision, integer) does not exist
LINE 103: ROUND(SUM((CASE WHEN account_move_line.balan...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
2025-01-31 21:21:32
|
ERROR
|
server
|
odoo.sql_db:357
bad query: b'\n WITH period_table(date_start, date_stop, period_index) AS ((VALUES (NULL, \'2025-01-31\', 0),(\'2025-01-30\', \'2025-01-01\', 1),(\'2024-12-31\', \'2024-12-02\', 2),(\'2024-12-01\', \'2024-11-02\', 3),(\'2024-11-01\', \'2024-10-03\', 4),(\'2024-10-02\', NULL, 5)))\n\n SELECT\n \n 1 * (\n SUM(account_move_line.amount_currency)\n - COALESCE(SUM(part_debit.debit_amount_currency), 0)\n + COALESCE(SUM(part_credit.credit_amount_currency), 0)\n ) AS amount_currency,\n ARRAY_AGG(DISTINCT account_move_line.partner_id) AS partner_id,\n ARRAY_AGG(account_move_line.payment_id) AS payment_id,\n ARRAY_AGG(DISTINCT move.invoice_date) AS invoice_date,\n ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS report_date,\n ARRAY_AGG(DISTINCT ("account_move_line__account_id"."code_store"->\'1\'->>0)::VARCHAR) AS account_name,\n ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS due_date,\n ARRAY_AGG(DISTINCT account_move_line.currency_id) AS currency_id,\n COUNT(account_move_line.id) AS aml_count,\n ARRAY_AGG(("account_move_line__account_id"."code_store"->\'1\'->>0)::VARCHAR) AS account_code,\n \n CASE WHEN period_table.period_index = 0\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period0"\n ,\n CASE WHEN period_table.period_index = 1\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period1"\n ,\n CASE WHEN period_table.period_index = 2\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period2"\n ,\n CASE WHEN period_table.period_index = 3\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period3"\n ,\n CASE WHEN period_table.period_index = 4\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period4"\n ,\n CASE WHEN period_table.period_index = 5\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period5"\n \n\n FROM "account_move_line" LEFT JOIN "account_account" AS "account_move_line__account_id" ON ("account_move_line"."account_id" = "account_move_line__account_id"."id")\n\n JOIN account_journal journal ON journal.id = account_move_line.journal_id\n JOIN account_move move ON move.id = account_move_line.move_id\n \n JOIN account_account aml_ct_account\n ON aml_ct_account.id = account_move_line.account_id\n LEFT JOIN account_currency_table\n ON account_move_line.company_id = account_currency_table.company_id\n AND (\n account_currency_table.rate_type = CASE\n WHEN aml_ct_account.account_type LIKE \'equity%\' THEN \'historical\'\n WHEN aml_ct_account.account_type LIKE ANY (ARRAY[\'income%\', \'expense%\', \'equity_unaffected\']) THEN \'historical\'\n ELSE \'closing\'\n END\n )\n AND (account_currency_table.date_from IS NULL OR account_currency_table.date_from <= account_move_line.date)\n AND (account_currency_table.date_next IS NULL OR account_currency_table.date_next > account_move_line.date)\n AND (account_currency_table.period_key = \'None_2025-01-31\' OR account_currency_table.period_key IS NULL)\n \n\n LEFT JOIN LATERAL (\n SELECT\n SUM(part.amount) AS amount,\n SUM(part.debit_amount_currency) AS debit_amount_currency,\n part.debit_move_id\n FROM account_partial_reconcile part\n WHERE part.max_date <= \'2025-01-31\'::date AND part.debit_move_id = account_move_line.id\n GROUP BY part.debit_move_id\n ) part_debit ON TRUE\n\n LEFT JOIN LATERAL (\n SELECT\n SUM(part.amount) AS amount,\n SUM(part.credit_amount_currency) AS credit_amount_currency,\n part.credit_move_id\n FROM account_partial_reconcile part\n WHERE part.max_date <= \'2025-01-31\'::date AND part.credit_move_id = account_move_line.id\n GROUP BY part.credit_move_id\n ) part_credit ON TRUE\n\n JOIN period_table ON\n (\n period_table.date_start IS NULL\n OR COALESCE(account_move_line."date_maturity", account_move_line.date) <= DATE(period_table.date_start)\n )\n AND\n (\n period_table.date_stop IS NULL\n OR COALESCE(account_move_line."date_maturity", account_move_line.date) >= DATE(period_table.date_stop)\n )\n\n WHERE (((((("account_move_line"."display_type" NOT IN (\'line_section\', \'line_note\')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" IN (1, 7))) AND ("account_move_line"."date" <= \'2025-01-31\')) AND ("account_move_line"."parent_state" = \'posted\')) AND ((("account_move_line__account_id"."non_trade" IS NULL OR "account_move_line__account_id"."non_trade" = FALSE) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\')) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\'))) AND (("account_move_line"."company_id" IN (1, 7)) AND ("account_move_line"."journal_id" IS NULL OR ("account_move_line"."journal_id" IN (SELECT "account_journal"."id" FROM "account_journal" WHERE (NOT EXISTS (SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids" WHERE "account_journal__user_ids"."journal_id" = "account_journal"."id") OR FALSE)))))\n\n GROUP BY period_table.period_index\n\n HAVING\n ROUND(SUM((CASE WHEN account_move_line.balance > 0 THEN account_move_line.balance else 0 END - COALESCE(part_debit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n OR ROUND(SUM((CASE WHEN account_move_line.balance < 0 THEN -account_move_line.balance else 0 END - COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n\n ORDER BY period_table.period_index\n\n \n '
ERROR: function round(double precision, integer) does not exist
LINE 103: ROUND(SUM((CASE WHEN account_move_line.balan...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
2025-01-31 21:21:32
|
ERROR
|
server
|
odoo.http:2401
Exception during request handling.
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2366, in __call__
response = request._serve_db()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1894, in _serve_db
return self._transactioning(
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1957, in _transactioning
return service_model.retrying(func, env=self.env)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 137, in retrying
result = func()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1924, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2171, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 329, in _dispatch
result = endpoint(**request.params)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 727, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 35, in call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 517, in call_kw
result = getattr(recs, name)(*args, **kwargs)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5129, in get_report_information
all_column_groups_expression_totals = self._compute_expression_totals_for_each_column_group(self.line_ids.expression_ids, options, warnings=warnings)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3064, in _compute_expression_totals_for_each_column_group
current_group_expression_totals = self._compute_expression_totals_for_single_column_group(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3227, in _compute_expression_totals_for_single_column_group
formula_results = self._compute_formula_batch(column_group_options, engine, date_scope, formulas_dict, current_groupby, next_groupby,
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3577, in _compute_formula_batch
return getattr(self, engine_function_name)(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4107, in _compute_formula_batch_with_engine_custom
rslt[(formula, expressions)] = custom_engine_function(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 84, in _report_custom_engine_aged_receivable
return self._aged_partner_report_custom_engine_common(options, 'asset_receivable', current_groupby, next_groupby, offset=offset, limit=limit)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 272, in _aged_partner_report_custom_engine_common
self._cr.execute(query)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 354, in execute
res = self._obj.execute(query, params)
psycopg2.errors.UndefinedFunction: function round(double precision, integer) does not exist
LINE 103: ROUND(SUM((CASE WHEN account_move_line.balan...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
2025-01-31 21:22:38
|
ERROR
|
server
|
odoo.sql_db:357
bad query: b'\n WITH period_table(date_start, date_stop, period_index) AS ((VALUES (NULL, \'2025-01-31\', 0),(\'2025-01-30\', \'2025-01-01\', 1),(\'2024-12-31\', \'2024-12-02\', 2),(\'2024-12-01\', \'2024-11-02\', 3),(\'2024-11-01\', \'2024-10-03\', 4),(\'2024-10-02\', NULL, 5)))\n\n SELECT\n \n 1 * (\n SUM(account_move_line.amount_currency)\n - COALESCE(SUM(part_debit.debit_amount_currency), 0)\n + COALESCE(SUM(part_credit.credit_amount_currency), 0)\n ) AS amount_currency,\n ARRAY_AGG(DISTINCT account_move_line.partner_id) AS partner_id,\n ARRAY_AGG(account_move_line.payment_id) AS payment_id,\n ARRAY_AGG(DISTINCT move.invoice_date) AS invoice_date,\n ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS report_date,\n ARRAY_AGG(DISTINCT ("account_move_line__account_id"."code_store"->\'7\'->>0)::VARCHAR) AS account_name,\n ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS due_date,\n ARRAY_AGG(DISTINCT account_move_line.currency_id) AS currency_id,\n COUNT(account_move_line.id) AS aml_count,\n ARRAY_AGG(("account_move_line__account_id"."code_store"->\'7\'->>0)::VARCHAR) AS account_code,\n \n CASE WHEN period_table.period_index = 0\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period0"\n ,\n CASE WHEN period_table.period_index = 1\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period1"\n ,\n CASE WHEN period_table.period_index = 2\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period2"\n ,\n CASE WHEN period_table.period_index = 3\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period3"\n ,\n CASE WHEN period_table.period_index = 4\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period4"\n ,\n CASE WHEN period_table.period_index = 5\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period5"\n \n\n FROM "account_move_line" LEFT JOIN "account_account" AS "account_move_line__account_id" ON ("account_move_line"."account_id" = "account_move_line__account_id"."id")\n\n JOIN account_journal journal ON journal.id = account_move_line.journal_id\n JOIN account_move move ON move.id = account_move_line.move_id\n \n JOIN account_account aml_ct_account\n ON aml_ct_account.id = account_move_line.account_id\n LEFT JOIN account_currency_table\n ON account_move_line.company_id = account_currency_table.company_id\n AND (\n account_currency_table.rate_type = CASE\n WHEN aml_ct_account.account_type LIKE \'equity%\' THEN \'historical\'\n WHEN aml_ct_account.account_type LIKE ANY (ARRAY[\'income%\', \'expense%\', \'equity_unaffected\']) THEN \'historical\'\n ELSE \'closing\'\n END\n )\n AND (account_currency_table.date_from IS NULL OR account_currency_table.date_from <= account_move_line.date)\n AND (account_currency_table.date_next IS NULL OR account_currency_table.date_next > account_move_line.date)\n AND (account_currency_table.period_key = \'None_2025-01-31\' OR account_currency_table.period_key IS NULL)\n \n\n LEFT JOIN LATERAL (\n SELECT\n SUM(part.amount) AS amount,\n SUM(part.debit_amount_currency) AS debit_amount_currency,\n part.debit_move_id\n FROM account_partial_reconcile part\n WHERE part.max_date <= \'2025-01-31\'::date AND part.debit_move_id = account_move_line.id\n GROUP BY part.debit_move_id\n ) part_debit ON TRUE\n\n LEFT JOIN LATERAL (\n SELECT\n SUM(part.amount) AS amount,\n SUM(part.credit_amount_currency) AS credit_amount_currency,\n part.credit_move_id\n FROM account_partial_reconcile part\n WHERE part.max_date <= \'2025-01-31\'::date AND part.credit_move_id = account_move_line.id\n GROUP BY part.credit_move_id\n ) part_credit ON TRUE\n\n JOIN period_table ON\n (\n period_table.date_start IS NULL\n OR COALESCE(account_move_line."date_maturity", account_move_line.date) <= DATE(period_table.date_start)\n )\n AND\n (\n period_table.date_stop IS NULL\n OR COALESCE(account_move_line."date_maturity", account_move_line.date) >= DATE(period_table.date_stop)\n )\n\n WHERE (((((("account_move_line"."display_type" NOT IN (\'line_section\', \'line_note\')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" IN (7, 1))) AND ("account_move_line"."date" <= \'2025-01-31\')) AND ("account_move_line"."parent_state" = \'posted\')) AND ((("account_move_line__account_id"."non_trade" IS NULL OR "account_move_line__account_id"."non_trade" = FALSE) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\')) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\'))) AND (("account_move_line"."company_id" IN (7, 1)) AND ("account_move_line"."journal_id" IS NULL OR ("account_move_line"."journal_id" IN (SELECT "account_journal"."id" FROM "account_journal" WHERE (NOT EXISTS (SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids" WHERE "account_journal__user_ids"."journal_id" = "account_journal"."id") OR FALSE)))))\n\n GROUP BY period_table.period_index\n\n HAVING\n ROUND(SUM((CASE WHEN account_move_line.balance > 0 THEN account_move_line.balance else 0 END - COALESCE(part_debit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n OR ROUND(SUM((CASE WHEN account_move_line.balance < 0 THEN -account_move_line.balance else 0 END - COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n\n ORDER BY period_table.period_index\n\n \n '
ERROR: function round(double precision, integer) does not exist
LINE 103: ROUND(SUM((CASE WHEN account_move_line.balan...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
2025-01-31 21:22:38
|
ERROR
|
server
|
odoo.http:2401
Exception during request handling.
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2366, in __call__
response = request._serve_db()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1894, in _serve_db
return self._transactioning(
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1957, in _transactioning
return service_model.retrying(func, env=self.env)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 137, in retrying
result = func()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1924, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2171, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 329, in _dispatch
result = endpoint(**request.params)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 727, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 35, in call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 517, in call_kw
result = getattr(recs, name)(*args, **kwargs)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5129, in get_report_information
all_column_groups_expression_totals = self._compute_expression_totals_for_each_column_group(self.line_ids.expression_ids, options, warnings=warnings)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3064, in _compute_expression_totals_for_each_column_group
current_group_expression_totals = self._compute_expression_totals_for_single_column_group(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3227, in _compute_expression_totals_for_single_column_group
formula_results = self._compute_formula_batch(column_group_options, engine, date_scope, formulas_dict, current_groupby, next_groupby,
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3577, in _compute_formula_batch
return getattr(self, engine_function_name)(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4107, in _compute_formula_batch_with_engine_custom
rslt[(formula, expressions)] = custom_engine_function(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 84, in _report_custom_engine_aged_receivable
return self._aged_partner_report_custom_engine_common(options, 'asset_receivable', current_groupby, next_groupby, offset=offset, limit=limit)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 272, in _aged_partner_report_custom_engine_common
self._cr.execute(query)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 354, in execute
res = self._obj.execute(query, params)
psycopg2.errors.UndefinedFunction: function round(double precision, integer) does not exist
LINE 103: ROUND(SUM((CASE WHEN account_move_line.balan...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
2025-01-31 21:27:42
|
ERROR
|
server
|
odoo.sql_db:357
bad query: b'\n WITH period_table(date_start, date_stop, period_index) AS ((VALUES (NULL, \'2025-01-31\', 0),(\'2025-01-30\', \'2025-01-01\', 1),(\'2024-12-31\', \'2024-12-02\', 2),(\'2024-12-01\', \'2024-11-02\', 3),(\'2024-11-01\', \'2024-10-03\', 4),(\'2024-10-02\', NULL, 5)))\n\n SELECT\n \n 1 * (\n SUM(account_move_line.amount_currency)\n - COALESCE(SUM(part_debit.debit_amount_currency), 0)\n + COALESCE(SUM(part_credit.credit_amount_currency), 0)\n ) AS amount_currency,\n ARRAY_AGG(DISTINCT account_move_line.partner_id) AS partner_id,\n ARRAY_AGG(account_move_line.payment_id) AS payment_id,\n ARRAY_AGG(DISTINCT move.invoice_date) AS invoice_date,\n ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS report_date,\n ARRAY_AGG(DISTINCT ("account_move_line__account_id"."code_store"->\'1\'->>0)::VARCHAR) AS account_name,\n ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS due_date,\n ARRAY_AGG(DISTINCT account_move_line.currency_id) AS currency_id,\n COUNT(account_move_line.id) AS aml_count,\n ARRAY_AGG(("account_move_line__account_id"."code_store"->\'1\'->>0)::VARCHAR) AS account_code,\n \n CASE WHEN period_table.period_index = 0\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period0"\n ,\n CASE WHEN period_table.period_index = 1\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period1"\n ,\n CASE WHEN period_table.period_index = 2\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period2"\n ,\n CASE WHEN period_table.period_index = 3\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period3"\n ,\n CASE WHEN period_table.period_index = 4\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period4"\n ,\n CASE WHEN period_table.period_index = 5\n THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n ELSE 0 END AS "period5"\n \n\n FROM "account_move_line" LEFT JOIN "account_account" AS "account_move_line__account_id" ON ("account_move_line"."account_id" = "account_move_line__account_id"."id")\n\n JOIN account_journal journal ON journal.id = account_move_line.journal_id\n JOIN account_move move ON move.id = account_move_line.move_id\n \n JOIN account_account aml_ct_account\n ON aml_ct_account.id = account_move_line.account_id\n LEFT JOIN account_currency_table\n ON account_move_line.company_id = account_currency_table.company_id\n AND (\n account_currency_table.rate_type = CASE\n WHEN aml_ct_account.account_type LIKE \'equity%\' THEN \'historical\'\n WHEN aml_ct_account.account_type LIKE ANY (ARRAY[\'income%\', \'expense%\', \'equity_unaffected\']) THEN \'historical\'\n ELSE \'closing\'\n END\n )\n AND (account_currency_table.date_from IS NULL OR account_currency_table.date_from <= account_move_line.date)\n AND (account_currency_table.date_next IS NULL OR account_currency_table.date_next > account_move_line.date)\n AND (account_currency_table.period_key = \'None_2025-01-31\' OR account_currency_table.period_key IS NULL)\n \n\n LEFT JOIN LATERAL (\n SELECT\n SUM(part.amount) AS amount,\n SUM(part.debit_amount_currency) AS debit_amount_currency,\n part.debit_move_id\n FROM account_partial_reconcile part\n WHERE part.max_date <= \'2025-01-31\'::date AND part.debit_move_id = account_move_line.id\n GROUP BY part.debit_move_id\n ) part_debit ON TRUE\n\n LEFT JOIN LATERAL (\n SELECT\n SUM(part.amount) AS amount,\n SUM(part.credit_amount_currency) AS credit_amount_currency,\n part.credit_move_id\n FROM account_partial_reconcile part\n WHERE part.max_date <= \'2025-01-31\'::date AND part.credit_move_id = account_move_line.id\n GROUP BY part.credit_move_id\n ) part_credit ON TRUE\n\n JOIN period_table ON\n (\n period_table.date_start IS NULL\n OR COALESCE(account_move_line."date_maturity", account_move_line.date) <= DATE(period_table.date_start)\n )\n AND\n (\n period_table.date_stop IS NULL\n OR COALESCE(account_move_line."date_maturity", account_move_line.date) >= DATE(period_table.date_stop)\n )\n\n WHERE (((((("account_move_line"."display_type" NOT IN (\'line_section\', \'line_note\')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" IN (1, 8))) AND ("account_move_line"."date" <= \'2025-01-31\')) AND ("account_move_line"."parent_state" = \'posted\')) AND ((("account_move_line__account_id"."non_trade" IS NULL OR "account_move_line__account_id"."non_trade" = FALSE) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\')) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\'))) AND (("account_move_line"."company_id" IN (1, 8)) AND ("account_move_line"."journal_id" IS NULL OR ("account_move_line"."journal_id" IN (SELECT "account_journal"."id" FROM "account_journal" WHERE (NOT EXISTS (SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids" WHERE "account_journal__user_ids"."journal_id" = "account_journal"."id") OR FALSE)))))\n\n GROUP BY period_table.period_index\n\n HAVING\n ROUND(SUM((CASE WHEN account_move_line.balance > 0 THEN account_move_line.balance else 0 END - COALESCE(part_debit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n OR ROUND(SUM((CASE WHEN account_move_line.balance < 0 THEN -account_move_line.balance else 0 END - COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n\n ORDER BY period_table.period_index\n\n \n '
ERROR: function round(double precision, integer) does not exist
LINE 103: ROUND(SUM((CASE WHEN account_move_line.balan...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
2025-01-31 21:27:42
|
ERROR
|
server
|
odoo.http:2401
Exception during request handling.
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2366, in __call__
response = request._serve_db()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1894, in _serve_db
return self._transactioning(
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1957, in _transactioning
return service_model.retrying(func, env=self.env)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 137, in retrying
result = func()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1924, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2171, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 329, in _dispatch
result = endpoint(**request.params)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 727, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 35, in call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 517, in call_kw
result = getattr(recs, name)(*args, **kwargs)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5129, in get_report_information
all_column_groups_expression_totals = self._compute_expression_totals_for_each_column_group(self.line_ids.expression_ids, options, warnings=warnings)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3064, in _compute_expression_totals_for_each_column_group
current_group_expression_totals = self._compute_expression_totals_for_single_column_group(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3227, in _compute_expression_totals_for_single_column_group
formula_results = self._compute_formula_batch(column_group_options, engine, date_scope, formulas_dict, current_groupby, next_groupby,
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3577, in _compute_formula_batch
return getattr(self, engine_function_name)(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4107, in _compute_formula_batch_with_engine_custom
rslt[(formula, expressions)] = custom_engine_function(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 84, in _report_custom_engine_aged_receivable
return self._aged_partner_report_custom_engine_common(options, 'asset_receivable', current_groupby, next_groupby, offset=offset, limit=limit)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 272, in _aged_partner_report_custom_engine_common
self._cr.execute(query)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 354, in execute
res = self._obj.execute(query, params)
psycopg2.errors.UndefinedFunction: function round(double precision, integer) does not exist
LINE 103: ROUND(SUM((CASE WHEN account_move_line.balan...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
|
|
2025-01-31 22:21:54
|
INFO
|
runbot
|
Kill build 117794-18-0
|