Error during CRM complete reinstall

SOLVED

Hi all,

I am doing a complete reinstallation on my Sage CRM 2024 R1. However encounter this error on Dashboard_Update.esChange.html

After line 10: 
Error creating view vReportOrders:The new view could not be created due to the following error message : SQLError: Invalid object name 'dbo.vReportOpportunity' (CREATE VIEW vReportOrders AS SELECT dbo.vReportOpportunity.*, dbo.Orders.* FROM dbo.vReportOpportunity INNER JOIN dbo.Orders ON dbo.vReportOpportunity.Oppo_OpportunityId = dbo.Orders.Orde_opportunityid )
SQL: CREATE VIEW vReportOrders AS SELECT dbo.vReportOpportunity.*, dbo.Orders.* FROM dbo.vReportOpportunity INNER JOIN dbo.Orders ON dbo.vReportOpportunity.Oppo_OpportunityId = dbo.Orders.Orde_opportunityid

Error creating view vReportQuotes:The new view could not be created due to the following error message : SQLError: Invalid object name 'dbo.vReportOpportunity' (CREATE VIEW vReportQuotes AS SELECT dbo.Quotes.*, dbo.vReportOpportunity.* FROM dbo.Quotes INNER JOIN dbo.vReportOpportunity ON dbo.Quotes.Quot_opportunityid = dbo.vReportOpportunity.Oppo_OpportunityId )
SQL: CREATE VIEW vReportQuotes AS SELECT dbo.Quotes.*, dbo.vReportOpportunity.* FROM dbo.Quotes INNER JOIN dbo.vReportOpportunity ON dbo.Quotes.Quot_opportunityid = dbo.vReportOpportunity.Oppo_OpportunityId

both are related to invalid object dbo.vReportOpportunity.

where can I find this vReportOpportunity query to create it manually?

thank you

Parents Reply Children
No Data