Date | Level | Type | Message |
---|---|---|---|
2024-12-20 15:08:42 | INFO | runbot | Init build environment with config Adhoc Conf for demo (y personalizaciones) 17+ |
2024-12-20 15:08:42 | Starting step all_no_test from config Adhoc Conf for demo (y personalizaciones) 17+ | ||
2024-12-20 15:08:42 | INFO | runbot | Using Dockerfile Tag odoo:adhoc-odoo-17 |
2024-12-20 15:09:06 | INFO | server | odoo.modules.loading:303 1 modules loaded in 11.38s, 9049 queries (+9049 extra) |
2024-12-20 15:14:43 | INFO | server | odoo.addons.l10n_ar_edi.models.res_company:216 Setting demo certificate from to OdooCert9 in (AR) Responsable Inscripto company |
2024-12-20 15:14:43 | INFO | server | odoo.addons.l10n_ar_edi.models.res_company:216 Setting demo certificate from to OdooCert2 in (AR) Monotributista company |
2024-12-20 15:14:43 | INFO | server | odoo.addons.l10n_ar_edi.models.res_company:216 Setting demo certificate from to OdooCert7 in (AR) Exento company |
2024-12-20 15:15:31 | 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-12-20 15:18:25 | INFO | server | odoo.modules.loading:303 303 modules loaded in 547.04s, 249984 queries (+250024 extra) |
2024-12-20 15:18:28 | INFO | server | odoo.modules.loading:303 310 modules loaded in 7.11s, 1641 queries (+1641 extra) |
2024-12-20 15:18:41 | Step all_no_test finished in 10m | ||
2024-12-20 15:18:41 | Starting step setup from config Adhoc Conf for demo (y personalizaciones) 17+ | ||
2024-12-20 15:18:41 | INFO | runbot | Using Dockerfile Tag odoo:adhoc-odoo-17 |
2024-12-20 15:18:43 | INFO | runbot | Step setup finished in 1s |
2024-12-20 15:18:43 | Starting step run from config Adhoc Conf for demo (y personalizaciones) 17+ | ||
2024-12-20 15:18:43 | INFO | runbot | Start running build 103958-17-0 |
2024-12-20 15:18:43 | INFO | runbot | Using Dockerfile Tag odoo:adhoc-odoo-17 |
2024-12-20 15:18:46 | INFO | server | odoo.modules.loading:303 1 modules loaded in 0.01s, 0 queries (+0 extra) |
2024-12-20 15:18:52 | INFO | server | odoo.modules.loading:303 310 modules loaded in 5.07s, 0 queries (+0 extra) |
2024-12-20 15:20:30 | 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-12-20 15:20:30 | 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-12-20 20:03:26 | INFO | runbot | Kill build 103958-17-0 |