Using DMPLuginWrapper Miniming Metrhod does not Display in BIDS

Question

I am running Visual Studio 2010  with SQL Server 2008 R2 on Windows64 7 Ultimate.  I built DMPluginWrapper on VS 2008.

It indicates that it register fins,

I then implented the Shell Algorithm in F# using VS2010 and registered it with no apparent complaint.  When I run BIDS I expect to be able to select "MyCompany Managed Plugin Algorithm" however it is not in the list.  Does anyone have any ideas as to what is wrong?  I belive I have followed the tutorial as exactly as I could given that I am using F# instead of C#.

 David

Answer 1

Analysis Services needs to be restarted after registering a plug-in algorithms.

Once the service restarts, please check the Windows Event Log. AS adds a log entry whenever it tries and succeeds, or fails, to load the plug-in

---

bogdan crivat / http://www.bogdancrivat.net/dm

Answer 2

The log tells me that the data mining algorithm's Class is not registered.  However all my post build steps ran to completion and indicated success.

---

David Thayer

Answer 3

A mismatch, maybe, between your AS platform and the target platform for your plug-in ? You can change VS to build for 32 or 64 bit

---

bogdan crivat / http://www.bogdancrivat.net/dm

Answer 4

I set the linker target machine to x64 and am getting an error module machine type x86 conflicts with target machine type x64.  I have found tha there is a macro defined of WIN32 should this be changed to WIN64?
There are also dependencies on numerous libraries such as ole32.lib advapi32.lib with inherited dependencies on kernel32.lib user32.lib gdi32.lib comdlg32.lib.  Do these need to be changed?  There doesn't seem to be any flags or settings on the compiler portion of the properties box that pertains to 64 bit windows. 

---

David Thayer

Answer 5

David,

You should not have to modify the individual settings. In particular, WIN32 all the libs should be the same. Instead, you should add, at the Visual Studio solution level, a new target platform, x64, copying the settings from the x86 platform. Also, once everything build correctly, you may need to use the right regasm.exe to install in the 64 bit registry hive. A DIR at the %windows%\Microsoft.Net level will show you the regasm.exe tool. One of them appears under the Framework64 folder

What version of Visual Studio are you using?

bogdan

---

bogdan crivat / http://www.bogdancrivat.net/dm

Answer 6

I am using VS 2010 Ultimate

---

David Thayer

Answer 7

I have been able to build a 64 bit version of DMPluginWrapper and install it in the GAC by turning off Code Database options and using the following command

"C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\NETFX 4.0 Tools\x64\gacutil.exe" /i "C:\Microsoft\Data Mining Managed Plug-in API\DMPluginWrapper\Debug\DMPluginWrapper.dll" /f

Now when I try to compile my F# version of the Shell I am getting the following error when i try to register it using the following command.

"%WINDIR%\Microsoft.NET\Framework64\v4.0.30319\RegAsm.exe" $(TargetFileName)

error RA0000: Could not load file or assembly 'DMPluginWrapper, Version=1.0.4437.23477, Culture=neutral, PublicKeyToken=a2b37e4067fd4b61' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

I am using a project reference for the DMPluginWrapper. Because I can't seem to find a reference to it in the System folder of the add reference dialog. When I browse there is no DMPluginWrapper in the Gac that is visible however when I use the gacutil to list the gac filteresd on the name I get 1 entry of type AMD64.

David

---

David Thayer

Answer 8

OK I found a Code Gellery Visual Studio Extension that allows me to add a reference from the GAC.  Now my Shell implementation builds and registers but when I restart Analysis Services I get the following errror in Event Viewer

The data mining algorithm provider (ProgID: 4AEAADE1-F0FC-429D-B8A1-A6EBE21C3289) for the My_Company_Managed_Plugin_Algorithm algorithm cannot be loaded. COM error: COM error: mscorlib; Value does not fall within the expected range..

---

David Thayer