Hi everyone,
Im trying to install management reporter 2012 for GP2015 R2 with CU11. I have installed it. But when
configuring i'm unable to install the application service. We have a dedicated user for running management reporting service. The same user we are using in Production server to run the service. But in test server im unable to use it. what could be the problem. I surfed a lots of blogs and communities but couldn't find a solution.
below is the screen shot of the message and log file.
9/7/2015 8:45:08 AM - Displaying user object picker for user account selection.
9/7/2015 8:46:40 AM - Displaying user object picker for user account selection.
9/7/2015 8:46:54 AM - Validating user nimrerpadmin, domain TAWAZUN, and password.
9/7/2015 8:46:54 AM - Verifying SQL connection while impersonating TAWAZUN\nimrerpadmin
9/7/2015 8:46:54 AM - Verifying SQL connection while impersonating TAWAZUN\nimrerpadmin
9/7/2015 8:46:55 AM - Checking whether current user has SQL role sysadmin
9/7/2015 8:46:55 AM - Checking Management Reporter database to determine if it needs to be updated.
9/7/2015 8:46:55 AM - Current database schema version: 2.1.6041; deployment package schema version: 2.1.11001.1; update required: True
9/7/2015 8:46:55 AM - Checking port 4712 against ports with active TCP listeners.
9/7/2015 8:46:55 AM - Validating user nimrerpadmin, domain TAWAZUN, and password.
9/7/2015 8:46:55 AM - Verifying SQL connection while impersonating TAWAZUN\nimrerpadmin
9/7/2015 8:46:55 AM - Verifying SQL connection while impersonating TAWAZUN\nimrerpadmin
9/7/2015 8:47:03 AM - System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at adtwtipwvsa025/CompanyService.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 10.1.82.35:4712
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)
--- End of inner exception stack trace ---
at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)
at System.Net.HttpWebRequest.GetRequestStream()
at System.ServiceModel.Channels.HttpOutput.WebRequestHttpOutput.GetOutputStream()
--- End of inner exception stack trace ---
Server stack trace:
at System.ServiceModel.Security.IssuanceTokenProviderBase`1.DoNegotiation(TimeSpan timeout)
at System.ServiceModel.Security.SspiNegotiationTokenProvider.OnOpen(TimeSpan timeout)
at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
at System.ServiceModel.Security.SymmetricSecurityProtocol.OnOpen(TimeSpan timeout)
at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
at System.ServiceModel.Channels.SecurityChannelFactory`1.ClientSecurityChannel`1.OnOpen(TimeSpan timeout)
at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
at System.ServiceModel.Security.SecuritySessionSecurityTokenProvider.DoOperation(SecuritySessionOperation operation, EndpointAddress target, Uri via, SecurityToken currentToken, TimeSpan timeout)
at System.ServiceModel.Security.SecuritySessionSecurityTokenProvider.GetTokenCore(TimeSpan timeout)
at System.IdentityModel.Selectors.SecurityTokenProvider.GetToken(TimeSpan timeout)
at System.ServiceModel.Security.SecuritySessionClientSettings`1.ClientSecuritySessionChannel.OnOpen(TimeSpan timeout)
at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout)
at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.CallOnceManager.CallOnce(TimeSpan timeout, CallOnceManager cascade)
at System.ServiceModel.Channels.ServiceChannel.EnsureOpened(TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.Dynamics.Performance.Deployment.CompanyImport.CompanyService.ICompanyService.FillAllConfiguredIntegrations()
at Microsoft.Dynamics.Performance.Deployment.Common.WcfUtility.ExecuteOnClient[TCommunicationObject,TReturn](Func`2 invokeMe, Func`1 clientFactory)
at Microsoft.Dynamics.Performance.Deployment.CompanyImport.CompanyServiceHelper.ExecuteOnClient[T](Func`2 invokeMe, Func`2 exceptionHandler, Uri applicationServiceUri)
9/7/2015 8:47:09 AM - Starting deployment of Management Reporter 2012 Application Service
9/7/2015 8:47:09 AM - Found database package: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Packages\ManagementReporter.dacpac
9/7/2015 8:47:09 AM - Found database package: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Packages\SchedulerStore.dacpac
9/7/2015 8:47:09 AM - Found database package: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Packages\ConnectorStore.dacpac
9/7/2015 8:47:09 AM - Deployment parameters:
DatabaseCollation: SQL_Latin1_General_CP1_CI_AS
WindowsLoginToCreate: TAWAZUN\nimrerpadmin
WindowsLoginToCreateEscaped: TAWAZUN\nimrerpadmin
FirstAdminUserName: n/a
FirstAdminSid: n/a
FirstAdminDisplayName: n/a
9/7/2015 8:47:09 AM - Extracting supporting files for database deployment...
9/7/2015 8:47:11 AM - Checking Management Reporter database to determine if it needs to be updated.
9/7/2015 8:47:11 AM - Current database schema version: 2.1.6041; deployment package schema version: 2.1.11001; update required: True
9/7/2015 8:47:11 AM - Beginning database deployment...
9/7/2015 8:47:12 AM - Initializing deployment (Start)
9/7/2015 8:47:58 AM - The table [dbo].[license_bkp] is being dropped, data loss could occur.
9/7/2015 8:47:59 AM - Initializing deployment (Complete)
9/7/2015 8:47:59 AM - Analyzing deployment plan (Start)
9/7/2015 8:47:59 AM - Analyzing deployment plan (Complete)
9/7/2015 8:47:59 AM - Updating database (Start)
9/7/2015 8:47:59 AM - .Net SqlClient Data Provider: Msg 50000, Level 16, State 127, Line 6 Rows were detected. The schema update is terminating because data loss might occur.
9/7/2015 8:47:59 AM - Script execution error. The executed script:
IF EXISTS (SELECT TOP 1 1
FROM [dbo].[license_bkp])
RAISERROR (N'Rows were detected. The schema update is terminating because data loss might occur.', 16, 127)
WITH NOWAIT;
9/7/2015 8:47:59 AM - An error occurred while the batch was being executed.
9/7/2015 8:47:59 AM - Updating database (Failed)
9/7/2015 8:48:00 AM - The database deployment failed. Additional information: Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package.
Warning SQL72015: The table [dbo].[license_bkp] is being dropped, data loss could occur.
Error SQL72014: .Net SqlClient Data Provider: Msg 50000, Level 16, State 127, Line 6 Rows were detected. The schema update is terminating because data loss might occur.
Error SQL72045: Script execution error. The executed script:
IF EXISTS (SELECT TOP 1 1
FROM [dbo].[license_bkp])
RAISERROR (N'Rows were detected. The schema update is terminating because data loss might occur.', 16, 127)
WITH NOWAIT;
at Microsoft.SqlServer.Dac.DeployOperation.ThrowIfErrorManagerHasErrors()
at Microsoft.SqlServer.Dac.DeployOperation.<>c__DisplayClass10.<>c__DisplayClass12.<CreatePlanExecutionOperation>b__f()
at Microsoft.Data.Tools.Schema.Sql.Dac.OperationLogger.Capture(Action action)
at Microsoft.SqlServer.Dac.DeployOperation.<>c__DisplayClass10.<CreatePlanExecutionOperation>b__e(Object operation, CancellationToken token)
at Microsoft.SqlServer.Dac.Operation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
at Microsoft.SqlServer.Dac.ReportMessageOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
at Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
at Microsoft.SqlServer.Dac.DeployOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
at Microsoft.SqlServer.Dac.OperationExtension.Execute(IOperation operation, DacLoggingContext loggingContext, CancellationToken cancellationToken)
at Microsoft.SqlServer.Dac.DacServices.InternalDeploy(IPackageSource packageSource, Boolean isDacpac, String targetDatabaseName, DacAzureDatabaseSpecification creationDefaults, DacDeployOptions options, CancellationToken cancellationToken, DacLoggingContext loggingContext)
at Microsoft.SqlServer.Dac.DacServices.Deploy(DacPackage package, String targetDatabaseName, Boolean upgradeExisting, DacDeployOptions options, Nullable`1 cancellationToken)
at Microsoft.Dynamics.Performance.Deployment.Database.DatabaseDeployer.TryPerformDeployment(Boolean forceNew)
9/7/2015 8:48:00 AM - An error occurred during database deployment. View the deployment log for more information.
9/7/2015 8:54:39 AM - Microsoft.Dynamics.Performance.Deployment.Console.Core.DeploymentFailedException: Exception of type 'Microsoft.Dynamics.Performance.Deployment.Console.Core.DeploymentFailedException' was thrown.
at Microsoft.Dynamics.Performance.Deployment.Reporting.ApplicationServiceDeploymentPart.DeployWithSettings(IDictionary`2 settingsToDeployWith)
at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.Screens.DeploymentViewModel.TryRemoveFromView(Boolean isProgressing)
