we've a problem using SSMS with 32-bit.
We create OLAP Roles on Analysis Service Databases automatically. They are for users of the MS Dynamics CRM and based on their security settings. Now we do have a lot of users with settings on many dimension attributes.
To create this roles we need a 64-bit version of an own written program based on the "Microsoft Dynamics CRM Analytics Foundation" available on Codeplex (http://crmanalytics.codeplex.com/). This works pretty good.
Now when we want to check or delete a role in SSMS we get always an error:
Deserialization failed: Exception of type 'System.OutOfMemoryException' was thrown. (Microsoft.AnalysisServices)
I do guess that the reason is that because the XMLA structure is very large cause of the created roles it doesn't fit into a 32-bit process any more.
So my question is, what I can do to handle this issue. Is there a SSMS available with 64-bit? Or is there another client with 64-bit I can use?
Thanks for suggestions.
View Complete Post