bad query: INSERT INTO "account_move_line" ("id", "account_id", "amount_currency", "blocked", "company_currency_id", "create_date", "create_uid", "credit", "currency_id", "date_maturity", "debit", "definitive_line_id", "discount", "display_type", "exclude_from_invoice_tab", "move_id", "name", "partner_id", "price_subtotal", "price_total", "price_unit", "purchase_line_id", "quantity", "sequence", "write_date", "write_uid") VALUES (nextval('account_move_line_id_seq'), NULL, '-15000.00', false, 19, '2023-04-14 11:34:05.404788', 2, '15000.00', 19, '2023-04-12', '0.00', NULL, '0.00', NULL, true, 53, '', 83, '-15000.00', '-15000.00', '-15000.00', NULL, '1.00', 10, '2023-04-14 11:34:05.404788', 2) RETURNING id
ERROR: new row for relation "account_move_line" violates check constraint "account_move_line_check_accountable_required_fields"
DETAIL:  Failing row contains (213, 53, null, null, null, null, null, null, 19, null, null, 10, , 1.00, -15000.00, 0.00, 0.00, 15000.00, null, -15000.00, -15000.00, -15000.00, null, f, 2023-04-12, 19, 83, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, t, 2, 2023-04-14 11:34:05.404788, 2, 2023-04-14 11:34:05.404788, null, null, null, null, null, null, null, null, null, null, null, null, null).

bad query: INSERT INTO "account_move_line" ("id", "account_id", "amount_currency", "blocked", "company_currency_id", "create_date", "create_uid", "credit", "currency_id", "date_maturity", "debit", "definitive_line_id", "discount", "display_type", "exclude_from_invoice_tab", "move_id", "name", "partner_id", "price_subtotal", "price_total", "price_unit", "purchase_line_id", "quantity", "sequence", "write_date", "write_uid") VALUES (nextval('account_move_line_id_seq'), NULL, '-15000.00', false, 19, '2023-04-14 11:34:49.357675', 2, '15000.00', 19, '2023-04-14', '0.00', NULL, '0.00', NULL, true, 54, '', 83, '-15000.00', '-15000.00', '-15000.00', NULL, '1.00', 10, '2023-04-14 11:34:49.357675', 2) RETURNING id
ERROR: new row for relation "account_move_line" violates check constraint "account_move_line_check_accountable_required_fields"
DETAIL:  Failing row contains (215, 54, null, null, null, null, null, null, 19, null, null, 10, , 1.00, -15000.00, 0.00, 0.00, 15000.00, null, -15000.00, -15000.00, -15000.00, null, f, 2023-04-14, 19, 83, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, t, 2, 2023-04-14 11:34:49.357675, 2, 2023-04-14 11:34:49.357675, null, null, null, null, null, null, null, null, null, null, null, null, null).

bad query: DELETE FROM account_journal WHERE id IN (47, 48)
ERROR: update or delete on table "account_journal" violates foreign key constraint "public_budget_advance_request_type_return_journal_id_fkey" on table "public_budget_advance_request_type"
DETAIL:  Key (id)=(47) is still referenced from table "public_budget_advance_request_type".

bad query: DELETE FROM account_journal WHERE id IN (47, 48)
ERROR: update or delete on table "account_journal" violates foreign key constraint "public_budget_advance_request_type_return_journal_id_fkey" on table "public_budget_advance_request_type"
DETAIL:  Key (id)=(47) is still referenced from table "public_budget_advance_request_type".

Call from cron Subsidy Report Week for server action #673 failed in Job #30
Traceback (most recent call last):
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/safe_eval.py", line 332, in safe_eval
    return unsafe_eval(c, globals_dict, locals_dict)
  File "", line 1, in <module>
  File "/data/build/sipreco-odoo-public-administration/sipreco_subsidy_management/models/subsidy.py", line 289, in _cron_recurring_subsidy_report
    template.with_context(
  File "/data/build/adhoc-cicd-odoo-odoo/addons/mail/models/mail_template.py", line 284, in send_mail
    values = self.generate_email(res_id, ['subject', 'body_html', 'email_from', 'email_to', 'partner_to', 'email_cc', 'reply_to', 'scheduled_date'])
  File "/data/build/adhoc-cicd-odoo-odoo/addons/account_edi/models/mail_template.py", line 21, in generate_email
    res = super().generate_email(res_ids, fields)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/mail/models/mail_template.py", line 212, in generate_email
    results = template.generate_recipients(results, template_res_ids)
  File "/data/build/adhoc-cicd-odoo-odoo/addons/mail/models/mail_template.py", line 179, in generate_recipients
    tpl_partner_ids = [int(pid) for pid in partner_to.split(',') if pid]
  File "/data/build/adhoc-cicd-odoo-odoo/addons/mail/models/mail_template.py", line 179, in <listcomp>
    tpl_partner_ids = [int(pid) for pid in partner_to.split(',') if pid]
ValueError: invalid literal for int() with base 10: '${object.id}'
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 367, 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 643, in run
    res = runner(run_self, eval_context=eval_context)
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/addons/base/models/ir_actions.py", line 512, in _run_action_code_multi
    safe_eval(self.code.strip(), eval_context, mode="exec", nocopy=True)  # nocopy allows to return 'action'
  File "/data/build/adhoc-cicd-odoo-odoo/odoo/tools/safe_eval.py", line 348, in safe_eval
    raise ValueError('%s: "%s" while evaluating\n%r' % (ustr(type(e)), ustr(e), expr))
ValueError: <class 'ValueError'>: "invalid literal for int() with base 10: '${object.id}'" while evaluating
'model._cron_recurring_subsidy_report(1)'

bad query: DELETE FROM account_journal WHERE id IN (47, 48)
ERROR: update or delete on table "account_journal" violates foreign key constraint "public_budget_advance_request_type_return_journal_id_fkey" on table "public_budget_advance_request_type"
DETAIL:  Key (id)=(47) is still referenced from table "public_budget_advance_request_type".

bad query: INSERT INTO "account_move_line" ("id", "account_id", "amount_currency", "blocked", "company_currency_id", "create_date", "create_uid", "credit", "currency_id", "date_maturity", "debit", "definitive_line_id", "discount", "display_type", "exclude_from_invoice_tab", "move_id", "name", "partner_id", "price_subtotal", "price_total", "price_unit", "purchase_line_id", "quantity", "sequence", "write_date", "write_uid") VALUES (nextval('account_move_line_id_seq'), NULL, '-15000.00', false, 19, '2023-04-24 12:37:40.671667', 2, '15000.00', 19, '2023-04-24', '0.00', NULL, '0.00', NULL, true, 59, '', 83, '-15000.00', '-15000.00', '-15000.00', NULL, '1.00', 10, '2023-04-24 12:37:40.671667', 2) RETURNING id
ERROR: new row for relation "account_move_line" violates check constraint "account_move_line_check_accountable_required_fields"
DETAIL:  Failing row contains (225, 59, null, null, null, null, null, null, 19, null, null, 10, , 1.00, -15000.00, 0.00, 0.00, 15000.00, null, -15000.00, -15000.00, -15000.00, null, f, 2023-04-24, 19, 83, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, t, 2, 2023-04-24 12:37:40.671667, 2, 2023-04-24 12:37:40.671667, null, null, null, null, null, null, null, null, null, null, null, null, null).

bad query: INSERT INTO "account_move_line" ("id", "account_id", "amount_currency", "blocked", "company_currency_id", "create_date", "create_uid", "credit", "currency_id", "date_maturity", "debit", "definitive_line_id", "discount", "display_type", "exclude_from_invoice_tab", "move_id", "name", "partner_id", "price_subtotal", "price_total", "price_unit", "purchase_line_id", "quantity", "sequence", "write_date", "write_uid") VALUES (nextval('account_move_line_id_seq'), NULL, '-15000.00', false, 19, '2023-04-24 12:38:03.959343', 2, '15000.00', 19, '2023-04-23', '0.00', NULL, '0.00', NULL, true, 60, '', 83, '-15000.00', '-15000.00', '-15000.00', NULL, '1.00', 10, '2023-04-24 12:38:03.959343', 2) RETURNING id
ERROR: new row for relation "account_move_line" violates check constraint "account_move_line_check_accountable_required_fields"
DETAIL:  Failing row contains (227, 60, null, null, null, null, null, null, 19, null, null, 10, , 1.00, -15000.00, 0.00, 0.00, 15000.00, null, -15000.00, -15000.00, -15000.00, null, f, 2023-04-23, 19, 83, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, t, 2, 2023-04-24 12:38:03.959343, 2, 2023-04-24 12:38:03.959343, null, null, null, null, null, null, null, null, null, null, null, null, null).

bad query: INSERT INTO "account_move_line" ("id", "account_id", "amount_currency", "blocked", "company_currency_id", "create_date", "create_uid", "credit", "currency_id", "date_maturity", "debit", "definitive_line_id", "discount", "display_type", "exclude_from_invoice_tab", "move_id", "name", "partner_id", "price_subtotal", "price_total", "price_unit", "purchase_line_id", "quantity", "sequence", "write_date", "write_uid") VALUES (nextval('account_move_line_id_seq'), NULL, '-1500000.00', false, 19, '2023-04-24 12:46:38.298179', 2, '1500000.00', 19, '2023-04-24', '0.00', NULL, '0.00', NULL, true, 63, '', 52, '-1500000.00', '-1500000.00', '-1500000.00', NULL, '1.00', 10, '2023-04-24 12:46:38.298179', 2) RETURNING id
ERROR: new row for relation "account_move_line" violates check constraint "account_move_line_check_accountable_required_fields"
DETAIL:  Failing row contains (233, 63, null, null, null, null, null, null, 19, null, null, 10, , 1.00, -1500000.00, 0.00, 0.00, 1500000.00, null, -1500000.00, -1500000.00, -1500000.00, null, f, 2023-04-24, 19, 52, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, t, 2, 2023-04-24 12:46:38.298179, 2, 2023-04-24 12:46:38.298179, null, null, null, null, null, null, null, null, null, null, null, null, null).

bad query: UPDATE "account_move" SET "amount_residual"='0.00',"amount_residual_signed"='0.00',"amount_tax"='0.00',"amount_tax_signed"='0.00',"amount_total"='0.00',"amount_total_in_currency_signed"='0.00',"amount_total_signed"='0.00',"amount_untaxed"='0.00',"amount_untaxed_signed"='0.00',"budget_id"=1,"date"=NULL,"partner_id"=52,"payment_group_id"=3,"payment_id"=5,"sequence_number"=1,"sequence_prefix"='BCO/2023/04/',"write_date"='2023-04-24T12:51:16.203984'::timestamp,"write_uid"=2 WHERE id IN (68)
ERROR: null value in column "date" violates not-null constraint
DETAIL:  Failing row contains (68, BCO/2023/04/, 1, null, null, BCO/2023/04/0001, null, null, null, draft, f, entry, f, 54, 6, 19, 52, null, f, null, null, 5, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, null, null, null, null, f, null, null, 2, null, null, null, null, null, null, null, null, null, null, null, 2, 2023-04-24 12:51:16.203984, 2, 2023-04-24 12:51:16.203984, null, null, null, null, null, no_extract_requested, null, -1, null, null, null, null, null, null, null, null, null, 1, null, null, null, null, null, null, null, 3, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 7, 1, null).

bad query: UPDATE "account_move" SET "amount_residual"='0.00',"amount_residual_signed"='0.00',"amount_tax"='0.00',"amount_tax_signed"='0.00',"amount_total"='0.00',"amount_total_in_currency_signed"='0.00',"amount_total_signed"='0.00',"amount_untaxed"='0.00',"amount_untaxed_signed"='0.00',"budget_id"=1,"date"=NULL,"partner_id"=52,"payment_group_id"=3,"payment_id"=6,"sequence_number"=1,"sequence_prefix"='BCO/2023/04/',"write_date"='2023-04-24T12:51:19.377928'::timestamp,"write_uid"=2 WHERE id IN (69)
ERROR: null value in column "date" violates not-null constraint
DETAIL:  Failing row contains (69, BCO/2023/04/, 1, null, null, BCO/2023/04/0001, null, null, null, draft, f, entry, f, 54, 6, 19, 52, null, f, null, null, 6, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, null, null, null, null, f, null, null, 2, null, null, null, null, null, null, null, null, null, null, null, 2, 2023-04-24 12:51:19.377928, 2, 2023-04-24 12:51:19.377928, null, null, null, null, null, no_extract_requested, null, -1, null, null, null, null, null, null, null, null, null, 1, null, null, null, null, null, null, null, 3, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 7, 1, null).