MSSQLServerOLAPService Stops

MSSQLServerOLAPService Service seems to crash rather sporadically during our nightly ETL with the error of:

The description for Event ID ( 22 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured. Internal error: An unexpected exception occured..

The time of the error in the event viewer seems to correspond with the step in the ETL that processes our AS 2005 database (Analysis Services Command Task). The job step reports success, and the data is refreshed so I don't understand why it is reporting an error in Event Viewer.

The server is x86 with SQL 2005 sp2 installed.

Has anyone else run across this?

I'm getting the same issue when I run a particular MDX query. I'm also on x86 with SQL 2005 sp2 installed. Please post if you find anything out.

Thanks,

Craig

MSSQLServerOLAPService crashing frequently

System: Sql-server 2005 (x64) SP1 , Windows 2003 Server (x64)

SSAS seems to crash now and then and application log fills with :

The description for Event ID ( 22 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured..

and...

The description for Event ID ( 22 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured..

etc.

System log at just before: (event id 7034)

The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly. It has done this 2 time(s).

Please contact Customer Support to report your problem.

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

|||

The following messages have been happening on our system (Windows 2000 SP 4) while it was at SQL Server SP3 and AS SP2.

-Unexpected fatal error occurred. Attempting to restart server.

-mssqlserverolapservice service terminated unexpectedly. it has done this X times

We upgraded to SP4 on both SQL Server 2000 and AS. Same issue is still happening after the upgrade which was one of the recommendations.

What are we missing at this point?

|||

Let me make a wild guess here: You might have case of data corruption.

If you have kept your backups and you know how to restore your Analysis Services cubes here is what you can do:
Cleanup your data folder. For AS2000 that should be something like "C:\Program Files\Microsoft Analysis Services\Data". Delete everything from that folder.
You will loose all of you Analysis Services data, and you should only do that if you sure you can recover later.

If you are not sure you can get all of your data from backups, you should contact customer support and CSS guys will help you to recover from data corruption without loosing data.

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

|||

Bizarre - we're getting this same behavior.

It's crashed every morning for the last week at about the same time....3-4AM. We're also on a x64 box, wonder if that has anything to do with it.

Ever figure out what the deal was?

|||

The solution I implemented was to upgrade to the latest SP on AS (I believe it we upgraded to SQL 2000 SP4, and AS SP 4 as well) - (AS Version 8.0.2039). Once we had the latest SPs in place, we proceeded to backup the entire <MSSQL\Microsoft Analysis Services\Data folder containing all the AS databases onto a different location as a fall back position. At this point, (with an empty /data folder) we proceeded to start the AS related services (MSSQLServerOLAPService) and they were steady. I then proceeded to iteratively re-introduce the AS Databases one folder at a time from the previously backed up location (<backuplocation>\MSSQL\Microsoft Analysis Services\Data\<AS databases> until the folder that caused the services to start crashing was identified. Once this folder was identified, I deleted it from the /data folder and process the appropriate dimensions/cubes to regenerate the AS databases. Make sure that your .odb file is backed up safely as an added precaution.

MSSQLServerOLAPService crashing frequently

System: Sql-server 2005 (x64) SP1 , Windows 2003 Server (x64)

SSAS seems to crash now and then and application log fills with :

The description for Event ID ( 22 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured..

and...

The description for Event ID ( 22 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured..

etc.

System log at just before: (event id 7034)

The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly. It has done this 2 time(s).

Please contact Customer Support to report your problem.

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

|||

The following messages have been happening on our system (Windows 2000 SP 4) while it was at SQL Server SP3 and AS SP2.

-Unexpected fatal error occurred. Attempting to restart server.

-mssqlserverolapservice service terminated unexpectedly. it has done this X times

We upgraded to SP4 on both SQL Server 2000 and AS. Same issue is still happening after the upgrade which was one of the recommendations.

What are we missing at this point?

|||

Let me make a wild guess here: You might have case of data corruption.

If you have kept your backups and you know how to restore your Analysis Services cubes here is what you can do:
Cleanup your data folder. For AS2000 that should be something like "C:\Program Files\Microsoft Analysis Services\Data". Delete everything from that folder.
You will loose all of you Analysis Services data, and you should only do that if you sure you can recover later.

If you are not sure you can get all of your data from backups, you should contact customer support and CSS guys will help you to recover from data corruption without loosing data.

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

|||

Bizarre - we're getting this same behavior.

It's crashed every morning for the last week at about the same time....3-4AM. We're also on a x64 box, wonder if that has anything to do with it.

Ever figure out what the deal was?

|||

The solution I implemented was to upgrade to the latest SP on AS (I believe it we upgraded to SQL 2000 SP4, and AS SP 4 as well) - (AS Version 8.0.2039). Once we had the latest SPs in place, we proceeded to backup the entire <MSSQL\Microsoft Analysis Services\Data folder containing all the AS databases onto a different location as a fall back position. At this point, (with an empty /data folder) we proceeded to start the AS related services (MSSQLServerOLAPService) and they were steady. I then proceeded to iteratively re-introduce the AS Databases one folder at a time from the previously backed up location (<backuplocation>\MSSQL\Microsoft Analysis Services\Data\<AS databases> until the folder that caused the services to start crashing was identified. Once this folder was identified, I deleted it from the /data folder and process the appropriate dimensions/cubes to regenerate the AS databases. Make sure that your .odb file is backed up safely as an added precaution.

sql

MSSQLServerOLAPService crashing frequently

System: Sql-server 2005 (x64) SP1 , Windows 2003 Server (x64)

SSAS seems to crash now and then and application log fills with :

The description for Event ID ( 22 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured..

and...

The description for Event ID ( 22 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured..

etc.

System log at just before: (event id 7034)

The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly. It has done this 2 time(s).

Please contact Customer Support to report your problem.

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

|||

The following messages have been happening on our system (Windows 2000 SP 4) while it was at SQL Server SP3 and AS SP2.

-Unexpected fatal error occurred. Attempting to restart server.

-mssqlserverolapservice service terminated unexpectedly. it has done this X times

We upgraded to SP4 on both SQL Server 2000 and AS. Same issue is still happening after the upgrade which was one of the recommendations.

What are we missing at this point?

|||

Let me make a wild guess here: You might have case of data corruption.

If you have kept your backups and you know how to restore your Analysis Services cubes here is what you can do:
Cleanup your data folder. For AS2000 that should be something like "C:\Program Files\Microsoft Analysis Services\Data". Delete everything from that folder.
You will loose all of you Analysis Services data, and you should only do that if you sure you can recover later.

If you are not sure you can get all of your data from backups, you should contact customer support and CSS guys will help you to recover from data corruption without loosing data.

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

|||

Bizarre - we're getting this same behavior.

It's crashed every morning for the last week at about the same time....3-4AM. We're also on a x64 box, wonder if that has anything to do with it.

Ever figure out what the deal was?

|||

The solution I implemented was to upgrade to the latest SP on AS (I believe it we upgraded to SQL 2000 SP4, and AS SP 4 as well) - (AS Version 8.0.2039). Once we had the latest SPs in place, we proceeded to backup the entire <MSSQL\Microsoft Analysis Services\Data folder containing all the AS databases onto a different location as a fall back position. At this point, (with an empty /data folder) we proceeded to start the AS related services (MSSQLServerOLAPService) and they were steady. I then proceeded to iteratively re-introduce the AS Databases one folder at a time from the previously backed up location (<backuplocation>\MSSQL\Microsoft Analysis Services\Data\<AS databases> until the folder that caused the services to start crashing was identified. Once this folder was identified, I deleted it from the /data folder and process the appropriate dimensions/cubes to regenerate the AS databases. Make sure that your .odb file is backed up safely as an added precaution.

|||

Hi,

I have this exact same problem error but it happens only when the cubes are being processed. In the middle of the dimension and cube processing AS crashes, returns that unexpected fatal error message to the event log, and then restarts. I've scheduled a Job that process the cubes after we load new data to our data mart, so SQL Server Agent is process that runs the job on the cubes. This happens erratically some days, some not.

If the process fails I go to Analysis Manager and reprocess the cubes without problem. I've seen this even happen in Analysis Manager, A first attempt to process fails and crashes the server, and then a second one works. Pretty strange. I have SP4 for both SQL and AS.

If anyone know how to deal with this I'd appreciate your advise.

Thanks,

Ricardo Sada

|||

we eventually opened up a case with MS, and found a resolution.

i wrote about it here: http://jesseorosz.spaces.live.com/blog/cns!E322FD91218E57CF!295.entry

basically it's a problem with the OLAP heap, we switched to use windows low frag and it's worked OK since

|||

Thanks Jesee

I read your post and I see that you are using SQL 2005, in our case we are still working with AS 2000.

May be the cause is similar and some out of Memory problem is the issue.

MSSQLServerOLAPService crashing frequently

System: Sql-server 2005 (x64) SP1 , Windows 2003 Server (x64)

SSAS seems to crash now and then and application log fills with :

The description for Event ID ( 22 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured..

and...

The description for Event ID ( 22 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured..

etc.

System log at just before: (event id 7034)

The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly. It has done this 2 time(s).

Please contact Customer Support to report your problem.

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

|||

The following messages have been happening on our system (Windows 2000 SP 4) while it was at SQL Server SP3 and AS SP2.

-Unexpected fatal error occurred. Attempting to restart server.

-mssqlserverolapservice service terminated unexpectedly. it has done this X times

We upgraded to SP4 on both SQL Server 2000 and AS. Same issue is still happening after the upgrade which was one of the recommendations.

What are we missing at this point?

|||

Let me make a wild guess here: You might have case of data corruption.

If you have kept your backups and you know how to restore your Analysis Services cubes here is what you can do:
Cleanup your data folder. For AS2000 that should be something like "C:\Program Files\Microsoft Analysis Services\Data". Delete everything from that folder.
You will loose all of you Analysis Services data, and you should only do that if you sure you can recover later.

If you are not sure you can get all of your data from backups, you should contact customer support and CSS guys will help you to recover from data corruption without loosing data.

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

|||

Bizarre - we're getting this same behavior.

It's crashed every morning for the last week at about the same time....3-4AM. We're also on a x64 box, wonder if that has anything to do with it.

Ever figure out what the deal was?

|||

The solution I implemented was to upgrade to the latest SP on AS (I believe it we upgraded to SQL 2000 SP4, and AS SP 4 as well) - (AS Version 8.0.2039). Once we had the latest SPs in place, we proceeded to backup the entire <MSSQL\Microsoft Analysis Services\Data folder containing all the AS databases onto a different location as a fall back position. At this point, (with an empty /data folder) we proceeded to start the AS related services (MSSQLServerOLAPService) and they were steady. I then proceeded to iteratively re-introduce the AS Databases one folder at a time from the previously backed up location (<backuplocation>\MSSQL\Microsoft Analysis Services\Data\<AS databases> until the folder that caused the services to start crashing was identified. Once this folder was identified, I deleted it from the /data folder and process the appropriate dimensions/cubes to regenerate the AS databases. Make sure that your .odb file is backed up safely as an added precaution.

MSSQLServerOLAPService crashing frequently

System: Sql-server 2005 (x64) SP1 , Windows 2003 Server (x64)

SSAS seems to crash now and then and application log fills with :

The description for Event ID ( 22 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured..

and...

The description for Event ID ( 22 ) 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. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured. Internal error: An unexpected exception occured..

etc.

System log at just before: (event id 7034)

The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly. It has done this 2 time(s).

Please contact Customer Support to report your problem.

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

|||

The following messages have been happening on our system (Windows 2000 SP 4) while it was at SQL Server SP3 and AS SP2.

-Unexpected fatal error occurred. Attempting to restart server.

-mssqlserverolapservice service terminated unexpectedly. it has done this X times

We upgraded to SP4 on both SQL Server 2000 and AS. Same issue is still happening after the upgrade which was one of the recommendations.

What are we missing at this point?

|||

Let me make a wild guess here: You might have case of data corruption.

If you have kept your backups and you know how to restore your Analysis Services cubes here is what you can do:
Cleanup your data folder. For AS2000 that should be something like "C:\Program Files\Microsoft Analysis Services\Data". Delete everything from that folder.
You will loose all of you Analysis Services data, and you should only do that if you sure you can recover later.

If you are not sure you can get all of your data from backups, you should contact customer support and CSS guys will help you to recover from data corruption without loosing data.

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

|||

Bizarre - we're getting this same behavior.

It's crashed every morning for the last week at about the same time....3-4AM. We're also on a x64 box, wonder if that has anything to do with it.

Ever figure out what the deal was?

|||

The solution I implemented was to upgrade to the latest SP on AS (I believe it we upgraded to SQL 2000 SP4, and AS SP 4 as well) - (AS Version 8.0.2039). Once we had the latest SPs in place, we proceeded to backup the entire <MSSQL\Microsoft Analysis Services\Data folder containing all the AS databases onto a different location as a fall back position. At this point, (with an empty /data folder) we proceeded to start the AS related services (MSSQLServerOLAPService) and they were steady. I then proceeded to iteratively re-introduce the AS Databases one folder at a time from the previously backed up location (<backuplocation>\MSSQL\Microsoft Analysis Services\Data\<AS databases> until the folder that caused the services to start crashing was identified. Once this folder was identified, I deleted it from the /data folder and process the appropriate dimensions/cubes to regenerate the AS databases. Make sure that your .odb file is backed up safely as an added precaution.

MSSQLSERVER Service Crashs

Hi
our MSSQLSERVER Service crash after it logs into the eventlog:
4 times
17066 :
SQL Server-Assertion : Datei:<umsio.cpp>, Zeile=563
Fehler bei Assertion='m_busyCnt == 1'.
17310 :
SqlDumpExceptionHandler: Prozess 2556 erzeugte eine schwere
Ausnahmebedingung c000001d EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server beendet
diesen Prozess.
17311 :
SQL Server wird abgebrochen. Schwere Ausnahmebedingung c000001d aufgetreten.
SQL Server Version
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
5.0 (Build 2195: Service Pack 4)
Server Syteme
Windows 2000 Server Service Pack 4
2 intel xeon 2,4 Ghz AT CPUs
2 GB RAM
What will fix the problem?
Thx
Tim B.B.
TimBB
Can you translate it into english
"TimBB" <TimBB@.discussions.microsoft.com> wrote in message
news:901AAEE2-2965-4303-8CFD-B28B5E16C966@.microsoft.com...
> Hi
> our MSSQLSERVER Service crash after it logs into the eventlog:
> --
> 4 times
> 17066 :
> SQL Server-Assertion : Datei:<umsio.cpp>, Zeile=563
> Fehler bei Assertion='m_busyCnt == 1'.
> --
> 17310 :
> SqlDumpExceptionHandler: Prozess 2556 erzeugte eine schwere
> Ausnahmebedingung c000001d EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server
beendet
> diesen Prozess.
> --
> 17311 :
> SQL Server wird abgebrochen. Schwere Ausnahmebedingung c000001d
aufgetreten.
>
> SQL Server Version
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
NT
> 5.0 (Build 2195: Service Pack 4)
> Server Syteme
> Windows 2000 Server Service Pack 4
> 2 intel xeon 2,4 Ghz AT CPUs
> 2 GB RAM
> What will fix the problem?
> Thx
> Tim B.B.
>
>
|||hi
okay a will try it.
4 times
17066 :
SQL Server-Assertion : Datei:<umsio.cpp>, Line=563
Error by Assertion='m_busyCnt == 1'.[vbcol=seagreen]
SqlDumpExceptionHandler: Process 2556 produce a Exception c000001d
EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server
quit this process Prozess.[vbcol=seagreen]
SQL Server will close. Heavy exception c000001d
occured.
> NT
>
>
"Uri Dimant" wrote:

> TimBB
> Can you translate it into english
>
> "TimBB" <TimBB@.discussions.microsoft.com> wrote in message
> news:901AAEE2-2965-4303-8CFD-B28B5E16C966@.microsoft.com...
> beendet
> aufgetreten.
> NT
>
>

MSSQLSERVER Service Crashs

Hi
our MSSQLSERVER Service crash after it logs into the eventlog:
--
4 times
17066 :
SQL Server-Assertion : Datei:<umsio.cpp>, Zeile=563
Fehler bei Assertion='m_busyCnt == 1'.
--
17310 :
SqlDumpExceptionHandler: Prozess 2556 erzeugte eine schwere
Ausnahmebedingung c000001d EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server beendet
diesen Prozess.
--
17311 :
SQL Server wird abgebrochen. Schwere Ausnahmebedingung c000001d aufgetreten.
SQL Server Version
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
5.0 (Build 2195: Service Pack 4)
Server Syteme
Windows 2000 Server Service Pack 4
2 intel xeon 2,4 Ghz AT CPUs
2 GB RAM
What will fix the problem?
Thx
Tim B.B.TimBB
Can you translate it into english
"TimBB" <TimBB@.discussions.microsoft.com> wrote in message
news:901AAEE2-2965-4303-8CFD-B28B5E16C966@.microsoft.com...
> Hi
> our MSSQLSERVER Service crash after it logs into the eventlog:
> --
> 4 times
> 17066 :
> SQL Server-Assertion : Datei:<umsio.cpp>, Zeile=563
> Fehler bei Assertion='m_busyCnt == 1'.
> --
> 17310 :
> SqlDumpExceptionHandler: Prozess 2556 erzeugte eine schwere
> Ausnahmebedingung c000001d EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server
beendet
> diesen Prozess.
> --
> 17311 :
> SQL Server wird abgebrochen. Schwere Ausnahmebedingung c000001d
aufgetreten.
>
> SQL Server Version
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
NT
> 5.0 (Build 2195: Service Pack 4)
> Server Syteme
> Windows 2000 Server Service Pack 4
> 2 intel xeon 2,4 Ghz AT CPUs
> 2 GB RAM
> What will fix the problem?
> Thx
> Tim B.B.
>
>|||hi
okay a will try it.
4 times
17066 :
SQL Server-Assertion : Datei:<umsio.cpp>, Line=563
Error by Assertion='m_busyCnt == 1'.
> > --
> > 17310 :
SqlDumpExceptionHandler: Process 2556 produce a Exception c000001d
EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server
quit this process Prozess.
> > --
> > 17311 :
SQL Server will close. Heavy exception c000001d
occured.
> >
> >
> > SQL Server Version
> > Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> > Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT
> > 5.0 (Build 2195: Service Pack 4)
> >
> > Server Syteme
> > Windows 2000 Server Service Pack 4
> > 2 intel xeon 2,4 Ghz AT CPUs
> > 2 GB RAM
> >
> > What will fix the problem?
> >
> > Thx
> >
> > Tim B.B.
> >
> >
> >
>
>
"Uri Dimant" wrote:
> TimBB
> Can you translate it into english
>
> "TimBB" <TimBB@.discussions.microsoft.com> wrote in message
> news:901AAEE2-2965-4303-8CFD-B28B5E16C966@.microsoft.com...
> > Hi
> >
> > our MSSQLSERVER Service crash after it logs into the eventlog:
> > --
> > 4 times
> > 17066 :
> > SQL Server-Assertion : Datei:<umsio.cpp>, Zeile=563
> > Fehler bei Assertion='m_busyCnt == 1'.
> > --
> > 17310 :
> > SqlDumpExceptionHandler: Prozess 2556 erzeugte eine schwere
> > Ausnahmebedingung c000001d EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server
> beendet
> > diesen Prozess.
> > --
> > 17311 :
> > SQL Server wird abgebrochen. Schwere Ausnahmebedingung c000001d
> aufgetreten.
> >
> >
> > SQL Server Version
> > Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> > Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT
> > 5.0 (Build 2195: Service Pack 4)
> >
> > Server Syteme
> > Windows 2000 Server Service Pack 4
> > 2 intel xeon 2,4 Ghz AT CPUs
> > 2 GB RAM
> >
> > What will fix the problem?
> >
> > Thx
> >
> > Tim B.B.
> >
> >
> >
>
>

MSSQLSERVER Service Crashs

Hi
our MSSQLSERVER Service crash after it logs into the eventlog:
--
4 times
17066 :
SQL Server-Assertion : Datei:<umsio.cpp>, Zeile=563
Fehler bei Assertion='m_busyCnt == 1'.
--
17310 :
SqlDumpExceptionHandler: Prozess 2556 erzeugte eine schwere
Ausnahmebedingung c000001d EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server beendet
diesen Prozess.
--
17311 :
SQL Server wird abgebrochen. Schwere Ausnahmebedingung c000001d aufgetreten
.
SQL Server Version
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows N
T
5.0 (Build 2195: Service Pack 4)
Server Syteme
Windows 2000 Server Service Pack 4
2 intel xeon 2,4 Ghz AT CPUs
2 GB RAM
What will fix the problem?
Thx
Tim B.B.TimBB
Can you translate it into english
"TimBB" <TimBB@.discussions.microsoft.com> wrote in message
news:901AAEE2-2965-4303-8CFD-B28B5E16C966@.microsoft.com...
> Hi
> our MSSQLSERVER Service crash after it logs into the eventlog:
> --
> 4 times
> 17066 :
> SQL Server-Assertion : Datei:<umsio.cpp>, Zeile=563
> Fehler bei Assertion='m_busyCnt == 1'.
> --
> 17310 :
> SqlDumpExceptionHandler: Prozess 2556 erzeugte eine schwere
> Ausnahmebedingung c000001d EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server
beendet
> diesen Prozess.
> --
> 17311 :
> SQL Server wird abgebrochen. Schwere Ausnahmebedingung c000001d
aufgetreten.
>
> SQL Server Version
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
NT
> 5.0 (Build 2195: Service Pack 4)
> Server Syteme
> Windows 2000 Server Service Pack 4
> 2 intel xeon 2,4 Ghz AT CPUs
> 2 GB RAM
> What will fix the problem?
> Thx
> Tim B.B.
>
>|||hi
okay a will try it.
4 times
17066 :
SQL Server-Assertion : Datei:<umsio.cpp>, Line=563
Error by Assertion='m_busyCnt == 1'.
SqlDumpExceptionHandler: Process 2556 produce a Exception c000001d
EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server
quit this process Prozess.[vbcol=seagreen]
SQL Server will close. Heavy exception c000001d
occured.[vbcol=seagreen]
> NT
>
>
"Uri Dimant" wrote:

> TimBB
> Can you translate it into english
>
> "TimBB" <TimBB@.discussions.microsoft.com> wrote in message
> news:901AAEE2-2965-4303-8CFD-B28B5E16C966@.microsoft.com...
> beendet
> aufgetreten.
> NT
>
>