bad query: b'SELECT date_trunc(\'day\', timezone(\'America/Buenos_Aires\', timezone(\'UTC\', "purchase_report"."date_approve"))::timestamp), COUNT(*), SUM("purchase_report"."untaxed_total") FROM (\n                \n                SELECT\n                    po.id as order_id,\n                    min(l.id) as id,\n                    po.date_order as date_order,\n                    po.state,\n                    po.date_approve,\n                    po.dest_address_id,\n                    po.partner_id as partner_id,\n                    po.user_id as user_id,\n                    po.company_id as company_id,\n                    po.fiscal_position_id as fiscal_position_id,\n                    l.product_id,\n                    p.product_tmpl_id,\n                    t.categ_id as category_id,\n                    c.currency_id,\n                    t.uom_id as product_uom,\n                    extract(epoch from age(po.date_approve,po.date_order))/(24*60*60)::decimal(16,2) as delay,\n                    extract(epoch from age(l.date_planned,po.date_order))/(24*60*60)::decimal(16,2) as delay_pass,\n                    count(*) as nbr_lines,\n                    sum(l.price_total / COALESCE(po.currency_rate, 1.0))::decimal(16,2) * account_currency_table.rate as price_total,\n                    (sum(l.product_qty * l.price_unit / COALESCE(po.currency_rate, 1.0))/NULLIF(sum(l.product_qty/line_uom.factor*product_uom.factor),0.0))::decimal(16,2) * account_currency_table.rate as price_average,\n                    partner.country_id as country_id,\n                    partner.commercial_partner_id as commercial_partner_id,\n                    sum(p.weight * l.product_qty/line_uom.factor*product_uom.factor) as weight,\n                    sum(p.volume * l.product_qty/line_uom.factor*product_uom.factor) as volume,\n                    sum(l.price_subtotal / COALESCE(po.currency_rate, 1.0))::decimal(16,2) * account_currency_table.rate as untaxed_total,\n                    sum(l.product_qty / line_uom.factor * product_uom.factor) as qty_ordered,\n                    sum(l.qty_received / line_uom.factor * product_uom.factor) as qty_received,\n                    sum(l.qty_invoiced / line_uom.factor * product_uom.factor) as qty_billed,\n                    case when t.purchase_method = \'purchase\'\n                         then sum(l.product_qty / line_uom.factor * product_uom.factor) - sum(l.qty_invoiced / line_uom.factor * product_uom.factor)\n                         else sum(l.qty_received / line_uom.factor * product_uom.factor) - sum(l.qty_invoiced / line_uom.factor * product_uom.factor)\n                    end as qty_to_be_billed\n            ,\n                spt.warehouse_id as picking_type_id, po.effective_date as effective_date,\n                extract(\n                    epoch from age(\n                        l.date_planned,\n                        COALESCE(\n                            order_effective_date.date_done,\n                            po.date_order\n                        )\n                    )\n                )/(24*60*60)::decimal(16,2) as days_to_arrival\n             \n                \n            FROM\n            purchase_order_line l\n                join purchase_order po on (l.order_id=po.id)\n                join res_partner partner on po.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 res_company C ON C.id = po.company_id\n                left join uom_uom line_uom on (line_uom.id=l.product_uom)\n                left join uom_uom product_uom on (product_uom.id=t.uom_id)\n                left 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 = po.company_id\n            \n                LEFT JOIN stock_picking_type spt ON (spt.id=po.picking_type_id)\n                LEFT JOIN (\n                    SELECT MIN(picking.date_done)                                   AS date_done,\n                        purchase.id                                                 AS purchase_id\n                    FROM purchase_order                                             AS purchase\n                    JOIN purchase_order_line                                        AS order_line\n                        ON order_line.order_id = purchase.id\n                    JOIN stock_move                                                 AS move\n                        ON move.purchase_line_id = order_line.id\n                    JOIN stock_picking                                              AS picking\n                        ON picking.id = move.picking_id\n                    JOIN stock_location                                             AS location_dest\n                        ON location_dest.id = picking.location_dest_id\n                    WHERE picking.state = \'done\'\n                        AND location_dest.usage != \'supplier\'\n                        AND picking.date_done IS NOT NULL\n                    GROUP BY\n                        purchase.id\n                ) order_effective_date\n                    ON order_effective_date.purchase_id = l.order_id\n             \n            WHERE\n                l.display_type IS NULL\n             \n            GROUP BY\n                po.company_id,\n                po.user_id,\n                po.partner_id,\n                line_uom.factor,\n                c.currency_id,\n                l.price_unit,\n                po.date_approve,\n                l.date_planned,\n                l.product_uom,\n                po.dest_address_id,\n                po.fiscal_position_id,\n                l.product_id,\n                p.product_tmpl_id,\n                t.categ_id,\n                po.date_order,\n                po.state,\n                line_uom.uom_type,\n                line_uom.category_id,\n                t.uom_id,\n                t.purchase_method,\n                line_uom.id,\n                product_uom.factor,\n                partner.country_id,\n                partner.commercial_partner_id,\n                po.id,\n                account_currency_table.rate\n            , spt.warehouse_id, effective_date, order_effective_date.date_done) AS "purchase_report" WHERE ((((("purchase_report"."state" != \'draft\') OR "purchase_report"."state" IS NULL) AND (("purchase_report"."state" != \'sent\') OR "purchase_report"."state" IS NULL)) AND (("purchase_report"."state" != \'cancel\') OR "purchase_report"."state" IS NULL)) OR (("purchase_report"."date_approve" >= \'2025-07-01 03:00:00\') AND ("purchase_report"."date_approve" <= \'2025-08-01 02:59:59\'))) AND ("purchase_report"."company_id" IN (1)) GROUP BY date_trunc(\'day\', timezone(\'America/Buenos_Aires\', timezone(\'UTC\', "purchase_report"."date_approve"))::timestamp) ORDER BY date_trunc(\'day\', timezone(\'America/Buenos_Aires\', timezone(\'UTC\', "purchase_report"."date_approve"))::timestamp) ASC '
ERROR: time zone "America/Buenos_Aires" not recognized

Exception during request handling.
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2533, in __call__
    response = request._serve_db()
               ^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2060, in _serve_db
    return self._transactioning(
           ^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2123, 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 2090, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2338, 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 2887, 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/Buenos_Aires" not recognized

bad query: b'SELECT date_trunc(\'day\', timezone(\'America/Buenos_Aires\', timezone(\'UTC\', "purchase_report"."date_approve"))::timestamp), COUNT(*), SUM("purchase_report"."untaxed_total") FROM (\n                \n                SELECT\n                    po.id as order_id,\n                    min(l.id) as id,\n                    po.date_order as date_order,\n                    po.state,\n                    po.date_approve,\n                    po.dest_address_id,\n                    po.partner_id as partner_id,\n                    po.user_id as user_id,\n                    po.company_id as company_id,\n                    po.fiscal_position_id as fiscal_position_id,\n                    l.product_id,\n                    p.product_tmpl_id,\n                    t.categ_id as category_id,\n                    c.currency_id,\n                    t.uom_id as product_uom,\n                    extract(epoch from age(po.date_approve,po.date_order))/(24*60*60)::decimal(16,2) as delay,\n                    extract(epoch from age(l.date_planned,po.date_order))/(24*60*60)::decimal(16,2) as delay_pass,\n                    count(*) as nbr_lines,\n                    sum(l.price_total / COALESCE(po.currency_rate, 1.0))::decimal(16,2) * account_currency_table.rate as price_total,\n                    (sum(l.product_qty * l.price_unit / COALESCE(po.currency_rate, 1.0))/NULLIF(sum(l.product_qty/line_uom.factor*product_uom.factor),0.0))::decimal(16,2) * account_currency_table.rate as price_average,\n                    partner.country_id as country_id,\n                    partner.commercial_partner_id as commercial_partner_id,\n                    sum(p.weight * l.product_qty/line_uom.factor*product_uom.factor) as weight,\n                    sum(p.volume * l.product_qty/line_uom.factor*product_uom.factor) as volume,\n                    sum(l.price_subtotal / COALESCE(po.currency_rate, 1.0))::decimal(16,2) * account_currency_table.rate as untaxed_total,\n                    sum(l.product_qty / line_uom.factor * product_uom.factor) as qty_ordered,\n                    sum(l.qty_received / line_uom.factor * product_uom.factor) as qty_received,\n                    sum(l.qty_invoiced / line_uom.factor * product_uom.factor) as qty_billed,\n                    case when t.purchase_method = \'purchase\'\n                         then sum(l.product_qty / line_uom.factor * product_uom.factor) - sum(l.qty_invoiced / line_uom.factor * product_uom.factor)\n                         else sum(l.qty_received / line_uom.factor * product_uom.factor) - sum(l.qty_invoiced / line_uom.factor * product_uom.factor)\n                    end as qty_to_be_billed\n            ,\n                spt.warehouse_id as picking_type_id, po.effective_date as effective_date,\n                extract(\n                    epoch from age(\n                        l.date_planned,\n                        COALESCE(\n                            order_effective_date.date_done,\n                            po.date_order\n                        )\n                    )\n                )/(24*60*60)::decimal(16,2) as days_to_arrival\n             \n                \n            FROM\n            purchase_order_line l\n                join purchase_order po on (l.order_id=po.id)\n                join res_partner partner on po.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 res_company C ON C.id = po.company_id\n                left join uom_uom line_uom on (line_uom.id=l.product_uom)\n                left join uom_uom product_uom on (product_uom.id=t.uom_id)\n                left 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 = po.company_id\n            \n                LEFT JOIN stock_picking_type spt ON (spt.id=po.picking_type_id)\n                LEFT JOIN (\n                    SELECT MIN(picking.date_done)                                   AS date_done,\n                        purchase.id                                                 AS purchase_id\n                    FROM purchase_order                                             AS purchase\n                    JOIN purchase_order_line                                        AS order_line\n                        ON order_line.order_id = purchase.id\n                    JOIN stock_move                                                 AS move\n                        ON move.purchase_line_id = order_line.id\n                    JOIN stock_picking                                              AS picking\n                        ON picking.id = move.picking_id\n                    JOIN stock_location                                             AS location_dest\n                        ON location_dest.id = picking.location_dest_id\n                    WHERE picking.state = \'done\'\n                        AND location_dest.usage != \'supplier\'\n                        AND picking.date_done IS NOT NULL\n                    GROUP BY\n                        purchase.id\n                ) order_effective_date\n                    ON order_effective_date.purchase_id = l.order_id\n             \n            WHERE\n                l.display_type IS NULL\n             \n            GROUP BY\n                po.company_id,\n                po.user_id,\n                po.partner_id,\n                line_uom.factor,\n                c.currency_id,\n                l.price_unit,\n                po.date_approve,\n                l.date_planned,\n                l.product_uom,\n                po.dest_address_id,\n                po.fiscal_position_id,\n                l.product_id,\n                p.product_tmpl_id,\n                t.categ_id,\n                po.date_order,\n                po.state,\n                line_uom.uom_type,\n                line_uom.category_id,\n                t.uom_id,\n                t.purchase_method,\n                line_uom.id,\n                product_uom.factor,\n                partner.country_id,\n                partner.commercial_partner_id,\n                po.id,\n                account_currency_table.rate\n            , spt.warehouse_id, effective_date, order_effective_date.date_done) AS "purchase_report" WHERE ((((("purchase_report"."state" != \'draft\') OR "purchase_report"."state" IS NULL) AND (("purchase_report"."state" != \'sent\') OR "purchase_report"."state" IS NULL)) AND (("purchase_report"."state" != \'cancel\') OR "purchase_report"."state" IS NULL)) OR (("purchase_report"."date_approve" >= \'2025-07-01 03:00:00\') AND ("purchase_report"."date_approve" <= \'2025-08-01 02:59:59\'))) AND ("purchase_report"."company_id" IN (1)) GROUP BY date_trunc(\'day\', timezone(\'America/Buenos_Aires\', timezone(\'UTC\', "purchase_report"."date_approve"))::timestamp) ORDER BY date_trunc(\'day\', timezone(\'America/Buenos_Aires\', timezone(\'UTC\', "purchase_report"."date_approve"))::timestamp) ASC '
ERROR: time zone "America/Buenos_Aires" not recognized

Exception during request handling.
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2533, in __call__
    response = request._serve_db()
               ^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2060, in _serve_db
    return self._transactioning(
           ^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2123, 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 2090, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2338, 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 2887, 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/Buenos_Aires" not recognized

bad query: b'SELECT date_trunc(\'day\', timezone(\'America/Buenos_Aires\', timezone(\'UTC\', "purchase_report"."date_approve"))::timestamp), COUNT(*), SUM("purchase_report"."untaxed_total") FROM (\n                \n                SELECT\n                    po.id as order_id,\n                    min(l.id) as id,\n                    po.date_order as date_order,\n                    po.state,\n                    po.date_approve,\n                    po.dest_address_id,\n                    po.partner_id as partner_id,\n                    po.user_id as user_id,\n                    po.company_id as company_id,\n                    po.fiscal_position_id as fiscal_position_id,\n                    l.product_id,\n                    p.product_tmpl_id,\n                    t.categ_id as category_id,\n                    c.currency_id,\n                    t.uom_id as product_uom,\n                    extract(epoch from age(po.date_approve,po.date_order))/(24*60*60)::decimal(16,2) as delay,\n                    extract(epoch from age(l.date_planned,po.date_order))/(24*60*60)::decimal(16,2) as delay_pass,\n                    count(*) as nbr_lines,\n                    sum(l.price_total / COALESCE(po.currency_rate, 1.0))::decimal(16,2) * account_currency_table.rate as price_total,\n                    (sum(l.product_qty * l.price_unit / COALESCE(po.currency_rate, 1.0))/NULLIF(sum(l.product_qty/line_uom.factor*product_uom.factor),0.0))::decimal(16,2) * account_currency_table.rate as price_average,\n                    partner.country_id as country_id,\n                    partner.commercial_partner_id as commercial_partner_id,\n                    sum(p.weight * l.product_qty/line_uom.factor*product_uom.factor) as weight,\n                    sum(p.volume * l.product_qty/line_uom.factor*product_uom.factor) as volume,\n                    sum(l.price_subtotal / COALESCE(po.currency_rate, 1.0))::decimal(16,2) * account_currency_table.rate as untaxed_total,\n                    sum(l.product_qty / line_uom.factor * product_uom.factor) as qty_ordered,\n                    sum(l.qty_received / line_uom.factor * product_uom.factor) as qty_received,\n                    sum(l.qty_invoiced / line_uom.factor * product_uom.factor) as qty_billed,\n                    case when t.purchase_method = \'purchase\'\n                         then sum(l.product_qty / line_uom.factor * product_uom.factor) - sum(l.qty_invoiced / line_uom.factor * product_uom.factor)\n                         else sum(l.qty_received / line_uom.factor * product_uom.factor) - sum(l.qty_invoiced / line_uom.factor * product_uom.factor)\n                    end as qty_to_be_billed\n            ,\n                spt.warehouse_id as picking_type_id, po.effective_date as effective_date,\n                extract(\n                    epoch from age(\n                        l.date_planned,\n                        COALESCE(\n                            order_effective_date.date_done,\n                            po.date_order\n                        )\n                    )\n                )/(24*60*60)::decimal(16,2) as days_to_arrival\n             \n                \n            FROM\n            purchase_order_line l\n                join purchase_order po on (l.order_id=po.id)\n                join res_partner partner on po.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 res_company C ON C.id = po.company_id\n                left join uom_uom line_uom on (line_uom.id=l.product_uom)\n                left join uom_uom product_uom on (product_uom.id=t.uom_id)\n                left join account_currency_table ON account_currency_table.company_id = po.company_id\n            \n                LEFT JOIN stock_picking_type spt ON (spt.id=po.picking_type_id)\n                LEFT JOIN (\n                    SELECT MIN(picking.date_done)                                   AS date_done,\n                        purchase.id                                                 AS purchase_id\n                    FROM purchase_order                                             AS purchase\n                    JOIN purchase_order_line                                        AS order_line\n                        ON order_line.order_id = purchase.id\n                    JOIN stock_move                                                 AS move\n                        ON move.purchase_line_id = order_line.id\n                    JOIN stock_picking                                              AS picking\n                        ON picking.id = move.picking_id\n                    JOIN stock_location                                             AS location_dest\n                        ON location_dest.id = picking.location_dest_id\n                    WHERE picking.state = \'done\'\n                        AND location_dest.usage != \'supplier\'\n                        AND picking.date_done IS NOT NULL\n                    GROUP BY\n                        purchase.id\n                ) order_effective_date\n                    ON order_effective_date.purchase_id = l.order_id\n             \n            WHERE\n                l.display_type IS NULL\n             \n            GROUP BY\n                po.company_id,\n                po.user_id,\n                po.partner_id,\n                line_uom.factor,\n                c.currency_id,\n                l.price_unit,\n                po.date_approve,\n                l.date_planned,\n                l.product_uom,\n                po.dest_address_id,\n                po.fiscal_position_id,\n                l.product_id,\n                p.product_tmpl_id,\n                t.categ_id,\n                po.date_order,\n                po.state,\n                line_uom.uom_type,\n                line_uom.category_id,\n                t.uom_id,\n                t.purchase_method,\n                line_uom.id,\n                product_uom.factor,\n                partner.country_id,\n                partner.commercial_partner_id,\n                po.id,\n                account_currency_table.rate\n            , spt.warehouse_id, effective_date, order_effective_date.date_done) AS "purchase_report" WHERE ((((("purchase_report"."state" != \'draft\') OR "purchase_report"."state" IS NULL) AND (("purchase_report"."state" != \'sent\') OR "purchase_report"."state" IS NULL)) AND (("purchase_report"."state" != \'cancel\') OR "purchase_report"."state" IS NULL)) OR (("purchase_report"."date_approve" >= \'2025-07-01 03:00:00\') AND ("purchase_report"."date_approve" <= \'2025-08-01 02:59:59\'))) AND ("purchase_report"."company_id" IN (1, 7)) GROUP BY date_trunc(\'day\', timezone(\'America/Buenos_Aires\', timezone(\'UTC\', "purchase_report"."date_approve"))::timestamp) ORDER BY date_trunc(\'day\', timezone(\'America/Buenos_Aires\', timezone(\'UTC\', "purchase_report"."date_approve"))::timestamp) ASC '
ERROR: time zone "America/Buenos_Aires" not recognized

Exception during request handling.
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2533, in __call__
    response = request._serve_db()
               ^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2060, in _serve_db
    return self._transactioning(
           ^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2123, 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 2090, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2338, 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 2887, 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/Buenos_Aires" not recognized