2025-04-15 06:15:28
|
ERROR
|
runbot
|
Error found in logs:
2025-04-15 06:14:08,901 77 ERROR 02681-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:08,905 77 ERROR 02681-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(');')])
2025-04-15 06:14:09,610 77 ERROR 02681-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:09,613 77 ERROR 02681-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(');')])
|
|