Hi,
After using 8201 as the Service Port as the correction, I am getting the below error. The setup was failed. THen I opened up MR Configuration Console and tried to create the DataMart DB, when I am getting the below error.
Log Name: Application
Source: Management Reporter 2012 Configuration Console
Date: 8/18/2016 11:43:56 AM
Event ID: 0
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: QDCPC-AXDEV01.qd-cpc.com
Description:
System.AggregateException: A Task's exception(s) were not observed either by Waiting on the Task or accessing its Exception property. As a result, the unobserved exception was rethrown by the finalizer thread. ---> System.Data.SqlClient.SqlException: Invalid column name 'DATAAREA'.
Invalid column name 'DATAAREA'.
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.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.CredentialConfigurationHelper.OpenConnectionAndExecuteReader[T](String sqlToExecute, ConfiguredCredential configuredCredential, Func`2 readerFunction, SqlParameter[] parameters)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.CredentialConfigurationHelper.ExecuteReader[T](String sqlToExecute, ConfiguredCredential configuredCredential, Func`2 readerFunction, SqlParameter[] parameters)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AXDesignerConnectionConfigurationTool.GetCompanies()
at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AXDesignerConnectionConfigurationTool.TryConfigureDesignerConnections(Boolean writeToLog)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AXDesignerConnectionConfigurationTool.VerifyCredentialAndConfigure(Boolean suppressUI, String& message)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AX2012DataMartDeploymentPart.ValidateSettings(IDictionary`2 settingsToValidate)
at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.Screens.ConfigurationViewModel.<TryRemoveFromView>b__13(IDeploymentPart part)
at System.Linq.Enumerable.<SelectManyIterator>d__1`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.Screens.ConfigurationViewModel.TryRemoveFromView(Boolean isProgressing)
at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.WizardViewModel.SetSelectedScreenControllerImplementation(Int32 targetIndex, Boolean isProgressing, WizardScreenViewModel activeModel)
at System.Threading.Tasks.Task.Execute()
--- End of inner exception stack trace ---
---> (Inner Exception #0) System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'DATAAREA'.
Invalid column name 'DATAAREA'.
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.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.CredentialConfigurationHelper.OpenConnectionAndExecuteReader[T](String sqlToExecute, ConfiguredCredential configuredCredential, Func`2 readerFunction, SqlParameter[] parameters)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.CredentialConfigurationHelper.ExecuteReader[T](String sqlToExecute, ConfiguredCredential configuredCredential, Func`2 readerFunction, SqlParameter[] parameters)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AXDesignerConnectionConfigurationTool.GetCompanies()
at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AXDesignerConnectionConfigurationTool.TryConfigureDesignerConnections(Boolean writeToLog)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AXDesignerConnectionConfigurationTool.VerifyCredentialAndConfigure(Boolean suppressUI, String& message)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AX2012DataMartDeploymentPart.ValidateSettings(IDictionary`2 settingsToValidate)
at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.Screens.ConfigurationViewModel.<TryRemoveFromView>b__13(IDeploymentPart part)
at System.Linq.Enumerable.<SelectManyIterator>d__1`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.Screens.ConfigurationViewModel.TryRemoveFromView(Boolean isProgressing)
at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.WizardViewModel.SetSelectedScreenControllerImplementation(Int32 targetIndex, Boolean isProgressing, WizardScreenViewModel activeModel)
at System.Threading.Tasks.Task.Execute()
ClientConnectionId:accb516f-1c9f-446d-aa28-dc9f0091be6e
Error Number:207,State:1,Class:16<---
Event Xml:
<Event xmlns="schemas.microsoft.com/.../event">
<System>
<Provider Name="Management Reporter 2012 Configuration Console" />
<EventID Qualifiers="0">0</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2016-08-18T08:43:56.000000000Z" />
<EventRecordID>61584</EventRecordID>
<Channel>Application</Channel>
<Computer>QDCPC-AXDEV01.qd-cpc.com</Computer>
<Security />
</System>
<EventData>
<Data>System.AggregateException: A Task's exception(s) were not observed either by Waiting on the Task or accessing its Exception property. As a result, the unobserved exception was rethrown by the finalizer thread. ---> System.Data.SqlClient.SqlException: Invalid column name 'DATAAREA'.
Invalid column name 'DATAAREA'.
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.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.CredentialConfigurationHelper.OpenConnectionAndExecuteReader[T](String sqlToExecute, ConfiguredCredential configuredCredential, Func`2 readerFunction, SqlParameter[] parameters)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.CredentialConfigurationHelper.ExecuteReader[T](String sqlToExecute, ConfiguredCredential configuredCredential, Func`2 readerFunction, SqlParameter[] parameters)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AXDesignerConnectionConfigurationTool.GetCompanies()
at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AXDesignerConnectionConfigurationTool.TryConfigureDesignerConnections(Boolean writeToLog)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AXDesignerConnectionConfigurationTool.VerifyCredentialAndConfigure(Boolean suppressUI, String& message)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AX2012DataMartDeploymentPart.ValidateSettings(IDictionary`2 settingsToValidate)
at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.Screens.ConfigurationViewModel.<TryRemoveFromView>b__13(IDeploymentPart part)
at System.Linq.Enumerable.<SelectManyIterator>d__1`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.Screens.ConfigurationViewModel.TryRemoveFromView(Boolean isProgressing)
at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.WizardViewModel.SetSelectedScreenControllerImplementation(Int32 targetIndex, Boolean isProgressing, WizardScreenViewModel activeModel)
at System.Threading.Tasks.Task.Execute()
--- End of inner exception stack trace ---
---> (Inner Exception #0) System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'DATAAREA'.
Invalid column name 'DATAAREA'.
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.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.CredentialConfigurationHelper.OpenConnectionAndExecuteReader[T](String sqlToExecute, ConfiguredCredential configuredCredential, Func`2 readerFunction, SqlParameter[] parameters)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.CredentialConfigurationHelper.ExecuteReader[T](String sqlToExecute, ConfiguredCredential configuredCredential, Func`2 readerFunction, SqlParameter[] parameters)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AXDesignerConnectionConfigurationTool.GetCompanies()
at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AXDesignerConnectionConfigurationTool.TryConfigureDesignerConnections(Boolean writeToLog)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AXDesignerConnectionConfigurationTool.VerifyCredentialAndConfigure(Boolean suppressUI, String& message)
at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AX2012DataMartDeploymentPart.ValidateSettings(IDictionary`2 settingsToValidate)
at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.Screens.ConfigurationViewModel.<TryRemoveFromView>b__13(IDeploymentPart part)
at System.Linq.Enumerable.<SelectManyIterator>d__1`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.Screens.ConfigurationViewModel.TryRemoveFromView(Boolean isProgressing)
at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.WizardViewModel.SetSelectedScreenControllerImplementation(Int32 targetIndex, Boolean isProgressing, WizardScreenViewModel activeModel)
at System.Threading.Tasks.Task.Execute()
ClientConnectionId:accb516f-1c9f-446d-aa28-dc9f0091be6e
Error Number:207,State:1,Class:16<---
</Data>
</EventData>
</Event>
Can someone please help me resolve this issue.
Would appreciate for some help.
Sincerely,
Muneeb