Poison Message Sample in BOL

Hello Remus,

I have implemented Event Notification sample you provided in my logic, but I am perplexed that even though my watched queue does go down, I do not get message in the Event_Collector queue all the time. The Event_Collector queue does stay enabled though. Any thoughts? I guess any suggestions on debugging the event notification portion would be helpful.

Lubomir
Upon further look at the sys.event_notifications view, I discovered that my event notification is not there any more - it disappears. So the first time the queue goes down, the notification is successful and the Event Notification is still in sys.event_notifications. Second attemp removes the Event Notification from sys.event_notifications.

Lubomir|||

Can you check if the event notification infrastructure isn't receving back an error or an end dialog message on the system dialog that delivers the notifications? Look into errorlog or in Event Viewer (Application), see if you find a record similar to one of these:

Event notification conversation on dialog handle '{4B086B77-C691-DA11-AD12-00030D303B72}' closed without an error.

or:

Closed event notification conversation endpoint with handle '{B1663957-C791-DA11-AD12-00030D303B72}', due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8494</Code><Description>You do not have permission to access the service &apos;s&apos;.</Description></Error>'.

HTH,
~ Remus

|||Thank you Remus,

Yup it was the End Dialog message I had; Things work great now.

Lubomir

Plug-in algorithm documentation and sample code

I've read in at least one book (and heard firsthand at the SQL Server launch event) that there's a plug-in framework for adding new algorithms to Data Mining. However, the book was apparently written against a Beta version, and the location it suggests for the plug-in sample code doesn't exist in the shipping version. I haven't been able to locate any documentation about the plug-in framework in the SQL Server Books Online, and I haven't been able to find any sample code, either.

Can someone give me a few pointers?Did you explicitly install the SQL Server Samples? You have to choose advanced options during setup to get them - they are not installed by default. If not, go to add/remove programs to run the installer again to add the samples to your installation.|||

You can also find the plug-in algorithm tutorial (with complete source code for a sample) here: http://www.sqlserverdatamining.com/DMCommunity/Tutorials/Links_LinkRedirector.aspx?id=62

The plug-in algorithm whitepaper is available here:
http://www.sqlserverdatamining.com/DMCommunity/Whitepapers+and+Articles/Whitepapers/Links_LinkRedirector.aspx?id=64

Raman Iyer
SQL Server Data Mining

|||Yes, I did install the samples. In fact, I tried on two different installations of SQL Server -- one in which I'd installed the samples with the original installation, and one in which I installed them after-the-fact. In neither case could I find any of the plug-in samples.|||Thank you very much!|||

Hi,

This site is very good but I need to ask aquistion.

Can I use the C# language instead of VC++ in order to create the new mining algorithm.

Is there any example?

Thanks in advance for any help,

Aya.

|||We are working on a framework/SDK for developing plug-in algorithms using managed code. We hope to make it available for download, along with sample code, in the next month or so.

Plug-in algorithm documentation and sample code

I've read in at least one book (and heard firsthand at the SQL Server launch event) that there's a plug-in framework for adding new algorithms to Data Mining. However, the book was apparently written against a Beta version, and the location it suggests for the plug-in sample code doesn't exist in the shipping version. I haven't been able to locate any documentation about the plug-in framework in the SQL Server Books Online, and I haven't been able to find any sample code, either.

Can someone give me a few pointers?Did you explicitly install the SQL Server Samples? You have to choose advanced options during setup to get them - they are not installed by default. If not, go to add/remove programs to run the installer again to add the samples to your installation.|||

You can also find the plug-in algorithm tutorial (with complete source code for a sample) here: http://www.sqlserverdatamining.com/DMCommunity/Tutorials/Links_LinkRedirector.aspx?id=62

The plug-in algorithm whitepaper is available here:
http://www.sqlserverdatamining.com/DMCommunity/Whitepapers+and+Articles/Whitepapers/Links_LinkRedirector.aspx?id=64

Raman Iyer
SQL Server Data Mining

|||Yes, I did install the samples. In fact, I tried on two different installations of SQL Server -- one in which I'd installed the samples with the original installation, and one in which I installed them after-the-fact. In neither case could I find any of the plug-in samples.|||Thank you very much!|||

Hi,

This site is very good but I need to ask aquistion.

Can I use the C# language instead of VC++ in order to create the new mining algorithm.

Is there any example?

Thanks in advance for any help,

Aya.

|||We are working on a framework/SDK for developing plug-in algorithms using managed code. We hope to make it available for download, along with sample code, in the next month or so.