Help for 'EXCEPTION_ACCESS_VIOLATION'

Hi,
I have a linked server on a win2000 server SQL Server which is pointing to
Analyis Services server on another machine. We are using OPENQUERY to run
drillthroughs on the OLAP server from a stored procedure in the sql server.
At one time when several users were doing multiple drillthrough using the
linked server, each returning large amounts of data, we got an exception and
the sql server crashed. We badly need help for this as it happened in
production.
The dump that I got from the dba is pasted below:
Computer type is AT/AT COMPATIBLE.
Bios Version is IBM BIOS Ver 9.0
Current time is 10:45:47 11/07/03.
8 Intel x86 level 6, 899 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 3.
Memory
MemoryLoad = 99%
Total Physical = 7935 MB
Available Physical = 35 MB
Total Page File = 9841 MB
Available Page File = 1876 MB
Total Virtual = 3071 MB
Available Virtual = 6 MB
***Symbol load failed - Proceed to dump without any symbols
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0002.txt
*
****************************************************************************
*
**
*
* BEGIN STACK DUMP:
* 11/07/03 10:45:47 spid 101
*
* Exception Address = 12246557
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 000050AE
* s p B I M C o u 12 00 73 00 70 00 42 00 49 00 4d 00 43 00 6f 00 75 00
* n t O f C l a i m 6e 00 74 00 4f 00 66 00 43 00 6c 00 61 00 69 00 6d 00
* s Ð 4 S7 73 00 00 00 00 00 a7 0f 00 09 04 d0 00 34 07 00 53
37
* 0858S Ð Ð 4b D 30 38 35 38 53 00 00 a7 d0 07 09 04 d0 00 34 62 00
44
* RILLTHROUGH MAXROW 52 49 4c 4c 54 48 52 4f 55 47 48 20 4d 41 58 52 4f 57
* S 1000 Select From 53 20 31 30 30 30 20 53 65 6c 65 63 74 20 46 72 6f 6d
* [Procedure] Where 20 5b 50 72 6f 63 65 64 75 72 65 5d 20 57 68 65 72 65
* ([Provider Name]. 20 28 5b 50 72 6f 76 69 64 65 72 20 4e 61 6d 65 5d 2e
* [Provider Name].&[ 5b 50 72 6f 76 69 64 65 72 20 4e 61 6d 65 5d 2e 26 5b
* 27454]) ? Ð 4 32 37 34 35 34 5d 29 00 00 a7 80 00 09 04 d0 00 34
09
* Procedure Ð 00 50 72 6f 63 65 64 75 72 65 00 00 a7 14 00 09
04 d0
* 4 DrillThru 00 34 09 00 44 72 69 6c 6c 54 68 72 75
*
===================================================================== BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server 8.00.760
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Bios Version is IBM BIOS Ver 9.0
Current time is 10:45:47 11/07/03.
8 Intel x86 level 6, 899 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 3.
Memory
MemoryLoad = 99%
Total Physical = 7935 MB
Available Physical = 35 MB
Total Page File = 9841 MB
Available Page File = 1876 MB
Total Virtual = 3071 MB
Available Virtual = 6 MB
***Symbol load failed - Proceed to dump without any symbols
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0002.txt
*
****************************************************************************
*
**
*
* BEGIN STACK DUMP:
* 11/07/03 10:45:47 spid 101
*
* Exception Address = 12246557
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 000050AE
* s p B I M C o u 12 00 73 00 70 00 42 00 49 00 4d 00 43 00 6f 00 75 00
* n t O f C l a i m 6e 00 74 00 4f 00 66 00 43 00 6c 00 61 00 69 00 6d 00
* s Ð 4 S7 73 00 00 00 00 00 a7 0f 00 09 04 d0 00 34 07 00 53
37
* 0858S Ð Ð 4b D 30 38 35 38 53 00 00 a7 d0 07 09 04 d0 00 34 62 00
44
* RILLTHROUGH MAXROW 52 49 4c 4c 54 48 52 4f 55 47 48 20 4d 41 58 52 4f 57
* S 1000 Select From 53 20 31 30 30 30 20 53 65 6c 65 63 74 20 46 72 6f 6d
* [Procedure] Where 20 5b 50 72 6f 63 65 64 75 72 65 5d 20 57 68 65 72 65
* ([Provider Name]. 20 28 5b 50 72 6f 76 69 64 65 72 20 4e 61 6d 65 5d 2e
* [Provider Name].&[ 5b 50 72 6f 76 69 64 65 72 20 4e 61 6d 65 5d 2e 26 5b
* 27454]) ? Ð 4 32 37 34 35 34 5d 29 00 00 a7 80 00 09 04 d0 00 34
09
* Procedure Ð 00 50 72 6f 63 65 64 75 72 65 00 00 a7 14 00 09
04 d0
* 4 DrillThru 00 34 09 00 44 72 69 6c 6c 54 68 72 75
*
*
* MODULE BASE END SIZE
*
* Edi: 12286A45: 2D6A1075 06E8006A 5E000003 000CC25D 6AEC8B55
0875F
F01
* Esi: 0C1CCF2C: 121A9488 00000001 133EBC20 0D1A6AD8 189D3EF8
00000
001
* Eax: 000050AA:
* Ebx: 000050AA:
* Ecx: 0000003B:
* Edx: 00107C2C: 00103EC8 FFFFFFFF 00000000 00000000 00000000
00000
FA0
* Eip: 12246557: 0443B70F 7508453B 0C458B0F 75164339 E045C707
00000
001
* Ebp: 0C1CCF0C: 0C1CCF88 12246D85 0000015F 00008D3E 12286A45
133EB
C20
* SegCs: 0000001B:
* EFlags: 00010206: 004E0049 0054004E 0073005C 00730079 00650074
00330
06D
* Esp: 0C1CCC94: 189D3EF8 00000001 00000001 0000FFFF 189D0000
00001
378
* SegSs: 00000023:
*
****************************************************************************
*
Thanks for your help,
JGPYour problem is significantly larger than what newsgroup help can usually
offer. I strongly suggest opening a case with Microsoft Product Support
Services. If you don't have an agreement with them, I believe it is $245
per incident. They have the tools to analyze your crash and make
recommendations on how to avoid such a condition
in the future.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Chumma Dede" <deja.removethis@.chothu.mailshell.com> wrote in message
news:O4%239ewGsDHA.1744@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a linked server on a win2000 server SQL Server which is pointing to
> Analyis Services server on another machine. We are using OPENQUERY to run
> drillthroughs on the OLAP server from a stored procedure in the sql
server.
> At one time when several users were doing multiple drillthrough using the
> linked server, each returning large amounts of data, we got an exception
and
> the sql server crashed. We badly need help for this as it happened in
> production.
>
> The dump that I got from the dba is pasted below:
> Computer type is AT/AT COMPATIBLE.
> Bios Version is IBM BIOS Ver 9.0
> Current time is 10:45:47 11/07/03.
> 8 Intel x86 level 6, 899 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 3.
>
> Memory
> MemoryLoad = 99%
> Total Physical = 7935 MB
> Available Physical = 35 MB
> Total Page File = 9841 MB
> Available Page File = 1876 MB
> Total Virtual = 3071 MB
> Available Virtual = 6 MB
> ***Symbol load failed - Proceed to dump without any symbols
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0002.txt
> *
>
****************************************************************************
> *
> **
> *
> * BEGIN STACK DUMP:
> * 11/07/03 10:45:47 spid 101
> *
> * Exception Address = 12246557
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 000050AE
> * s p B I M C o u 12 00 73 00 70 00 42 00 49 00 4d 00 43 00 6f 00 75
00
> * n t O f C l a i m 6e 00 74 00 4f 00 66 00 43 00 6c 00 61 00 69 00 6d
00
> * s Ð 4 S7 73 00 00 00 00 00 a7 0f 00 09 04 d0 00 34 07 00
53
> 37
> * 0858S Ð Ð 4b D 30 38 35 38 53 00 00 a7 d0 07 09 04 d0 00 34 62 00
> 44
> * RILLTHROUGH MAXROW 52 49 4c 4c 54 48 52 4f 55 47 48 20 4d 41 58 52 4f
57
> * S 1000 Select From 53 20 31 30 30 30 20 53 65 6c 65 63 74 20 46 72 6f
6d
> * [Procedure] Where 20 5b 50 72 6f 63 65 64 75 72 65 5d 20 57 68 65 72
65
> * ([Provider Name]. 20 28 5b 50 72 6f 76 69 64 65 72 20 4e 61 6d 65 5d
2e
> * [Provider Name].&[ 5b 50 72 6f 76 69 64 65 72 20 4e 61 6d 65 5d 2e 26
5b
> * 27454]) ? Ð 4 32 37 34 35 34 5d 29 00 00 a7 80 00 09 04 d0 00
34
> 09
> * Procedure Ð 00 50 72 6f 63 65 64 75 72 65 00 00 a7 14 00 09
> 04 d0
> * 4 DrillThru 00 34 09 00 44 72 69 6c 6c 54 68 72 75
> *
> =====================================================================> BugCheck Dump
> =====================================================================> This file is generated by Microsoft SQL Server 8.00.760
> upon detection of fatal unexpected error. Please return this file,
> the query or program that produced the bugcheck, the database and
> the error log, and any other pertinent information with a Service Request.
> Computer type is AT/AT COMPATIBLE.
> Bios Version is IBM BIOS Ver 9.0
> Current time is 10:45:47 11/07/03.
> 8 Intel x86 level 6, 899 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 3.
>
> Memory
> MemoryLoad = 99%
> Total Physical = 7935 MB
> Available Physical = 35 MB
> Total Page File = 9841 MB
> Available Page File = 1876 MB
> Total Virtual = 3071 MB
> Available Virtual = 6 MB
> ***Symbol load failed - Proceed to dump without any symbols
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0002.txt
> *
>
****************************************************************************
> *
> **
> *
> * BEGIN STACK DUMP:
> * 11/07/03 10:45:47 spid 101
> *
> * Exception Address = 12246557
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 000050AE
> * s p B I M C o u 12 00 73 00 70 00 42 00 49 00 4d 00 43 00 6f 00 75
00
> * n t O f C l a i m 6e 00 74 00 4f 00 66 00 43 00 6c 00 61 00 69 00 6d
00
> * s Ð 4 S7 73 00 00 00 00 00 a7 0f 00 09 04 d0 00 34 07 00
53
> 37
> * 0858S Ð Ð 4b D 30 38 35 38 53 00 00 a7 d0 07 09 04 d0 00 34 62 00
> 44
> * RILLTHROUGH MAXROW 52 49 4c 4c 54 48 52 4f 55 47 48 20 4d 41 58 52 4f
57
> * S 1000 Select From 53 20 31 30 30 30 20 53 65 6c 65 63 74 20 46 72 6f
6d
> * [Procedure] Where 20 5b 50 72 6f 63 65 64 75 72 65 5d 20 57 68 65 72
65
> * ([Provider Name]. 20 28 5b 50 72 6f 76 69 64 65 72 20 4e 61 6d 65 5d
2e
> * [Provider Name].&[ 5b 50 72 6f 76 69 64 65 72 20 4e 61 6d 65 5d 2e 26
5b
> * 27454]) ? Ð 4 32 37 34 35 34 5d 29 00 00 a7 80 00 09 04 d0 00
34
> 09
> * Procedure Ð 00 50 72 6f 63 65 64 75 72 65 00 00 a7 14 00 09
> 04 d0
> * 4 DrillThru 00 34 09 00 44 72 69 6c 6c 54 68 72 75
> *
> *
> * MODULE BASE END SIZE
> *
> * Edi: 12286A45: 2D6A1075 06E8006A 5E000003 000CC25D 6AEC8B55
> 0875F
> F01
> * Esi: 0C1CCF2C: 121A9488 00000001 133EBC20 0D1A6AD8 189D3EF8
> 00000
> 001
> * Eax: 000050AA:
> * Ebx: 000050AA:
> * Ecx: 0000003B:
> * Edx: 00107C2C: 00103EC8 FFFFFFFF 00000000 00000000 00000000
> 00000
> FA0
> * Eip: 12246557: 0443B70F 7508453B 0C458B0F 75164339 E045C707
> 00000
> 001
> * Ebp: 0C1CCF0C: 0C1CCF88 12246D85 0000015F 00008D3E 12286A45
> 133EB
> C20
> * SegCs: 0000001B:
> * EFlags: 00010206: 004E0049 0054004E 0073005C 00730079 00650074
> 00330
> 06D
> * Esp: 0C1CCC94: 189D3EF8 00000001 00000001 0000FFFF 189D0000
> 00001
> 378
> * SegSs: 00000023:
> *
>
****************************************************************************
> *
>
>
> Thanks for your help,
> JGP
>sql