Call from cron 0. Cron Job - Load AEC XSD Files (Chilean SII) for server action #1346 failed in Job #86
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/safe_eval.py", line 399, in safe_eval
    return unsafe_eval(c, globals_dict, locals_dict)
  File "ir.actions.server(1346,)", line 1, in <module>
  File "/data/build/ingadhoc-enterprise-extensions/l10n_cl_edi_factoring/models/ir_attachment.py", line 66, in _load_aec_xsd_sii
    xsd_object = self._modify_and_validate_sii_xsd_content(content)
AttributeError: 'ir.attachment' object has no attribute '_modify_and_validate_sii_xsd_content'

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 391, 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 675, 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 545, 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 413, in safe_eval
    raise ValueError('%s: "%s" while evaluating\n%r' % (ustr(type(e)), ustr(e), expr))
ValueError: <class 'AttributeError'>: "'ir.attachment' object has no attribute '_modify_and_validate_sii_xsd_content'" while evaluating
'model._load_aec_xsd_sii()'

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"."tax_audit", "aml"."matching_number", "aml"."display_type", "aml"."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"."discount_percentage", "aml"."store_id", "aml"."expense_id", "aml"."purchase_line_id", "aml"."expected_pay_date", "aml"."user_id", "aml"."l10n_latam_document_type_id", "aml"."purchase_subscription_id", "aml"."is_downpayment", "aml"."followup_line_id", "aml"."last_followup_date", "aml"."next_action_date", "aml"."l10n_pe_group_id", "aml"."discount1", "aml"."discount2", "aml"."discount3", "aml"."is_landed_costs_line", "aml"."l10n_pe_edi_allowance_charge_reason_code", "aml"."l10n_pe_edi_affectation_reason", "aml"."subscription_mrr", "aml"."subscription_id", "aml"."subscription_start_date", "aml"."subscription_end_date", "aml"."tax_settlement_move_id", "aml"."tax_state", "aml"."reward_id", "aml"."price_taxcloud",
        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
                                                 ^

Call from cron Update AML in currency for server action #1124 failed in Job #68
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/safe_eval.py", line 399, in safe_eval
    return unsafe_eval(c, globals_dict, locals_dict)
  File "ir.actions.server(1124,)", line 1, in <module>
  File "/data/build/ingadhoc-enterprise-extensions/account_reports_multicurrency/models/currency_group.py", line 15, 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 39, 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 324, 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 391, 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 675, 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 545, 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 413, 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()'

Error Updating ADHOC Modules Data. Error:
Not Provider url or saas database uuid configured

bad query: INSERT INTO "purchase_order" ("company_id", "create_date", "create_uid", "currency_id", "date_order", "delivery_status", "invoice_count", "invoice_status", "mail_reception_confirmed", "mail_reminder_confirmed", "name", "picking_type_id", "priority", "state", "user_id", "write_date", "write_uid") VALUES (10, '2025-08-21 20:05:39.451517', 2, 20, '2025-08-21 20:05:39', 'no', 0, 'no', false, false, '1-1', 121, '0', 'draft', 2, '2025-08-21 20:05:39.451517', 2) RETURNING "id"
ERROR: null value in column "partner_id" of relation "purchase_order" violates not-null constraint
DETAIL:  Failing row contains (79, null, null, null, 20, 0, null, null, null, 2, 10, 2, 2, null, 1-1, 0, null, null, draft, no, null, null, null, null, f, f, 2025-08-21 20:05:39, null, null, null, 2025-08-21 20:05:39.451517, 2025-08-21 20:05:39.451517, null, 121, null, null, null, null, null, null, null, null, no, null).

bad query: INSERT INTO "purchase_order" ("company_id", "create_date", "create_uid", "currency_id", "date_order", "delivery_status", "invoice_count", "invoice_status", "mail_reception_confirmed", "mail_reminder_confirmed", "name", "picking_type_id", "priority", "state", "user_id", "write_date", "write_uid") VALUES (10, '2025-08-21 20:15:14.941624', 2, 20, '2025-08-21 20:15:14', 'no', 0, 'no', false, false, '6-6', 121, '0', 'draft', 2, '2025-08-21 20:15:14.941624', 2) RETURNING "id"
ERROR: null value in column "partner_id" of relation "purchase_order" violates not-null constraint
DETAIL:  Failing row contains (81, null, null, null, 20, 0, null, null, null, 2, 10, 2, 2, null, 6-6, 0, null, null, draft, no, null, null, null, null, f, f, 2025-08-21 20:15:14, null, null, null, 2025-08-21 20:15:14.941624, 2025-08-21 20:15:14.941624, null, 121, null, null, null, null, null, null, null, null, no, null).

Call from cron Saas Client Database Backup for server action #372 failed in Job #21
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_cron.py", line 391, 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 675, 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 545, 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 399, in safe_eval
    return unsafe_eval(c, globals_dict, locals_dict)
  File "ir.actions.server(372,)", line 1, in <module>
  File "/data/build/ingadhoc-odoo-saas/saas_client/wizards/saas_client_dashboard.py", line 101, in cron_backup_database
    self.backup_database()
  File "/data/build/ingadhoc-odoo-saas/saas_client/wizards/saas_client_dashboard.py", line 133, in backup_database
    storage_type = self.get_bucket_type()
  File "/data/build/ingadhoc-odoo-saas/saas_client/wizards/saas_client_dashboard.py", line 66, in get_bucket_type
    raise ValidationError(_('No hay bucket configurado'))
odoo.exceptions.ValidationError: No hay bucket configurado

Error Updating ADHOC Modules Data. Error:
Not Provider url or saas database uuid configured

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"."tax_audit", "aml"."matching_number", "aml"."display_type", "aml"."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"."discount_percentage", "aml"."store_id", "aml"."expense_id", "aml"."purchase_line_id", "aml"."expected_pay_date", "aml"."user_id", "aml"."l10n_latam_document_type_id", "aml"."purchase_subscription_id", "aml"."is_downpayment", "aml"."followup_line_id", "aml"."last_followup_date", "aml"."next_action_date", "aml"."l10n_pe_group_id", "aml"."discount1", "aml"."discount2", "aml"."discount3", "aml"."is_landed_costs_line", "aml"."l10n_pe_edi_allowance_charge_reason_code", "aml"."l10n_pe_edi_affectation_reason", "aml"."subscription_mrr", "aml"."subscription_id", "aml"."subscription_start_date", "aml"."subscription_end_date", "aml"."tax_settlement_move_id", "aml"."tax_state", "aml"."reward_id", "aml"."price_taxcloud",
        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
                                                 ^

Call from cron Update AML in currency for server action #1124 failed in Job #68
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/safe_eval.py", line 399, in safe_eval
    return unsafe_eval(c, globals_dict, locals_dict)
  File "ir.actions.server(1124,)", line 1, in <module>
  File "/data/build/ingadhoc-enterprise-extensions/account_reports_multicurrency/models/currency_group.py", line 15, 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 39, 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 324, 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 391, 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 675, 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 545, 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 413, 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()'

bad query: 
                WITH visitor AS (
                    
            INSERT INTO website_visitor (
                partner_id, access_token, last_connection_datetime, visit_count, lang_id,
                website_id, timezone, write_uid, create_uid, write_date, create_date, country_id)
            VALUES (
                3, 3, now() at time zone 'UTC', 1, 1,
                1, 'America/Cordoba', 2, 2,
                now() at time zone 'UTC', now() at time zone 'UTC', (
                    SELECT id FROM res_country WHERE code = NULL
                )
            )
            ON CONFLICT (access_token)
            DO UPDATE SET
                last_connection_datetime=excluded.last_connection_datetime,
                visit_count = CASE WHEN website_visitor.last_connection_datetime < NOW() AT TIME ZONE 'UTC' - INTERVAL '8 hours'
                                    THEN website_visitor.visit_count + 1
                                    ELSE website_visitor.visit_count
                                END
            RETURNING id, CASE WHEN create_date = now() at time zone 'UTC' THEN 'inserted' ELSE 'updated' END AS upsert
        , 'https://04521-16-0-all.runbot.dev-adhoc.com/' AS url, 4 AS page_id
                ), track AS (
                    INSERT INTO website_track (visitor_id, url, page_id, visit_datetime)
                    SELECT id, url, page_id::integer, now() at time zone 'UTC' FROM visitor
                )
                SELECT id, upsert from visitor;
            
ERROR: could not serialize access due to concurrent update

Call from cron Saas Client Database Backup for server action #372 failed in Job #21
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_cron.py", line 391, 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 675, 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 545, 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 399, in safe_eval
    return unsafe_eval(c, globals_dict, locals_dict)
  File "ir.actions.server(372,)", line 1, in <module>
  File "/data/build/ingadhoc-odoo-saas/saas_client/wizards/saas_client_dashboard.py", line 101, in cron_backup_database
    self.backup_database()
  File "/data/build/ingadhoc-odoo-saas/saas_client/wizards/saas_client_dashboard.py", line 133, in backup_database
    storage_type = self.get_bucket_type()
  File "/data/build/ingadhoc-odoo-saas/saas_client/wizards/saas_client_dashboard.py", line 66, in get_bucket_type
    raise ValidationError(_('No hay bucket configurado'))
odoo.exceptions.ValidationError: No hay bucket configurado

Error Updating ADHOC Modules Data. Error:
Not Provider url or saas database uuid configured

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"."tax_audit", "aml"."matching_number", "aml"."display_type", "aml"."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"."discount_percentage", "aml"."store_id", "aml"."expense_id", "aml"."purchase_line_id", "aml"."expected_pay_date", "aml"."user_id", "aml"."l10n_latam_document_type_id", "aml"."purchase_subscription_id", "aml"."is_downpayment", "aml"."followup_line_id", "aml"."last_followup_date", "aml"."next_action_date", "aml"."l10n_pe_group_id", "aml"."discount1", "aml"."discount2", "aml"."discount3", "aml"."is_landed_costs_line", "aml"."l10n_pe_edi_allowance_charge_reason_code", "aml"."l10n_pe_edi_affectation_reason", "aml"."subscription_mrr", "aml"."subscription_id", "aml"."subscription_start_date", "aml"."subscription_end_date", "aml"."tax_settlement_move_id", "aml"."tax_state", "aml"."reward_id", "aml"."price_taxcloud",
        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
                                                 ^

Call from cron Update AML in currency for server action #1124 failed in Job #68
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/safe_eval.py", line 399, in safe_eval
    return unsafe_eval(c, globals_dict, locals_dict)
  File "ir.actions.server(1124,)", line 1, in <module>
  File "/data/build/ingadhoc-enterprise-extensions/account_reports_multicurrency/models/currency_group.py", line 15, 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 39, 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 324, 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 391, 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 675, 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 545, 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 413, 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()'

Call from cron Saas Client Database Backup for server action #372 failed in Job #21
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_cron.py", line 391, 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 675, 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 545, 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 399, in safe_eval
    return unsafe_eval(c, globals_dict, locals_dict)
  File "ir.actions.server(372,)", line 1, in <module>
  File "/data/build/ingadhoc-odoo-saas/saas_client/wizards/saas_client_dashboard.py", line 101, in cron_backup_database
    self.backup_database()
  File "/data/build/ingadhoc-odoo-saas/saas_client/wizards/saas_client_dashboard.py", line 133, in backup_database
    storage_type = self.get_bucket_type()
  File "/data/build/ingadhoc-odoo-saas/saas_client/wizards/saas_client_dashboard.py", line 66, in get_bucket_type
    raise ValidationError(_('No hay bucket configurado'))
odoo.exceptions.ValidationError: No hay bucket configurado

Error Updating ADHOC Modules Data. Error:
Not Provider url or saas database uuid configured

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"."tax_audit", "aml"."matching_number", "aml"."display_type", "aml"."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"."discount_percentage", "aml"."store_id", "aml"."expense_id", "aml"."purchase_line_id", "aml"."expected_pay_date", "aml"."user_id", "aml"."l10n_latam_document_type_id", "aml"."purchase_subscription_id", "aml"."is_downpayment", "aml"."followup_line_id", "aml"."last_followup_date", "aml"."next_action_date", "aml"."l10n_pe_group_id", "aml"."discount1", "aml"."discount2", "aml"."discount3", "aml"."is_landed_costs_line", "aml"."l10n_pe_edi_allowance_charge_reason_code", "aml"."l10n_pe_edi_affectation_reason", "aml"."subscription_mrr", "aml"."subscription_id", "aml"."subscription_start_date", "aml"."subscription_end_date", "aml"."tax_settlement_move_id", "aml"."tax_state", "aml"."reward_id", "aml"."price_taxcloud",
        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
                                                 ^

Call from cron Update AML in currency for server action #1124 failed in Job #68
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/safe_eval.py", line 399, in safe_eval
    return unsafe_eval(c, globals_dict, locals_dict)
  File "ir.actions.server(1124,)", line 1, in <module>
  File "/data/build/ingadhoc-enterprise-extensions/account_reports_multicurrency/models/currency_group.py", line 15, 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 39, 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 324, 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 391, 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 675, 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 545, 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 413, 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()'

Call from cron Saas Client Database Backup for server action #372 failed in Job #21
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_cron.py", line 391, 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 675, 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 545, 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 399, in safe_eval
    return unsafe_eval(c, globals_dict, locals_dict)
  File "ir.actions.server(372,)", line 1, in <module>
  File "/data/build/ingadhoc-odoo-saas/saas_client/wizards/saas_client_dashboard.py", line 101, in cron_backup_database
    self.backup_database()
  File "/data/build/ingadhoc-odoo-saas/saas_client/wizards/saas_client_dashboard.py", line 133, in backup_database
    storage_type = self.get_bucket_type()
  File "/data/build/ingadhoc-odoo-saas/saas_client/wizards/saas_client_dashboard.py", line 66, in get_bucket_type
    raise ValidationError(_('No hay bucket configurado'))
odoo.exceptions.ValidationError: No hay bucket configurado

Error Updating ADHOC Modules Data. Error:
Not Provider url or saas database uuid configured

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"."tax_audit", "aml"."matching_number", "aml"."display_type", "aml"."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"."discount_percentage", "aml"."store_id", "aml"."expense_id", "aml"."purchase_line_id", "aml"."expected_pay_date", "aml"."user_id", "aml"."l10n_latam_document_type_id", "aml"."purchase_subscription_id", "aml"."is_downpayment", "aml"."followup_line_id", "aml"."last_followup_date", "aml"."next_action_date", "aml"."l10n_pe_group_id", "aml"."discount1", "aml"."discount2", "aml"."discount3", "aml"."is_landed_costs_line", "aml"."l10n_pe_edi_allowance_charge_reason_code", "aml"."l10n_pe_edi_affectation_reason", "aml"."subscription_mrr", "aml"."subscription_id", "aml"."subscription_start_date", "aml"."subscription_end_date", "aml"."tax_settlement_move_id", "aml"."tax_state", "aml"."reward_id", "aml"."price_taxcloud",
        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
                                                 ^

Call from cron Update AML in currency for server action #1124 failed in Job #68
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/safe_eval.py", line 399, in safe_eval
    return unsafe_eval(c, globals_dict, locals_dict)
  File "ir.actions.server(1124,)", line 1, in <module>
  File "/data/build/ingadhoc-enterprise-extensions/account_reports_multicurrency/models/currency_group.py", line 15, 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 39, 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 324, 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 391, 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 675, 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 545, 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 413, 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()'

Call from cron Saas Client Database Backup for server action #372 failed in Job #21
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_cron.py", line 391, 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 675, 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 545, 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 399, in safe_eval
    return unsafe_eval(c, globals_dict, locals_dict)
  File "ir.actions.server(372,)", line 1, in <module>
  File "/data/build/ingadhoc-odoo-saas/saas_client/wizards/saas_client_dashboard.py", line 101, in cron_backup_database
    self.backup_database()
  File "/data/build/ingadhoc-odoo-saas/saas_client/wizards/saas_client_dashboard.py", line 133, in backup_database
    storage_type = self.get_bucket_type()
  File "/data/build/ingadhoc-odoo-saas/saas_client/wizards/saas_client_dashboard.py", line 66, in get_bucket_type
    raise ValidationError(_('No hay bucket configurado'))
odoo.exceptions.ValidationError: No hay bucket configurado

Error Updating ADHOC Modules Data. Error:
Not Provider url or saas database uuid configured

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"."tax_audit", "aml"."matching_number", "aml"."display_type", "aml"."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"."discount_percentage", "aml"."store_id", "aml"."expense_id", "aml"."purchase_line_id", "aml"."expected_pay_date", "aml"."user_id", "aml"."l10n_latam_document_type_id", "aml"."purchase_subscription_id", "aml"."is_downpayment", "aml"."followup_line_id", "aml"."last_followup_date", "aml"."next_action_date", "aml"."l10n_pe_group_id", "aml"."discount1", "aml"."discount2", "aml"."discount3", "aml"."is_landed_costs_line", "aml"."l10n_pe_edi_allowance_charge_reason_code", "aml"."l10n_pe_edi_affectation_reason", "aml"."subscription_mrr", "aml"."subscription_id", "aml"."subscription_start_date", "aml"."subscription_end_date", "aml"."tax_settlement_move_id", "aml"."tax_state", "aml"."reward_id", "aml"."price_taxcloud",
        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
                                                 ^

Call from cron Update AML in currency for server action #1124 failed in Job #68
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/safe_eval.py", line 399, in safe_eval
    return unsafe_eval(c, globals_dict, locals_dict)
  File "ir.actions.server(1124,)", line 1, in <module>
  File "/data/build/ingadhoc-enterprise-extensions/account_reports_multicurrency/models/currency_group.py", line 15, 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 39, 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 324, 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 391, 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 675, 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 545, 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 413, 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()'