Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

9.1 On Premise - Reports associated with Entities disappear

  • 1.  9.1 On Premise - Reports associated with Entities disappear

    SILVER CONTRIBUTOR
    Posted 2 days ago
    9.1 was recently released for version 9 on premise.   We loaded and discovered two problems.
    1. if you go to workspace / reports,  the edit button stopped working
    2. If you open an entity and click reports,  there are none listed to run
    3. if you are on a grid and you select some records and select reports,  none are listed.

    We opened a case with Microsoft support about it today.  Will be interesting to see what they find.  We got no errors loading the update and discovered this afterwards.


    ------------------------------
    Kevin Knorr
    IT Director
    MHG Services
    Fort Lauderdale FL
    ------------------------------


  • 2.  RE: 9.1 On Premise - Reports associated with Entities disappear

    Posted yesterday
    We found this error on the logs (xxxxxxx-Microsoft.Crm.Sandbox.WorkerProcess.log), it could be causing the issue, as can be seen below the failing query includes ReportServerUrl

    >Exception when executing query: SELECT Id, [ConnectionString], [DatabaseName], [ExternalSdkEndpoint], [HelpContentServerUrl], [InternalSdkEndpoint], [MirroredSqlServerName], [Name], [PartitionNumber], [PodId], [ProvisioningAffinityGroupId], [ProvisioningState], [ReportServerUrl], [ScaleGroupWebStoreName], [SqlServerName], [State], [StatsScaleGroupWebStoreName], [UniqueifierId], [WebApplicationUrl], [WebStoreName], [WitnessServerId] FROM [ScaleGroup] WHERE ((([Id] = @Id0)) ) Exception: Invalid object name 'ScaleGroup'. Exception: System.Data.SqlClient.SqlException: Invalid object name 'ScaleGroup'.

    ------------------------------
    Odin Bujeiro
    MHG Services
    Fort Lauderdale FL
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role