Error Installing Management Reporter 2012

Question Status

Verified
Tom Bowman asked a question on 2 Apr 2012 2:35 PM

We are trying to install Management Reporter 2012 on Windows Server 2008 R2. When I attempt to run the configuration I get the following error:

There was no endpoint listening at http://w2k8tempalte:4712/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.5.162:4712

I have verfied that Windows Firewall is turned off, and I cannot find any other documentation. I've also tried installing this on a Windows 2003 server and receive the error message.

Any help or tips is appreciated.

Reply
Thomas Hänsel responded on 3 Apr 2012 7:17 AM

Exactly the same issue here on Win 2008 R2:

* Service account is not installed,

* Management Reporter web site is not created

* SQL server database is not created

Reply
Tom Bowman responded on 3 Apr 2012 8:37 AM

Just for kicks, I tried installing MR 2.0 in this same environment and it installed fine, so it must be something to do specifically with the MR 2012 installation routine.

Reply
Verified Answer
Ryan Sandness responded on 3 Apr 2012 11:38 AM

A few things for you to check.

1. Verify if you are deploying using the domain\administrator that the "Display Name" in active directory is set, and not blank.

2. Try deploying an app and process service first. If it fails, please close the config console and reopen. Then click on Deployment logs and attach the log or copy/paste into your thread so we can see the error you are hitting.

Management Reporter 2012 does not use IIS, so no website will be created. You should see Windows Services and a SQL Server database.

Thanks

Ryan

Reply
Verified Answer
Thomas Hänsel responded on 3 Apr 2012 12:58 PM

You made my day, Ryan!

The 'Display Name' of the MR Administrator account was empty.

Thanks a lot.

Thomas

Reply
Tom Bowman responded on 3 Apr 2012 1:28 PM

Ryan, it was was indeed the issue. My user did not have a name listed. Say hi to the MR team from Tom Bowman.

Reply
Suggested Answer
Thomas Hänsel responded on 4 Apr 2012 3:27 AM

I am facing another problem now with MR: the configuration of the AX2012 Data Mart Connector stops with errors (and the configuration of the AX 2012 legacy crashes). Update 1 of AX2012 and the MR..xpo is installed.

Domain account OC_MR_DP is system administrator in AX2012 and sql sysadmin, AX2012 and MR are running on the same computer.

Below you will find a copy of the deployment log.

Thanks for help in advance.

----start log

04.04.2012 12:14:27 - Checking whether database DDM1 exists

04.04.2012 12:14:27 - Checking SQL Server version; result: 10.50.1790.0

04.04.2012 12:14:27 - Checking whether current user has SQL role sysadmin

04.04.2012 12:14:28 - Deploying Dynamics AX 2012 data mart integration.

04.04.2012 12:14:28 - Checking database collation for database AX2012 on server OC-VSRV-02.

04.04.2012 12:14:28 - Database collation is Latin1_General_CI_AS.

04.04.2012 12:14:28 - Deploying data mart database with settings:

Create new database: True

Server name: OC-VSRV-02

Database name: DDM1

Integrated authentication: True

Encrypted connection: False

04.04.2012 12:14:28 - Database deployment package path is: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Packages\DDM.dbpkg

04.04.2012 12:14:28 - Extracting vsdbcmd.exe and supporting files...

04.04.2012 12:14:28 - Extracting database schema, scripts, and settings files...

04.04.2012 12:14:28 - Writing deployment parameters file...

04.04.2012 12:14:28 - Parameter list is:

04.04.2012 12:14:28 - /manifest:"C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.deploymanifest"

04.04.2012 12:14:28 - /a:Deploy

04.04.2012 12:14:28 - /dd+

04.04.2012 12:14:28 - /p:TargetDatabase="DDM1"

04.04.2012 12:14:28 - /p:AlwaysCreateNewDatabase=false

04.04.2012 12:14:28 - /p:SqlCommandVariablesFile="C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM_Database.sqlcmdvars"

04.04.2012 12:14:28 - Beginning database deployment...

04.04.2012 12:14:35 - TSD00566 Deployment script generated to:

C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (41,0) Creating DDM1...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (161,0) Updating Collation

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (161,0) Setting AUTO_UPDATE_STATISTICS_ASYNC to ON

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (186,0) Creating [GeneralUser]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (195,0) Creating [dbo].[Account]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (211,0) Creating [dbo].[AccountCategory]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (224,0) Creating [dbo].[AccountType]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (237,0) Creating [dbo].[AttributeDefinition]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (253,0) Creating [dbo].[ConvertedAmount]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (266,0) Creating [dbo].[DimensionCombination]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (278,0) Creating [dbo].[DimensionDefinition]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (300,0) Creating [dbo].[DimensionsPeriodBalance]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (315,0) Creating [dbo].[DimensionsPeriodBalance].[DimensionsPeriodBalanceIndex_Ordered]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (325,0) Creating [dbo].[DimensionValue]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (345,0) Creating [dbo].[DimensionValueAttributeValue]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (356,0) Creating [dbo].[DimensionValueCriterion]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (370,0) Creating [dbo].[Fact]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (396,0) Creating [dbo].[Fact].[FactIndex_KeyMatch]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (407,0) Creating [dbo].[FactAttributeValue]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (418,0) Creating [dbo].[FiscalYear]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (436,0) Creating [dbo].[Organization]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (454,0) Creating [dbo].[OrganizationUsers]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (465,0) Creating [dbo].[Period]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (482,0) Creating [dbo].[Period].[PeriodIndex_DateRange]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (493,0) Creating [dbo].[Scenario]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (512,0) Creating [dbo].[TableStatus]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (525,0) Creating [dbo].[UnitOfMeasure]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (539,0) Creating [dbo].[Users]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (553,0) Creating [dbo].[VersionHistory]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (564,0) Creating DF_NaturalAccount_CurrencyMethod...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (573,0) Creating DF_NaturalAccount_Statistical...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (582,0) Creating DF_NaturalAccount_TypicalBalance...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (591,0) Creating DF_AttributeDefinition_AttributeType...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (600,0) Creating DF_DimensionDefinition_IsActive...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (609,0) Creating DF_DimensionDefinition_Ordinal...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (618,0) Creating DF_DimensionsPeriodBalance_CreditAmount...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (627,0) Creating DF_DimensionsPeriodBalance_DebitAmount...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (636,0) Creating DF_Fact_FactType...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (645,0) Creating DF__FiscalYea__IsHis__164452B1...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (654,0) Creating DF_Organization_CalculateBeginningBalance...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (663,0) Creating DF__Period__IsClosed__1B0907CE...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (672,0) Creating DF_Scenario_IsActual...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (681,0) Creating DF_Scenario_IsDefault...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (690,0) Creating <unnamed>...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (699,0) Creating [dbo].[Fact].[FactStats_Id_OrganizationId_PeriodId]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (708,0) Creating [dbo].[Fact].[FactStats_PeriodId_Id]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (717,0) Creating FK_Account_AccountCategory...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (726,0) Creating FK_Account_AccountType...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (735,0) Creating FK_ConvertedAmount_UnitOfMeasure...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (744,0) Creating FK_DimensionDefinition_Organization...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (753,0) Creating FK_DimensionsPeriodBalance_DimensionCombinations...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (762,0) Creating FK_DimensionsPeriodBalance_Period...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (771,0) Creating FK_DimensionsPeriodBalance_Scenario...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (780,0) Creating FK_DimensionValue_DimensionDefinition1...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (789,0) Creating FK_Fact_DimensionCombinations...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (798,0) Creating FK_Fact_Organization...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (807,0) Creating FK_Fact_Scenario...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (816,0) Creating FK_Fact_UnitOfMeasure...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (825,0) Creating FK_FiscalYear_Organization...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (834,0) Creating FK_Organization_UnitOfMeasure...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (843,0) Creating FK_OrganizationUsers_Organization...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (852,0) Creating FK_OrganizationUsers_User...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (861,0) Creating FK_Period_Organization...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (870,0) Creating Period_FiscalYear...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (879,0) Creating FK_Scenario_Organization...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (888,0) Creating FK_Scenario_Scenario...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (897,0) Creating [dbo].[PeriodInsertTrigger]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (917,0) Creating [dbo].[PeriodUpdateTrigger]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (942,0) Creating [dbo].[AddNewDimension]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (991,0) Creating [dbo].[CalculatePeriodBalances]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1071,0) Creating [dbo].[GetScenarioId]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1088,0) Creating [dbo].[InsertAccountCategory]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1127,0) Creating [dbo].[InsertAccountType]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1166,0) Creating [dbo].[InsertAttributeDefinition]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1215,0) Creating [dbo].[InsertDimensionDefinition]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1300,0) Creating [dbo].[InsertFiscalYear]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1373,0) Creating [dbo].[InsertOrganization]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1451,0) Creating [dbo].[InsertPeriod]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1517,0) Creating [dbo].[InsertScenario]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1597,0) Creating [dbo].[InsertUnitOfMeasure]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1632,0) Creating [dbo].[RecalculateBalances]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1832,0) Creating [dbo].[UpdateDimensionValueReferences]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1901,0) Creating [dbo].[AccountCodeView]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1912,0) Creating [dbo].[DimensionDefinitionView]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1929,0) Creating [dbo].[FiscalCalendarView]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1941,0) Creating [dbo].[Fact].[FactType].[MS_Description]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1956,0)    Assign role permissions to stored procedures

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1956,0)    Assign role permissions to functions

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1956,0)   Assign role permissions to Tables and Views

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1956,0) :

(1 row(s) affected)

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1956,0) **** Creating Windows User

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1956,0) **** Created Windows User

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1956,0) **** Assign Role

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (2078,0) Checking existing data against newly created constraints

04.04.2012 12:14:35 -

04.04.2012 12:14:35 - Application service URI is http://oc-vsrv-02:4712/

04.04.2012 12:14:35 - Configuring Dynamics AX adapter with settings: AOS: AOS60$01:2712, AX Services Port: 2712, User: ORGCONSULT\OC_MR_DP, Database: AX2012, SQL Server: OC-VSRV-02

04.04.2012 12:14:35 - Configuring data mart adapter with settings: Server: OC-VSRV-02, Database: DDM1, User name: , Windows auth: True, Encrypt connection: False

04.04.2012 12:14:36 - Exception while trying to create an instance of the query services client.

04.04.2012 12:14:36 - Rolling back data mart database creation due to installation error. Connection information:

Create new database: True

Server name: OC-VSRV-02

Database name: DDM1

Integrated authentication: True

Encrypted connection: False

04.04.2012 12:14:36 - The data mart database was rolled back successfully.

04.04.2012 12:14:37 - Microsoft.Dynamics.Performance.Deployment.Console.Core.DeploymentFailedException: The settings for the Dynamics AX 2012 connection are not valid. Check the deployment log for details.

  at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AX2012DataMartDeploymentPart.DeployWithSettings(IDictionary`2 settingsToDeployWith)

  at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.Screens.DeploymentViewModel.TryRemoveFromView(Boolean isProgressing)

-----stop log

Reply
Suggested Answer
Thomas Hänsel responded on 5 Apr 2012 4:29 AM

Got it.

You have to type in the name of the AOS (here OC-VSRV-02), not the name of the service (AOS60$01).

Thanks to Markus M. from cosmoconsult for his support.

Reply
Salman Ali responded on 2 May 2012 6:52 PM

Thanks. It was a great help for me.

Reply
Teri Knecht responded on 4 Dec 2012 9:16 AM

Ryan,

Thanks a million for the Display Name answer.  I've been working on this for two hours.  Quick fix once you know the problem.  Thanks again.

Teri

Reply
Humayun Najam Khan responded on 11 Mar 2013 8:56 AM

I am getting the similar error below. I am using my domain user which is local admin on server and i have verified that the my display name is there in active directory .

3/11/2013 3:26:16 AM - Creating Windows user...

3/11/2013 3:26:16 AM - Assigning role...

3/11/2013 3:26:16 AM - Update complete.

3/11/2013 3:26:16 AM - Application service URI is http://XXX:4712/

3/11/2013 3:26:18 AM - Configuring Dynamics GP adapter with settings: Server: xxx\xxx_DYNAMICS_GP, Database: DYNAMICS, User name: sa

3/11/2013 3:26:18 AM - Configuring data mart adapter with settings: Server: xxx\xxx_DYNAMICS_GP, Database: DDM, User name: sa, Windows auth: False, Encrypt connection: False

3/11/2013 3:26:20 AM - System.ServiceModel.FaultException`1[Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.Connector.UnexpectedServiceError]: A service error has occurred.  Please check your server error logs for details. (Fault Detail is equal to Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.Connector.UnexpectedServiceError).

3/11/2013 3:26:20 AM - Rolling back data mart database creation due to installation error. Connection information:

Create new database: True

Server name:xxx\xxx_DYNAMICS_GP

Database name: DDM

Integrated authentication: False

User name: sa

Encrypted connection: False

3/11/2013 3:26:20 AM - The data mart database was rolled back successfully.

3/11/2013 3:26:26 AM - System.ServiceModel.FaultException`1[Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.Connector.UnexpectedServiceError]: A service error has occurred.  Please check your server error logs for details. (Fault Detail is equal to Microsoft.Dynamics.Performance.Deployment.DataProvider.DataMart.Connector.UnexpectedServiceError).

Reply
Ryan Sandness responded on 11 Mar 2013 1:19 PM

Hi Humayun,

You may want to post this issue in the Dynamics GP thread to see if anyone there has any ideas. There should be a detailed error log with more information. In the Configuration Console click on Deployment Log and open the most recent file. You should see the error near to the bottom.

Reply
Humayun Najam Khan responded on 11 Mar 2013 11:45 PM

Thanks Ryan. I have copied the above logs from deployment  logs as you mentioned here. i have other information in logs as well but that are not an error , I have just pasted the error here.

Reply
Xin Duan responded on 27 May 2013 12:17 AM

I have my "domain/administrator" with display name and assign it as MR administrator when deploying the application and process service(the same account used to install/configure application/process service). Before configure EPR intergration all seems OK. but once I configured and enable a integration with AX 2012 (the same account administrator was used to connect AX), it report error of unable to connect application service (Microsoft.Dynamics.Performance.Reporting.Common.ReportingPermissionException: You don't have permission to perform this operation.). Because this error in "configuration console" i also cannot see the configured integration with AX 2012.

So i removed application/process service and re-deploy. This time i assign another domain user as the MR administrator and everything works well. When I open "report Designer" I saw domain/administrator was regiestered as "generator" user. I cannot changed it to MR administrator since the combox was disabled (gray).

Then i did another test again: configure application/process service with another domain account with administrator rights and assign "domain/administrator" as MR administrator. After this, i switch to login with "domain/administrator" to conifgure the integration with AX2012. And this time i choose the third user account as AX user account. Once I enable the integration. The same mistake appear.

My question is why it alwyas failed if i use build-in "domain/administrator" as the MR administrator? In my second test why it was automatically was created as "generator" user.

Reply
Sathiyamoorthy S responded on 16 Feb 2015 5:49 AM

Hi Ryan,

I have tried to deploy app and process service only.  During the configuration logs are given below;

Before the account has empty display name after assign Display Name also getting the error.

--------Start Error-------------

- Checking SQL Server version; result: 12.0.2000.8

- System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at dynamics/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.0.0.5: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)

2/16/2015 3:16:09 PM - Starting deployment of Management Reporter 2012 Application Service

2/16/2015 3:16:09 PM - Creating PrincipalContext for domain <domain>

2/16/2015 3:16:09 PM - Finding Principal for user entadmin in context for domain <domain>

2/16/2015 3:16:09 PM - Found database package: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Packages\ManagementReporter.dacpac

2/16/2015 3:16:09 PM - Found database package: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Packages\SchedulerStore.dacpac

2/16/2015 3:16:09 PM - Found database package: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Packages\ConnectorStore.dacpac

2/16/2015 3:16:09 PM - Deployment parameters:

DatabaseCollation: SQL_Latin1_General_CP1_CI_AS

WindowsLoginToCreate: <domain>\mrsvc

FirstAdminUserName: <domain>\entadmin

FirstAdminSid: S-1-5-21-1583657088-1483352188-1218694631-500

FirstAdminDisplayName: Ent Admin

2/16/2015 3:16:09 PM - Extracting supporting files for database deployment...

2/16/2015 3:16:09 PM - Beginning database deployment...

2/16/2015 3:16:11 PM - The database deployment failed. Additional information: Could not deploy package.

2/16/2015 3:17:21 PM - Microsoft.Dynamics.Performance.Deployment.Console.Core.DeploymentFailedException: An error occurred during database deployment. View the deployment log for more information.

  at Microsoft.Dynamics.Performance.Deployment.Reporting.ReportingDatabase.DeployDatabasePackages(String connectionString, String databaseName, Dictionary`2 parameters)

  at Microsoft.Dynamics.Performance.Deployment.Reporting.ApplicationServiceDeploymentPart.DeployWithSettings(IDictionary`2 settingsToDeployWith)

  at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.Screens.DeploymentViewModel.TryRemoveFromView(Boolean isProgressing)

----End Error-----

Please let me know how to resolve this issue.

Regards,

Sakthi

Reply
Sathiyamoorthy S responded on 18 Feb 2015 6:57 AM

I have fixed the issue ref sathiya.io/.../error-configuring-management-reporter-2012.php

Reply
Verified Answer
Ryan Sandness responded on 3 Apr 2012 11:38 AM

A few things for you to check.

1. Verify if you are deploying using the domain\administrator that the "Display Name" in active directory is set, and not blank.

2. Try deploying an app and process service first. If it fails, please close the config console and reopen. Then click on Deployment logs and attach the log or copy/paste into your thread so we can see the error you are hitting.

Management Reporter 2012 does not use IIS, so no website will be created. You should see Windows Services and a SQL Server database.

Thanks

Ryan

Reply
Verified Answer
Thomas Hänsel responded on 3 Apr 2012 12:58 PM

You made my day, Ryan!

The 'Display Name' of the MR Administrator account was empty.

Thanks a lot.

Thomas

Reply
Suggested Answer
Thomas Hänsel responded on 4 Apr 2012 3:27 AM

I am facing another problem now with MR: the configuration of the AX2012 Data Mart Connector stops with errors (and the configuration of the AX 2012 legacy crashes). Update 1 of AX2012 and the MR..xpo is installed.

Domain account OC_MR_DP is system administrator in AX2012 and sql sysadmin, AX2012 and MR are running on the same computer.

Below you will find a copy of the deployment log.

Thanks for help in advance.

----start log

04.04.2012 12:14:27 - Checking whether database DDM1 exists

04.04.2012 12:14:27 - Checking SQL Server version; result: 10.50.1790.0

04.04.2012 12:14:27 - Checking whether current user has SQL role sysadmin

04.04.2012 12:14:28 - Deploying Dynamics AX 2012 data mart integration.

04.04.2012 12:14:28 - Checking database collation for database AX2012 on server OC-VSRV-02.

04.04.2012 12:14:28 - Database collation is Latin1_General_CI_AS.

04.04.2012 12:14:28 - Deploying data mart database with settings:

Create new database: True

Server name: OC-VSRV-02

Database name: DDM1

Integrated authentication: True

Encrypted connection: False

04.04.2012 12:14:28 - Database deployment package path is: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Packages\DDM.dbpkg

04.04.2012 12:14:28 - Extracting vsdbcmd.exe and supporting files...

04.04.2012 12:14:28 - Extracting database schema, scripts, and settings files...

04.04.2012 12:14:28 - Writing deployment parameters file...

04.04.2012 12:14:28 - Parameter list is:

04.04.2012 12:14:28 - /manifest:"C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.deploymanifest"

04.04.2012 12:14:28 - /a:Deploy

04.04.2012 12:14:28 - /dd+

04.04.2012 12:14:28 - /p:TargetDatabase="DDM1"

04.04.2012 12:14:28 - /p:AlwaysCreateNewDatabase=false

04.04.2012 12:14:28 - /p:SqlCommandVariablesFile="C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM_Database.sqlcmdvars"

04.04.2012 12:14:28 - Beginning database deployment...

04.04.2012 12:14:35 - TSD00566 Deployment script generated to:

C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (41,0) Creating DDM1...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (161,0) Updating Collation

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (161,0) Setting AUTO_UPDATE_STATISTICS_ASYNC to ON

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (186,0) Creating [GeneralUser]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (195,0) Creating [dbo].[Account]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (211,0) Creating [dbo].[AccountCategory]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (224,0) Creating [dbo].[AccountType]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (237,0) Creating [dbo].[AttributeDefinition]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (253,0) Creating [dbo].[ConvertedAmount]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (266,0) Creating [dbo].[DimensionCombination]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (278,0) Creating [dbo].[DimensionDefinition]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (300,0) Creating [dbo].[DimensionsPeriodBalance]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (315,0) Creating [dbo].[DimensionsPeriodBalance].[DimensionsPeriodBalanceIndex_Ordered]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (325,0) Creating [dbo].[DimensionValue]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (345,0) Creating [dbo].[DimensionValueAttributeValue]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (356,0) Creating [dbo].[DimensionValueCriterion]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (370,0) Creating [dbo].[Fact]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (396,0) Creating [dbo].[Fact].[FactIndex_KeyMatch]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (407,0) Creating [dbo].[FactAttributeValue]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (418,0) Creating [dbo].[FiscalYear]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (436,0) Creating [dbo].[Organization]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (454,0) Creating [dbo].[OrganizationUsers]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (465,0) Creating [dbo].[Period]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (482,0) Creating [dbo].[Period].[PeriodIndex_DateRange]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (493,0) Creating [dbo].[Scenario]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (512,0) Creating [dbo].[TableStatus]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (525,0) Creating [dbo].[UnitOfMeasure]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (539,0) Creating [dbo].[Users]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (553,0) Creating [dbo].[VersionHistory]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (564,0) Creating DF_NaturalAccount_CurrencyMethod...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (573,0) Creating DF_NaturalAccount_Statistical...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (582,0) Creating DF_NaturalAccount_TypicalBalance...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (591,0) Creating DF_AttributeDefinition_AttributeType...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (600,0) Creating DF_DimensionDefinition_IsActive...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (609,0) Creating DF_DimensionDefinition_Ordinal...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (618,0) Creating DF_DimensionsPeriodBalance_CreditAmount...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (627,0) Creating DF_DimensionsPeriodBalance_DebitAmount...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (636,0) Creating DF_Fact_FactType...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (645,0) Creating DF__FiscalYea__IsHis__164452B1...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (654,0) Creating DF_Organization_CalculateBeginningBalance...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (663,0) Creating DF__Period__IsClosed__1B0907CE...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (672,0) Creating DF_Scenario_IsActual...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (681,0) Creating DF_Scenario_IsDefault...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (690,0) Creating <unnamed>...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (699,0) Creating [dbo].[Fact].[FactStats_Id_OrganizationId_PeriodId]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (708,0) Creating [dbo].[Fact].[FactStats_PeriodId_Id]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (717,0) Creating FK_Account_AccountCategory...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (726,0) Creating FK_Account_AccountType...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (735,0) Creating FK_ConvertedAmount_UnitOfMeasure...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (744,0) Creating FK_DimensionDefinition_Organization...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (753,0) Creating FK_DimensionsPeriodBalance_DimensionCombinations...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (762,0) Creating FK_DimensionsPeriodBalance_Period...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (771,0) Creating FK_DimensionsPeriodBalance_Scenario...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (780,0) Creating FK_DimensionValue_DimensionDefinition1...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (789,0) Creating FK_Fact_DimensionCombinations...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (798,0) Creating FK_Fact_Organization...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (807,0) Creating FK_Fact_Scenario...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (816,0) Creating FK_Fact_UnitOfMeasure...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (825,0) Creating FK_FiscalYear_Organization...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (834,0) Creating FK_Organization_UnitOfMeasure...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (843,0) Creating FK_OrganizationUsers_Organization...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (852,0) Creating FK_OrganizationUsers_User...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (861,0) Creating FK_Period_Organization...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (870,0) Creating Period_FiscalYear...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (879,0) Creating FK_Scenario_Organization...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (888,0) Creating FK_Scenario_Scenario...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (897,0) Creating [dbo].[PeriodInsertTrigger]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (917,0) Creating [dbo].[PeriodUpdateTrigger]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (942,0) Creating [dbo].[AddNewDimension]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (991,0) Creating [dbo].[CalculatePeriodBalances]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1071,0) Creating [dbo].[GetScenarioId]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1088,0) Creating [dbo].[InsertAccountCategory]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1127,0) Creating [dbo].[InsertAccountType]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1166,0) Creating [dbo].[InsertAttributeDefinition]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1215,0) Creating [dbo].[InsertDimensionDefinition]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1300,0) Creating [dbo].[InsertFiscalYear]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1373,0) Creating [dbo].[InsertOrganization]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1451,0) Creating [dbo].[InsertPeriod]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1517,0) Creating [dbo].[InsertScenario]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1597,0) Creating [dbo].[InsertUnitOfMeasure]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1632,0) Creating [dbo].[RecalculateBalances]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1832,0) Creating [dbo].[UpdateDimensionValueReferences]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1901,0) Creating [dbo].[AccountCodeView]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1912,0) Creating [dbo].[DimensionDefinitionView]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1929,0) Creating [dbo].[FiscalCalendarView]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1941,0) Creating [dbo].[Fact].[FactType].[MS_Description]...

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1956,0)    Assign role permissions to stored procedures

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1956,0)    Assign role permissions to functions

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1956,0)   Assign role permissions to Tables and Views

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1956,0) :

(1 row(s) affected)

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1956,0) **** Creating Windows User

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1956,0) **** Created Windows User

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (1956,0) **** Assign Role

SQL01268 C:\Users\Administrator.OC-VSRV-02\AppData\Local\Temp\1\5652f9ef-39e6-46fe-8efc-2dc58e4f312f\DDM.sql (2078,0) Checking existing data against newly created constraints

04.04.2012 12:14:35 -

04.04.2012 12:14:35 - Application service URI is http://oc-vsrv-02:4712/

04.04.2012 12:14:35 - Configuring Dynamics AX adapter with settings: AOS: AOS60$01:2712, AX Services Port: 2712, User: ORGCONSULT\OC_MR_DP, Database: AX2012, SQL Server: OC-VSRV-02

04.04.2012 12:14:35 - Configuring data mart adapter with settings: Server: OC-VSRV-02, Database: DDM1, User name: , Windows auth: True, Encrypt connection: False

04.04.2012 12:14:36 - Exception while trying to create an instance of the query services client.

04.04.2012 12:14:36 - Rolling back data mart database creation due to installation error. Connection information:

Create new database: True

Server name: OC-VSRV-02

Database name: DDM1

Integrated authentication: True

Encrypted connection: False

04.04.2012 12:14:36 - The data mart database was rolled back successfully.

04.04.2012 12:14:37 - Microsoft.Dynamics.Performance.Deployment.Console.Core.DeploymentFailedException: The settings for the Dynamics AX 2012 connection are not valid. Check the deployment log for details.

  at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AX2012DataMartDeploymentPart.DeployWithSettings(IDictionary`2 settingsToDeployWith)

  at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.Screens.DeploymentViewModel.TryRemoveFromView(Boolean isProgressing)

-----stop log

Reply
Suggested Answer
Thomas Hänsel responded on 5 Apr 2012 4:29 AM

Got it.

You have to type in the name of the AOS (here OC-VSRV-02), not the name of the service (AOS60$01).

Thanks to Markus M. from cosmoconsult for his support.

Reply
Suggested Answer
Ryan Sandness responded on 1 Sep 2015 9:22 AM

Arunkumar,

My best guess is that you have a table that normally doesn't exist. I'm not familiar with this table -   [dbo].[license_bkp]). Take a backup of your MRDB and drop this table prior to upgrading. Otherwise, if you have spent 3 days troubleshooting this you may want to open a support ticket and the support team may have some suggestions on why you are experiencing this error.

Reply