Problem with plug-in algorithm in SQL Server 2005

Hi,all here,

Could please anyone here help me for this problem?

My problem is: I have registered my plug-in algortihm with SQL Server 2005 analysis services, and I can see my plug-in algortihm added to the analysis service configuration file (msmdsrv.ini). But why I can not see my algorithm appearing in the list of algorithms when I tested it? Really need help for that.

Thanks a lot for any guidance and help.

With best regards,

Yours sincerely,

Hi Helen -

I've noticed you've had a few questions over the last week. I am a partner at Apollo Data Technologies, we specialize in building predictive models utilizing SQL Server 2K5 Data Mining.

Not sure if it's of interest to you or your organization - please feel free to contact us if you would like to explore professional consulting. We've helped many clients in the past jump-start their modeling projects.

You can read more about Apollo at: http://apollodatatech.com/

Best regards,

Jeff Kaplan
312.787.7376
|||

Hi, please anyone here gives me some advice for this problem? It is needed indeed urgently. Thanks a lot.

With best regards,

Yours sincerely,

|||

Hi, all here,

Please would any expert give me some ideas about what is going on for that. In the analysis services configuration file, under the <Algorithms> tag, I can see the name of my plug-in algorithm, but under the <serivces> tag, my plug-in algorithm dose not appear tho. Is it this problem causing the above error? (in the algorithms list, my plug-in algortihm is not there) If so, what else can I try to fix this problem tho? But all I have done is actually following the Micorsoft's data mining plug-in algortihms tutorial downloaded. Any guidance is very much needed and appreciated.

Thanks a lot.

With best regards,

|||

Hello, Helen

Your plugin should only appear under Algorithms, as a tag (algorithm name) with 2 sub-elements (ProgID and Enabled)

There may be multiple reasons for the plug-in not to show up in the BI Developer Studio (BIDS) list :

- BIDS was not restarted after the plug-in was installed. BIDS caches the list of algorithms on the server so it needs to be restarted after installing a new plug-in on the server

- server did not load the plug-in. There are a few possible reasons:

- the tag name does not match the actual algorithm name

- incorrect ProgID in the INI file

- plug-in dll not registered

- dependency DLL not found

- error in the plug-in metadata

If the server failed to load the plug-in, then the Event log contains error information

If this is not enough, could you please ask send the server INI file and the error log events ?

|||

Hi, Bogdan, thank you very much for your guidance.

Yes, I checked the event view finding the error message as below:

Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date: 12/06/2006
Time: 09:42:31
User: NT AUTHORITY\NETWORK SERVICE
Computer: TAH2005
Description:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{BA126AD1-2166-11D1-B1D0-00805FC1270E}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

I then looked at the component services administrative tool there, but I cant see the CLSID posed in the above error message? (BA126AD1-2166-11D1-B1D0-00805FC1270E)

Thank you very much for your further guidance.

With best regards,

|||

I have looked the DCOM Config file and have set the user with permission to that. but new erroe appreared as below:

Event Type: Warning
Event Source: MSSQLServerOLAPService
Event Category: (289)
Event ID: 0
Date: 13/06/2006
Time: 12:05:10
User: N/A
Computer: xxxx
Description:
The data mining algorithm provider (ProgID: 44503EAB-570E-4b25-A9F4-043949A7D78E) for the MyCompany_Managed_Plugin_Algorithm algorithm cannot be loaded. Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. The following system error occurred: The system cannot find the file specified. .

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

So what is the problem tho? thanks a lot for any guidance.

|||

Hi, Bogdan, would you please give me more guidance for this? Why the data mining prodiver can not be loaded then and what else should I try for that? I have tried to fixed this problem for a while still getting stuck in it, before moving forward to embedding my plug-in algorithm, I really need to fix this stage first. Thank you very much.

PS:I can not find the CLSID in Registry Editor tho. Really dont have idea what is going on.

With best regards,

Yours sincerely,

|||

Looks like the plug-in is not registered.

After building the plug-in DLL, please go, in command line, to the build folder and execute:

%windir%\system32\regsvr32 your_plugin_dll.dll

Typically, this step should be part of the build process. However, it seems either the step i s not included in the build or it failed.

After that, the CLSID for your plug-in will appear in the registry and the server will also find it and load the DLL

thanks

|||Hi, Bogdan, Thanks a lot. Have got it done! Now I can embed my plug-in Algorithms with customized features :)

Problem with picking the right algorithm

Hi

I'm using SQL Server 2005. The problem I have is as follows. I have several production lines and as with everything parts in the line tend to break. I have data from all the breaks that occurred in the last 2 years. What I want to do is predict the next break and the production line it's going to happen on. I would also like to go to a future date and check what possible breaks might occur on that date. I've run quite a few models but none of them helps me with future events. I think I might be using the wrong algorithm or I’m just not doing it right. If somebody can please suggest an algorithm and maybe help me with a web site that has a tutorial similar to my problem

Thanks
Elmo

This sounds like an interesting topic. Would you please provide us more information: like how are you current current data structured, what are you trying to predict, what algorithms have you tried, and why the results are not good enough, etc. It will also be helpful if you could provide a small sample of your data.

Thanks,

|||

Hi

Thanks for the reply. I've mailed an Excel spreadsheet with some data on it to yiminwu@.online.microsoft.com. The things I would like to predict as follows: Plant, Circuit, Start Date and End Date. I would also like to be able to go to a future date and see what possible breaks will happen on that day. The aim is to do preventative maintenance.

I’ve tried the following algorithms: Decision Trees & Neural Networks. The problem I have with these is that it predicts that if something breaks on say Circuit 1 it is in Plant B. This is quite obvious. Thing is I need a way to look at future dates. I also tried the Sequence Clustering algorithm to see if could predict the next break but it detected no sequence.

Elmo

|||

Thanks a lot for your information. You need to transform your data a little for data mining algorithms to do meaningful predictions on your problem. Instead of using the plain date, you may transform it into various ranges like this:

Date interval (from start date to end date) Date interval value for mining model

0-6 monthBrand New

6-12 month Used for a while

12-24 monthSort of Worn

>2YearsWorn

The above is just an example. You should decide the best mapping based on your domain knowledge. The structure of your training data will then look like the following:

PlantIDKey Long

CircuitIDKey Long

Device IntervalText Discrete Input

Break Boolean Discrete Predict

And your data will look like this:

PlantIDCircuitIDDevice IntervalBreak

11BrandNewNo

……

11WornYes

In the above, I assume that PlantID and CircuitID comprise the composite key of your product lines. You can then train Microsoft Decision Tree or Microsoft Neural Network to predict whether your product lines will break.

Moreover, you may also bring in more information that affects the status of your product lines, such as: humidity and temperature, etc. As a reminder, you want to identify the features that: 1) contributed the failure of your product lines; 2) were different on various breaks. This basically requires you to use your domain knowledge to identify the key factors of product line breaks.

BTW, if possible, please post your sample data directly in your post in the future.

Good luck,

|||

As Yimin says, this is not an algorithm selection issue, rather a data preparation issue. If you want to predict if a break will happen in the next day, for instance you need to create a variable that says "a break happened in this day" and variables describing the time period leading up to the break, e.g. the previous day, previous week, etc.

For example

Next Day Break (predict)
Today's Volume
7 day average volume
30 day average volume
days since last break
# of breaks in last month
# of breaks in last year
personnel info
product info

etc.

HTH

-Jamie

|||

Hi

Sorry for only replying now but I was not at work for the most of last week.

Thank you both for the replies I’m sure I’ll be able to sort it out now. If I can’t I know where to find you.

Thanks again

Elmo