Error when clicking on "Push" in Manage Migration in OpsConsole : "Sequence contains no elements"

Version 1

    Details

     

    Error when clicking on "Push" in Manage Migration in OpsConsole : "Sequence contains no elements"...  Full error stack:

    ------

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

    Exception Details: System.InvalidOperationException: Sequence contains no elements

    Source Error: 
    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 

    Stack Trace: 

    [InvalidOperationException: Sequence contains no elements]
       System.Linq.Enumerable.First(IEnumerable`1 source) +514
       System.Linq.Queryable.First(IQueryable`1 source) +330
       OpsConsole.Infrastructure.Repositories.DBServerRepository.GetReportServer() +103
       OpsConsole.Core.Services.TenantService.GetReportServer(OpsEnvironment env) +162
       OpsConsole.UI.Controllers.TenantController.SetReportServerSettings(SandboxOperationDescription operationDescription, TenantService tenantService, OpsEnvironment srcEnv, Tenant srcTenant, OpsEnvironment destEnv) +253
       OpsConsole.UI.Controllers.TenantController.SandboxOperationDialog(String direction, String sourceEnvironmentId, String destinationEnvironmentId, String destinationServerHost, String sourceTenantId, String destinationTenantId) +1365
       lambda_method(Closure , ControllerBase , Object[] ) +404
      System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +274
       System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +39
       System.Web.Mvc.Async.<>c__DisplayClass39.<BeginInvokeActionMethodWithFilters>b__33() +120
       System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +452
       System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +452
       System.Web.Mvc.Async.<>c__DisplayClass37.<BeginInvokeActionMethodWithFilters>b__36(IAsyncResult asyncResult) +15
       System.Web.Mvc.Async.<>c__DisplayClass2a.<BeginInvokeAction>b__20() +33
       System.Web.Mvc.Async.<>c__DisplayClass25.<BeginInvokeAction>b__22(IAsyncResult asyncResult) +240
       System.Web.Mvc.<>c__DisplayClass1d.<BeginExecuteCore>b__18(IAsyncResult asyncResult) +28
       System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +15
       System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +53
       System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +15
       System.Web.Mvc.<>c__DisplayClass8.<BeginProcessRequest>b__3(IAsyncResult asyncResult) +42
       System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +15
       System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +606
       System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +288

     


    Resolution

    This error occurs in some versions when Reporting has not been configured yet.  To work around the error, In ConfigDB, click More > Report Server > New Report Server.  


    Populate each field to a dummy value (we have tested this resolution by using the HEAT App Server name, service account username/password used in the OpsConsole Lanscape ConnectionString, and the internal IP of the app server).

    Save.

    Note that if this does not work, you may also try populating the same dummy values in each tenant in the ConfigDB, under the "Reports" child tab.