| Date | Level | Type | Message |
|---|---|---|---|
| 2024-10-23 17:53:50 | INFO | runbot | Init build environment with config Adhoc Conf for demo (y personalizaciones) 17+ |
| 2024-10-23 17:53:50 | Starting step all_no_test from config Adhoc Conf for demo (y personalizaciones) 17+ | ||
| 2024-10-23 17:53:50 | INFO | runbot | Using Dockerfile Tag odoo:adhoc-odoo-17 |
| 2024-10-23 17:54:14 | INFO | server | odoo.modules.loading:301 1 modules loaded in 11.79s, 9047 queries (+9047 extra) |
| 2024-10-23 18:00:46 | INFO | server | odoo.addons.l10n_ar_edi.models.res_company:216 Setting demo certificate from to OdooCert9 in (AR) Responsable Inscripto company |
| 2024-10-23 18:00:46 | INFO | server | odoo.addons.l10n_ar_edi.models.res_company:216 Setting demo certificate from to OdooCert7 in (AR) Monotributista company |
| 2024-10-23 18:00:46 | INFO | server | odoo.addons.l10n_ar_edi.models.res_company:216 Setting demo certificate from to OdooCert8 in (AR) Exento company |
| 2024-10-23 18:01:46 | 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-10-23 18:04:13 | INFO | server | odoo.addons.l10n_ar_currency_update.models.res_company:46 Currency Provider configured as AFIP for next companies: (AR) Exento, Muebleria ARG |
| 2024-10-23 18:04:53 | INFO | server | odoo.modules.loading:301 331 modules loaded in 630.16s, 273738 queries (+273780 extra) |
| 2024-10-23 18:04:59 | INFO | server | odoo.modules.loading:301 339 modules loaded in 9.96s, 1845 queries (+1845 extra) |
| 2024-10-23 18:05:17 | Step all_no_test finished in 11m | ||
| 2024-10-23 18:05:17 | Starting step setup from config Adhoc Conf for demo (y personalizaciones) 17+ | ||
| 2024-10-23 18:05:17 | INFO | runbot | Using Dockerfile Tag odoo:adhoc-odoo-17 |
| 2024-10-23 18:05:19 | INFO | runbot | Step setup finished in 1s |
| 2024-10-23 18:05:19 | Starting step run from config Adhoc Conf for demo (y personalizaciones) 17+ | ||
| 2024-10-23 18:05:19 | INFO | runbot | Start running build 85216-17-0 |
| 2024-10-23 18:05:19 | INFO | runbot | Using Dockerfile Tag odoo:adhoc-odoo-17 |
| 2024-10-23 18:05:31 | INFO | server | odoo.modules.loading:301 1 modules loaded in 0.01s, 0 queries (+0 extra) |
| 2024-10-23 18:05:31 | INFO | server | odoo.modules.loading:301 339 modules loaded in 5.73s, 0 queries (+0 extra) |
| 2024-10-23 18:06:45 | ERROR | server |
odoo.sql_db:335
bad query: CREATE TABLE IF NOT EXISTS account_move_line_in_currency_0 AS
WITH currency_rate AS MATERIALIZED (
SELECT
c.currency_id,
COALESCE(r.company_id, c.company_id) as company_id,
r.rate,
r.name AS date_start,
c.currency_group,
(SELECT name FROM res_currency_rate r2
WHERE r2.name > r.name AND
r2.currency_id = r.currency_id AND
(r2.company_id is null or r2.company_id = c.company_id)
ORDER BY r2.name ASC
LIMIT 1) AS date_end
FROM res_currency_rate r
RIGHT JOIN currency_group_line c ON (r.company_id is null or (r.company_id = c.company_id and r.currency_id = c.currency_id))
where c.currency_group = False
)
select aml.id, aml.move_id, aml.journal_id, aml.company_id, aml.company_currency_id, aml.sequence, aml.account_id, aml.partner_id, aml.reconcile_model_id, aml.payment_id, aml.statement_line_id, aml.statement_id, aml.group_tax_id, aml.tax_line_id, aml.tax_group_id, aml.tax_repartition_line_id, aml.full_reconcile_id, aml.account_root_id, aml.product_id, aml.product_uom_id, aml.create_uid, aml.write_uid, aml.move_name, aml.parent_state, aml.ref, aml.name, aml.matching_number, aml.display_type, aml.date, aml.invoice_date, aml.date_maturity, aml.discount_date, aml.analytic_distribution, aml.amount_currency, aml.tax_base_amount, aml.amount_residual, aml.amount_residual_currency, aml.quantity, aml.price_unit, aml.price_subtotal, aml.price_total, aml.discount, aml.discount_amount_currency, aml.discount_balance, aml.tax_tag_invert, aml.reconciled, aml.blocked, aml.create_date, aml.write_date, aml.deferred_start_date, aml.deferred_end_date, aml.expense_id, aml.purchase_line_id, aml.cogs_origin_id, aml.expected_pay_date, aml.user_id, aml.l10n_latam_document_type_id, aml.is_downpayment, aml.followup_line_id, aml.last_followup_date, aml.next_action_date, aml.l10n_pe_group_id, aml.tax_settlement_move_id, aml.tax_state, aml.l10n_pe_edi_allowance_charge_reason_code, aml.l10n_pe_edi_affectation_reason,
CASE WHEN cr.rate is null or cr.currency_id = c.currency_id THEN aml.balance ELSE aml.balance * cr.rate END as balance,
CASE WHEN cr.rate is null or cr.currency_id = c.currency_id THEN aml.credit ELSE aml.credit * cr.rate END as credit,
CASE WHEN cr.rate is null or cr.currency_id = c.currency_id THEN aml.debit ELSE aml.debit * cr.rate END as debit,
cr.currency_id,
(case when cr.rate is null or cr.currency_id = c.currency_id then 1.0 else cr.rate end) as aml_rate
from account_move_line aml
left join currency_rate cr on
(cr.currency_id in () and
cr.company_id = aml.company_id and
(cr.date_start <= COALESCE(aml.date, NOW()) or cr.date_start is null) and
(cr.date_end IS NULL OR cr.date_end > COALESCE(aml.date, NOW())))
join res_company as c on c.id=cr.company_id
ERROR: syntax error at or near ")"
LINE 27: (cr.currency_id in () and
^
|
| 2024-10-23 18:06:45 | ERROR | server |
odoo.addons.base.models.ir_cron:406
Call from cron Update AML in currency for server action #939 failed in Job #52
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/safe_eval.py", line 391, in safe_eval
return unsafe_eval(c, globals_dict, locals_dict)
File "ir.actions.server(939,)", line 1, in <module>
File "/data/build/ingadhoc-enterprise-extensions/account_reports_multicurrency/models/currency_group.py", line 22, in cron_recreate_aml_materialized
to_update.action_currency_aml_materialized()
File "/data/build/ingadhoc-enterprise-extensions/account_reports_multicurrency/models/currency_group.py", line 42, in action_currency_aml_materialized
self._cr.execute("""CREATE TABLE IF NOT EXISTS %s AS
File "/data/build/adhoc-cicd-odoo-odoo/odoo/sql_db.py", line 332, in execute
res = self._obj.execute(query, params)
psycopg2.errors.SyntaxError: syntax error at or near ")"
LINE 27: (cr.currency_id in () and
^
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_cron.py", line 397, in _callback
self.env['ir.actions.server'].browse(server_action_id).run()
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_actions.py", line 939, in run
res = runner(run_self, eval_context=eval_context)
File "/data/build/adhoc-cicd-odoo-odoo/addons/website/models/ir_actions_server.py", line 61, in _run_action_code_multi
res = super(ServerAction, self)._run_action_code_multi(eval_context)
File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_actions.py", line 771, in _run_action_code_multi
safe_eval(self.code.strip(), eval_context, mode="exec", nocopy=True, filename=str(self)) # nocopy allows to return 'action'
File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/safe_eval.py", line 405, in safe_eval
raise ValueError('%s: "%s" while evaluating\n%r' % (ustr(type(e)), ustr(e), expr))
ValueError: <class 'psycopg2.errors.SyntaxError'>: "syntax error at or near ")"
LINE 27: (cr.currency_id in () and
^
" while evaluating
'model.cron_recreate_aml_materialized()'
|
| 2024-10-23 20:27:48 | INFO | runbot | Kill build 85216-17-0 |