Installing SRSDataconnector in my new SQL Server 2012

Asked By 30 points N/A Posted on -
qa-featured

Whenever I go with installing SRSDataconnector in my new SQL Server 2012 for CRM2011, the following error occurs. 

Rollup 6 is included within my installer. Here follows the problem related part of the log file. 

Does anyone of techyvalley.com say what the problem is?

I am in a great trouble with this. To speak the truth, I can’t work for this problem.

Please help me.

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)

Microsoft Dynamics CRM Reporting Extensions Setup

Action

Microsoft.Crm.Set.SrsDataConnector.RegsterServerAction

failed.

Column 'DatacenterId’ does not exist on table Server

Retry Cancel

SHARE
Answered By 0 points N/A #143201

Installing SRSDataconnector in my new SQL Server 2012

qa-featured

Hi,

The cause of a problem like the one you are getting is usually the installation of a different version of the Reporting Extensions than what the Server has already installed. You will therefore need to check that and do the necessary changes. Make sure that the reporting extensions do not differ from what the server has installed.

Regards,

Nicke

 

Related Questions