bad query: b'\n            WITH period_table(date_start, date_stop, period_index) AS ((VALUES (NULL, \'2025-02-05\', 0),(\'2025-02-04\', \'2025-01-06\', 1),(\'2025-01-05\', \'2024-12-07\', 2),(\'2024-12-06\', \'2024-11-07\', 3),(\'2024-11-06\', \'2024-10-08\', 4),(\'2024-10-07\', NULL, 5)))\n\n            SELECT\n                \n                1 * (\n                    SUM(account_move_line.amount_currency)\n                    - COALESCE(SUM(part_debit.debit_amount_currency), 0)\n                    + COALESCE(SUM(part_credit.credit_amount_currency), 0)\n                ) AS amount_currency,\n                ARRAY_AGG(DISTINCT account_move_line.partner_id) AS partner_id,\n                ARRAY_AGG(account_move_line.payment_id) AS payment_id,\n                ARRAY_AGG(DISTINCT move.invoice_date) AS invoice_date,\n                ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS report_date,\n                ARRAY_AGG(DISTINCT ("account_move_line__account_id"."code_store"->\'1\'->>0)::VARCHAR) AS account_name,\n                ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS due_date,\n                ARRAY_AGG(DISTINCT account_move_line.currency_id) AS currency_id,\n                COUNT(account_move_line.id) AS aml_count,\n                ARRAY_AGG(("account_move_line__account_id"."code_store"->\'1\'->>0)::VARCHAR) AS account_code,\n                \n                CASE WHEN period_table.period_index = 0\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period0"\n                ,\n                CASE WHEN period_table.period_index = 1\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period1"\n                ,\n                CASE WHEN period_table.period_index = 2\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period2"\n                ,\n                CASE WHEN period_table.period_index = 3\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period3"\n                ,\n                CASE WHEN period_table.period_index = 4\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period4"\n                ,\n                CASE WHEN period_table.period_index = 5\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period5"\n                \n\n            FROM "account_move_line" LEFT JOIN "account_account" AS "account_move_line__account_id" ON ("account_move_line"."account_id" = "account_move_line__account_id"."id")\n\n            JOIN account_journal journal ON journal.id = account_move_line.journal_id\n            JOIN account_move move ON move.id = account_move_line.move_id\n            \n                    JOIN account_account aml_ct_account\n                        ON aml_ct_account.id = account_move_line.account_id\n                    LEFT JOIN account_currency_table\n                        ON account_move_line.company_id = account_currency_table.company_id\n                        AND (\n                            account_currency_table.rate_type = CASE\n                                WHEN aml_ct_account.account_type LIKE \'equity%\' THEN \'historical\'\n                                WHEN aml_ct_account.account_type LIKE ANY (ARRAY[\'income%\', \'expense%\', \'equity_unaffected\']) THEN \'historical\'\n                                ELSE \'closing\'\n                            END\n                        )\n                        AND (account_currency_table.date_from IS NULL OR account_currency_table.date_from <= account_move_line.date)\n                        AND (account_currency_table.date_next IS NULL OR account_currency_table.date_next > account_move_line.date)\n                        AND (account_currency_table.period_key = \'None_2025-02-05\' OR account_currency_table.period_key IS NULL)\n                \n\n            LEFT JOIN LATERAL (\n                SELECT\n                    SUM(part.amount) AS amount,\n                    SUM(part.debit_amount_currency) AS debit_amount_currency,\n                    part.debit_move_id\n                FROM account_partial_reconcile part\n                WHERE part.max_date <= \'2025-02-05\'::date AND part.debit_move_id = account_move_line.id\n                GROUP BY part.debit_move_id\n            ) part_debit ON TRUE\n\n            LEFT JOIN LATERAL (\n                SELECT\n                    SUM(part.amount) AS amount,\n                    SUM(part.credit_amount_currency) AS credit_amount_currency,\n                    part.credit_move_id\n                FROM account_partial_reconcile part\n                WHERE part.max_date <= \'2025-02-05\'::date AND part.credit_move_id = account_move_line.id\n                GROUP BY part.credit_move_id\n            ) part_credit ON TRUE\n\n            JOIN period_table ON\n                (\n                    period_table.date_start IS NULL\n                    OR COALESCE(account_move_line."date_maturity", account_move_line.date) <= DATE(period_table.date_start)\n                )\n                AND\n                (\n                    period_table.date_stop IS NULL\n                    OR COALESCE(account_move_line."date_maturity", account_move_line.date) >= DATE(period_table.date_stop)\n                )\n\n            WHERE (((((("account_move_line"."display_type" NOT IN (\'line_section\', \'line_note\')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" IN (1, 7))) AND ("account_move_line"."date" <= \'2025-02-05\')) AND ("account_move_line"."parent_state" = \'posted\')) AND ((("account_move_line__account_id"."non_trade" IS NULL OR "account_move_line__account_id"."non_trade" = FALSE) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\')) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\'))) AND (("account_move_line"."company_id" IN (1, 7)) AND ("account_move_line"."journal_id" IS NULL OR ("account_move_line"."journal_id" IN (SELECT "account_journal"."id" FROM "account_journal" WHERE (NOT EXISTS (SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids" WHERE "account_journal__user_ids"."journal_id" = "account_journal"."id") OR FALSE)))))\n\n            GROUP BY period_table.period_index\n\n            HAVING\n                ROUND(SUM((CASE WHEN account_move_line.balance > 0  THEN account_move_line.balance else 0 END - COALESCE(part_debit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n                OR ROUND(SUM((CASE WHEN account_move_line.balance < 0  THEN -account_move_line.balance else 0 END - COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n\n            ORDER BY period_table.period_index\n\n            \n            '
ERROR: function round(double precision, integer) does not exist
LINE 103:                 ROUND(SUM((CASE WHEN account_move_line.balan...
                          ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Exception during request handling.
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2371, in __call__
    response = request._serve_db()
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1898, in _serve_db
    return self._transactioning(
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1961, in _transactioning
    return service_model.retrying(func, env=self.env)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 137, in retrying
    result = func()
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1928, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2176, 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 329, in _dispatch
    result = endpoint(**request.params)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 727, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 35, in call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 517, in call_kw
    result = getattr(recs, name)(*args, **kwargs)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports_cash_basis/models/account_report.py", line 17, in get_report_information
    info = super().get_report_information(options)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5143, in get_report_information
    all_column_groups_expression_totals = self._compute_expression_totals_for_each_column_group(self.line_ids.expression_ids, options, warnings=warnings)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3077, in _compute_expression_totals_for_each_column_group
    current_group_expression_totals = self._compute_expression_totals_for_single_column_group(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3240, in _compute_expression_totals_for_single_column_group
    formula_results = self._compute_formula_batch(column_group_options, engine, date_scope, formulas_dict, current_groupby, next_groupby,
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3590, in _compute_formula_batch
    return getattr(self, engine_function_name)(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4121, in _compute_formula_batch_with_engine_custom
    rslt[(formula, expressions)] = custom_engine_function(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 84, in _report_custom_engine_aged_receivable
    return self._aged_partner_report_custom_engine_common(options, 'asset_receivable', current_groupby, next_groupby, offset=offset, limit=limit)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 272, in _aged_partner_report_custom_engine_common
    self._cr.execute(query)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 354, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.UndefinedFunction: function round(double precision, integer) does not exist
LINE 103:                 ROUND(SUM((CASE WHEN account_move_line.balan...
                          ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

bad query: b'\n            WITH period_table(date_start, date_stop, period_index) AS ((VALUES (NULL, \'2025-02-05\', 0),(\'2025-02-04\', \'2025-01-06\', 1),(\'2025-01-05\', \'2024-12-07\', 2),(\'2024-12-06\', \'2024-11-07\', 3),(\'2024-11-06\', \'2024-10-08\', 4),(\'2024-10-07\', NULL, 5)))\n\n            SELECT\n                \n                1 * (\n                    SUM(account_move_line.amount_currency)\n                    - COALESCE(SUM(part_debit.debit_amount_currency), 0)\n                    + COALESCE(SUM(part_credit.credit_amount_currency), 0)\n                ) AS amount_currency,\n                ARRAY_AGG(DISTINCT account_move_line.partner_id) AS partner_id,\n                ARRAY_AGG(account_move_line.payment_id) AS payment_id,\n                ARRAY_AGG(DISTINCT move.invoice_date) AS invoice_date,\n                ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS report_date,\n                ARRAY_AGG(DISTINCT ("account_move_line__account_id"."code_store"->\'7\'->>0)::VARCHAR) AS account_name,\n                ARRAY_AGG(DISTINCT COALESCE(account_move_line."date_maturity", account_move_line.date)) AS due_date,\n                ARRAY_AGG(DISTINCT account_move_line.currency_id) AS currency_id,\n                COUNT(account_move_line.id) AS aml_count,\n                ARRAY_AGG(("account_move_line__account_id"."code_store"->\'7\'->>0)::VARCHAR) AS account_code,\n                \n                CASE WHEN period_table.period_index = 0\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period0"\n                ,\n                CASE WHEN period_table.period_index = 1\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period1"\n                ,\n                CASE WHEN period_table.period_index = 2\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period2"\n                ,\n                CASE WHEN period_table.period_index = 3\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period3"\n                ,\n                CASE WHEN period_table.period_index = 4\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period4"\n                ,\n                CASE WHEN period_table.period_index = 5\n                THEN 1 * SUM((account_move_line.balance - COALESCE(part_debit.amount, 0) + COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1))\n                ELSE 0 END AS "period5"\n                \n\n            FROM "account_move_line" LEFT JOIN "account_account" AS "account_move_line__account_id" ON ("account_move_line"."account_id" = "account_move_line__account_id"."id")\n\n            JOIN account_journal journal ON journal.id = account_move_line.journal_id\n            JOIN account_move move ON move.id = account_move_line.move_id\n            \n                    JOIN account_account aml_ct_account\n                        ON aml_ct_account.id = account_move_line.account_id\n                    LEFT JOIN account_currency_table\n                        ON account_move_line.company_id = account_currency_table.company_id\n                        AND (\n                            account_currency_table.rate_type = CASE\n                                WHEN aml_ct_account.account_type LIKE \'equity%\' THEN \'historical\'\n                                WHEN aml_ct_account.account_type LIKE ANY (ARRAY[\'income%\', \'expense%\', \'equity_unaffected\']) THEN \'historical\'\n                                ELSE \'closing\'\n                            END\n                        )\n                        AND (account_currency_table.date_from IS NULL OR account_currency_table.date_from <= account_move_line.date)\n                        AND (account_currency_table.date_next IS NULL OR account_currency_table.date_next > account_move_line.date)\n                        AND (account_currency_table.period_key = \'None_2025-02-05\' OR account_currency_table.period_key IS NULL)\n                \n\n            LEFT JOIN LATERAL (\n                SELECT\n                    SUM(part.amount) AS amount,\n                    SUM(part.debit_amount_currency) AS debit_amount_currency,\n                    part.debit_move_id\n                FROM account_partial_reconcile part\n                WHERE part.max_date <= \'2025-02-05\'::date AND part.debit_move_id = account_move_line.id\n                GROUP BY part.debit_move_id\n            ) part_debit ON TRUE\n\n            LEFT JOIN LATERAL (\n                SELECT\n                    SUM(part.amount) AS amount,\n                    SUM(part.credit_amount_currency) AS credit_amount_currency,\n                    part.credit_move_id\n                FROM account_partial_reconcile part\n                WHERE part.max_date <= \'2025-02-05\'::date AND part.credit_move_id = account_move_line.id\n                GROUP BY part.credit_move_id\n            ) part_credit ON TRUE\n\n            JOIN period_table ON\n                (\n                    period_table.date_start IS NULL\n                    OR COALESCE(account_move_line."date_maturity", account_move_line.date) <= DATE(period_table.date_start)\n                )\n                AND\n                (\n                    period_table.date_stop IS NULL\n                    OR COALESCE(account_move_line."date_maturity", account_move_line.date) >= DATE(period_table.date_stop)\n                )\n\n            WHERE (((((("account_move_line"."display_type" NOT IN (\'line_section\', \'line_note\')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."company_id" IN (7, 1))) AND ("account_move_line"."date" <= \'2025-02-05\')) AND ("account_move_line"."parent_state" = \'posted\')) AND ((("account_move_line__account_id"."non_trade" IS NULL OR "account_move_line__account_id"."non_trade" = FALSE) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\')) AND ("account_move_line__account_id"."account_type" = \'asset_receivable\'))) AND (("account_move_line"."company_id" IN (7, 1)) AND ("account_move_line"."journal_id" IS NULL OR ("account_move_line"."journal_id" IN (SELECT "account_journal"."id" FROM "account_journal" WHERE (NOT EXISTS (SELECT 1 FROM "journal_security_journal_users" AS "account_journal__user_ids" WHERE "account_journal__user_ids"."journal_id" = "account_journal"."id") OR FALSE)))))\n\n            GROUP BY period_table.period_index\n\n            HAVING\n                ROUND(SUM((CASE WHEN account_move_line.balance > 0  THEN account_move_line.balance else 0 END - COALESCE(part_debit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n                OR ROUND(SUM((CASE WHEN account_move_line.balance < 0  THEN -account_move_line.balance else 0 END - COALESCE(part_credit.amount, 0)) * COALESCE(account_currency_table.rate, 1)), 2) != 0\n\n            ORDER BY period_table.period_index\n\n            \n            '
ERROR: function round(double precision, integer) does not exist
LINE 103:                 ROUND(SUM((CASE WHEN account_move_line.balan...
                          ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Exception during request handling.
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2371, in __call__
    response = request._serve_db()
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1898, in _serve_db
    return self._transactioning(
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1961, in _transactioning
    return service_model.retrying(func, env=self.env)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 137, in retrying
    result = func()
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1928, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2176, 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 329, in _dispatch
    result = endpoint(**request.params)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 727, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 35, in call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 517, in call_kw
    result = getattr(recs, name)(*args, **kwargs)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports_cash_basis/models/account_report.py", line 17, in get_report_information
    info = super().get_report_information(options)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5143, in get_report_information
    all_column_groups_expression_totals = self._compute_expression_totals_for_each_column_group(self.line_ids.expression_ids, options, warnings=warnings)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3077, in _compute_expression_totals_for_each_column_group
    current_group_expression_totals = self._compute_expression_totals_for_single_column_group(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3240, in _compute_expression_totals_for_single_column_group
    formula_results = self._compute_formula_batch(column_group_options, engine, date_scope, formulas_dict, current_groupby, next_groupby,
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3590, in _compute_formula_batch
    return getattr(self, engine_function_name)(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4121, in _compute_formula_batch_with_engine_custom
    rslt[(formula, expressions)] = custom_engine_function(
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 84, in _report_custom_engine_aged_receivable
    return self._aged_partner_report_custom_engine_common(options, 'asset_receivable', current_groupby, next_groupby, offset=offset, limit=limit)
  File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_aged_partner_balance.py", line 272, in _aged_partner_report_custom_engine_common
    self._cr.execute(query)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 354, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.UndefinedFunction: function round(double precision, integer) does not exist
LINE 103:                 ROUND(SUM((CASE WHEN account_move_line.balan...
                          ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.