Service Error When Creating Management Reporter Datamart

(0) Share

Report

Posted on by Aaron Withington

Hello,

I am performing and upgrade from Management Reporter CU 12 to CU 13. The Management Reporter database update was successful but when I attempt to recreate the datamart I get the following error:

System.ComponentModel.Composition.CompositionException: The composition produced a single composition error. The root cause is provided below. Review the CompositionException.Errors property for more detailed information.

1) Composition container must be initialized before import is attempted!

Resulting in: An exception occurred while calling the 'OnImportsSatisfied' method on type 'Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Composition.ComposableParts'.

Resulting in: Cannot activate part 'Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Composition.ComposableParts'.
Element: Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Composition.ComposableParts --> Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Composition.ComposableParts

   at System.ComponentModel.Composition.CompositionResult.ThrowOnErrors(AtomicComposition atomicComposition)
   at System.ComponentModel.Composition.Hosting.ImportEngine.SatisfyImportsOnce(ComposablePart part)
   at System.ComponentModel.Composition.Hosting.CompositionContainer.SatisfyImportsOnce(ComposablePart part)
   at System.ComponentModel.Composition.AttributedModelServices.SatisfyImportsOnce(ICompositionService compositionService, Object attributedPart)
   at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Composition.RootContainer.RecomposeParts()
   at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.App.OnStartup(StartupEventArgs e)
   at System.Windows.Application.<.ctor>b__1(Object unused)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)
   at System.Windows.Threading.DispatcherOperation.InvokeImpl()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Threading.DispatcherOperation.Invoke()
   at System.Windows.Threading.Dispatcher.ProcessQueue()
   at System.Windows.Threading.Dispatcher.WndProcHook(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)
   at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Int32 numArgs)
   at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam)
   at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)
   at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)
   at System.Windows.Application.RunInternal(Window window)
   at System.Windows.Application.Run()
   at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.App.Main()

Has anyone seem this error before or know how to get past it?

Thank you.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Justin Sutton on at

Like (0)

Report

RE: Service Error When Creating Management Reporter Datamart

Hello Aaron,

I have seen this error before.

From my experience, it appears to occur when the services are not removed/recreated when upgrading MR and the automatic upgrade does not remove them properly for some reason. . I would recommend the following:

1. Remove both Services

a. From MR, simply click Disable then Remove.

2. Check the Services in Windows and make sure both MR services are gone:

a. You can find the Services section here: Control Panel\System and Security\Administrative Tools.

b. If the Services are still there you will want to manually remove them.

2. Recreate your Services

3. Attempt your integration again.

Please let me know if you have any additional questions on this.

Justin Sutton

------------------------------------------------------------------------------------

Microsoft Dynamics GP Support

------------------------------------------------------------------------------------

**This posting is provided 'AS IS' with no warranties and confers no rights.**

Was this reply helpful? Yes No
Verified answer

soma 24,410 on at

Like (0)

Report

RE: Service Error When Creating Management Reporter Datamart

Take a backup of your management reporter and datamart database and Export MR building blocks. Then rebuild your MR services.

Hope this helps!!!

Was this reply helpful? Yes No
Aaron Withington 30 on at

Like (0)

Report

RE: Service Error When Creating Management Reporter Datamart

Thank you for the response. I have tried this as part of my troubleshooting. It did not help but I realize I left out a major aspect of this upgrade. I also changed the database server that the management reporter database lives on. After removing and recreating both services and the integration I am now getting this error.

Error retrieving company information for Dynamics GP GL Adapter.

Error retrieving company information for Dynamics GP GL Adapter.

--- Exception Dump ---

Caught Exception: [Microsoft.Dynamics.Integration.AdapterAbstractionLayer.AdapterException] The connection to the Microsoft Dynamics GP database failed. The server name and user credentials are required.

Stack trace:

at Microsoft.Dynamics.Performance.Integration.Reporting.Adapter.GP.DataConnector.CreateConnection()

at Microsoft.Dynamics.Performance.Integration.Reporting.Adapter.GPAdapter.GetDatabases()

at Microsoft.Dynamics.Performance.Integration.Reporting.Adapter.GPAdapter.GetSettingsValueList(String settingsName, Boolean forceRefresh)

at Microsoft.Dynamics.Integration.Service.AdapterSiteCache.GetSites(AdapterProxy adapter)

Component: Microsoft.Dynamics.Integration.Common.TraceLog

User: Domain\service account name

Machine: GPserver

Followed by:

The encrypted setting, Password, could not be decrypted.

--- Exception Dump ---

Caught Exception: [System.Security.Cryptography.CryptographicException] Encrypted data was invalid and cannot be decrypted.

Stack trace:

at Microsoft.Dynamics.Integration.DataAccessLayer.DataProtection.Decrypt(Byte[] data)

at Microsoft.Dynamics.Integration.DataAccessLayer.DataProtection.DecryptSettings(XElement settings)

Component: Microsoft.Dynamics.Integration.Common.TraceLog

User: Domain\service account name

Machine: GPserver

Was this reply helpful? Yes No
Aaron Withington 30 on at

Like (0)

Report

RE: Service Error When Creating Management Reporter Datamart

Thanks for the response. I tried these steps and the issue remains. I have also migrated the SQL server as part of the upgrade. I think that is what is causing the issue. After following this suggestion I am getting the following errors:

The encrypted setting, Password, could not be decrypted.

--- Exception Dump ---

Caught Exception: [System.Security.Cryptography.CryptographicException] Encrypted data was invalid and cannot be decrypted.

Stack trace:

at Microsoft.Dynamics.Integration.DataAccessLayer.DataProtection.Decrypt(Byte[] data)

at Microsoft.Dynamics.Integration.DataAccessLayer.DataProtection.DecryptSettings(XElement settings)

Component: Microsoft.Dynamics.Integration.Common.TraceLog

User: Domain\service account name

Machine: GPserver

Was this reply helpful? Yes No
Suggested answer

Justin Sutton on at

Like (0)

Report

RE: Service Error When Creating Management Reporter Datamart

Hello Aaron,

For that error (Encryption) you would want to run the script in KB2744330:

2744330 Error messages when you restore a Microsoft Management Reporter 2012 database: “The operation could not be completed”

support.microsoft.com/.../EN-US

Make sure you follow the first instruction within the script instructions.

If you are still seeing the 'Error retrieving company information for Dynamics GP GL Adapter' error, you will want to look through the Connector.MapCategoryAdapterSettings table for references to your old server. These would need removed.

As always, create a backup for your Management Reporter database before doing any of these back end solutions.

Please let me know if you have any additional questions on this.

Justin Sutton

------------------------------------------------------------------------------------

Microsoft Dynamics GP Support

------------------------------------------------------------------------------------

**This posting is provided 'AS IS' with no warranties and confers no rights.**

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Service Error When Creating Management Reporter Datamart

Justin Sutton,

I am getting the Service error, "Error retrieving company information for Dynamics GP GL Adapter. The connection to the MDGP database failed. The server name and user credentials are required." When trying to restore production data in our test environment. (e.g. moving from one server to another)

In production we are running MR2012 v. 2.12.13002.1 & in test we applied CU 14 (MR2012 v. 2.12.14001.45). When I create the MR services in Configuration Console a warning displays saying the older version of the db is going to be updated to a newer version. I assume this is b/c we've applied CU 14 in test and not in production. I queried both Connector.MapCategoryAdapterSettings & Reporting.ControlCompany and found references to the production server, which I corrected, but still I get the same error about the server name and user credentials being required.

What am I missing?

PS I've also followed all of the steps in KB2744330.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Service Error When Creating Management Reporter Datamart

Hi Justin, thanks so much for your posting.. I transfered my MR to a new server and this table had blank entries for the password values and old server name so hence why I could not connect to my databases.. The only issue is that these passwords (on my old server) were encrypted. By placing the unencrypted password, I got MR to connect properly but spits an error message.. Is there a way to figure out the encryption value of an SQL Password? I looked at my sys.syslogins table.. password shown in there looks japanese... lol. This is what I had as my connection to my Dynamics DB on my old server

<SettingsValue>

<FieldDefinition Name="SystemDatabase" TypeName="string" DisplayName="System Database" IsRequired="true" IsReadOnly="false" />

<Attributes>Site SupportsValueList</Attributes>

<Value>Dynamics</Value>

</SettingsValue>

<SettingsValue>

<FieldDefinition Name="UserName" TypeName="string" DisplayName="User Name" IsRequired="true" IsReadOnly="false" />

<Attributes />

<Value>sa</Value>

</SettingsValue>

<SettingsValue>

<FieldDefinition Name="Password" TypeName="string" DisplayName="Password" IsRequired="true" IsReadOnly="false" />

<Attributes>Password</Attributes>

<Value>ANyt+bYcmkqIo0++YbEGhQEAAABwX1EuwwZP4o8uOrI3/B7T+6Uqfn30NKFGokpRTp37731Es6NjePh3pPUdjKS7WtrA/H/MH9HJhCnxWOhPInb7</Value>

</SettingsValue>

</ArrayOfSettingsValue>

</SettingsCollection>

It is funny that MR did not overwrite this infomation in the table when I installed MR on the new server (I specified installing with an existing database).

Was this reply helpful? Yes No