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
  • +1
    verified answer

    If you go to Admin | Customisation | Opportunity | Views and see if it exists, if not create a new one using the following which is from my demo system and so just the generic view script (don't forget to name the view vReportOpportunity) 

    This post won't allow me to post the actual script, so here is a screenshot of it

Reply
  • +1
    verified answer

    If you go to Admin | Customisation | Opportunity | Views and see if it exists, if not create a new one using the following which is from my demo system and so just the generic view script (don't forget to name the view vReportOpportunity) 

    This post won't allow me to post the actual script, so here is a screenshot of it

Children