Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Jennifer Manteufel]

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
——————————