Problem with scheduling an Analysis Services task

Hi All,

I have a problem with scheduling an Analysis Services task.

When I execute the DTS package from EM, every thing works fine.

When I schedule the package from SQL Agent, I get the following error when the job executes:

Error = -2147024770 (8007007E)
Error string: The specified module could not be found.
Error source: Microsoft Data Transformation Services (DTS) Package

I am running SQL 2K SP3a with Analysis Services 2K SP3a on WIN Server 2003 Std Edition

Any ideas or suggestions?Looks like your client has modules installed that the SQL Server does not. When you run the package from SQL EM, it uses your local machine's configuration as the context. When you run from SQL Agent, it uses the SQL Server's context.

Try searching here (http://support.microsoft.com) using "The specified module could not be found" -2147024770 (8007007E)|||Hi MaxA,

Thanks for your response. When I execute the package from EM on the server itself it works fine.

Will check out the ms site now... I thought Google would pick up everything on it?

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 panda antivirus and olap cubes

I have the next problem:
i have MS sql server 2005 installed in a server.
We have some olap cubes in the server deployed with analysis services 2005.
When we try to connect to the analysis server from a client pc using pivot tables we obtain this error:
"Errors in network layers. Error code=0XC10D0009, External code=0x00000000"
The client pc has panda antivirus (corporate) with true prevent
When i unisnstall it, we can connect to the analysis server and to the cube normally and when we install the antivirus again (without true prevent and with the minimun options) the problem starts again and we can't conect to the analysis server.
Anybody had a similar problem?
Anybody knows a solution for it?
Thanks
Jose
coormx@.yahoo.com.mx

Jose,

In this situaion, the fast way is to contact the antivirus vendor to solve the issue.

However, if you can post your *connection string* and *exact error message*, somebody in this forum might help you to pinpoint your issue.

|||

Moving to the SQL Server Analysis Services Forum.

|||panda has fixed the problem. Tank you panda

problem with panda antivirus and olap cubes

I have the next problem:
i have MS sql server 2005 installed in a server.
We have some olap cubes in the server deployed with analysis services 2005.
When we try to connect to the analysis server from a client pc using pivot tables we obtain this error:
"Errors in network layers. Error code=0XC10D0009, External code=0x00000000"
The client pc has panda antivirus (corporate) with true prevent
When i unisnstall it, we can connect to the analysis server and to the cube normally and when we install the antivirus again (without true prevent and with the minimun options) the problem starts again and we can't conect to the analysis server.
Anybody had a similar problem?
Anybody knows a solution for it?
Thanks
Jose
coormx@.yahoo.com.mx

Jose,

In this situaion, the fast way is to contact the antivirus vendor to solve the issue.

However, if you can post your *connection string* and *exact error message*, somebody in this forum might help you to pinpoint your issue.

|||

Moving to the SQL Server Analysis Services Forum.

|||panda has fixed the problem. Tank you panda