bad query: b'SELECT date_trunc(\'month\', timezone(\'America/Cordoba\', timezone(\'UTC\', "sale_report"."date"))::timestamp), COUNT(*), SUM("sale_report"."price_subtotal") FROM (\n            \n            SELECT \n            MIN(l.id) AS id,\n            l.product_id AS product_id,\n            l.invoice_status AS line_invoice_status,\n            t.uom_id AS product_uom,\n            CASE WHEN l.product_id IS NOT NULL THEN SUM(l.product_uom_qty / u.factor * u2.factor) ELSE 0 END AS product_uom_qty,\n            CASE WHEN l.product_id IS NOT NULL THEN SUM(l.qty_delivered / u.factor * u2.factor) ELSE 0 END AS qty_delivered,\n            CASE WHEN l.product_id IS NOT NULL THEN SUM((l.product_uom_qty - l.qty_delivered) / u.factor * u2.factor) ELSE 0 END AS qty_to_deliver,\n            CASE WHEN l.product_id IS NOT NULL THEN SUM(l.qty_invoiced / u.factor * u2.factor) ELSE 0 END AS qty_invoiced,\n            CASE WHEN l.product_id IS NOT NULL THEN SUM(l.qty_to_invoice / u.factor * u2.factor) ELSE 0 END AS qty_to_invoice,\n            CASE WHEN l.product_id IS NOT NULL THEN AVG(l.price_unit\n                / CASE COALESCE(s.currency_rate, 0) WHEN 0 THEN 1.0 ELSE s.currency_rate END\n                * CASE COALESCE(account_currency_table.rate, 0) WHEN 0 THEN 1.0 ELSE account_currency_table.rate END\n                ) ELSE 0\n            END AS price_unit,\n            CASE WHEN l.product_id IS NOT NULL THEN SUM(l.price_total\n                / CASE COALESCE(s.currency_rate, 0) WHEN 0 THEN 1.0 ELSE s.currency_rate END\n                * CASE COALESCE(account_currency_table.rate, 0) WHEN 0 THEN 1.0 ELSE account_currency_table.rate END\n                ) ELSE 0\n            END AS price_total,\n            CASE WHEN l.product_id IS NOT NULL THEN SUM(l.price_subtotal\n                / CASE COALESCE(s.currency_rate, 0) WHEN 0 THEN 1.0 ELSE s.currency_rate END\n                * CASE COALESCE(account_currency_table.rate, 0) WHEN 0 THEN 1.0 ELSE account_currency_table.rate END\n                ) ELSE 0\n            END AS price_subtotal,\n            CASE WHEN l.product_id IS NOT NULL OR l.is_downpayment THEN SUM(l.untaxed_amount_to_invoice\n                / CASE COALESCE(s.currency_rate, 0) WHEN 0 THEN 1.0 ELSE s.currency_rate END\n                * CASE COALESCE(account_currency_table.rate, 0) WHEN 0 THEN 1.0 ELSE account_currency_table.rate END\n                ) ELSE 0\n            END AS untaxed_amount_to_invoice,\n            CASE WHEN l.product_id IS NOT NULL OR l.is_downpayment THEN SUM(l.untaxed_amount_invoiced\n                / CASE COALESCE(s.currency_rate, 0) WHEN 0 THEN 1.0 ELSE s.currency_rate END\n                * CASE COALESCE(account_currency_table.rate, 0) WHEN 0 THEN 1.0 ELSE account_currency_table.rate END\n                ) ELSE 0\n            END AS untaxed_amount_invoiced,\n            COUNT(*) AS nbr,\n            s.name AS name,\n            s.date_order AS date,\n            s.state AS state,\n            s.invoice_status as invoice_status,\n            s.partner_id AS partner_id,\n            s.user_id AS user_id,\n            s.company_id AS company_id,\n            s.campaign_id AS campaign_id,\n            s.medium_id AS medium_id,\n            s.source_id AS source_id,\n            t.categ_id AS categ_id,\n            s.pricelist_id AS pricelist_id,\n            s.team_id AS team_id,\n            p.product_tmpl_id,\n            partner.commercial_partner_id AS commercial_partner_id,\n            partner.country_id AS country_id,\n            partner.industry_id AS industry_id,\n            partner.state_id AS state_id,\n            partner.zip AS partner_zip,\n            CASE WHEN l.product_id IS NOT NULL THEN SUM(p.weight * l.product_uom_qty / u.factor * u2.factor) ELSE 0 END AS weight,\n            CASE WHEN l.product_id IS NOT NULL THEN SUM(p.volume * l.product_uom_qty / u.factor * u2.factor) ELSE 0 END AS volume,\n            l.discount AS discount,\n            CASE WHEN l.product_id IS NOT NULL THEN SUM(l.price_unit * l.product_uom_qty * l.discount / 100.0\n                / CASE COALESCE(s.currency_rate, 0) WHEN 0 THEN 1.0 ELSE s.currency_rate END\n                * CASE COALESCE(account_currency_table.rate, 0) WHEN 0 THEN 1.0 ELSE account_currency_table.rate END\n                ) ELSE 0\n            END AS discount_amount,\n            concat(\'sale.order\', \',\', s.id) AS order_reference,\n            t.product_brand_id AS product_brand_id,\n            s.warehouse_id AS warehouse_id,\n            SUM(l.margin\n            / CASE COALESCE(s.currency_rate, 0) WHEN 0 THEN 1.0 ELSE s.currency_rate END\n            * CASE COALESCE(account_currency_table.rate, 0) WHEN 0 THEN 1.0 ELSE account_currency_table.rate END)\n         AS margin,\n            s.website_id AS website_id,\n            \n            s.date_order <= (timezone(\'utc\', now()) - ((COALESCE(w.cart_abandoned_delay, \'1.0\') || \' hour\')::INTERVAL))\n            AND s.website_id IS NOT NULL\n            AND s.state = \'draft\'\n            AND s.partner_id != 4 AS is_abandoned_cart,\n            s.project_id AS project_id,\n            s.type_id AS type_id\n            FROM \n            sale_order_line l\n            LEFT JOIN sale_order s ON s.id=l.order_id\n            JOIN res_partner partner ON s.partner_id = partner.id\n            LEFT JOIN product_product p ON l.product_id=p.id\n            LEFT JOIN product_template t ON p.product_tmpl_id=t.id\n            LEFT JOIN uom_uom u ON u.id=l.product_uom\n            LEFT JOIN uom_uom u2 ON u2.id=t.uom_id\n            JOIN account_currency_table ON account_currency_table.company_id = s.company_id\n            \n            LEFT JOIN website w ON w.id = s.website_id\n            WHERE \n            l.display_type IS NULL\n            AND (\n                s.subscription_state IS NULL OR\n                (t.recurring_invoice IS False AND\n                s.subscription_state = \'7_upsell\') OR\n                s.subscription_state != \'7_upsell\'\n            )\n        \n            GROUP BY \n            \n            l.product_id,\n            l.order_id,\n            l.price_unit,\n            l.invoice_status,\n            t.uom_id,\n            t.categ_id,\n            s.name,\n            s.date_order,\n            s.partner_id,\n            s.user_id,\n            s.state,\n            s.invoice_status,\n            s.company_id,\n            s.campaign_id,\n            s.medium_id,\n            s.source_id,\n            s.pricelist_id,\n            s.team_id,\n            p.product_tmpl_id,\n            partner.commercial_partner_id,\n            partner.country_id,\n            partner.industry_id,\n            partner.state_id,\n            partner.zip,\n            l.is_downpayment,\n            l.discount,\n            s.id,\n            account_currency_table.rate,\n            t.product_brand_id,\n            s.warehouse_id,\n            s.website_id,\n            w.cart_abandoned_delay, s.type_id\n            \n        UNION ALL (\n            SELECT \n            -MIN(l.id) AS id,\n            l.product_id AS product_id,\n            NULL AS line_invoice_status,\n            t.uom_id AS product_uom,\n            SUM(l.qty) AS product_uom_qty,\n            SUM(l.qty_delivered) AS qty_delivered,\n            SUM(l.qty - l.qty_delivered) AS qty_to_deliver,\n            CASE WHEN pos.state = \'invoiced\' THEN SUM(l.qty) ELSE 0 END AS qty_invoiced,\n            CASE WHEN pos.state != \'invoiced\' THEN SUM(l.qty) ELSE 0 END AS qty_to_invoice,\n            AVG(l.price_unit)\n                / MIN(CASE COALESCE(pos.currency_rate, 0) WHEN 0 THEN 1.0 ELSE pos.currency_rate END)\n                * CASE COALESCE(account_currency_table.rate, 0) WHEN 0 THEN 1.0 ELSE account_currency_table.rate END\n            AS price_unit,\n            SUM(l.price_subtotal_incl)\n                / MIN(CASE COALESCE(pos.currency_rate, 0) WHEN 0 THEN 1.0 ELSE pos.currency_rate END)\n                * CASE COALESCE(account_currency_table.rate, 0) WHEN 0 THEN 1.0 ELSE account_currency_table.rate END\n            AS price_total,\n            SUM(l.price_subtotal)\n                / MIN(CASE COALESCE(pos.currency_rate, 0) WHEN 0 THEN 1.0 ELSE pos.currency_rate END)\n                * CASE COALESCE(account_currency_table.rate, 0) WHEN 0 THEN 1.0 ELSE account_currency_table.rate END\n            AS price_subtotal,\n            (CASE WHEN pos.state != \'invoiced\' THEN SUM(l.price_subtotal) ELSE 0 END)\n                / MIN(CASE COALESCE(pos.currency_rate, 0) WHEN 0 THEN 1.0 ELSE pos.currency_rate END)\n                * CASE COALESCE(account_currency_table.rate, 0) WHEN 0 THEN 1.0 ELSE account_currency_table.rate END\n            AS amount_to_invoice,\n            (CASE WHEN pos.state = \'invoiced\' THEN SUM(l.price_subtotal) ELSE 0 END)\n                / MIN(CASE COALESCE(pos.currency_rate, 0) WHEN 0 THEN 1.0 ELSE pos.currency_rate END)\n                * CASE COALESCE(account_currency_table.rate, 0) WHEN 0 THEN 1.0 ELSE account_currency_table.rate END\n            AS amount_invoiced,\n            count(*) AS nbr,\n            pos.name AS name,\n            pos.date_order AS date,\n            (CASE WHEN pos.state = \'done\' THEN \'sale\' ELSE pos.state END) AS state,\n            NULL as invoice_status,\n            pos.partner_id AS partner_id,\n            pos.user_id AS user_id,\n            pos.company_id AS company_id,\n            NULL AS campaign_id,\n            NULL AS medium_id,\n            NULL AS source_id,\n            t.categ_id AS categ_id,\n            pos.pricelist_id AS pricelist_id,\n            pos.crm_team_id AS team_id,\n            p.product_tmpl_id,\n            partner.commercial_partner_id AS commercial_partner_id,\n            partner.country_id AS country_id,\n            partner.industry_id AS industry_id,\n            partner.state_id AS state_id,\n            partner.zip AS partner_zip,\n            (SUM(p.weight) * l.qty) AS weight,\n           
 ...<message too long, truncated>

Exception during request handling.
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2576, in __call__
    response = request._serve_db()
               ^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2103, in _serve_db
    return self._transactioning(
           ^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2166, in _transactioning
    return service_model.retrying(func, env=self.env)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 156, in retrying
    result = func()
             ^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2133, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2381, 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 333, in _dispatch
    result = endpoint(**request.params)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 754, in route_wrapper
    result = endpoint(self, *args, **params_ok)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 36, in call_kw
    return call_kw(request.env[model], method, args, kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 535, in call_kw
    result = getattr(recs, name)(*args, **kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/models/models.py", line 246, in web_read_group
    groups = self._web_read_group(domain, fields, groupby, limit, offset, orderby, lazy)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/models/models.py", line 272, in _web_read_group
    groups = self.read_group(domain, fields, groupby, offset=offset, limit=limit,
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 2888, in read_group
    rows = self._read_group(domain, annotated_groupby.values(), annotated_aggregates.values(), offset=offset, limit=limit, order=orderby)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/models.py", line 2021, in _read_group
    row_values = self.env.execute_query(query.select(*[groupby_terms[spec] for spec in groupby], *select_terms))
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 993, in execute_query
    self.cr.execute(query)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 357, in execute
    res = self._obj.execute(query, params)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
psycopg2.errors.InvalidParameterValue: time zone "America/Cordoba" not recognized