Date |
Level |
Type |
Message |
2024-06-18 13:11:55
|
INFO
|
runbot
|
Init build environment with config Adhoc Conf con tests
|
2024-06-18 13:11:55
|
|
|
Starting step base from config Adhoc Conf con tests
|
2024-06-18 13:11:55
|
INFO
|
runbot
|
Using Dockerfile Tag odoo:adhoc-odoo-16
|
2024-06-18 13:12:14
|
INFO
|
server
|
odoo.modules.loading:303
1 modules loaded in 8.91s, 9027 queries (+9027 extra)
|
2024-06-18 13:12:27
|
INFO
|
server
|
odoo.modules.loading:303
14 modules loaded in 6.16s, 5292 queries (+5292 extra)
|
2024-06-18 13:12:27
|
|
|
Step base finished in 29s
|
2024-06-18 13:12:27
|
|
|
Starting step all from config Adhoc Conf con tests
|
2024-06-18 13:12:27
|
INFO
|
runbot
|
Using Dockerfile Tag odoo:adhoc-odoo-16
|
2024-06-18 13:12:55
|
INFO
|
server
|
odoo.modules.loading:303
1 modules loaded in 10.43s, 9027 queries (+9027 extra)
|
2024-06-18 13:21:38
|
INFO
|
server
|
odoo.addons.l10n_uy_currency_update.models.res_company:41
Currency Provider configured as BCU for next companies: (UY) Company
|
2024-06-18 13:22:46
|
INFO
|
server
|
odoo.addons.l10n_uy_currency_update.models.res_company:41
Currency Provider configured as BCU for next companies: (UY) Company
|
2024-06-18 13:24:26
|
INFO
|
server
|
odoo.addons.l10n_uy_currency_update.models.res_company:41
Currency Provider configured as BCU for next companies: (UY) Company
|
2024-06-18 13:24:26
|
INFO
|
server
|
odoo.addons.l10n_ar_currency_update.models.res_company:46
Currency Provider configured as AFIP for next companies: (AR) Exento
|
2024-06-18 13:24:26
|
INFO
|
server
|
odoo.addons.l10n_uy_currency_update.models.res_company:41
Currency Provider configured as BCU for next companies: (UY) Company
|
2024-06-18 13:24:26
|
INFO
|
server
|
odoo.addons.l10n_ar_currency_update.models.res_company:46
Currency Provider configured as AFIP for next companies: (AR) Exento, (AR) Monotributista
|
2024-06-18 13:24:32
|
INFO
|
server
|
odoo.addons.l10n_uy_currency_update.models.res_company:41
Currency Provider configured as BCU for next companies: (UY) Company
|
2024-06-18 13:24:32
|
INFO
|
server
|
odoo.addons.l10n_ar_currency_update.models.res_company:46
Currency Provider configured as AFIP for next companies: (AR) Exento, (AR) Monotributista, (AR) Responsable Inscripto
|
2024-06-18 13:24:44
|
INFO
|
server
|
odoo.addons.l10n_ar_edi.models.res_company:216
Setting demo certificate from to OdooCert9 in (AR) Responsable Inscripto company
|
2024-06-18 13:24:44
|
INFO
|
server
|
odoo.addons.l10n_ar_edi.models.res_company:216
Setting demo certificate from to OdooCert2 in (AR) Monotributista company
|
2024-06-18 13:24:44
|
INFO
|
server
|
odoo.addons.l10n_ar_edi.models.res_company:216
Setting demo certificate from to OdooCert1 in (AR) Exento company
|
2024-06-18 13:27:04
|
INFO
|
server
|
odoo.modules.loading:303
609 modules loaded in 843.64s, 386318 queries (+388077 extra)
|
2024-06-18 13:27:04
|
INFO
|
server
|
odoo.modules.loading:303
610 modules loaded in 0.96s, 242 queries (+242 extra)
|
2024-06-18 13:27:10
|
INFO
|
server
|
odoo.addons.l10n_uy_currency_update.models.res_company:41
Currency Provider configured as BCU for next companies: Muebleria UY
|
2024-06-18 13:27:10
|
INFO
|
server
|
odoo.addons.l10n_ar_currency_update.models.res_company:46
Currency Provider configured as AFIP for next companies: (AR) Exento, Muebleria ARG, company_2_data
|
2024-06-18 13:27:16
|
INFO
|
server
|
odoo.addons.l10n_uy_currency_update.models.res_company:41
Currency Provider configured as BCU for next companies: Muebleria UY
|
2024-06-18 13:27:16
|
INFO
|
server
|
odoo.addons.l10n_ar_currency_update.models.res_company:46
Currency Provider configured as AFIP for next companies: (AR) Exento, Muebleria ARG, company_1_data, company_2_data
|
2024-06-18 13:27:16
|
INFO
|
server
|
odoo.addons.l10n_uy_currency_update.models.res_company:41
Currency Provider configured as BCU for next companies: Muebleria UY
|
2024-06-18 13:27:16
|
INFO
|
server
|
odoo.addons.l10n_ar_currency_update.models.res_company:46
Currency Provider configured as AFIP for next companies: (AR) Exento, (AR) Monotributista (Unit Tests), (AR) Responsable Inscripto (Unit Tests), Muebleria ARG, company_2_data
|
2024-06-18 13:28:03
|
INFO
|
runbot
|
Getting results for build 57520-16-0
|
2024-06-18 13:28:03
|
|
|
Step all finished in 15m
|
2024-06-18 13:28:03
|
|
|
Starting step setup from config Adhoc Conf con tests
|
2024-06-18 13:28:03
|
INFO
|
runbot
|
Using Dockerfile Tag odoo:adhoc-odoo-16
|
2024-06-18 13:28:04
|
INFO
|
runbot
|
Step setup finished in 0s
|
2024-06-18 13:28:04
|
|
|
Starting step run from config Adhoc Conf con tests
|
2024-06-18 13:28:04
|
INFO
|
runbot
|
Start running build 57520-16-0
|
2024-06-18 13:28:04
|
INFO
|
runbot
|
Using Dockerfile Tag odoo:adhoc-odoo-16
|
2024-06-18 13:28:11
|
INFO
|
server
|
odoo.modules.loading:303
1 modules loaded in 0.01s, 0 queries (+0 extra)
|
2024-06-18 13:28:11
|
INFO
|
server
|
odoo.modules.loading:303
14 modules loaded in 0.10s, 0 queries (+0 extra)
|
2024-06-18 13:34:03
|
INFO
|
server
|
odoo.modules.loading:303
1 modules loaded in 0.01s, 0 queries (+0 extra)
|
2024-06-18 13:34:03
|
INFO
|
server
|
odoo.modules.loading:303
1 modules loaded in 0.01s, 0 queries (+0 extra)
|
2024-06-18 13:34:09
|
INFO
|
server
|
odoo.modules.loading:303
610 modules loaded in 5.50s, 0 queries (+0 extra)
|
2024-06-18 13:34:09
|
INFO
|
server
|
odoo.modules.loading:303
610 modules loaded in 5.34s, 0 queries (+0 extra)
|
2024-06-18 13:45:30
|
INFO
|
server
|
odoo.modules.loading:303
1 modules loaded in 0.01s, 0 queries (+0 extra)
|
2024-06-18 13:45:43
|
INFO
|
server
|
odoo.modules.loading:303
610 modules loaded in 5.46s, 0 queries (+0 extra)
|
2024-06-18 14:02:48
|
WARNING
|
server
|
odoo.http:2048
No se ha seleccionado WS AFIP
|
2024-06-18 14:03:54
|
WARNING
|
server
|
odoo.http:2048
Por restricciones de seguridad no tienes permiso para acceder a los informes de 'Usuario' (res.users).
Ponte en contacto con tu administrador para pedirle acceso si es necesario
|
2024-06-18 14:08:12
|
WARNING
|
server
|
odoo.http:2048
El Diario seleccionado no se puede usar en esta transacción, por favor seleccione uno que no use documentos, ya que estos son solo para Facturas.
|
2024-06-18 14:08:21
|
WARNING
|
server
|
odoo.http:2048
El Diario seleccionado no se puede usar en esta transacción, por favor seleccione uno que no use documentos, ya que estos son solo para Facturas.
|
2024-06-18 14:08:28
|
WARNING
|
server
|
odoo.http:2048
El Diario seleccionado no se puede usar en esta transacción, por favor seleccione uno que no use documentos, ya que estos son solo para Facturas.
|
2024-06-18 14:22:21
|
WARNING
|
server
|
odoo.http:2048
Se requiere la fecha de Facturación / Reembolso para validar este documento.
|
2024-06-18 19:22:37
|
ERROR
|
server
|
odoo.sql_db:324
bad query:
WITH custom_currency_table(currency_id, rate) AS ((VALUES (46, 1.0), (1, 1.0), (172, 1.0), (156, 1.0), (170, 1.0), (2, 1.0), (171, 1.0), (168, 1.0), (47, 1.0)))
-- Final select that gets the following lines:
-- (where there is a change in the rates of currency between the creation of the move and the full payments)
-- - Moves that don't have a payment yet at a certain date
-- - Moves that have a partial but are not fully paid at a certain date
SELECT
subquery.grouping_key,
ARRAY_AGG(DISTINCT(subquery.currency_id)) AS currency_id,
SUM(subquery.balance_currency) AS balance_currency,
SUM(subquery.balance_operation) AS balance_operation,
SUM(subquery.balance_current) AS balance_current,
SUM(subquery.adjustment) AS adjustment,
COUNT(subquery.aml_id) AS aml_count
FROM (
-- Get moves that have at least one partial at a certain date and are not fully paid at that date
SELECT
account_move_line.currency_id AS grouping_key,
ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places) AS balance_operation,
ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) AS balance_currency,
ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) / custom_currency_table.rate AS balance_current,
(
-- adjustment is computed as: balance_current - balance_operation
ROUND( account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) / custom_currency_table.rate
- ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places)
) AS adjustment,
account_move_line.currency_id AS currency_id,
account_move_line.id AS aml_id
FROM "account_move_line_in_currency_2" AS "account_move_line",
account_account AS account,
res_currency AS aml_currency,
res_currency AS aml_comp_currency,
custom_currency_table,
-- Get for each move line the amount residual and amount_residual currency
-- both for matched "debit" and matched "credit" the same way as account.move.line
-- '_compute_amount_residual()' method does
-- (using LATERAL greatly reduce the number of lines for which we have to compute it)
LATERAL (
-- Get sum of matched "debit" amount and amount in currency for related move line at date
SELECT COALESCE(SUM(part.amount), 0.0) AS amount_debit,
ROUND(
SUM(part.debit_amount_currency),
curr.decimal_places
) AS amount_debit_currency,
0.0 AS amount_credit,
0.0 AS amount_credit_currency,
account_move_line.currency_id AS currency_id,
account_move_line.id AS aml_id
FROM account_partial_reconcile part
JOIN res_currency curr ON curr.id = part.debit_currency_id
WHERE account_move_line.id = part.debit_move_id
AND part.max_date <= '2024-05-31'::date
GROUP BY aml_id,
curr.decimal_places
UNION
-- Get sum of matched "credit" amount and amount in currency for related move line at date
SELECT 0.0 AS amount_debit,
0.0 AS amount_debit_currency,
COALESCE(SUM(part.amount), 0.0) AS amount_credit,
ROUND(
SUM(part.credit_amount_currency),
curr.decimal_places
) AS amount_credit_currency,
account_move_line.currency_id AS currency_id,
account_move_line.id AS aml_id
FROM account_partial_reconcile part
JOIN res_currency curr ON curr.id = part.credit_currency_id
WHERE account_move_line.id = part.credit_move_id
AND part.max_date <= '2024-05-31'::date
GROUP BY aml_id,
curr.decimal_places
) AS ara
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 (10))) AND ("account_move_line"."date" <= '2024-05-31')) AND ("account_move_line"."parent_state" = 'posted')) AND ((("account_move_line"."company_id" in (10)) OR "account_move_line"."company_id" IS NULL) 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))
AND account_move_line.account_id = account.id
AND account_move_line.currency_id = aml_currency.id
AND account_move_line.company_currency_id = aml_comp_currency.id
AND account_move_line.currency_id = custom_currency_table.currency_id
AND account.account_type NOT IN ('income', 'income_other', 'expense', 'expense_depreciation', 'expense_direct_cost', 'off_balance')
AND (
account.currency_id != account_move_line.company_currency_id
OR (
account.account_type IN ('asset_receivable', 'liability_payable')
AND (account_move_line.currency_id != account_move_line.company_currency_id)
)
)
AND NOT EXISTS (
SELECT 1
FROM account_account_exclude_res_currency_provision
WHERE account_account_id = account_move_line.account_id
AND res_currency_id = account_move_line.currency_id
)
AND (
NOT EXISTS (
SELECT 1
FROM account_partial_reconcile part_exch
WHERE part_exch.exchange_move_id = account_move_line.move_id
AND part_exch.max_date <= '2024-05-31'::date
)
)
GROUP BY account_move_line.id, aml_comp_currency.decimal_places, aml_currency.decimal_places, custom_currency_table.rate
HAVING ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places) != 0
OR ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) != 0.0
UNION
-- Moves that don't have a payment yet at a certain date
SELECT
account_move_line.currency_id AS grouping_key,
account_move_line.balance AS balance_operation,
account_move_line.amount_currency AS balance_currency,
account_move_line.amount_currency / custom_currency_table.rate AS balance_current,
account_move_line.amount_currency / custom_currency_table.rate - account_move_line.balance AS adjustment,
account_move_line.currency_id AS currency_id,
account_move_line.id AS aml_id
FROM "account_move_line_in_currency_2" AS "account_move_line"
JOIN account_account account ON account_move_line.account_id = account.id
JOIN custom_currency_table ON custom_currency_table.currency_id = account_move_line.currency_id
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 (10))) AND ("account_move_line"."date" <= '2024-05-31')) AND ("account_move_line"."parent_state" = 'posted')) AND ((("account_move_line"."company_id" in (10)) OR "account_move_line"."company_id" IS NULL) 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
...<message too long, truncated>
|
2024-06-18 19:22:37
|
ERROR
|
server
|
odoo.http:2050
Exception during request handling.
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2028, in __call__
response = request._serve_db()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1616, in _serve_db
return service_model.retrying(self._serve_ir_http, self.env)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 133, in retrying
result = func()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1643, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1847, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/data/build/adhoc-cicd-odoo-odoo/addons/website/models/ir_http.py", line 237, in _dispatch
response = super()._dispatch(endpoint)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
result = endpoint(**request.params)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 700, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 42, in call_kw
return self._call_kw(model, method, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 33, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 468, in call_kw
result = _call_kw_multi(method, model, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 453, in _call_kw_multi
result = method(recs, *args, **kwargs)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3799, in get_report_informations
lines = self._get_lines(options, all_column_groups_expression_totals)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 1918, in _get_lines
lines = self._fully_unfold_lines_if_needed(lines, options)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 1947, in _fully_unfold_lines_if_needed
to_insert = self._expand_unfoldable_line(line_dict['expand_function'], line_dict['id'], groupby, options, progress, 0,
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4038, in _expand_unfoldable_line
expansion_result = expand_function(line_dict_id, groupby, options, progress, offset, unfold_all_batch_data=unfold_all_batch_data)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4149, in _report_expand_unfoldable_line_with_groupby
rslt_lines = line._expand_groupby(line_dict_id, groupby, options, offset=offset, limit=limit_to_load, load_one_more=bool(limit_to_load), unfold_all_batch_data=unfold_all_batch_data)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5075, in _expand_groupby
all_column_groups_expression_totals = self.report_id._compute_expression_totals_for_each_column_group(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2213, 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 2367, 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, offset=offset, limit=limit)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2712, in _compute_formula_batch
return getattr(self, engine_function_name)(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3156, in _compute_formula_batch_with_engine_custom
rslt[(formula, expressions)] = custom_engine_function(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_multicurrency_revaluation_report.py", line 152, in _report_custom_engine_multi_currency_revaluation_to_adjust
return self._multi_currency_revaluation_get_custom_lines(options, 'to_adjust', current_groupby, next_groupby, offset=offset, limit=limit)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_multicurrency_revaluation_report.py", line 349, in _multi_currency_revaluation_get_custom_lines
self._cr.execute(full_query, params)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 321, in execute
res = self._obj.execute(query, params)
psycopg2.errors.GroupingError: column "account_move_line.currency_id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 19: account_move_line.currency_id AS grou...
^
|
2024-06-18 19:23:01
|
ERROR
|
server
|
odoo.sql_db:324
bad query:
WITH custom_currency_table(currency_id, rate) AS ((VALUES (46, 1.0), (1, 1.0), (172, 1.0), (156, 1.0), (170, 1.0), (2, 1.0), (171, 1.0), (168, 1.0), (47, 1.0)))
-- Final select that gets the following lines:
-- (where there is a change in the rates of currency between the creation of the move and the full payments)
-- - Moves that don't have a payment yet at a certain date
-- - Moves that have a partial but are not fully paid at a certain date
SELECT
subquery.grouping_key,
ARRAY_AGG(DISTINCT(subquery.currency_id)) AS currency_id,
SUM(subquery.balance_currency) AS balance_currency,
SUM(subquery.balance_operation) AS balance_operation,
SUM(subquery.balance_current) AS balance_current,
SUM(subquery.adjustment) AS adjustment,
COUNT(subquery.aml_id) AS aml_count
FROM (
-- Get moves that have at least one partial at a certain date and are not fully paid at that date
SELECT
account_move_line.currency_id AS grouping_key,
ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places) AS balance_operation,
ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) AS balance_currency,
ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) / custom_currency_table.rate AS balance_current,
(
-- adjustment is computed as: balance_current - balance_operation
ROUND( account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) / custom_currency_table.rate
- ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places)
) AS adjustment,
account_move_line.currency_id AS currency_id,
account_move_line.id AS aml_id
FROM "account_move_line_in_currency_2" AS "account_move_line",
account_account AS account,
res_currency AS aml_currency,
res_currency AS aml_comp_currency,
custom_currency_table,
-- Get for each move line the amount residual and amount_residual currency
-- both for matched "debit" and matched "credit" the same way as account.move.line
-- '_compute_amount_residual()' method does
-- (using LATERAL greatly reduce the number of lines for which we have to compute it)
LATERAL (
-- Get sum of matched "debit" amount and amount in currency for related move line at date
SELECT COALESCE(SUM(part.amount), 0.0) AS amount_debit,
ROUND(
SUM(part.debit_amount_currency),
curr.decimal_places
) AS amount_debit_currency,
0.0 AS amount_credit,
0.0 AS amount_credit_currency,
account_move_line.currency_id AS currency_id,
account_move_line.id AS aml_id
FROM account_partial_reconcile part
JOIN res_currency curr ON curr.id = part.debit_currency_id
WHERE account_move_line.id = part.debit_move_id
AND part.max_date <= '2023-12-31'::date
GROUP BY aml_id,
curr.decimal_places
UNION
-- Get sum of matched "credit" amount and amount in currency for related move line at date
SELECT 0.0 AS amount_debit,
0.0 AS amount_debit_currency,
COALESCE(SUM(part.amount), 0.0) AS amount_credit,
ROUND(
SUM(part.credit_amount_currency),
curr.decimal_places
) AS amount_credit_currency,
account_move_line.currency_id AS currency_id,
account_move_line.id AS aml_id
FROM account_partial_reconcile part
JOIN res_currency curr ON curr.id = part.credit_currency_id
WHERE account_move_line.id = part.credit_move_id
AND part.max_date <= '2023-12-31'::date
GROUP BY aml_id,
curr.decimal_places
) AS ara
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 (10))) AND ("account_move_line"."date" <= '2023-12-31')) AND ("account_move_line"."parent_state" = 'posted')) AND ((("account_move_line"."company_id" in (10)) OR "account_move_line"."company_id" IS NULL) 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))
AND account_move_line.account_id = account.id
AND account_move_line.currency_id = aml_currency.id
AND account_move_line.company_currency_id = aml_comp_currency.id
AND account_move_line.currency_id = custom_currency_table.currency_id
AND account.account_type NOT IN ('income', 'income_other', 'expense', 'expense_depreciation', 'expense_direct_cost', 'off_balance')
AND (
account.currency_id != account_move_line.company_currency_id
OR (
account.account_type IN ('asset_receivable', 'liability_payable')
AND (account_move_line.currency_id != account_move_line.company_currency_id)
)
)
AND NOT EXISTS (
SELECT 1
FROM account_account_exclude_res_currency_provision
WHERE account_account_id = account_move_line.account_id
AND res_currency_id = account_move_line.currency_id
)
AND (
NOT EXISTS (
SELECT 1
FROM account_partial_reconcile part_exch
WHERE part_exch.exchange_move_id = account_move_line.move_id
AND part_exch.max_date <= '2023-12-31'::date
)
)
GROUP BY account_move_line.id, aml_comp_currency.decimal_places, aml_currency.decimal_places, custom_currency_table.rate
HAVING ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places) != 0
OR ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) != 0.0
UNION
-- Moves that don't have a payment yet at a certain date
SELECT
account_move_line.currency_id AS grouping_key,
account_move_line.balance AS balance_operation,
account_move_line.amount_currency AS balance_currency,
account_move_line.amount_currency / custom_currency_table.rate AS balance_current,
account_move_line.amount_currency / custom_currency_table.rate - account_move_line.balance AS adjustment,
account_move_line.currency_id AS currency_id,
account_move_line.id AS aml_id
FROM "account_move_line_in_currency_2" AS "account_move_line"
JOIN account_account account ON account_move_line.account_id = account.id
JOIN custom_currency_table ON custom_currency_table.currency_id = account_move_line.currency_id
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 (10))) AND ("account_move_line"."date" <= '2023-12-31')) AND ("account_move_line"."parent_state" = 'posted')) AND ((("account_move_line"."company_id" in (10)) OR "account_move_line"."company_id" IS NULL) 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
...<message too long, truncated>
|
2024-06-18 19:23:01
|
ERROR
|
server
|
odoo.http:2050
Exception during request handling.
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2028, in __call__
response = request._serve_db()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1616, in _serve_db
return service_model.retrying(self._serve_ir_http, self.env)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 133, in retrying
result = func()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1643, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1847, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/data/build/adhoc-cicd-odoo-odoo/addons/website/models/ir_http.py", line 237, in _dispatch
response = super()._dispatch(endpoint)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
result = endpoint(**request.params)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 700, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 42, in call_kw
return self._call_kw(model, method, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 33, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 468, in call_kw
result = _call_kw_multi(method, model, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 453, in _call_kw_multi
result = method(recs, *args, **kwargs)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3799, in get_report_informations
lines = self._get_lines(options, all_column_groups_expression_totals)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 1918, in _get_lines
lines = self._fully_unfold_lines_if_needed(lines, options)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 1947, in _fully_unfold_lines_if_needed
to_insert = self._expand_unfoldable_line(line_dict['expand_function'], line_dict['id'], groupby, options, progress, 0,
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4038, in _expand_unfoldable_line
expansion_result = expand_function(line_dict_id, groupby, options, progress, offset, unfold_all_batch_data=unfold_all_batch_data)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4149, in _report_expand_unfoldable_line_with_groupby
rslt_lines = line._expand_groupby(line_dict_id, groupby, options, offset=offset, limit=limit_to_load, load_one_more=bool(limit_to_load), unfold_all_batch_data=unfold_all_batch_data)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5075, in _expand_groupby
all_column_groups_expression_totals = self.report_id._compute_expression_totals_for_each_column_group(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2213, 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 2367, 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, offset=offset, limit=limit)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2712, in _compute_formula_batch
return getattr(self, engine_function_name)(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3156, in _compute_formula_batch_with_engine_custom
rslt[(formula, expressions)] = custom_engine_function(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_multicurrency_revaluation_report.py", line 152, in _report_custom_engine_multi_currency_revaluation_to_adjust
return self._multi_currency_revaluation_get_custom_lines(options, 'to_adjust', current_groupby, next_groupby, offset=offset, limit=limit)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_multicurrency_revaluation_report.py", line 349, in _multi_currency_revaluation_get_custom_lines
self._cr.execute(full_query, params)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 321, in execute
res = self._obj.execute(query, params)
psycopg2.errors.GroupingError: column "account_move_line.currency_id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 19: account_move_line.currency_id AS grou...
^
|
2024-06-18 19:23:09
|
ERROR
|
server
|
odoo.sql_db:324
bad query:
WITH custom_currency_table(currency_id, rate) AS ((VALUES (46, 1.0), (1, 1.0), (172, 1.0), (156, 1.0), (170, 1.0), (2, 1.0), (171, 1.0), (168, 1.0), (47, 1.0)))
-- Final select that gets the following lines:
-- (where there is a change in the rates of currency between the creation of the move and the full payments)
-- - Moves that don't have a payment yet at a certain date
-- - Moves that have a partial but are not fully paid at a certain date
SELECT
subquery.grouping_key,
ARRAY_AGG(DISTINCT(subquery.currency_id)) AS currency_id,
SUM(subquery.balance_currency) AS balance_currency,
SUM(subquery.balance_operation) AS balance_operation,
SUM(subquery.balance_current) AS balance_current,
SUM(subquery.adjustment) AS adjustment,
COUNT(subquery.aml_id) AS aml_count
FROM (
-- Get moves that have at least one partial at a certain date and are not fully paid at that date
SELECT
account_move_line.currency_id AS grouping_key,
ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places) AS balance_operation,
ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) AS balance_currency,
ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) / custom_currency_table.rate AS balance_current,
(
-- adjustment is computed as: balance_current - balance_operation
ROUND( account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) / custom_currency_table.rate
- ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places)
) AS adjustment,
account_move_line.currency_id AS currency_id,
account_move_line.id AS aml_id
FROM "account_move_line_in_currency_2" AS "account_move_line",
account_account AS account,
res_currency AS aml_currency,
res_currency AS aml_comp_currency,
custom_currency_table,
-- Get for each move line the amount residual and amount_residual currency
-- both for matched "debit" and matched "credit" the same way as account.move.line
-- '_compute_amount_residual()' method does
-- (using LATERAL greatly reduce the number of lines for which we have to compute it)
LATERAL (
-- Get sum of matched "debit" amount and amount in currency for related move line at date
SELECT COALESCE(SUM(part.amount), 0.0) AS amount_debit,
ROUND(
SUM(part.debit_amount_currency),
curr.decimal_places
) AS amount_debit_currency,
0.0 AS amount_credit,
0.0 AS amount_credit_currency,
account_move_line.currency_id AS currency_id,
account_move_line.id AS aml_id
FROM account_partial_reconcile part
JOIN res_currency curr ON curr.id = part.debit_currency_id
WHERE account_move_line.id = part.debit_move_id
AND part.max_date <= '2024-05-31'::date
GROUP BY aml_id,
curr.decimal_places
UNION
-- Get sum of matched "credit" amount and amount in currency for related move line at date
SELECT 0.0 AS amount_debit,
0.0 AS amount_debit_currency,
COALESCE(SUM(part.amount), 0.0) AS amount_credit,
ROUND(
SUM(part.credit_amount_currency),
curr.decimal_places
) AS amount_credit_currency,
account_move_line.currency_id AS currency_id,
account_move_line.id AS aml_id
FROM account_partial_reconcile part
JOIN res_currency curr ON curr.id = part.credit_currency_id
WHERE account_move_line.id = part.credit_move_id
AND part.max_date <= '2024-05-31'::date
GROUP BY aml_id,
curr.decimal_places
) AS ara
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 (10))) AND ("account_move_line"."date" <= '2024-05-31')) AND ("account_move_line"."parent_state" = 'posted')) AND ((("account_move_line"."company_id" in (10)) OR "account_move_line"."company_id" IS NULL) 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))
AND account_move_line.account_id = account.id
AND account_move_line.currency_id = aml_currency.id
AND account_move_line.company_currency_id = aml_comp_currency.id
AND account_move_line.currency_id = custom_currency_table.currency_id
AND account.account_type NOT IN ('income', 'income_other', 'expense', 'expense_depreciation', 'expense_direct_cost', 'off_balance')
AND (
account.currency_id != account_move_line.company_currency_id
OR (
account.account_type IN ('asset_receivable', 'liability_payable')
AND (account_move_line.currency_id != account_move_line.company_currency_id)
)
)
AND NOT EXISTS (
SELECT 1
FROM account_account_exclude_res_currency_provision
WHERE account_account_id = account_move_line.account_id
AND res_currency_id = account_move_line.currency_id
)
AND (
NOT EXISTS (
SELECT 1
FROM account_partial_reconcile part_exch
WHERE part_exch.exchange_move_id = account_move_line.move_id
AND part_exch.max_date <= '2024-05-31'::date
)
)
GROUP BY account_move_line.id, aml_comp_currency.decimal_places, aml_currency.decimal_places, custom_currency_table.rate
HAVING ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places) != 0
OR ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) != 0.0
UNION
-- Moves that don't have a payment yet at a certain date
SELECT
account_move_line.currency_id AS grouping_key,
account_move_line.balance AS balance_operation,
account_move_line.amount_currency AS balance_currency,
account_move_line.amount_currency / custom_currency_table.rate AS balance_current,
account_move_line.amount_currency / custom_currency_table.rate - account_move_line.balance AS adjustment,
account_move_line.currency_id AS currency_id,
account_move_line.id AS aml_id
FROM "account_move_line_in_currency_2" AS "account_move_line"
JOIN account_account account ON account_move_line.account_id = account.id
JOIN custom_currency_table ON custom_currency_table.currency_id = account_move_line.currency_id
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 (10))) AND ("account_move_line"."date" <= '2024-05-31')) AND ("account_move_line"."parent_state" = 'posted')) AND ((("account_move_line"."company_id" in (10)) OR "account_move_line"."company_id" IS NULL) 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
...<message too long, truncated>
|
2024-06-18 19:23:09
|
ERROR
|
server
|
odoo.http:2050
Exception during request handling.
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2028, in __call__
response = request._serve_db()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1616, in _serve_db
return service_model.retrying(self._serve_ir_http, self.env)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 133, in retrying
result = func()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1643, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1847, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/data/build/adhoc-cicd-odoo-odoo/addons/website/models/ir_http.py", line 237, in _dispatch
response = super()._dispatch(endpoint)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
result = endpoint(**request.params)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 700, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 42, in call_kw
return self._call_kw(model, method, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 33, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 468, in call_kw
result = _call_kw_multi(method, model, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 453, in _call_kw_multi
result = method(recs, *args, **kwargs)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3799, in get_report_informations
lines = self._get_lines(options, all_column_groups_expression_totals)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 1918, in _get_lines
lines = self._fully_unfold_lines_if_needed(lines, options)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 1947, in _fully_unfold_lines_if_needed
to_insert = self._expand_unfoldable_line(line_dict['expand_function'], line_dict['id'], groupby, options, progress, 0,
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4038, in _expand_unfoldable_line
expansion_result = expand_function(line_dict_id, groupby, options, progress, offset, unfold_all_batch_data=unfold_all_batch_data)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4149, in _report_expand_unfoldable_line_with_groupby
rslt_lines = line._expand_groupby(line_dict_id, groupby, options, offset=offset, limit=limit_to_load, load_one_more=bool(limit_to_load), unfold_all_batch_data=unfold_all_batch_data)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5075, in _expand_groupby
all_column_groups_expression_totals = self.report_id._compute_expression_totals_for_each_column_group(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2213, 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 2367, 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, offset=offset, limit=limit)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2712, in _compute_formula_batch
return getattr(self, engine_function_name)(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3156, in _compute_formula_batch_with_engine_custom
rslt[(formula, expressions)] = custom_engine_function(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_multicurrency_revaluation_report.py", line 152, in _report_custom_engine_multi_currency_revaluation_to_adjust
return self._multi_currency_revaluation_get_custom_lines(options, 'to_adjust', current_groupby, next_groupby, offset=offset, limit=limit)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_multicurrency_revaluation_report.py", line 349, in _multi_currency_revaluation_get_custom_lines
self._cr.execute(full_query, params)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 321, in execute
res = self._obj.execute(query, params)
psycopg2.errors.GroupingError: column "account_move_line.currency_id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 19: account_move_line.currency_id AS grou...
^
|
2024-06-18 19:44:08
|
ERROR
|
server
|
odoo.sql_db:324
bad query:
WITH custom_currency_table(currency_id, rate) AS ((VALUES (46, 1.0), (1, 1.0), (172, 1.0), (156, 1.0), (170, 1.0), (2, 1.0), (171, 1.0), (168, 1.0), (47, 1.0)))
-- Final select that gets the following lines:
-- (where there is a change in the rates of currency between the creation of the move and the full payments)
-- - Moves that don't have a payment yet at a certain date
-- - Moves that have a partial but are not fully paid at a certain date
SELECT
subquery.grouping_key,
ARRAY_AGG(DISTINCT(subquery.currency_id)) AS currency_id,
SUM(subquery.balance_currency) AS balance_currency,
SUM(subquery.balance_operation) AS balance_operation,
SUM(subquery.balance_current) AS balance_current,
SUM(subquery.adjustment) AS adjustment,
COUNT(subquery.aml_id) AS aml_count
FROM (
-- Get moves that have at least one partial at a certain date and are not fully paid at that date
SELECT
account_move_line.currency_id AS grouping_key,
ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places) AS balance_operation,
ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) AS balance_currency,
ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) / custom_currency_table.rate AS balance_current,
(
-- adjustment is computed as: balance_current - balance_operation
ROUND( account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) / custom_currency_table.rate
- ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places)
) AS adjustment,
account_move_line.currency_id AS currency_id,
account_move_line.id AS aml_id
FROM "account_move_line_in_currency_2" AS "account_move_line",
account_account AS account,
res_currency AS aml_currency,
res_currency AS aml_comp_currency,
custom_currency_table,
-- Get for each move line the amount residual and amount_residual currency
-- both for matched "debit" and matched "credit" the same way as account.move.line
-- '_compute_amount_residual()' method does
-- (using LATERAL greatly reduce the number of lines for which we have to compute it)
LATERAL (
-- Get sum of matched "debit" amount and amount in currency for related move line at date
SELECT COALESCE(SUM(part.amount), 0.0) AS amount_debit,
ROUND(
SUM(part.debit_amount_currency),
curr.decimal_places
) AS amount_debit_currency,
0.0 AS amount_credit,
0.0 AS amount_credit_currency,
account_move_line.currency_id AS currency_id,
account_move_line.id AS aml_id
FROM account_partial_reconcile part
JOIN res_currency curr ON curr.id = part.debit_currency_id
WHERE account_move_line.id = part.debit_move_id
AND part.max_date <= '2024-03-31'::date
GROUP BY aml_id,
curr.decimal_places
UNION
-- Get sum of matched "credit" amount and amount in currency for related move line at date
SELECT 0.0 AS amount_debit,
0.0 AS amount_debit_currency,
COALESCE(SUM(part.amount), 0.0) AS amount_credit,
ROUND(
SUM(part.credit_amount_currency),
curr.decimal_places
) AS amount_credit_currency,
account_move_line.currency_id AS currency_id,
account_move_line.id AS aml_id
FROM account_partial_reconcile part
JOIN res_currency curr ON curr.id = part.credit_currency_id
WHERE account_move_line.id = part.credit_move_id
AND part.max_date <= '2024-03-31'::date
GROUP BY aml_id,
curr.decimal_places
) AS ara
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 (10))) AND ("account_move_line"."date" <= '2024-03-31')) AND ("account_move_line"."parent_state" = 'posted')) AND ((("account_move_line"."company_id" in (10)) OR "account_move_line"."company_id" IS NULL) 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))
AND account_move_line.account_id = account.id
AND account_move_line.currency_id = aml_currency.id
AND account_move_line.company_currency_id = aml_comp_currency.id
AND account_move_line.currency_id = custom_currency_table.currency_id
AND account.account_type NOT IN ('income', 'income_other', 'expense', 'expense_depreciation', 'expense_direct_cost', 'off_balance')
AND (
account.currency_id != account_move_line.company_currency_id
OR (
account.account_type IN ('asset_receivable', 'liability_payable')
AND (account_move_line.currency_id != account_move_line.company_currency_id)
)
)
AND NOT EXISTS (
SELECT 1
FROM account_account_exclude_res_currency_provision
WHERE account_account_id = account_move_line.account_id
AND res_currency_id = account_move_line.currency_id
)
AND (
NOT EXISTS (
SELECT 1
FROM account_partial_reconcile part_exch
WHERE part_exch.exchange_move_id = account_move_line.move_id
AND part_exch.max_date <= '2024-03-31'::date
)
)
GROUP BY account_move_line.id, aml_comp_currency.decimal_places, aml_currency.decimal_places, custom_currency_table.rate
HAVING ROUND(account_move_line.balance - SUM(ara.amount_debit) + SUM(ara.amount_credit), aml_comp_currency.decimal_places) != 0
OR ROUND(account_move_line.amount_currency - SUM(ara.amount_debit_currency) + SUM(ara.amount_credit_currency), aml_currency.decimal_places) != 0.0
UNION
-- Moves that don't have a payment yet at a certain date
SELECT
account_move_line.currency_id AS grouping_key,
account_move_line.balance AS balance_operation,
account_move_line.amount_currency AS balance_currency,
account_move_line.amount_currency / custom_currency_table.rate AS balance_current,
account_move_line.amount_currency / custom_currency_table.rate - account_move_line.balance AS adjustment,
account_move_line.currency_id AS currency_id,
account_move_line.id AS aml_id
FROM "account_move_line_in_currency_2" AS "account_move_line"
JOIN account_account account ON account_move_line.account_id = account.id
JOIN custom_currency_table ON custom_currency_table.currency_id = account_move_line.currency_id
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 (10))) AND ("account_move_line"."date" <= '2024-03-31')) AND ("account_move_line"."parent_state" = 'posted')) AND ((("account_move_line"."company_id" in (10)) OR "account_move_line"."company_id" IS NULL) 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
...<message too long, truncated>
|
2024-06-18 19:44:08
|
ERROR
|
server
|
odoo.http:2050
Exception during request handling.
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 2028, in __call__
response = request._serve_db()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1616, in _serve_db
return service_model.retrying(self._serve_ir_http, self.env)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/service/model.py", line 133, in retrying
result = func()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1643, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 1847, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/data/build/adhoc-cicd-odoo-odoo/addons/website/models/ir_http.py", line 237, in _dispatch
response = super()._dispatch(endpoint)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
result = endpoint(**request.params)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/http.py", line 700, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 42, in call_kw
return self._call_kw(model, method, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/addons/web/controllers/dataset.py", line 33, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 468, in call_kw
result = _call_kw_multi(method, model, args, kwargs)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/api.py", line 453, in _call_kw_multi
result = method(recs, *args, **kwargs)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3799, in get_report_informations
lines = self._get_lines(options, all_column_groups_expression_totals)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 1918, in _get_lines
lines = self._fully_unfold_lines_if_needed(lines, options)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 1947, in _fully_unfold_lines_if_needed
to_insert = self._expand_unfoldable_line(line_dict['expand_function'], line_dict['id'], groupby, options, progress, 0,
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4038, in _expand_unfoldable_line
expansion_result = expand_function(line_dict_id, groupby, options, progress, offset, unfold_all_batch_data=unfold_all_batch_data)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 4149, in _report_expand_unfoldable_line_with_groupby
rslt_lines = line._expand_groupby(line_dict_id, groupby, options, offset=offset, limit=limit_to_load, load_one_more=bool(limit_to_load), unfold_all_batch_data=unfold_all_batch_data)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 5075, in _expand_groupby
all_column_groups_expression_totals = self.report_id._compute_expression_totals_for_each_column_group(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2213, 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 2367, 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, offset=offset, limit=limit)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 2712, in _compute_formula_batch
return getattr(self, engine_function_name)(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_report.py", line 3156, in _compute_formula_batch_with_engine_custom
rslt[(formula, expressions)] = custom_engine_function(
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_multicurrency_revaluation_report.py", line 152, in _report_custom_engine_multi_currency_revaluation_to_adjust
return self._multi_currency_revaluation_get_custom_lines(options, 'to_adjust', current_groupby, next_groupby, offset=offset, limit=limit)
File "/data/build/adhoc-cicd-odoo-enterprise/account_reports/models/account_multicurrency_revaluation_report.py", line 349, in _multi_currency_revaluation_get_custom_lines
self._cr.execute(full_query, params)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 321, in execute
res = self._obj.execute(query, params)
psycopg2.errors.GroupingError: column "account_move_line.currency_id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 19: account_move_line.currency_id AS grou...
^
|
2024-06-19 14:49:15
|
INFO
|
runbot
|
Kill build 57520-16-0
|