Error found in logs:
2025-04-15 06:14:13,913 77 ERROR 02678-18-0-all odoo.sql_db: bad query: b'CREATE VIEW "x_bi_sql_view_l10n_ro_account_move_line_materialized" AS (SELECT\n                    aml.id as x_move_line_id,\n                    aml.company_id as x_company_id,\n                    aml.journal_id as x_journal_id,\n                    COALESCE(journal.name->>\'en_US\', \'\') as x_journal_name,\n                    aml.move_id as x_account_move_id,\n                    REPLACE(aml.move_name, \',\', \' \') as x_move_name,\n                    REPLACE(aml.ref, \',\', \' \') as x_move_ref,\n                    REPLACE(aml.name, \',\', \' \') as x_name,\n                    aml.parent_state as x_state,\n                    aml.date as x_date,\n                    aml.partner_id as x_partner_id,\n                    partner.name as x_partner_name,\n                    aml.account_id as x_account_id,\n                    account.code_store as x_account_code,\n                    aml.l10n_ro_counterpart_id as x_l10n_ro_counterpart_id,\n                    counterpart_account.l10n_ro_external_code as x_counterpart_account_code,\n                    aml.l10n_ro_counterpart_line_id as x_l10n_ro_counterpart_line_id,\n                    aml.debit as x_debit,\n                    aml.credit as x_credit,\n                    aml.balance as x_balance,\n                    aml.amount_currency as x_amount_currency,\n                    aml.currency_id as x_currency_id,\n                    currency.name as x_currency_name,\n                    aml.company_currency_id as x_company_currency_id,\n                    company_currency.name as x_company_currency_name\n                FROM account_move_line aml\n                LEFT JOIN res_company company on company.id = aml.company_id\n                LEFT JOIN  account_journal journal on journal.id = aml.journal_id\n                LEFT JOIN  account_account account on account.id = aml.account_id\n                LEFT JOIN  account_account counterpart_account on counterpart_account.id = aml.l10n_ro_counterpart_id\n                LEFT JOIN  res_partner partner on partner.id = aml.partner_id\n                LEFT JOIN  res_currency currency on currency.id = aml.currency_id\n                LEFT JOIN  res_currency company_currency on company_currency.id = aml.company_currency_id\n            WHERE company.l10n_ro_accounting and aml.display_type not in (\'line_section\', \'line_note\') and aml.parent_state = \'posted\'\n            ORDER by aml.id);'
2025-04-15 06:14:13,917 77 ERROR 02678-18-0-all odoo.addons.sql_request_abstract.models.sql_request_mixin: Failed query: Composed([SQL('CREATE VIEW '), Identifier('x_bi_sql_view_l10n_ro_account_move_line_materialized'), SQL(' AS ('), SQL("SELECT\n                    aml.id as x_move_line_id,\n                    aml.company_id as x_company_id,\n                    aml.journal_id as x_journal_id,\n                    COALESCE(journal.name->>'en_US', '') as x_journal_name,\n                    aml.move_id as x_account_move_id,\n                    REPLACE(aml.move_name, ',', ' ') as x_move_name,\n                    REPLACE(aml.ref, ',', ' ') as x_move_ref,\n                    REPLACE(aml.name, ',', ' ') as x_name,\n                    aml.parent_state as x_state,\n                    aml.date as x_date,\n                    aml.partner_id as x_partner_id,\n                    partner.name as x_partner_name,\n                    aml.account_id as x_account_id,\n                    account.code_store as x_account_code,\n                    aml.l10n_ro_counterpart_id as x_l10n_ro_counterpart_id,\n                    counterpart_account.l10n_ro_external_code as x_counterpart_account_code,\n                    aml.l10n_ro_counterpart_line_id as x_l10n_ro_counterpart_line_id,\n                    aml.debit as x_debit,\n                    aml.credit as x_credit,\n                    aml.balance as x_balance,\n                    aml.amount_currency as x_amount_currency,\n                    aml.currency_id as x_currency_id,\n                    currency.name as x_currency_name,\n                    aml.company_currency_id as x_company_currency_id,\n                    company_currency.name as x_company_currency_name\n                FROM account_move_line aml\n                LEFT JOIN res_company company on company.id = aml.company_id\n                LEFT JOIN  account_journal journal on journal.id = aml.journal_id\n                LEFT JOIN  account_account account on account.id = aml.account_id\n                LEFT JOIN  account_account counterpart_account on counterpart_account.id = aml.l10n_ro_counterpart_id\n                LEFT JOIN  res_partner partner on partner.id = aml.partner_id\n                LEFT JOIN  res_currency currency on currency.id = aml.currency_id\n                LEFT JOIN  res_currency company_currency on company_currency.id = aml.company_currency_id\n            WHERE company.l10n_ro_accounting and aml.display_type not in ('line_section', 'line_note') and aml.parent_state = 'posted'\n            ORDER by aml.id"), SQL(');')])