Question about Analysis services configuration file

Hi, all here,

Please help: I am currently embedding my own plug-in data mining algorithms added to SQL Server 2005 data miming algorithms family. I can see my own plug-in algorithm apprearing in the analysis services configuration file. After the change of the configuaration file, I have actually restart the analysis services server. But why I can not see my plug-in algorithms available in the algorithms list when I open business intelligence development studio? I have also tried to change the configuration file for other algorithms already available in SQL Server 2005 analysis services for data mining, save the configuration file, then restarted the analysis services server,but those algorithms I have deleted from configuration file are still there when I view them from business intelligence development studio? It seems that my changes of configuration file dose not affect the analysis services server at all? Please anyone here gives me any idea for that? Thanks a lot.

With best regards,

Yours sincerely,

Hello,

Deleting algorithms in the config file of SQL Server 2005 Analysis Services will only work for plug-in algorithms.

Could you please check the following on the server side?

1. In your config file you have the Algorigthm added and a flag <Enabled>1</Enabled> set?

2. As mentioned by you, you would need to restart Analysis Services.

On the client side could you please restart BI Dev Studio and see if you can see your algorithm?

After restarting BI Dev Studio if you are unable to see your plug-in could you please check the following

1. CLSID/ProgID of the data mining plug in in the config file.

2. Ensure plug-in is registered

3. Any dependency DDLs are all found

4. Check Event log to see if Analysis Services failed to load the plug-in

Regards

Siva

This posting is provided "AS IS" with no warranties, and confers no rights.

.

|||

Hi, Siva, thanks a lot for your guidance.

Yes, I have checked the flag <enable>ture</enable>, and I have exit the business intelligence development studio, but the list was the same as before. my plug-in algortihm wasnt there.

all the .dll files are available in the glable assembly cache.

Yes, I got one problem, the event viewer showed the error for the plug-in Algorithm 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: xxxx
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 have looked at the component services administrative tool there(DCOM Config), but I cant see the CLSID posted in the error message?

Thanks a lot for any further advice for that.

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 why the data mining algortithm provider can not be loaded then?

What is the problem tho? thanks a lot for any guidance. Really need more help. I have tried to fix this problem for a while. Before going forward to embed my plug-in algorithm, I really need to fix this problem first. Would please anyone here give me more ideas about that? Thanks a lot.

With best regards,

|||

Thanks a lot for all of you here giving me advice.

Have got it done! :)