locked
Microsoft Dynamics CRM Reporting Extensions Setup - Column 'DatacenterID' RRS feed

  • Question

  • Hi folks

    This is the error when i am trying to install the SRSDataconnector onto my new SQL Server 2012 for CRM2011.  The installer I am using is the one that includes Rollup 6.  Below is the relevant portion of the log file.  Does anyone have any ideas??

    16:23:41|   Info| Executing Install action: Microsoft.Crm.Setup.SrsDataConnector.RegisterServerAction
    16:23:42|   Info| Adding server INTERNALDB3 to configuration database with role SrsDataConnector
    16:23:42|  Error| System.Exception: Action Microsoft.Crm.Setup.SrsDataConnector.RegisterServerAction failed. ---> Microsoft.Crm.CrmException: Column 'DatacenterId' does not exist on table Server
       at Microsoft.Crm.SharedDatabase.DatabaseService.CheckColumnSetColumns(PropertyBag columnSet)
       at Microsoft.Crm.SharedDatabase.DatabaseService.Create(String tableName, PropertyBag columnSet)
       at Microsoft.Crm.Admin.AdminService.CrmServerService.Create(String serverName, Guid scaleGroupId, Guid podId, Guid datacenterId, ServerRoles roles, ServerState state)
       at Microsoft.Crm.Admin.AdminService.CrmServerService.Create(String serverName, Guid scaleGroupId, Guid podId, ServerRoles roles, ServerState state)
       at Microsoft.Crm.Setup.SrsDataConnector.RegisterServerAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---, Error, RetryCancel, Option1
    16:41:35|   Info| InputResult: Cancel
    16:41:35|   Info| CrmAction execution time; RegisterServerAction; 00:17:54.7783702
    16:41:35|  Error| Installer Complete: SrsDataConnectorInstaller - Error encountered
    16:41:35|  Error| Install exception.System.Exception: Action Microsoft.Crm.Setup.SrsDataConnector.RegisterServerAction failed. ---> Microsoft.Crm.CrmException: Column 'DatacenterId' does not exist on table Server
       at Microsoft.Crm.SharedDatabase.DatabaseService.CheckColumnSetColumns(PropertyBag columnSet)
       at Microsoft.Crm.SharedDatabase.DatabaseService.Create(String tableName, PropertyBag columnSet)
       at Microsoft.Crm.Admin.AdminService.CrmServerService.Create(String serverName, Guid scaleGroupId, Guid podId, Guid datacenterId, ServerRoles roles, ServerState state)
       at Microsoft.Crm.Admin.AdminService.CrmServerService.Create(String serverName, Guid scaleGroupId, Guid podId, ServerRoles roles, ServerState state)
       at Microsoft.Crm.Setup.SrsDataConnector.RegisterServerAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
       at Microsoft.Crm.Setup.Common.ComposedInstaller.InvokeInstall(Installer installer, IDictionary stateSaver)
       at Microsoft.Crm.Setup.Common.ComposedInstaller.InternalInstall(IDictionary stateSaver)
       at Microsoft.Crm.Setup.Common.ComposedInstaller.Install(IDictionary stateSaver)
       at Microsoft.Crm.Setup.SrsDataConnector.SrsDataConnectorSetup.Install(IDictionary data)
       at Microsoft.Crm.Setup.Common.SetupBase.ExecuteOperation()
    16:41:35|Verbose| Method exit: Microsoft.Crm.Setup.SrsDataConnector.SrsDataConnectorSetup.ExecuteOperation
    16:41:35|   Info| ActivatePage(FinishPage)

    Friday, August 10, 2012 3:44 PM

All replies

  • The person in this thread had the same issue and determined the problem was caused by installing a different version of the Reporting Extensions than what the Server had installed.


    Jason Lattimer

    Friday, August 10, 2012 3:50 PM
    Moderator