Management Reporter DataMart created in single user mode

  • Management Reporter DataMart created in single user mode

    Posted by DSC Communities on December 2, 2016 at 10:41 am
    • Jennifer Manteufel

      Member

      December 2, 2016 at 10:41 AM

      We have setup a new server to host our MR services and when we try to configure the datamart for GP 2015 we get the following error. 

      The process gets to the part where the service account is added to the General User Role then we receive the following error. For some reason the datamart continues to get created in singleuser mode in sql. 

      12/2/2016 9:33:05 AM – Application service URI is http://<MachineName>:4712/
      12/2/2016 9:33:05 AM – System.ServiceModel.FaultException: A service error has occurred. Please check your server error logs for details.

      Server stack trace:
      at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
      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.Connector.Service.IConfigurationServiceContract.GetDefaultAdaptersWithSettings(DefaultAdapterWithSettingsRequest[] requests)
      at Microsoft.Dynamics.Performance.Deployment.Connector.ConnectorConfigurationHelper.<>c__DisplayClassb.b__9()
      at Microsoft.Dynamics.Performance.Deployment.Connector.ConnectorConfigurationHelper.ExecuteAndNotifyError[T](Func`1 function)
      12/2/2016 9:33:05 AM – Rolling back data mart database creation due to installation error. Connection information:
      Create new database: True
      Server name: <sqlinstance>
      Database name: ManagementReporterDM
      Integrated authentication: True
      Encrypted connection: False
      SSDT command timeout: 0
      12/2/2016 9:33:05 AM – Attempt to drop database ManagementReporterDM with connection information Data Source=<sqlinstance>;Initial Catalog=ManagementReporterDM;Integrated Security=True;Persist Security Info=False;Encrypt=False failed. Error text: System.Data.SqlClient.SqlException (0x80131904): Cannot drop database “ManagementReporterDM” because it is currently in use.
      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
      at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
      at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
      at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
      at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
      at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.SqlCommandExtensions.<>c__DisplayClass1.b__0()
      at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
      at Microsoft.Dynamics.Performance.Core.SqlCommandWrapper.RunCommand[TResult](SqlCommand command, Func`1 execute)
      at Microsoft.Dynamics.Performance.Deployment.Common.SqlUtility.TryDropDatabase(String connectionString)
      ClientConnectionId:77be83a8-1569-4e83-8679-e05c7f4ad979
      Error Number:3702,State:3,Class:16
      12/2/2016 9:33:05 AM – The data mart database couldn’t be rolled back. Full error text can be found earlier in the deployment log.
      12/2/2016 9:33:06 AM – System.ServiceModel.FaultException: A service error has occurred. Please check your server error logs for details.

      Server stack trace:
      at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
      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.Connector.Service.IConfigurationServiceContract.GetDefaultAdaptersWithSettings(DefaultAdapterWithSettingsRequest[] requests)
      at Microsoft.Dynamics.Performance.Deployment.Connector.ConnectorConfigurationHelper.<>c__DisplayClassb.b__9()
      at Microsoft.Dynamics.Performance.Deployment.Connector.ConnectorConfigurationHelper.ExecuteAndNotifyError[T](Func`1 function)
      at Microsoft.Dynamics.Performance.Deployment.DataProvider.GP.GPDataMartDeploymentPart.ConfigureGpToDMAdapters(GPIntegrationSettings gpIntegrationSettings, ConfiguredDatabaseConnection configuredGpDatabaseConnection, ConfiguredDatabaseConnection configuredDataMartDatabaseConnection, ConnectorConfigurationHelper helper, AdapterWithSettings& gpAdapter, AdapterWithSettings& dataMartAdapter)
      at Microsoft.Dynamics.Performance.Deployment.DataProvider.GP.GPDataMartDeploymentPart.ValidateSettingsWhenAppServiceExists(IDictionary`2 settingsToValidate)
      at Microsoft.Dynamics.Performance.Deployment.DataProvider.GP.GPDataMartDeploymentPart.DeployWithSettings(IDictionary`2 settingsToDeployWith)
      at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.Screens.DeploymentViewModel.TryRemoveFromView(Boolean isProgressing)

      ——————————
      Jennifer Manteufel
      Supervisor, IT Application Systems
      Navitus Health Solutions
      Appleton WI
      ——————————

    DSC Communities replied 7 years, 4 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Management Reporter DataMart created in single user mode’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!