Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    2

    Unanswered: Access Violation When Selecting Data

    Hi,

    I have suddenly developed a problem when trying to select from a table. Even a standard select * from generates a SQL Dump exception handler. The table is below:

    CREATE TABLE [Stagetb_GIDeptGroup] (
    [f_GIImportID] [int] IDENTITY (1, 1) NOT NULL ,
    [f_GIAction] [int] NOT NULL CONSTRAINT [DF_stagetb_GIDeptGroup_f_GIAction] DEFAULT (0),
    [f_ImportBatchID] [int] NULL ,
    [f_VisualDeptGroupID] [int] NULL ,
    [f_DeptGroupName] [varchar] (40) COLLATE Latin1_General_CI_AS NULL ,
    [f_DeptGroupTarget] [d_Percentage] NULL ,
    [f_ExternalDeptGroupID] [int] NULL ,
    [f_StatusID] [int] NOT NULL CONSTRAINT [DF_stagetb_GIDeptGroup_f_StatusID] DEFAULT (0),
    [f_StatusDetailID] [int] NOT NULL CONSTRAINT [DF_stagetb_GIDeptGroup_f_StatusDetailID] DEFAULT (0),
    CONSTRAINT [PK_stagetb_GIDeptGroup] PRIMARY KEY CLUSTERED
    (
    [f_GIImportID]
    ) ON [PRIMARY]
    ) ON [PRIMARY]
    GO

    When i run a dbcc checkdb it finds nothing, if i try and connect from a remote connection i get a general network error and when connecting from the local machine i get this Dump exception error:

    2005-12-06 08:40:55.28 spid53 Error: 0, Severity: 19, State: 0
    2005-12-06 08:40:55.28 spid53 language_exec: Process 53 generated an access violation. SQL Server is terminating this process..
    2005-12-06 08:40:57.76 spid53 Using 'sqlimage.dll' version '4.0.5'
    Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQL00010.dmp
    2005-12-06 08:40:57.76 spid53 Error: 0, Severity: 19, State: 0
    2005-12-06 08:40:57.76 spid53 SqlDumpExceptionHandler: Process 53 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
    ************************************************** *****************************
    *
    * BEGIN STACK DUMP:
    * 12/06/05 08:40:57 spid 53
    *
    * Exception Address = 00425E61
    * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
    * Access Violation occurred reading address 00000000
    * Input Buffer 70 bytes -
    * select * from stagetb_GIDeptGroup
    *
    *
    * MODULE BASE END SIZE
    * sqlservr 00400000 00B19FFF 0071a000
    * ntdll 77F50000 77FF6FFF 000a7000
    * kernel32 77E60000 77F45FFF 000e6000
    * ADVAPI32 77DD0000 77E5CFFF 0008d000
    * RPCRT4 78000000 78085FFF 00086000
    * USER32 77D40000 77DC5FFF 00086000
    * GDI32 7E090000 7E0D0FFF 00041000
    * OPENDS60 41060000 41065FFF 00006000
    * MSVCRT 77C10000 77C62FFF 00053000
    * UMS 41070000 4107CFFF 0000d000
    * SQLSORT 42AE0000 42B6FFFF 00090000
    * MSVCIRT 002A0000 002AFFFF 00010000
    * sqlevn70 41080000 41086FFF 00007000
    * NETAPI32 71C20000 71C6DFFF 0004e000
    * wmi 76D30000 76D33FFF 00004000
    * SSNETLIB 42CF0000 42D05FFF 00016000
    * WSOCK32 71AD0000 71AD7FFF 00008000
    * WS2_32 71AB0000 71AC4FFF 00015000
    * WS2HELP 71AA0000 71AA7FFF 00008000
    * SSNMPN70 410D0000 410D5FFF 00006000
    * security 71F80000 71F83FFF 00004000
    * SECUR32 76F90000 76F9FFFF 00010000
    * crypt32 762C0000 76347FFF 00088000
    * MSASN1 762A0000 762AFFFF 00010000
    * VERSION 77C00000 77C06FFF 00007000
    * userenv 75A70000 75B14FFF 000a5000
    * mswsock 71A50000 71A8AFFF 0003b000
    * DNSAPI 76F20000 76F44FFF 00025000
    * winrnr 76FB0000 76FB6FFF 00007000
    * WLDAP32 76F60000 76F8BFFF 0002c000
    * rasadhlp 76FC0000 76FC4FFF 00005000
    * wshtcpip 71A90000 71A97FFF 00008000
    * SSmsLPCn 42CD0000 42CD6FFF 00007000
    * ntdsapi 767A0000 767B2FFF 00013000
    * msv1_0 76D10000 76D2CFFF 0001d000
    * OLE32 771B0000 772D0FFF 00121000
    * CLBCATQ 76FD0000 77047FFF 00078000
    * OLEAUT32 77120000 771AAFFF 0008b000
    * COMRes 77050000 77114FFF 000c5000
    * sqloledb 01D80000 01DF2FFF 00073000
    * MSDART 74C50000 74C6EFFF 0001f000
    * COMCTL32 77340000 773CAFFF 0008b000
    * comdlg32 763B0000 763F4FFF 00045000
    * SHLWAPI 70A70000 70AD4FFF 00065000
    * SHELL32 773D0000 77BC1FFF 007f2000
    * MSDATL3 60E30000 60E44FFF 00015000
    * comctl32 71950000 71A33FFF 000e4000
    * oledb32 02020000 02084FFF 00065000
    * OLEDB32R 01E00000 01E0FFFF 00010000
    * xpsqlbot 42F00000 42F05FFF 00006000
    * xpstar 410F0000 41133FFF 00044000
    * SQLUNIRL 5C1B0000 5C1DCFFF 0002d000
    * WINSPOOL 73000000 73022FFF 00023000
    * SQLRESLD 42AC0000 42AC6FFF 00007000
    * SQLSVC 42C40000 42C56FFF 00017000
    * ODBC32 02150000 02181FFF 00032000
    * odbcbcp 02190000 02195FFF 00006000
    * W95SCM 41140000 4114BFFF 0000c000
    * NDDEAPI 75940000 75946FFF 00007000
    * odbcint 022B0000 022C5FFF 00016000
    * clusapi 55560000 55570FFF 00011000
    * resutils 750B0000 750C0FFF 00011000
    * SQLSVC 43970000 43975FFF 00006000
    * xpstar 439E0000 439EBFFF 0000c000
    * DBGHELP 02420000 02432FFF 00013000
    * msdbi 6BE90000 6BEABFFF 0001c000
    * sqlimage 4A400000 4A40CFFF 0000d000
    *
    * Edi: 1ADA13F4: 00000000 1ADA1758 00000000 1ADA1400 00000001 00000000
    * Esi: 00000000:
    * Eax: 1ADA13E0: 009802E4 00000032 00000000 00000000 00000000 00000000
    * Ebx: 1ADA13E0: 009802E4 00000032 00000000 00000000 00000000 00000000
    * Ecx: 00000000:
    * Edx: 1ADA1410: 00000000 6E006100 00000000 00000000 00000000 1ADA0030
    * Eip: 00425E61: 7589018B 8B10FFFC F44D8BF0 A5A5A5A5 5EC38B5F 0D89645B
    * Ebp: 0213DFE8: 0213E01C 004C4EB7 1ADA0020 00000000 1ADA1168 1ADC84D0
    * SegCs: 0000001B:
    * EFlags: 00010282: 0050004F 00300048 00300033 00560030 004F0042 004E0000
    * Esp: 0213DFCC: 1ADA07F0 1ADA0020 00A0A4A0 1ADA13E0 0213E010 0092D7B0
    * SegSs: 00000023:
    ************************************************** *****************************
    -------------------------------------------------------------------------------
    Short Stack Dump
    00425E61 Module(sqlservr+00025E61)
    004C4EB7 Module(sqlservr+000C4EB7)
    0049DCD9 Module(sqlservr+0009DCD9)
    0049DAF9 Module(sqlservr+0009DAF9)
    00447078 Module(sqlservr+00047078)
    004510FE Module(sqlservr+000510FE)
    00415080 Module(sqlservr+00015080)
    004592CE Module(sqlservr+000592CE)
    005A7208 Module(sqlservr+001A7208) (SQLExit(unsigned long)+000523F6)
    005A7099 Module(sqlservr+001A7099) (SQLExit(unsigned long)+00052287)
    00446A83 Module(sqlservr+00046A83)
    004510FE Module(sqlservr+000510FE)
    00415080 Module(sqlservr+00015080)
    004592CE Module(sqlservr+000592CE)
    0041534F Module(sqlservr+0001534F)
    00459A54 Module(sqlservr+00059A54)
    004175D8 Module(sqlservr+000175D8)
    410735D0 Module(UMS+000035D0) (UmsSystemUserContext::UmsSystemUserContext(class UmsScheduler *,struct UMS_SYSPARAMS *)+00000434)
    4107382C Module(UMS+0000382C) (UmsScheduler::FiberEnabled(void)+000001D2)
    77C37E53 Module(MSVCRT+00027E53) (_endthread+000000AA)
    77E7D33B Module(kernel32+0001D33B) (RegisterWaitForInputIdle+00000043)

    I am running Windows XP Professional & MSDE Service Pack 3. Any ideas anyone?

  2. #2
    Join Date
    Dec 2005
    Posts
    2
    Has anyone ever experienced this before with any tables? Unable to select, update, insert or delete from the table as it throws a dump exception error. But DBCC CHECKDB returns no error?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •