Error during query execution

Hi,
Does anyone know how to solve the following error during
query execution?
Using 'dbghelp.dll' version '4.0.5'
*Stack Dump being sent to e:\sql_data\Microsoft SQL
Server\MSSQL$DEVA_AP04_SQL\log\SQL00048.dmp
*
****************************************
*******************
********************
*
* BEGIN STACK DUMP:
* 03/11/04 16:40:34 spid 57
*
* Exception Address = 00418209 (FastDBCSToUnicode +
000000B6 Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000015
* Input Buffer 2824 bytes -
* SELECT event_time as [Alert Time],
combo_orders.firm_name AS [Firm], dbo
* .GetTradingSymbol(underlying_id) AS [Underlying],
combo_orders.order_pri
* ce AS [Price], combo_orders.original_quantity AS
[Original Quantity], tr
* aded_quantity AS [Traded Quantity],
combo_orders.current_quantity AS [Cu
* rrrent Quantity], order_begin_time as [Time of Entry],
dbo.GetOrderStatu
* sText(combo_orders.current_order_status) AS [Current
Status], dbo.GetCom
* bexAlertText(reason_code) as [Alert Type],
dbo.GetCombexAlertAcknowledge
* dText(acknowledged) as [Acknowledged], login_id as [ISE
Analyst], combex
* _alerts.logb_order_number as [LogB Order Number],
item_id as [Item ID],
* combex_alert_id as [Combex Alert ID] FROM combex_alerts
WITH (NOLOCK), c
* ombo_orders WITH (NOLOCK) WHERE
combex_alerts.logb_order_number = combo_
* orders.logb_order_number AND reason_code IN
(13,7,2,3,9,11,12,10,8,4,6,1
* ,14,5,15,22,20,18,21,19,16,17) AND display_on_off = 1
AND combex_alerts.
* market_date ='3/11/2004 12:00:00 AM' AND
combo_orders.logb_order_number
* <> 999 AND (combo_orders.sequence_number = (SELECT MAX
(sequence_number)
* FROM combo_orders co2 WITH (NOLOCK) WHERE
co2.logb_order_number = combo
* _orders.logb_order_number AND co2.logb_order_number <>
999 AND co2.mar
* ket_date = combo_orders.market_date AND
co2.market_date = '3/11/2004 12
* :00:00 AM' AND co2.underlying_id =
combo_orders.underlying_id)) ORDER B
* Y [Acknowledged], [Combex Alert ID] DESC
.
.
.
Error: 0, Severity: 19, State: 0
language_exec: Process 57 generated an access violation.
SQL Server is terminating this process..
Regards,
JennyJenny,
Access violations are more often than not SQL Server bugs. The first
thing to do is make sure you are up-to-date on service packs. What is
the result you get when you run select @.@.version? The one solution I
can find in newsgroups to an access violation referring to
FastDBCSToUnicode was solved by the installation of SQL Server 2000
service pack 3.
SK
Jenny wrote:

>Hi,
>Does anyone know how to solve the following error during
>query execution?
>Using 'dbghelp.dll' version '4.0.5'
>*Stack Dump being sent to e:\sql_data\Microsoft SQL
>Server\MSSQL$DEVA_AP04_SQL\log\SQL00048.dmp
>*
> ****************************************
*******************
>********************
>*
>* BEGIN STACK DUMP:
>* 03/11/04 16:40:34 spid 57
>*
>* Exception Address = 00418209 (FastDBCSToUnicode +
>000000B6 Line 0+00000000)
>* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
>* Access Violation occurred reading address 00000015
>* Input Buffer 2824 bytes -
>* SELECT event_time as [Alert Time],
>combo_orders.firm_name AS [Firm], dbo
>* .GetTradingSymbol(underlying_id) AS [Underlying],
>combo_orders.order_pri
>* ce AS [Price], combo_orders.original_quantity AS
>[Original Quantity], tr
>* aded_quantity AS [Traded Quantity],
>combo_orders.current_quantity AS [Cu
>* rrrent Quantity], order_begin_time as [Time of Entry],
>dbo.GetOrderStatu
>* sText(combo_orders.current_order_status) AS [Current
>Status], dbo.GetCom
>* bexAlertText(reason_code) as [Alert Type],
>dbo.GetCombexAlertAcknowledge
>* dText(acknowledged) as [Acknowledged], login_id as [ISE
>Analyst], combex
>* _alerts.logb_order_number as [LogB Order Number],
>item_id as [Item ID],
>* combex_alert_id as [Combex Alert ID] FROM combex_alerts
>WITH (NOLOCK), c
>* ombo_orders WITH (NOLOCK) WHERE
>combex_alerts.logb_order_number = combo_
>* orders.logb_order_number AND reason_code IN
>(13,7,2,3,9,11,12,10,8,4,6,1
>* ,14,5,15,22,20,18,21,19,16,17) AND display_on_off = 1
>AND combex_alerts.
>* market_date ='3/11/2004 12:00:00 AM' AND
>combo_orders.logb_order_number
>* <> 999 AND (combo_orders.sequence_number = (SELECT MAX
>(sequence_number)
>* FROM combo_orders co2 WITH (NOLOCK) WHERE
>co2.logb_order_number = combo
>* _orders.logb_order_number AND co2.logb_order_number <>
>999 AND co2.mar
>* ket_date = combo_orders.market_date AND
>co2.market_date = '3/11/2004 12
>* :00:00 AM' AND co2.underlying_id =
>combo_orders.underlying_id)) ORDER B
>* Y [Acknowledged], [Combex Alert ID] DESC
>.
>.
>.
>Error: 0, Severity: 19, State: 0
>language_exec: Process 57 generated an access violation.
>SQL Server is terminating this process..
>
>Regards,
>Jenny
>
>

error dump file

Hi,
Our production server had frozen suddenly (it was working=20
for years without any issues), and I noticed sql server=20
error dump file afterwards(see below). I think that=20
process SPID 60 caused the problem, but I'm not sure how=20
to find out what was SPID before the "accident". Is=20
it "SELECT" statement which can be seen in the first part=20
of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal=20
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server=20
is terminating this process..
*=20
************************************************** ********
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address =3D 004766C1 (CMemManager::ReleaseOS=20
+ 0000003A Line 0+00000000)
* Exception Code =3D c0000005=20
EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00=20
65 00 63 00 75 00
* t e s q l =E7 74 00 65 00 73 00 71 00 6c 00 02=20
00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00=20
45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00=20
72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
Baki
Generally yes. For AV's you should really contact PSS to help you diagnose
the issue.
http://support.microsoft.com/default...s;Prodoffer41a
You'll get your money back if it's a bug (and AV's generally are)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Baki" <anonymous@.discussions.microsoft.com> wrote in message
news:0aaa01c490f1$4402d190$a401280a@.phx.gbl...
Hi,
Our production server had frozen suddenly (it was working
for years without any issues), and I noticed sql server
error dump file afterwards(see below). I think that
process SPID 60 caused the problem, but I'm not sure how
to find out what was SPID before the "accident". Is
it "SELECT" statement which can be seen in the first part
of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process..
*
************************************************** ********
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address = 004766C1 (CMemManager::ReleaseOS
+ 0000003A Line 0+00000000)
* Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00
65 00 63 00 75 00
* t e s q l 74 00 65 00 73 00 71 00 6c 00 02
00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00
45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00
72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
Baki

error dump file

Hi,
Our production server had frozen suddenly (it was working for years without any issues), and I noticed sql server error dump file afterwards(see below). I think that process SPID 60 caused the problem, but I'm not sure how to find out what was SPID before the "accident". Is it "SELECT" statement which can be seen in the first part of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* **********************************************************
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address =3D 004766C1 (CMemManager::ReleaseOS + 0000003A Line 0+00000000)
* Exception Code =3D c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00 65 00 63 00 75 00
* t e s q l =E7 74 00 65 00 73 00 71 00 6c 00 02 00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00 45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00 72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
BakiGenerally yes. For AV's you should really contact PSS to help you diagnose
the issue.
http://support.microsoft.com/default.aspx?scid=fh;en-us;Prodoffer41a
You'll get your money back if it's a bug (and AV's generally are)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Baki" <anonymous@.discussions.microsoft.com> wrote in message
news:0aaa01c490f1$4402d190$a401280a@.phx.gbl...
Hi,
Our production server had frozen suddenly (it was working
for years without any issues), and I noticed sql server
error dump file afterwards(see below). I think that
process SPID 60 caused the problem, but I'm not sure how
to find out what was SPID before the "accident". Is
it "SELECT" statement which can be seen in the first part
of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process..
*
**********************************************************
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address = 004766C1 (CMemManager::ReleaseOS
+ 0000003A Line 0+00000000)
* Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00
65 00 63 00 75 00
* t e s q l ç 74 00 65 00 73 00 71 00 6c 00 02
00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00
45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00
72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
Baki

error dump file

Hi,
Our production server had frozen suddenly (it was working=20
for years without any issues), and I noticed sql server=20
error dump file afterwards(see below). I think that=20
process SPID 60 caused the problem, but I'm not sure how=20
to find out what was SPID before the "accident". Is=20
it "SELECT" statement which can be seen in the first part=20
of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal=20
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server=20
is terminating this process..
*=20
****************************************
******************
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address =3D 004766C1 (CMemManager::ReleaseOS=20
+ 0000003A Line 0+00000000)
* Exception Code =3D c0000005=20
EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00=20
65 00 63 00 75 00
* t e s q l =E7 74 00 65 00 73 00 71 00 6c 00 02=20
00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00=20
45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00=20
72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
BakiGenerally yes. For AV's you should really contact PSS to help you diagnose
the issue.
http://support.microsoft.com/defaul...us;Prodoffer41a
You'll get your money back if it's a bug (and AV's generally are)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Baki" <anonymous@.discussions.microsoft.com> wrote in message
news:0aaa01c490f1$4402d190$a401280a@.phx.gbl...
Hi,
Our production server had frozen suddenly (it was working
for years without any issues), and I noticed sql server
error dump file afterwards(see below). I think that
process SPID 60 caused the problem, but I'm not sure how
to find out what was SPID before the "accident". Is
it "SELECT" statement which can be seen in the first part
of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process..
*
****************************************
******************
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address = 004766C1 (CMemManager::ReleaseOS
+ 0000003A Line 0+00000000)
* Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00
65 00 63 00 75 00
* t e s q l 74 00 65 00 73 00 71 00 6c 00 02
00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00
45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00
72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
Baki

Error de Aplication

SQL dump exception Handler: Process 58 Generated fatal exception C0000005. Exception acces violation. SQL server is terminating this process.
I don=B4t undesrstand please help me !!!
please send email anaula@.maint.com.ecThese types of errors are bugs in SQL Server. Search Knowledgebase for info and make sure you are
current on service packs. If that doesn't help, open a case with Microsoft Support.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Ana Naula" <anaula@.maint.com.ec> wrote in message news:0c5c01c391ea$f8fb4f20$a101280a@.phx.gbl...
SQL dump exception Handler: Process 58 Generated fatal
exception C0000005. Exception acces violation. SQL server
is terminating this process.
I don´t undesrstand please help me !!!
please send email anaula@.maint.com.ec