Oracle Linked Server Issues

  • I am in charge of making sure all the server have same version /configuration.

    I have installed SQL2K with SP4. The server has oracle client installed(9.2). I am able to use the DTS to connect to oracle server(after updating tnsnames.ora file). Then I create linked server to connect to oracle. When I run any linked server query my SQL crashes. I see the following error "spid 0 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at 0x06062217". I had migrated 3 SQL Servers with the same configuration week before and did not have any issues but when I installed it on a server last week it crashed.

    Its a good thing that I am trying the migration on Non production servers. I would like to fix this issues before i start working on production server. I have the SQL dump. Can u please help me?.

    Thanks for your time.

    Sreejith

  • can you see if there is stack dump for e.g. C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump0030.txt

    If there is then can you please post that up, as that might give some more info. thanks

  • Hope this helps:

    ----------------

    2007-03-30 16:39:21.26 server    Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)

     May  3 2005 23:18:38

     Copyright (c) 1988-2003 Microsoft Corporation

     Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

    2007-03-30 16:39:21.28 server    Copyright (C) 1988-2002 Microsoft Corporation.

    2007-03-30 16:39:21.28 server    All rights reserved.

    2007-03-30 16:39:21.28 server    Server Process ID is 1944.

    2007-03-30 16:39:21.28 server    Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

    2007-03-30 16:39:21.29 server    SQL Server is starting at priority class 'normal'(4 CPUs detected).

    2007-03-30 16:39:21.68 server    SQL Server configured for thread mode processing.

    2007-03-30 16:39:21.73 server    Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.

    2007-03-30 16:39:21.92 server    Attempting to initialize Distributed Transaction Coordinator.

    2007-03-30 16:39:24.12 spid3     Starting up database 'master'.

    2007-03-30 16:39:24.35 spid5     Starting up database 'model'.

    2007-03-30 16:39:24.39 spid3     Server name is 'TLTEMP03'.

    2007-03-30 16:39:24.39 spid8     Starting up database 'msdb'.

    2007-03-30 16:39:24.39 spid9     Starting up database 'pubs'.

    2007-03-30 16:39:24.39 spid10    Starting up database 'Northwind'.

    2007-03-30 16:39:24.62 server    Using 'SSNETLIB.DLL' version '8.0.2039'.

    2007-03-30 16:39:24.71 spid5     Clearing tempdb database.

    2007-03-30 16:39:24.79 server    SQL server listening on 10.6.5.7: 1433.

    2007-03-30 16:39:24.81 server    SQL server listening on 127.0.0.1: 1433.

    2007-03-30 16:39:25.15 server    SQL server listening on TCP, Shared Memory, Named Pipes.

    2007-03-30 16:39:25.15 server    SQL Server is ready for client connections

    2007-03-30 16:39:25.26 spid5     Starting up database 'tempdb'.

    2007-03-30 16:39:25.37 spid3     Recovery complete.

    2007-03-30 16:39:25.37 spid3     SQL global counter collection task is created.

    2007-03-30 16:41:56.37 spid51    Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'sp_MSgetversion'.

    2007-03-30 16:43:04.52 server    Using 'dbghelp.dll' version '4.0.5'

    *Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump0001.txt

    2007-03-30 16:43:04.55 server    SqlDumpExceptionHandler: Process 2260 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

    * *******************************************************************************

    *

    * BEGIN STACK DUMP:

    *   03/30/07 16:43:04 spid 0

    *

    *   Exception Address = 06062217 (lmsaicmt + 00000317 Line 0+00000000)

    *   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION

    *   Access Violation occurred reading address 00000020

    *

    *  MODULE                          BASE      END       SIZE

    * sqlservr                       00400000  00CBAFFF  008bb000

    * ntdll                          7C800000  7C8BFFFF  000c0000

    * kernel32                       77E40000  77F41FFF  00102000

    * ADVAPI32                       77F50000  77FEBFFF  0009c000

    * RPCRT4                         77C50000  77CEEFFF  0009f000

    * MSVCP71                        7C3A0000  7C41AFFF  0007b000

    * MSVCR71                        7C340000  7C395FFF  00056000

    * opends60                       41060000  41065FFF  00006000

    * SHELL32                        7C8D0000  7D0D2FFF  00803000

    * GDI32                          77C00000  77C47FFF  00048000

    * USER32                         77380000  77411FFF  00092000

    * msvcrt                         77BA0000  77BF9FFF  0005a000

    * SHLWAPI                        77DA0000  77DF1FFF  00052000

    * sqlsort                        42AE0000  42B6FFFF  00090000

    * ums                            41070000  4107DFFF  0000e000

    * comctl32                       77420000  77522FFF  00103000

    * sqlevn70                       41080000  4108AFFF  0000b000

    * NETAPI32                       03200000  03257FFF  00058000

    * AUTHZ                          03260000  03273FFF  00014000

    * COMRES                         03610000  036D5FFF  000c6000

    * ole32                          036E0000  03813FFF  00134000

    * XOLEHLP                        038A0000  038A5FFF  00006000

    * MSDTCPRX                       038B0000  03927FFF  00078000

    * msvcp60                        03930000  03990FFF  00061000

    * MTXCLU                         039A0000  039B8FFF  00019000

    * VERSION                        039C0000  039C7FFF  00008000

    * WSOCK32                        039D0000  039D8FFF  00009000

    * WS2_32                         039E0000  039F6FFF  00017000

    * WS2HELP                        03A00000  03A07FFF  00008000

    * OLEAUT32                       03A10000  03A9BFFF  0008c000

    * CLUSAPI                        03AE0000  03AF1FFF  00012000

    * RESUTILS                       03B00000  03B12FFF  00013000

    * USERENV                        03B20000  03BE3FFF  000c4000

    * secur32                        03BF0000  03C02FFF  00013000

    * mswsock                        03C20000  03C60FFF  00041000

    * DNSAPI                         03C70000  03C98FFF  00029000

    * winrnr                         03CE0000  03CE6FFF  00007000

    * WLDAP32                        03CF0000  03D1DFFF  0002e000

    * rasadhlp                       03D40000  03D44FFF  00005000

    * SSNETLIB                       00E20000  00E35FFF  00016000

    * NTMARTA                        00E50000  00E71FFF  00022000

    * SAMLIB                         00E80000  00E8EFFF  0000f000

    * security                       04A60000  04A63FFF  00004000

    * Invalid Address                04AF0000  04B48FFF  00059000

    * wshtcpip                       04A50000  04A57FFF  00008000

    * SSmsLPCn                       04930000  04937FFF  00008000

    * SSnmPN70                       04940000  04946FFF  00007000

    * ntdsapi                        04950000  04964FFF  00015000

    * kerberos                       04B90000  04BE7FFF  00058000

    * cryptdll                       04980000  0498BFFF  0000c000

    * MSASN1                         04990000  049A1FFF  00012000

    * SQLFTQRY                       00EB0000  00ED5FFF  00026000

    * xpsp2res                       10000000  102C4FFF  002c5000

    * CLBCatQ                        05000000  05082FFF  00083000

    * sqloledb                       05090000  05110FFF  00081000

    * MSDART                         00F00000  00F19FFF  0001a000

    * MSDATL3                        05120000  05134FFF  00015000

    * oledb32                        054C0000  05538FFF  00079000

    * OLEDB32R                       05540000  05550FFF  00011000

    * msv1_0                         05710000  05736FFF  00027000

    * iphlpapi                       05740000  05759FFF  0001a000

    * PSAPI                          05760000  0576AFFF  0000b000

    * xpstar                         05780000  057CCFFF  0004d000

    * SQLRESLD                       05700000  0570BFFF  0000c000

    * SQLSVC                         057D0000  057EAFFF  0001b000

    * ODBC32                         057F0000  0582CFFF  0003d000

    * COMCTL32                       05830000  058C6FFF  00097000

    * comdlg32                       058D0000  05919FFF  0004a000

    * odbcbcp                        05920000  05925FFF  00006000

    * W95SCM                         05930000  0593CFFF  0000d000

    * SQLUNIRL                       05940000  0596CFFF  0002d000

    * WINSPOOL                       05970000  05996FFF  00027000

    * SHFOLDER                       059A0000  059A8FFF  00009000

    * odbcint                        05B80000  05B96FFF  00017000

    * NDDEAPI                        05CB0000  05CB6FFF  00007000

    * SQLSVC                         05CC0000  05CC5FFF  00006000

    * xpstar                         05CD0000  05CD8FFF  00009000

    * msdaora                        05D80000  05DC0FFF  00041000

    * MSDAORAR                       05DD0000  05DD3FFF  00004000

    * oci                            05E10000  05E2CFFF  0001d000

    * OCIW32                         05DE0000  05DE8FFF  00009000

    * ORACLIENT9                     05E30000  05FB3FFF  00184000

    * oracore9                       05FC0000  0605EFFF  0009f000

    * oranls9                        06060000  060D8FFF  00079000

    * oraunls9                       05DF0000  05E00FFF  00011000

    * WINMM                          060E0000  0610CFFF  0002d000

    * oravsn9                        06110000  06115FFF  00006000

    * oracommon9                     06120000  061AFFFF  00090000

    * orageneric9                    061B0000  06406FFF  00257000

    * oraxml9                        06410000  0648CFFF  0007d000

    * MSVCIRT                        06490000  0649FFFF  00010000

    * oraxsd9                        064A0000  064BFFFF  00020000

    * orannzsbb9                     064C0000  06548FFF  00089000

    * oran9                          06550000  06603FFF  000b4000

    * oranl9                         06610000  0663BFFF  0002c000

    * oranldap9                      06640000  06650FFF  00011000

    * oraldapclnt9                   06660000  06683FFF  00024000

    * orancrypt9                     06690000  066A6FFF  00017000

    * ORATRACE9                      066B0000  066EDFFF  0003e000

    * oranro9                        066F0000  06725FFF  00036000

    * oranhost9                      06730000  06735FFF  00006000

    * oranoname9                     06740000  06745FFF  00006000

    * orancds9                       06750000  06755FFF  00006000

    * orantns9                       06760000  06766FFF  00007000

    * oranms                         06770000  06776FFF  00007000

    * oranmsp                        06780000  0678FFFF  00010000

    * orapls9                        06790000  06AA2FFF  00313000

    * oraslax9                       06AB0000  06AB6FFF  00007000

    * orasnls9                       06AC0000  06ACFFFF  00010000

    * orawtc9                        06AD0000  06AD5FFF  00006000

    * orasql9                        06AE0000  06B54FFF  00075000

    * comsvcs                        06CA0000  06DD8FFF  00139000

    * dbghelp                        070A0000  0719FFFF  00100000

    *

    *        Edi: 00000000:

    *        Esi: 03E08720: 00000017  00000063  00000000  03E01670  060C7D10  00000000 

    *        Eax: 00000000:

    *        Ebx: 03E08D1C: 03E08CF0  03E08D04  03DFC718  00000000  00000000  03E08720 

    *        Ecx: 00000000:

    *        Edx: 03E08720: 00000017  00000063  00000000  03E01670  060C7D10  00000000 

    *        Eip: 06062217: 204F8B66  8B0C568B  4D8B8A04  10438924  8528458B  0001C7C0 

    *        Ebp: 07068368: 070683A8  06618501  0706829C  00000000  03E08CF0  03E08D04 

    *      SegCs: 0000001B:

    *     EFlags: 00010246: 006D0061  00460020  006C0069  00730065  004F005C  00610072 

    *        Esp: 07068080: 03E08D1C  03E08CF0  03E08CF0  00000000  00000000  00000000 

    *      SegSs: 00000023:

    * *******************************************************************************

    * -------------------------------------------------------------------------------

    * Short Stack Dump

    * 06062217 Module(oranls9+00002217) (lmsaicmt+00000317)

    * 06618501 Module(oranl9+00008501) (nlemomf+00000061)

    * 06618AF3 Module(oranl9+00008AF3) (nlemgmz+000000D3)

    * 066195B4 Module(oranl9+000095B4) (nlerbem+000000A4)

    * 0662690A Module(oranl9+0001690A) (nlstdggo+0000060A)

    * 066262F0 Module(oranl9+000162F0) (nlstdgg+00000020)

    * 0655F026 Module(oran9+0000F026) (nigini1+00000306)

    * 065B16FA Module(oran9+000616FA) (osncon+0000026A)

    * 05E7AEEE Module(ORACLIENT9+0004AEEE) (kpuatch+0000064E)

    * 05F15B07 Module(ORACLIENT9+000E5B07) (xaolog+0002F567)

    * 05F3B6F7 Module(ORACLIENT9+0010B6F7) (xaolog+00055157)

    * 05F3B752 Module(ORACLIENT9+0010B752) (xaolog+000551B2)

    * 05F13158 Module(ORACLIENT9+000E3158) (xaolog+0002CBB8)

    * 05F1428C Module(ORACLIENT9+000E428C) (xaolog+0002DCEC)

    * 05F141D9 Module(ORACLIENT9+000E41D9) (xaolog+0002DC39)

    * 05ED3D24 Module(ORACLIENT9+000A3D24) (upilog+00000064)

    * 05ED2C80 Module(ORACLIENT9+000A2C80) (ocirlo+000000B0)

    * 05DE1E3C Module(OCIW32+00001E3C) (olog+0000005C)

    * 05DA0EAE Module(msdaora+00020EAE) (DllRegisterServer+000012CF)

    * 05DA1E2D Module(msdaora+00021E2D) (DllRegisterServer+0000224E)

    * 77BCB530 Module(msvcrt+0002B530) (endthreadex+000000A3)

    * 77E66063 Module(kernel32+00026063) (GetModuleFileNameA+000000EB)

    * -------------------------------------------------------------------------------

    *Dump thread - spid = 1, PSS = 0x42c680c0, EC = 0x42c683f0

    *Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump0001.txt

    * *******************************************************************************

    *

    * BEGIN STACK DUMP:

    *   03/30/07 16:43:07 spid 1

    *

    * StackDump (all)

    *

    *

    *        Edi: 00000000:

    *        Esi: 000002CC:

    *        Eax: 4303A0C0: 0100000C  00000000  01127FFA  00009901  00000000  00000000 

    *        Ebx: 002974D8: 41076770  00000003  00000004  00000000  00F5C340  00000004 

    *        Ecx: 00000000:

    *        Edx: 000005B4:

    *        Eip: 7C82ED54: 24A48DC3  00000000  0024648D  0824548D  55C32ECD  A48DEC8B 

    *        Ebp: 0430FCF8: 00297530  41074AEE  000002CC  FFFFFFFF  00000001  00297ED8 

    *      SegCs: 0000001B:

    *     EFlags: 00000246:

    *        Esp: 0430FC88: 7C822124  77E6BAA8  000002CC  00000001  00000000  77E6BA20 

    *      SegSs: 00000023:

    * *******************************************************************************

    * -------------------------------------------------------------------------------

    * Short Stack Dump

    * 7C82ED54 Module(ntdll+0002ED54) (KiFastSystemCallRet+00000000)

    * 41074AEE Module(ums+00004AEE) (UmsThreadScheduler::Switch+0000004E Line 490+0000000A)

    * 410729F9 Module(ums+000029F9) (UmsScheduler::IdleLoop+00000119 Line 1373+0000000D)

    * 41072B26 Module(ums+00002B26) (UmsScheduler::Suspend+00000066 Line 1182+00000000)

    * 4107311B Module(ums+0000311B) (UmsEvent::Wait+0000007B Line 320+00000000)

    * 00401261 Module(sqlservr+00001261)

    * 00401852 Module(sqlservr+00001852)

    * 00408374 Module(sqlservr+00008374)

    * 00408419 Module(sqlservr+00008419)

    * 00563A63 Module(sqlservr+00163A63)

    * 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)

    * 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)

    * 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)

    * 77E66063 Module(kernel32+00026063) (GetModuleFileNameA+000000EB)

    * -------------------------------------------------------------------------------

    *Dump thread - spid = 2, PSS = 0x42c6c0c0, EC = 0x42c6c3f0

    *Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump0001.txt

    * *******************************************************************************

    *

    * BEGIN STACK DUMP:

    *   03/30/07 16:43:07 spid 2

    *

    * StackDump (all)

    *

    *

    *        Edi: 00000000:

    *        Esi: 0000018C:

    *        Eax: 00000000:

    *        Ebx: 00296F78: 000006B1  0000011D  00000001  00000000  00140009  000C014C 

    *        Ecx: 000326D2:

    *        Edx: 00000B70:

    *        Eip: 7C82ED54: 24A48DC3  00000000  0024648D  0824548D  55C32ECD  A48DEC8B 

    *        Ebp: 0418FB20: 0418FB34  77E6BA12  0000018C  0000036B  00000000  00296F48 

    *      SegCs: 0000001B:

    *     EFlags: 00000297:

    *        Esp: 0418FAB0: 7C822124  77E6BAA8  0000018C  00000000  0418FAF4  002979C0 

    *      SegSs: 00000023:

    * *******************************************************************************

    * -------------------------------------------------------------------------------

    * Short Stack Dump

    * 7C82ED54 Module(ntdll+0002ED54) (KiFastSystemCallRet+00000000)

    * 77E6BA12 Module(kernel32+0002BA12) (WaitForSingleObject+00000012)

    * 4107297F Module(ums+0000297F) (UmsScheduler::IdleLoop+0000009F Line 1343+00000000)

    * 41072B26 Module(ums+00002B26) (UmsScheduler::Suspend+00000066 Line 1182+00000000)

    * 4107311B Module(ums+0000311B) (UmsEvent::Wait+0000007B Line 320+00000000)

    * 00401261 Module(sqlservr+00001261)

    * 00401C92 Module(sqlservr+00001C92)

    * 00565F7E Module(sqlservr+00165F7E)

    * 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)

    * 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)

    * 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)

    * 77E66063 Module(kernel32+00026063) (GetModuleFileNameA+000000EB)

    * -------------------------------------------------------------------------------

    *Dump thread - spid = 3, PSS = 0x42c6a0c0, EC = 0x42c6a3f0

    *Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump0001.txt

    * *******************************************************************************

    *

    * BEGIN STACK DUMP:

    *   03/30/07 16:43:07 spid 3

    *

    * StackDump (all)

    *

    *

    *        Edi: 00000000:

    *        Esi: 000002C4:

    *        Eax: 00000103:

    *        Ebx: 002972E8: 41076770  00000002  00000005  00000000  00F5A19C  00000004 

    *        Ecx: 0428F74C: 00F5A1E4  42D6D444  0428F768  004094F3  00F5A19C  002972E8 

    *        Edx: 7C82ED54: 24A48DC3  00000000  0024648D  0824548D  55C32ECD  A48DEC8B 

    *        Eip: 7C82ED54: 24A48DC3  00000000  0024648D  0824548D  55C32ECD  A48DEC8B 

    *        Ebp: 0428FE48: 00297340  41074AEE  000002C4  FFFFFFFF  00000001  00297D60 

    *      SegCs: 0000001B:

    *     EFlags: 00000246:

    *        Esp: 0428FDD8: 7C822124  77E6BAA8  000002C4  00000001  00000000  77E6BA20 

    *      SegSs: 00000023:

    * *******************************************************************************

    * -------------------------------------------------------------------------------

    * Short Stack Dump

    * 7C82ED54 Module(ntdll+0002ED54) (KiFastSystemCallRet+00000000)

    * 41074AEE Module(ums+00004AEE) (UmsThreadScheduler::Switch+0000004E Line 490+0000000A)

    * 410729F9 Module(ums+000029F9) (UmsScheduler::IdleLoop+00000119 Line 1373+0000000D)

    * 41072B26 Module(ums+00002B26) (UmsScheduler::Suspend+00000066 Line 1182+00000000)

    * 4107311B Module(ums+0000311B) (UmsEvent::Wait+0000007B Line 320+00000000)

    * 0055F1CE Module(sqlservr+0015F1CE)

    * 005515C6 Module(sqlservr+001515C6)

    * -------------------------------------------------------------------------------

    *Dump thread - spid = 4, PSS = 0x42d6a0c0, EC = 0x42d6a3f0

    *Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump0001.txt

    * *******************************************************************************

    *

    * BEGIN STACK DUMP:

    *   03/30/07 16:43:07 spid 4

    *

    * StackDump (all)

    *

    *

    *        Edi: 00000000:

    *        Esi: 000002BC:

    *        Eax: 42D5E180: 00000000  00000000  00000000  00000000  00000000  00000000 

    *        Ebx: 002970F8: 41076770  00000001  00000005  00000000  00F5A370  00000004 

    *        Ecx: 0000000D:

    *        Edx: 42D5E290: 42D5EDB0  42D5EDC8  00000000  00000000  42D5E6B0  00000000 

    *        Eip: 7C82ED54: 24A48DC3  00000000  0024648D  0824548D  55C32ECD  A48DEC8B 

    *        Ebp: 0420F9D4: 00297150  41074AEE  000002BC  FFFFFFFF  00000001  00297B38 

    *      SegCs: 0000001B:

    *     EFlags: 00000246:

    *        Esp: 0420F964: 7C822124  77E6BAA8  000002BC  00000001  00000000  77E6BA20 

    *      SegSs: 00000023:

    * *******************************************************************************

    * -------------------------------------------------------------------------------

    * Short Stack Dump

    * 7C82ED54 Module(ntdll+0002ED54) (KiFastSystemCallRet+00000000)

    * 41074AEE Module(ums+00004AEE) (UmsThreadScheduler::Switch+0000004E Line 490+0000000A)

    * 410729F9 Module(ums+000029F9) (UmsScheduler::IdleLoop+00000119 Line 1373+0000000D)

    * 41072B26 Module(ums+00002B26) (UmsScheduler::Suspend+00000066 Line 1182+00000000)

    * 4107311B Module(ums+0000311B) (UmsEvent::Wait+0000007B Line 320+00000000)

    * 00401261 Module(sqlservr+00001261)

    * 00401852 Module(sqlservr+00001852)

    * 0040C796 Module(sqlservr+0000C796)

    * 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)

    * 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)

    * 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)

    * 77E66063 Module(kernel32+00026063) (GetModuleFileNameA+000000EB)

    * -------------------------------------------------------------------------------

    ***Unable to get thread context for spid 5

    *Dump thread - spid = 6, PSS = 0x42d680c0, EC = 0x42d683f0

    *Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump0001.txt

    * *******************************************************************************

    *

    * BEGIN STACK DUMP:

    *   03/30/07 16:43:07 spid 6

    *

    * StackDump (all)

    *

    *

    *        Edi: 00000000:

    *        Esi: 000002D4:

    *        Eax: 00000000:

    *        Ebx: 00296EF0: 41076770  00000000  00000005  00000000  00F5E310  00000004 

    *        Ecx: 42D68820: 00000000  00000000  00000000  00000000  00000000  00000000 

    *        Edx: 42D68810: 00000000  00000000  00000000  00000000  00000000  00000000 

    *        Eip: 7C82ED54: 24A48DC3  00000000  0024648D  0824548D  55C32ECD  A48DEC8B 

    *        Ebp: 0438FBB0: 00296F48  41074AEE  000002D4  FFFFFFFF  00000001  00297FB8 

    *      SegCs: 0000001B:

    *     EFlags: 00000246:

    *        Esp: 0438FB40: 7C822124  77E6BAA8  000002D4  00000001  00000000  77E6BA20 

    *      SegSs: 00000023:

    * *******************************************************************************

    * -------------------------------------------------------------------------------

    * Short Stack Dump

    * 7C82ED54 Module(ntdll+0002ED54) (KiFastSystemCallRet+00000000)

    * 41074AEE Module(ums+00004AEE) (UmsThreadScheduler::Switch+0000004E Line 490+0000000A)

    * 410729F9 Module(ums+000029F9) (UmsScheduler::IdleLoop+00000119 Line 1373+0000000D)

    * 41072B26 Module(ums+00002B26) (UmsScheduler::Suspend+00000066 Line 1182+00000000)

    * 4107311B Module(ums+0000311B) (UmsEvent::Wait+0000007B Line 320+00000000)

    * 00401261 Module(sqlservr+00001261)

    * 00401852 Module(sqlservr+00001852)

    * 0060E107 Module(sqlservr+0020E107) (SQLExit+000A6610)

    * 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)

    * 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)

    * 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)

    * 77E66063 Module(kernel32+00026063) (GetModuleFileNameA+000000EB)

    * -------------------------------------------------------------------------------

    *Dump thread - spid = 7, PSS = 0x42d620c0, EC = 0x42d623f0

    *Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump0001.txt

    * *******************************************************************************

    *

    * BEGIN STACK DUMP:

    *   03/30/07 16:43:07 spid 7

    *

    * StackDump (all)

    *

    *

    *        Edi: 00000000:

    *        Esi: 000002DC:

    *        Eax: 42D4BFF0: 00000001  00000E28  42D4B1C0  00000000  00000A01  00000002 

    *        Ebx: 002970F8: 41076770  00000001  00000005  00000000  00F5A370  00000004 

    *        Ecx: FFFFFFFF:

    *        Edx: 42D4A020: 00000001  00000000  00000000  42D4B1C0  00000001  10000008 

    *        Eip: 7C82ED54: 24A48DC3  00000000  0024648D  0824548D  55C32ECD  A48DEC8B 

    *        Ebp: 0440FBA8: 00297150  41074AEE  000002DC  FFFFFFFF  00000001  002981E0 

    *      SegCs: 0000001B:

    *     EFlags: 00000246:

    *        Esp: 0440FB38: 7C822124  77E6BAA8  000002DC  00000001  00000000  77E6BA20 

    *      SegSs: 00000023:

    * *******************************************************************************

    * -------------------------------------------------------------------------------

    * Short Stack Dump

    * 7C82ED54 Module(ntdll+0002ED54) (KiFastSystemCallRet+00000000)

    * 41074AEE Module(ums+00004AEE) (UmsThreadScheduler::Switch+0000004E Line 490+0000000A)

    * 410729F9 Module(ums+000029F9) (UmsScheduler::IdleLoop+00000119 Line 1373+0000000D)

    * 41072B26 Module(ums+00002B26) (UmsScheduler::Suspend+00000066 Line 1182+00000000)

    * 4107311B Module(ums+0000311B) (UmsEvent::Wait+0000007B Line 320+00000000)

    * 00401261 Module(sqlservr+00001261)

    * 00401852 Module(sqlservr+00001852)

    * 00404776 Module(sqlservr+00004776)

    * 00562867 Module(sqlservr+00162867)

    * 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)

    * 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)

    * 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)

    * 77E66063 Module(kernel32+00026063) (GetModuleFileNameA+000000EB)

    * -------------------------------------------------------------------------------

    ***Unable to get thread context for spid 8

    ***Unable to get thread context for spid 9

    ***Unable to get thread context for spid 10

    ***Unable to get thread context for spid 11

    ***Unable to get thread context for spid 12

    ***Unable to get thread context for spid 13

    ***Unable to get thread context for spid 14

    ***Unable to get thread context for spid 15

    ***Unable to get thread context for spid 16

    *Dump thread - spid = 51, PSS = 0x42f25228, EC = 0x42f25558

    *Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump0001.txt

    * *******************************************************************************

    *

    * BEGIN STACK DUMP:

    *   03/30/07 16:43:07 spid 51

    *

    * StackDump (all)

    *

    * Input Buffer 130 bytes -

    *  exec master..sp_tables_ex N'RCDM' , null, null, null, '''TABLE'''

    *

    *        Edi: 00000000:

    *        Esi: 00000620:

    *        Eax: 05300608: 00C10008  00000100  FFEEFFEE  00000000  05300000  0003D000 

    *        Ebx: 00000016:

    *        Ecx: 04F7D520: 00000000  00000000  00000000  00000000  00000000  00000000 

    *        Edx: 00001000:

    *        Eip: 7C82ED54: 24A48DC3  00000000  0024648D  0824548D  55C32ECD  A48DEC8B 

    *        Ebp: 04F7D6E0: 04F7D6F4  77E6BA12  00000620  FFFFFFFF  00000000  04F7D70C 

    *      SegCs: 0000001B:

    *     EFlags: 00000246:

    *        Esp: 04F7D670: 7C822124  77E6BAA8  00000620  00000000  00000000  051440F8 

    *      SegSs: 00000023:

    * *******************************************************************************

    * -------------------------------------------------------------------------------

    * Short Stack Dump

    * 7C82ED54 Module(ntdll+0002ED54) (KiFastSystemCallRet+00000000)

    * 77E6BA12 Module(kernel32+0002BA12) (WaitForSingleObject+00000012)

    * 05DA0D5B Module(msdaora+00020D5B) (DllRegisterServer+0000117C)

    * 05DA1191 Module(msdaora+00021191) (DllRegisterServer+000015B2)

    * 05DA1983 Module(msdaora+00021983) (DllRegisterServer+00001DA4)

    * 05DA1FF2 Module(msdaora+00021FF2) (DllRegisterServer+00002413)

    * 05DAD078 Module(msdaora+0002D078) (DllRegisterServer+0000D499)

    * 054C5DE2 Module(oledb32+00005DE2) (DllGetClassObject+0000446E)

    * 054C5E6D Module(oledb32+00005E6D) (DllGetClassObject+000044F9)

    * 054C2323 Module(oledb32+00002323) (DllGetClassObject+000009AF)

    * 06CE2CF8 Module(comsvcs+00042CF8) (DispManGetContext+00000A45)

    * 06CE4291 Module(comsvcs+00044291) (DispManGetContext+00001FDE)

    * 054C26DB Module(oledb32+000026DB) (DllGetClassObject+00000D67)

    * 054C5F31 Module(oledb32+00005F31) (DllGetClassObject+000045BD)

    * 054C2C2C Module(oledb32+00002C2C) (DllGetClassObject+000012B8)

    * 007A2944 Module(sqlservr+003A2944) (SQLExit+0023AE4D)

    * 007A3448 Module(sqlservr+003A3448) (SQLExit+0023B951)

    * 007A68CB Module(sqlservr+003A68CB) (SQLExit+0023EDD4)

    * 00609FCD Module(sqlservr+00209FCD) (SQLExit+000A24D6)

    * 0060A12D Module(sqlservr+0020A12D) (SQLExit+000A2636)

    * 0041D396 Module(sqlservr+0001D396)

    * 005B810A Module(sqlservr+001B810A) (SQLExit+00050613)

    * 005B8266 Module(sqlservr+001B8266) (SQLExit+0005076F)

    * 004194B9 Module(sqlservr+000194B9)

    * 004193E4 Module(sqlservr+000193E4)

    * 00429EAA Module(sqlservr+00029EAA)

    * 00415D04 Module(sqlservr+00015D04)

    * 00416214 Module(sqlservr+00016214)

    * 00415F28 Module(sqlservr+00015F28)

    * 0050BCEF Module(sqlservr+0010BCEF)

    * 0050BB13 Module(sqlservr+0010BB13)

    * 00415D04 Module(sqlservr+00015D04)

    * 00416214 Module(sqlservr+00016214)

    * 00415F28 Module(sqlservr+00015F28)

    * 0049C32E Module(sqlservr+0009C32E)

    * 0049C46A Module(sqlservr+0009C46A)

    * 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)

    * 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)

    * 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)

    * 77E66063 Module(kernel32+00026063) (GetModuleFileNameA+000000EB)

    * -------------------------------------------------------------------------------

    ***Unable to get thread context for spid 52

    ***Unable to get thread context for spid 53

    2007-03-30 16:43:08.36 server    Stack Signature for the dump is 0xFC5AA91D

    2007-03-30 16:43:08.36 server    SQL Server is aborting. Fatal exception c0000005 caught.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply