November 13, 2009 at 3:05 am
I am getting the following error msgs every 10 seconds :
1)
The description for Event ID (2003) in Source (
MSSQLServerOLAPService) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: The event log file is corrupt..
2)
The Open Procedure for source "MSSQLServerOLAPService" in DLL "C:\Program Files\Microsoft Analysis Services\Bin\msmdctr80.dll" failed.
Performance data for this service will not be available. Status code returned is data DWORD 0.
These errors are on SQL SERVER 2000 with SP4.
Any help in this regards .....
November 13, 2009 at 3:00 pm
Do you have any analysis services that are failing? OLAP is for analytical processing, so it would be needed it you were running anything like a data warehouse. If you look at the properties of the service on Computer Manager, is it set to restart the service after 1st, 2nd and subsequent failures? That may help explain why you are getting an error message every 10 seconds.
Joie Andrew
"Since 1982"
November 17, 2009 at 4:25 am
Yes, it has sql agent job which stops and starts the service. But this job is failing these days.
The service is set to automatic start up. 1st step of the job is to stop the service, 2nd step is to wait for 30 seconds, 3rd step is to start the service again. It is using netstart and netstop commands.
so, this job is failing in its 3rd step daily.
what is the work around for this, any resolution?
November 17, 2009 at 1:27 pm
I am not that experienced with Analysis Services, especially on SQL 2000, but it seems strange that a SQL Agent would have a job that just starts the service. Does the service stop to allow another job to run at that time?
As for your error, it sounds like a file is missing that is needed for the service. Does the .dll file that the error you posted was talking about exist in the location listed in the error? Does the account that is running the job have permissions to that directory/file?
Joie Andrew
"Since 1982"
December 19, 2009 at 8:55 am
I believe that the job issue has been sorted out now!.. for this error check this link
http://www.eventid.net/display.asp?eventid=1008&eventno=70&source=Perflib&phase=1
December 20, 2009 at 10:49 pm
The thing is should I ignore this ?
December 20, 2009 at 10:50 pm
No the problem still exists..
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply