bad query: b'SELECT date_trunc(\'month\', timezone(\'America/Cordoba\', timezone(\'UTC\', "sale_report"."date"))::timestamp), COUNT(*), SUM("sale_report"."product_uom_qty") 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_id,\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            1 AS currency_id,\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.type_id AS type_id,\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            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_id\n            LEFT JOIN uom_uom u2 ON u2.id=t.uom_id\n            JOIN (VALUES (1, CAST(NULL AS VARCHAR), CAST(NULL AS DATE), CAST(NULL AS DATE), \'current\', 1)) AS account_currency_table(company_id, period_key, date_from, date_next, rate_type, rate) 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, s.type_id,\n            s.website_id,\n            w.cart_abandoned_delay\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_id,\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.account_move IS NOT NULL THEN SUM(l.qty) ELSE 0 END AS qty_invoiced,\n            CASE WHEN pos.account_move IS NULL 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(SIGN(l.qty) * SIGN(l.price_unit) * ABS(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(SIGN(l.qty) * SIGN(l.price_unit) * ABS(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.account_move IS NULL 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.account_move IS NOT NULL 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            pos.state 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          
 ...<message too long, truncated>

Exception during request handling.
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2829, in __call__
    response = request._serve_db()
               ^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2304, in _serve_db
    raise self._update_served_exception(exc)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2302, in _serve_db
    return service_model.retrying(serve_func, env=self.env)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 188, in retrying
    result = func()
             ^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2357, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2572, 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 353, in _dispatch
    result = endpoint(**request.params)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 811, in route_wrapper
    result = endpoint(self, *args, **params_ok)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 32, in call_kw
    return call_kw(request.env[model], method, args, kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 97, in call_kw
    result = method(recs, *args, **kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/models/models.py", line 878, in formatted_read_group
    groups = self._read_group(
             ^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/orm/models.py", line 1932, in _read_group
    row_values = self.env.execute_query(query.select(*select_args))
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/orm/environments.py", line 534, in execute_query
    self.cr.execute(query)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 440, in execute
    self._obj.execute(query, params)
psycopg2.errors.InvalidParameterValue: time zone "America/Cordoba" not recognized