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