Query generate Access Violation

  • Hello all,

    Windows 2003 Enterprise x64 SP2 Fully Patched

    SQL Server 2005 Standard x64 SP2 9.00.3159.00

    A user has a query that they run daily, with no complaints. However today the query failed reporting the following error through SMSS

    SELECT DIM_Business_Unit.BusinessUnitCD+AccountNo+ContactID 'ContactUnique',

    MAX(DIM_Date.Fulldate) LatestOrderDate,

    sum(case when OrderChannelCD = 'P' then 1 else 0 end) EPROC,

    sum(case when OrderChannelCD = 'E' then 1 else 0 end) EDI,

    sum(case when OrderChannelCD = 'W' then 1 else 0 end) WEB

    FROM FACT_Shipment_Invoice_Line,

    DIM_Business_Unit,DIM_Account,

    DIM_Contact,

    DIM_Invoice_Info,

    DIM_Date

    where FACT_Shipment_Invoice_Line.BusinessUnitKey=DIM_Business_Unit.BusinessUnitKeyand FACT_Shipment_Invoice_Line.AccountKey=DIM_Account.AccountKey

    and FACT_Shipment_Invoice_Line.ContactKey=DIM_Contact.ContactKey

    and FACT_Shipment_Invoice_Line.PostedDTKey=DIM_Date.DateKey

    and FACT_Shipment_Invoice_Line.InvoiceInfoKey=DIM_Invoice_Info.InvoiceInfoKey

    and [PF-Company]= 'Farnell Europe' and DIM_Date.DateKey > 20070620

    and BillingTransactionType = 'INVOICE' and ContactID <> '0'

    and AccountManager <> 'PRODADMIN'

    GROUP BY DIM_Business_Unit.BusinessUnitCD+AccountNo+ContactID

    Msg 0, Level 11, State 0, Line 0

    A severe error occurred on the current command. The results, if any, should be discarded

    Looking through the SQL Logs the attached stack dump below was returned

    30.21 spid77 * PSAPI 000007FF7E380000 000007FF7E38FFFF 00010000

    2009-10-16 09:49:30.21 spid77 * VERSION 000007FF7FBF0000 000007FF7FBFAFFF 0000b000

    2009-10-16 09:49:30.21 spid77 * HIPIS0e011aa 0000000064200000 000000006420EFFF 0000f000

    2009-10-16 09:49:30.21 spid77 * HIPQA 000000006AF70000 000000006AF80FFF 00011000

    2009-10-16 09:49:30.21 spid77 * ole32 000007FF57140000 000007FF573C4FFF 00285000

    2009-10-16 09:49:30.21 spid77 * HcApi 0000000180000000 0000000180011FFF 00012000

    2009-10-16 09:49:30.21 spid77 * instapi 0000000048060000 000000004806CFFF 0000d000

    2009-10-16 09:49:30.21 spid77 * sqlevn70 000000004F610000 000000004F7B8FFF 001a9000

    2009-10-16 09:49:30.21 spid77 * SQLOS 00000000344D0000 00000000344D5FFF 00006000

    2009-10-16 09:49:30.21 spid77 * rsaenh 0000000068000000 000000006804BFFF 0004c000

    2009-10-16 09:49:30.21 spid77 * AUTHZ 000007FF7E490000 000007FF7E4BDFFF 0002e000

    2009-10-16 09:49:30.21 spid77 * MSCOREE 000006427EE50000 000006427EEC3FFF 00074000

    2009-10-16 09:49:30.21 spid77 * msv1_0 000007FF7E500000 000007FF7E544FFF 00045000

    2009-10-16 09:49:30.21 spid77 * cryptdll 000007FF7DC90000 000007FF7DC9EFFF 0000f000

    2009-10-16 09:49:30.21 spid77 * iphlpapi 000007FF57040000 000007FF57070FFF 00031000

    2009-10-16 09:49:30.21 spid77 * kerberos 000007FF77410000 000007FF774C4FFF 000b5000

    2009-10-16 09:49:30.21 spid77 * schannel 000007FF7DD50000 000007FF7DD91FFF 00042000

    2009-10-16 09:49:30.21 spid77 * COMRES 000007FF7EAF0000 000007FF7EBB5FFF 000c6000

    2009-10-16 09:49:30.21 spid77 * XOLEHLP 000007FF5C5B0000 000007FF5C5B6FFF 00007000

    2009-10-16 09:49:30.21 spid77 * MSDTCPRX 000007FF67140000 000007FF67213FFF 000d4000

    2009-10-16 09:49:30.21 spid77 * OLEAUT32 000007FF7EBC0000 000007FF7ECD5FFF 00116000

    2009-10-16 09:49:30.21 spid77 * msvcp60 000000000DAE0000 000000000DBC9FFF 000ea000

    2009-10-16 09:49:30.21 spid77 * MTXCLU 000007FF7B540000 000007FF7B569FFF 0002a000

    2009-10-16 09:49:30.21 spid77 * WSOCK32 000007FF770F0000 000007FF770F9FFF 0000a000

    2009-10-16 09:49:30.21 spid77 * CLUSAPI 000007FF7B3A0000 000007FF7B3C3FFF 00024000

    2009-10-16 09:49:30.21 spid77 * RESUTILS 000007FF7B310000 000007FF7B32BFFF 0001c000

    2009-10-16 09:49:30.21 spid77 * DNSAPI 000007FF7E8F0000 000007FF7E93DFFF 0004e000

    2009-10-16 09:49:30.21 spid77 * winrnr 000007FF7E9F0000 000007FF7E9FAFFF 0000b000

    2009-10-16 09:49:30.21 spid77 * WLDAP32 000007FF7E950000 000007FF7E9B5FFF 00066000

    2009-10-16 09:49:30.21 spid77 * rasadhlp 000007FF7EA00000 000007FF7EA06FFF 00007000

    2009-10-16 09:49:30.21 spid77 * hnetcfg 000007FF6D200000 000007FF6D292FFF 00093000

    2009-10-16 09:49:30.21 spid77 * wshtcpip 000007FF77170000 000007FF7717AFFF 0000b000

    2009-10-16 09:49:30.21 spid77 * security 000007FF77530000 000007FF77534FFF 00005000

    2009-10-16 09:49:30.21 spid77 * msfte 0000000049980000 0000000049D2DFFF 003ae000

    2009-10-16 09:49:30.21 spid77 * dbghelp 0000000010610000 000000001076CFFF 0015d000

    2009-10-16 09:49:30.21 spid77 * WINTRUST 000007FF7E3E0000 000007FF7E42DFFF 0004e000

    2009-10-16 09:49:30.21 spid77 * imagehlp 000007FF7E470000 000007FF7E482FFF 00013000

    2009-10-16 09:49:30.21 spid77 * dssenh 0000000068100000 000000006813EFFF 0003f000

    2009-10-16 09:49:30.21 spid77 * NTMARTA 000007FF7E4C0000 000007FF7E4FBFFF 0003c000

    2009-10-16 09:49:30.21 spid77 * SAMLIB 000007FF77150000 000007FF77165FFF 00016000

    2009-10-16 09:49:30.21 spid77 * ntdsapi 000007FF7DCB0000 000007FF7DCD3FFF 00024000

    2009-10-16 09:49:30.21 spid77 * xpsp2res 0000000010C00000 0000000010EC6FFF 002c7000

    2009-10-16 09:49:30.21 spid77 * CLBCatQ 000007FF7EA10000 000007FF7EAEDFFF 000de000

    2009-10-16 09:49:30.21 spid77 * sqlncli 00000000337A0000 0000000033A63FFF 002c4000

    2009-10-16 09:49:30.21 spid77 * COMCTL32 000007FF76200000 000007FF762EEFFF 000ef000

    2009-10-16 09:49:30.21 spid77 * comdlg32 000007FF7D540000 000007FF7D5B6FFF 00077000

    2009-10-16 09:49:30.21 spid77 * SQLNCLIR 0000000035000000 0000000035032FFF 00033000

    2009-10-16 09:49:30.21 spid77 * msftepxy 0000000003850000 0000000003870FFF 00021000

    2009-10-16 09:49:30.21 spid77 * xpstar90 0000000053C30000 0000000053CB5FFF 00086000

    2009-10-16 09:49:30.21 spid77 * SQLSCM90 0000000053AD0000 0000000053ADBFFF 0000c000

    2009-10-16 09:49:30.21 spid77 * ODBC32 000007FF63F00000 000007FF63F66FFF 00067000

    2009-10-16 09:49:30.21 spid77 * BatchParser90 00000000520C0000 00000000520ECFFF 0002d000

    2009-10-16 09:49:30.21 spid77 * ATL80 000000007C630000 000000007C64EFFF 0001f000

    2009-10-16 09:49:30.21 spid77 * odbcint 000007FF63DC0000 000007FF63DD7FFF 00018000

    2009-10-16 09:49:30.21 spid77 * xpstar90 0000000013390000 00000000133B5FFF 00026000

    2009-10-16 09:49:30.21 spid77 * xpsqlbot 000000004A7C0000 000000004A7C7FFF 00008000

    2009-10-16 09:49:30.21 spid77 * xplog70 0000000034730000 000000003473FFFF 00010000

    2009-10-16 09:49:30.21 spid77 * xplog70 0000000013420000 0000000013422FFF 00003000

    2009-10-16 09:49:30.21 spid77 * msxmlsql 0000000078800000 0000000078967FFF 00168000

    2009-10-16 09:49:30.21 spid77 * msxml3 000007FF56D40000 000007FF56F53FFF 00214000

    2009-10-16 09:49:30.21 spid77 * xpSLS 000000000F210000 000000000F3A3FFF 00194000

    2009-10-16 09:49:30.21 spid77 * sqlvdi 0000000034510000 000000003453BFFF 0002c000

    2009-10-16 09:49:30.21 spid77 *

    2009-10-16 09:49:30.21 spid77 * P1Home: 0000000000000014:

    2009-10-16 09:49:30.21 spid77 * P2Home: 000000001A6CE5D0: 0000000000000014 000000001A6CE5D0 0000000000000001 0000000393CF6DB0 84000000000001FF FFFFFADDB519E040

    2009-10-16 09:49:30.21 spid77 * P3Home: 0000000000000001:

    2009-10-16 09:49:30.21 spid77 * P4Home: 0000000393CF6DB0: 0000000000000000 0000000393CF81D8 0000000393E48790 0034003700370038 0000000393CF7810 006500700073006E

    2009-10-16 09:49:30.21 spid77 * P5Home: 84000000000001FF:

    2009-10-16 09:49:30.21 spid77 * P6Home: FFFFFADDB519E040:

    2009-10-16 09:49:30.21 spid77 * ContextFlags: 000000000010001F:

    2009-10-16 09:49:30.21 spid77 * MxCsr: 0000000000001FA0:

    2009-10-16 09:49:30.21 spid77 * SegCs: 0000000000000033:

    2009-10-16 09:49:30.21 spid77 * SegDs: 000000000000002B:

    2009-10-16 09:49:30.21 spid77 * SegEs: 000000000000002B:

    2009-10-16 09:49:30.21 spid77 * SegFs: 0000000000000053:

    2009-10-16 09:49:30.21 spid77 * SegGs: 000000000000002B:

    2009-10-16 09:49:30.21 spid77 * SegSs: 000000000000002B:

    2009-10-16 09:49:30.21 spid77 * EFlags: 0000000000010246: 0074007400650053 00730067006E0069 006C006C0041005C 0065007300550020 0041005C00730072 0069006C00700070

    2009-10-16 09:49:30.21 spid77 * Rax: 000000008155DD50:

    2009-10-16 09:49:30.21 spid77 * Rcx: 0000000000000000:

    2009-10-16 09:49:30.21 spid77 * Rdx: 0000000000000000:

    2009-10-16 09:49:30.23 spid77 * Rbx: 0000000000000001:

    2009-10-16 09:49:30.23 spid77 * Rsp: 000000001A6CEB70: 000000001A6CEBC8 003FA08E00000000 00012E3C34680D80 0000000000F24080 0000000000000000 00012E3C346809A8

    2009-10-16 09:49:30.23 spid77 * Rbp: 0000000393CF6DB0: 0000000000000000 0000000393CF81D8 0000000393E48790 0034003700370038 0000000393CF7810 006500700073006E

    2009-10-16 09:49:30.23 spid77 * Rsi: 0000000000000000:

    2009-10-16 09:49:30.23 spid77 * Rdi: 0000000000000000:

    2009-10-16 09:49:30.23 spid77 * R8: 000000018155DD50: 0000000081550001 0000000000000000 0000000000000000 0000000000000000 0000000000000031 000000018155CCB0

    2009-10-16 09:49:30.23 spid77 * R9: 0000000393CF8228: FF00000000000000 0000000000000000 0000000393CF6DB0 0000000000000000 0000000000000000 0000000000000000

    2009-10-16 09:49:30.23 spid77 * R10: 000000000100C980: 2444C74868EC8348 5C8948FFFFFFFE30 4858246C89486024 247C894850247489 8B48402464894C48 0FD28548F98B48DA

    2009-10-16 09:49:30.23 spid77 * R11: 000000001A6CEDD8: 0000000000000000 00000000FFFFFFFF 0000000300000000 0000000000000000 00000000FFFFFFFF 0000000300000000

    2009-10-16 09:49:30.23 spid77 * R12: 000000018155DD50: 0000000081550001 0000000000000000 0000000000000000 0000000000000000 0000000000000031 000000018155CCB0

    2009-10-16 09:49:30.23 spid77 * R13: 000000001A6CEE50: 0000000000000000 0000000393CB2ED0 FFFFFFFFFFFFFFFE 00000003020000BA FFFFFFFFFFFFFFFE 000000000B59D1C8

    2009-10-16 09:49:30.23 spid77 * R14: 0000000012A04580: 0000000212A00000 0000000000000008 0000026300000000 0000000012A04080 000000018155E300 000000018155C2B0

    2009-10-16 09:49:30.23 spid77 * R15: 0000000000000002:

    2009-10-16 09:49:30.23 spid77 * Rip: 0000000002216E1F: 848900000194808B 548D480000018024 FB07E8C88B497824 485024448948FEE7 1374187D3B66E88B 01DCB58B187D8B66

    2009-10-16 09:49:30.23 spid77 * *******************************************************************************

    2009-10-16 09:49:30.23 spid77 * -------------------------------------------------------------------------------

    2009-10-16 09:49:30.23 spid77 * Short Stack Dump

    2009-10-16 09:49:30.23 spid77 0000000002216E1F Module(sqlservr+0000000001216E1F)

    2009-10-16 09:49:30.23 spid77 0000000002225DA0 Module(sqlservr+0000000001225DA0)

    2009-10-16 09:49:30.23 spid77 0000000002225F1A Module(sqlservr+0000000001225F1A)

    2009-10-16 09:49:30.23 spid77 0000000002225FFE Module(sqlservr+0000000001225FFE)

    2009-10-16 09:49:30.23 spid77 00000000017C438E Module(sqlservr+00000000007C438E)

    2009-10-16 09:49:30.23 spid77 0000000001368D6C Module(sqlservr+0000000000368D6C)

    2009-10-16 09:49:30.23 spid77 0000000001352E3B Module(sqlservr+0000000000352E3B)

    2009-10-16 09:49:30.23 spid77 0000000001CA8B7D Module(sqlservr+0000000000CA8B7D)

    2009-10-16 09:49:30.23 spid77 00000000014A126D Module(sqlservr+00000000004A126D)

    2009-10-16 09:49:30.23 spid77 0000000001367722 Module(sqlservr+0000000000367722)

    2009-10-16 09:49:30.23 spid77 0000000001367AAC Module(sqlservr+0000000000367AAC)

    2009-10-16 09:49:30.23 spid77 0000000001367B5F Module(sqlservr+0000000000367B5F)

    2009-10-16 09:49:30.23 spid77 0000000001028A0D Module(sqlservr+0000000000028A0D)

    2009-10-16 09:49:30.23 spid77 0000000001340864 Module(sqlservr+0000000000340864)

    2009-10-16 09:49:30.23 spid77 00000000013407C4 Module(sqlservr+00000000003407C4)

    2009-10-16 09:49:30.23 spid77 0000000001340434 Module(sqlservr+0000000000340434)

    2009-10-16 09:49:30.23 spid77 0000000001340FC6 Module(sqlservr+0000000000340FC6)

    2009-10-16 09:49:30.23 spid77 00000000010079FE Module(sqlservr+00000000000079FE)

    2009-10-16 09:49:30.23 spid77 0000000001008362 Module(sqlservr+0000000000008362)

    2009-10-16 09:49:30.23 spid77 0000000001007DA1 Module(sqlservr+0000000000007DA1)

    2009-10-16 09:49:30.23 spid77 00000000014787A7 Module(sqlservr+00000000004787A7)

    2009-10-16 09:49:30.23 spid77 00000000014789CA Module(sqlservr+00000000004789CA)

    2009-10-16 09:49:30.23 spid77 0000000001478911 Module(sqlservr+0000000000478911)

    2009-10-16 09:49:30.24 spid77 00000000014795D9 Module(sqlservr+00000000004795D9)

    2009-10-16 09:49:30.24 spid77 00000000781337D7 Module(MSVCR80+00000000000037D7)

    2009-10-16 09:49:30.24 spid77 0000000078133894 Module(MSVCR80+0000000000003894)

    2009-10-16 09:49:30.24 spid77 0000000077D6B71A Module(kernel32+000000000002B71A)

    2009-10-16 09:49:30.32 spid77 Stack Signature for the dump is 0x000000016A19D0EF

    2009-10-16 09:49:31.68 spid77 External dump process return code 0x20000001.

    External dump process returned no errors.

    2009-10-16 09:49:31.68 spid77 Using 'dbghelp.dll' version '4.0.5'

    2009-10-16 09:49:31.70 spid77 ***Stack Dump being sent to G:\CDW_EUR_PROD\LOG\SQLDump0214.txt

    2009-10-16 09:49:31.70 spid77 SqlDumpExceptionHandler: Process 9964 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

    2009-10-16 09:49:31.70 spid77 * *******************************************************************************

    2009-10-16 09:49:31.70 spid77 *

    2009-10-16 09:49:31.70 spid77 * BEGIN STACK DUMP:

    2009-10-16 09:49:31.71 spid77 * 10/16/09 09:49:31 spid 77

    2009-10-16 09:49:31.71 spid77 *

    2009-10-16 09:49:31.71 spid77 *

    2009-10-16 09:49:31.71 spid77 * Exception Address = 0000000002216E1F Module(sqlservr+0000000001216E1F)

    2009-10-16 09:49:31.71 spid77 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

    2009-10-16 09:49:31.71 spid77 * Access Violation occurred reading address 000000008155DEE4

    2009-10-16 09:49:31.71 spid77 * Input Buffer 510 bytes -

    2009-10-16 09:49:31.71 spid77 * SELECT DIM_Business_Unit.BusinessUnitCD+AccountNo+ContactID '

    2009-10-16 09:49:31.71 spid77 * ContactUnique', MAX(DIM_Date.Fulldate) LatestOrderDate, sum(case

    2009-10-16 09:49:31.71 spid77 * when OrderChannelCD = 'P' then 1 else 0 end) EPROC, sum(case when O

    2009-10-16 09:49:31.71 spid77 * rderChannelCD = 'E' then 1 else 0 end) EDI, sum(case when OrderChann

    2009-10-16 09:49:31.71 spid77 * elCD = 'W' then 1 else 0 end) WEB FROM FACT_Shipment_Invoice_Line I

    2009-10-16 09:49:31.71 spid77 * NNER JOIN DIM_Business_Unit ONFACT_Shipment_Invoice_Line.BusinessUnit

    2009-10-16 09:49:31.71 spid77 * Key=DIM_Business_Unit.BusinessUnitKey INNER JOIN DIM_Account ONFACT_

    2009-10-16 09:49:31.71 spid77 * Shipment_Invoice_Line.AccountKey=DIM_Account.AccountKey INNER JOIN DIM

    2009-10-16 09:49:31.71 spid77 * _Contact ONFACT_Shipment_Invoice_Line.ContactKey=DIM_Contact.ContactK

    2009-10-16 09:49:31.71 spid77 * ey INNER JOIN DIM_Date ONFACT_Shipment_Invoice_Line.PostedDTKey=DIM

    2009-10-16 09:49:31.71 spid77 * _Date.DateKey INNER JOIN DIM_Invoice_Info ONFACT_Shipment_Invoice_L

    2009-10-16 09:49:31.71 spid77 * ine.InvoiceInfoKey=DIM_Invoice_Info.InvoiceInfoKey WHERE [PF-Company

    2009-10-16 09:49:31.71 spid77 * ]= 'Farnell Europe' AND DIM_Date.DateKey > 20090620 AND BillingTransa

    2009-10-16 09:49:31.71 spid77 * ctionType = 'INVOICE' AND ContactID <> '0' AND AccountManager <> 'PRO

    2009-10-16 09:49:31.71 spid77 * DADMIN' GROUP BY DIM_Business_Unit.BusinessUnitCD+AccountNo+ContactI

    2009-10-16 09:49:31.71 spid77 * D

    2009-10-16 09:49:31.71 spid77 *

    2009-10-16 09:49:31.71 spid77 *

    2009-10-16 09:49:31.71 spid77 * MODULE BASE END SIZE

    2009-10-16 09:49:31.71 spid77 * sqlservr 0000000001000000 0000000003503FFF 02504000

    2009-10-16 09:49:31.71 spid77 * ntdll 0000000077EC0000 0000000077FFAFFF 0013b000

    2009-10-16 09:49:31.71 spid77 * kernel32 0000000077D40000 0000000077EB2FFF 00173000

    2009-10-16 09:49:31.71 spid77 * MSVCR80 0000000078130000 00000000781F8FFF 000c9000

    2009-10-16 09:49:31.71 spid77 * msvcrt 000007FF7FC00000 000007FF7FC85FFF 00086000

    2009-10-16 09:49:31.71 spid77 * MSVCP80 000000007C420000 000000007C528FFF 00109000

    2009-10-16 09:49:31.71 spid77 * ADVAPI32 000007FF7FEE0000 000007FF7FFE5FFF 00106000

    2009-10-16 09:49:31.71 spid77 * RPCRT4 000007FF7FD30000 000007FF7FEC8FFF 00199000

    2009-10-16 09:49:31.71 spid77 * Secur32 000007FF7E9C0000 000007FF7E9E1FFF 00022000

    2009-10-16 09:49:31.71 spid77 * USER32 0000000077C20000 0000000077D2BFFF 0010c000

    2009-10-16 09:49:31.71 spid77 * GDI32 000007FF7FC90000 000007FF7FD2BFFF 0009c000

    2009-10-16 09:49:31.71 spid77 * CRYPT32 000007FF7D370000 000007FF7D4CEFFF 0015f000

    2009-10-16 09:49:31.71 spid77 * MSASN1 000007FF7D340000 000007FF7D36BFFF 0002c000

    2009-10-16 09:49:31.71 spid77 * MSWSOCK 000007FF771B0000 000007FF7722CFFF 0007d000

    2009-10-16 09:49:31.71 spid77 * WS2_32 000007FF77310000 000007FF7733FFFF 00030000

    2009-10-16 09:49:31.71 spid77 * WS2HELP 000007FF77140000 000007FF7714BFFF 0000c000

    2009-10-16 09:49:31.71 spid77 * USERENV 000007FF7C680000 000007FF7C789FFF 0010a000

    2009-10-16 09:49:31.71 spid77 * opends60 00000000333E0000 00000000333E7FFF 00008000

    2009-10-16 09:49:31.71 spid77 * NETAPI32 000007FF77370000 000007FF77408FFF 00099000

    2009-10-16 09:49:31.71 spid77 * SHELL32 000007FF7F190000 000007FF7FB9AFFF 00a0b000

    2009-10-16 09:49:31.71 spid77 * SHLWAPI 000007FF7EF60000 000007FF7EFFAFFF 0009b000

    2009-10-16 09:49:31.71 spid77 * IMM32 000007FF7D500000 000007FF7D538FFF 00039000

    2009-10-16 09:49:31.71 spid77 * comctl32 000007FF7F000000 000007FF7F186FFF 00187000

    2009-10-16 09:49:31.71 spid77 * hipi 0000000065A50000 0000000065A80FFF 00031000

    2009-10-16 09:49:31.71 spid77 * PSAPI 000007FF7E380000 000007FF7E38FFFF 00010000

    2009-10-16 09:49:31.71 spid77 * VERSION 000007FF7FBF0000 000007FF7FBFAFFF 0000b000

    2009-10-16 09:49:31.71 spid77 * HIPIS0e011aa 0000000064200000 000000006420EFFF 0000f000

    2009-10-16 09:49:31.71 spid77 * HIPQA 000000006AF70000 000000006AF80FFF 00011000

    2009-10-16 09:49:31.71 spid77 * ole32 000007FF57140000 000007FF573C4FFF 00285000

    2009-10-16 09:49:31.71 spid77 * HcApi 0000000180000000 0000000180011FFF 00012000

    2009-10-16 09:49:31.71 spid77 * instapi 0000000048060000 000000004806CFFF 0000d000

    2009-10-16 09:49:31.71 spid77 * sqlevn70 000000004F610000 000000004F7B8FFF 001a9000

    2009-10-16 09:49:31.71 spid77 * SQLOS 00000000344D0000 00000000344D5FFF 00006000

    2009-10-16 09:49:31.71 spid77 * rsaenh 0000000068000000 000000006804BFFF 0004c000

    2009-10-16 09:49:31.71 spid77 * AUTHZ 000007FF7E490000 000007FF7E4BDFFF 0002e000

    2009-10-16 09:49:31.71 spid77 * MSCOREE 000006427EE50000 000006427EEC3FFF 00074000

    2009-10-16 09:49:31.71 spid77 * msv1_0 000007FF7E500000 000007FF7E544FFF 00045000

    2009-10-16 09:49:31.71 spid77 * cryptdll 000007FF7DC90000 000007FF7DC9EFFF 0000f000

    2009-10-16 09:49:31.71 spid77 * iphlpapi 000007FF57040000 000007FF57070FFF 00031000

    2009-10-16 09:49:31.71 spid77 * kerberos 000007FF77410000 000007FF774C4FFF 000b5000

    2009-10-16 09:49:31.71 spid77 * schannel 000007FF7DD50000 000007FF7DD91FFF 00042000

    2009-10-16 09:49:31.71 spid77 * COMRES 000007FF7EAF0000 000007FF7EBB5FFF 000c6000

    2009-10-16 09:49:31.71 spid77 * XOLEHLP 000007FF5C5B0000 000007FF5C5B6FFF 00007000

    2009-10-16 09:49:31.71 spid77 * MSDTCPRX 000007FF67140000 000007FF67213FFF 000d4000

    2009-10-16 09:49:31.71 spid77 * OLEAUT32 000007FF7EBC0000 000007FF7ECD5FFF 00116000

    2009-10-16 09:49:31.71 spid77 * msvcp60 000000000DAE0000 000000000DBC9FFF 000ea000

    2009-10-16 09:49:31.71 spid77 * MTXCLU 000007FF7B540000 000007FF7B569FFF 0002a000

    2009-10-16 09:49:31.71 spid77 * WSOCK32 000007FF770F0000 000007FF770F9FFF 0000a000

    2009-10-16 09:49:31.71 spid77 * CLUSAPI 000007FF7B3A0000 000007FF7B3C3FFF 00024000

    2009-10-16 09:49:31.71 spid77 * RESUTILS 000007FF7B310000 000007FF7B32BFFF 0001c000

    2009-10-16 09:49:31.71 spid77 * DNSAPI 000007FF7E8F0000 000007FF7E93DFFF 0004e000

    2009-10-16 09:49:31.71 spid77 * winrnr 000007FF7E9F0000 000007FF7E9FAFFF 0000b000

    2009-10-16 09:49:31.71 spid77 * WLDAP32 000007FF7E950000 000007FF7E9B5FFF 00066000

    2009-10-16 09:49:31.71 spid77 * rasadhlp 000007FF7EA00000 000007FF7EA06FFF 00007000

    2009-10-16 09:49:31.71 spid77 * hnetcfg 000007FF6D200000 000007FF6D292FFF 00093000

    2009-10-16 09:49:31.71 spid77 * wshtcpip 000007FF77170000 000007FF7717AFFF 0000b000

    2009-10-16 09:49:31.71 spid77 * security 000007FF77530000 000007FF77534FFF 00005000

    2009-10-16 09:49:31.71 spid77 * msfte 0000000049980000 0000000049D2DFFF 003ae000

    2009-10-16 09:49:31.71 spid77 * dbghelp 0000000010610000 000000001076CFFF 0015d000

    2009-10-16 09:49:31.71 spid77 * WINTRUST 000007FF7E3E0000 000007FF7E42DFFF 0004e000

    2009-10-16 09:49:31.71 spid77 * imagehlp 000007FF7E470000 000007FF7E482FFF 00013000

    2009-10-16 09:49:31.71 spid77 * dssenh 0000000068100000 000000006813EFFF 0003f000

    2009-10-16 09:49:31.71 spid77 * NTMARTA 000007FF7E4C0000 000007FF7E4FBFFF 0003c000

    2009-10-16 09:49:31.71 spid77 * SAMLIB 000007FF77150000 000007FF77165FFF 00016000

    2009-10-16 09:49:31.71 spid77 * ntdsapi 000007FF7DCB0000 000007FF7DCD3FFF 00024000

    2009-10-16 09:49:31.71 spid77 * xpsp2res 0000000010C00000 0000000010EC6FFF 002c7000

    2009-10-16 09:49:31.71 spid77 * CLBCatQ 000007FF7EA10000 000007FF7EAEDFFF 000de000

    2009-10-16 09:49:31.71 spid77 * sqlncli 00000000337A0000 0000000033A63FFF 002c4000

    2009-10-16 09:49:31.71 spid77 * COMCTL32 000007FF76200000 000007FF762EEFFF 000ef000

    2009-10-16 09:49:31.71 spid77 * comdlg32 000007FF7D540000 000007FF7D5B6FFF 00077000

    2009-10-16 09:49:31.71 spid77 * SQLNCLIR 0000000035000000 0000000035032FFF 00033000

    2009-10-16 09:49:31.71 spid77 * msftepxy 0000000003850000 0000000003870FFF 00021000

    2009-10-16 09:49:31.71 spid77 * xpstar90 0000000053C30000 0000000053CB5FFF 00086000

    2009-10-16 09:49:31.71 spid77 * SQLSCM90 0000000053AD0000 0000000053ADBFFF 0000c000

    2009-10-16 09:49:31.71 spid77 * ODBC32 000007FF63F00000 000007FF63F66FFF 00067000

    2009-10-16 09:49:31.71 spid77 * BatchParser90 00000000520C0000 00000000520ECFFF 0002d000

    2009-10-16 09:49:31.71 spid77 * ATL80 000000007C630000 000000007C64EFFF 0001f000

    2009-10-16 09:49:31.71 spid77 * odbcint 000007FF63DC0000 000007FF63DD7FFF 00018000

    2009-10-16 09:49:31.71 spid77 * xpstar90 0000000013390000 00000000133B5FFF 00026000

    2009-10-16 09:49:31.71 spid77 * xpsqlbot 000000004A7C0000 000000004A7C7FFF 00008000

    2009-10-16 09:49:31.71 spid77 * xplog70 0000000034730000 000000003473FFFF 00010000

    2009-10-16 09:49:31.71 spid77 * xplog70 0000000013420000 0000000013422FFF 00003000

    2009-10-16 09:49:31.71 spid77 * msxmlsql 0000000078800000 0000000078967FFF 00168000

    2009-10-16 09:49:31.71 spid77 * msxml3 000007FF56D40000 000007FF56F53FFF 00214000

    2009-10-16 09:49:31.71 spid77 * xpSLS 000000000F210000 000000000F3A3FFF 00194000

    2009-10-16 09:49:31.71 spid77 * sqlvdi 0000000034510000 000000003453BFFF 0002c000

    2009-10-16 09:49:31.71 spid77 *

    2009-10-16 09:49:31.71 spid77 * P1Home: FFFFFADCDB5C5E50:

    2009-10-16 09:49:31.71 spid77 * P2Home: 0000000015EBE5D0: FFFFFADCDB5C5E50 0000000015EBE5D0 0000000000000001 0000000393E50DB0 84000000000001FF FFFFFADD1B5E2F80

    2009-10-16 09:49:31.71 spid77 * P3Home: 0000000000000001:

    2009-10-16 09:49:31.71 spid77 * P4Home: 0000000393E50DB0: 0000000000000000 0000000393C661D8 0000000393E5A790 0036003500330039 0000000393E51810 006500700073006E

    2009-10-16 09:49:31.73 spid77 * P5Home: 84000000000001FF:

    2009-10-16 09:49:31.73 spid77 * P6Home: FFFFFADD1B5E2F80:

    2009-10-16 09:49:31.73 spid77 * ContextFlags: 000000000010001F:

    2009-10-16 09:49:31.73 spid77 * MxCsr: 0000000000001FA0:

    2009-10-16 09:49:31.73 spid77 * SegCs: 0000000000000033:

    2009-10-16 09:49:31.73 spid77 * SegDs: 000000000000002B:

    2009-10-16 09:49:31.73 spid77 * SegEs: 000000000000002B:

    2009-10-16 09:49:31.73 spid77 * SegFs: 0000000000000053:

    2009-10-16 09:49:31.73 spid77 * SegGs: 000000000000002B:

    2009-10-16 09:49:31.73 spid77 * SegSs: 000000000000002B:

    2009-10-16 09:49:31.73 spid77 * EFlags: 0000000000010246: 0074007400650053 00730067006E0069 006C006C0041005C 0065007300550020 0041005C00730072 0069006C00700070

    2009-10-16 09:49:31.73 spid77 * Rax: 000000008155DD50:

    2009-10-16 09:49:31.73 spid77 * Rcx: 0000000000000000:

    2009-10-16 09:49:31.73 spid77 * Rdx: 0000000000000000:

    2009-10-16 09:49:31.73 spid77 * Rbx: 0000000000000001:

    2009-10-16 09:49:31.73 spid77 * Rsp: 0000000015EBEB70: 0000000015EBEBC8 00A4236100000000 00012E3C3469C750 0000000000EF8080 0000000000000000 00012E3C3469C640

    2009-10-16 09:49:31.73 spid77 * Rbp: 0000000393E50DB0: 0000000000000000 0000000393C661D8 0000000393E5A790 0036003500330039 0000000393E51810 006500700073006E

    2009-10-16 09:49:31.73 spid77 * Rsi: 0000000000000000:

    2009-10-16 09:49:31.73 spid77 * Rdi: 0000000000000000:

    2009-10-16 09:49:31.73 spid77 * R8: 000000018155DD50: 0000000081550001 0000000000000000 0000000000000000 0000000000000000 0000000000000031 000000018155CCB0

    2009-10-16 09:49:31.73 spid77 * R9: 0000000393C66228: FF00000000000000 0000000000000000 0000000393E50DB0 0000000000000000 0000000000000000 0000000000000000

    2009-10-16 09:49:31.73 spid77 * R10: 000000000100C980: 2444C74868EC8348 5C8948FFFFFFFE30 4858246C89486024 247C894850247489 8B48402464894C48 0FD28548F98B48DA

    2009-10-16 09:49:31.73 spid77 * R11: 0000000015EBEDD8: 0000000000000000 00000000FFFFFFFF 0000000300000000 0000000000000000 00000000FFFFFFFF 0000000300000000

    2009-10-16 09:49:31.73 spid77 * R12: 000000018155DD50: 0000000081550001 0000000000000000 0000000000000000 0000000000000000 0000000000000031 000000018155CCB0

    2009-10-16 09:49:31.73 spid77 * R13: 0000000015EBEE50: 0000000000000000 0000000393E54ED0 FFFFFFFFFFFFFFFE 0000000393E5CA30 FFFFFFFFFFFFFFFE 0000000001348792

    2009-10-16 09:49:31.73 spid77 * R14: 0000000012A04580: 0000000212A00000 0000000000000008 0000026300000000 0000000012A04080 000000018155E300 000000018155C2B0

    2009-10-16 09:49:31.73 spid77 * R15: 0000000000000002:

    2009-10-16 09:49:31.73 spid77 * Rip: 0000000002216E1F: 848900000194808B 548D480000018024 FB07E8C88B497824 485024448948FEE7 1374187D3B66E88B 01DCB58B187D8B66

    2009-10-16 09:49:31.73 spid77 * *******************************************************************************

    2009-10-16 09:49:31.73 spid77 * -------------------------------------------------------------------------------

    2009-10-16 09:49:31.73 spid77 * Short Stack Dump

    2009-10-16 09:49:31.73 spid77 0000000002216E1F Module(sqlservr+0000000001216E1F)

    2009-10-16 09:49:31.73 spid77 0000000002225DA0 Module(sqlservr+0000000001225DA0)

    2009-10-16 09:49:31.73 spid77 0000000002225F1A Module(sqlservr+0000000001225F1A)

    2009-10-16 09:49:31.73 spid77 0000000002225FFE Module(sqlservr+0000000001225FFE)

    2009-10-16 09:49:31.73 spid77 00000000017C438E Module(sqlservr+00000000007C438E)

    2009-10-16 09:49:31.73 spid77 0000000001368D6C Module(sqlservr+0000000000368D6C)

    2009-10-16 09:49:31.73 spid77 0000000001352E3B Module(sqlservr+0000000000352E3B)

    2009-10-16 09:49:31.73 spid77 0000000001CA8B7D Module(sqlservr+0000000000CA8B7D)

    2009-10-16 09:49:31.73 spid77 00000000014A126D Module(sqlservr+00000000004A126D)

    2009-10-16 09:49:31.73 spid77 0000000001367722 Module(sqlservr+0000000000367722)

    2009-10-16 09:49:31.73 spid77 0000000001367AAC Module(sqlservr+0000000000367AAC)

    2009-10-16 09:49:31.73 spid77 0000000001367B5F Module(sqlservr+0000000000367B5F)

    2009-10-16 09:49:31.73 spid77 0000000001028A0D Module(sqlservr+0000000000028A0D)

    2009-10-16 09:49:31.73 spid77 0000000001340864 Module(sqlservr+0000000000340864)

    2009-10-16 09:49:31.73 spid77 00000000013407C4 Module(sqlservr+00000000003407C4)

    2009-10-16 09:49:31.73 spid77 0000000001340434 Module(sqlservr+0000000000340434)

    2009-10-16 09:49:31.73 spid77 0000000001340FC6 Module(sqlservr+0000000000340FC6)

    2009-10-16 09:49:31.73 spid77 00000000010079FE Module(sqlservr+00000000000079FE)

    2009-10-16 09:49:31.73 spid77 0000000001008362 Module(sqlservr+0000000000008362)

    2009-10-16 09:49:31.73 spid77 0000000001007DA1 Module(sqlservr+0000000000007DA1)

    2009-10-16 09:49:31.73 spid77 00000000014787A7 Module(sqlservr+00000000004787A7)

    2009-10-16 09:49:31.73 spid77 00000000014789CA Module(sqlservr+00000000004789CA)

    2009-10-16 09:49:31.73 spid77 0000000001478911 Module(sqlservr+0000000000478911)

    2009-10-16 09:49:31.74 spid77 00000000014795D9 Module(sqlservr+00000000004795D9)

    2009-10-16 09:49:31.74 spid77 00000000781337D7 Module(MSVCR80+00000000000037D7)

    2009-10-16 09:49:31.74 spid77 0000000078133894 Module(MSVCR80+0000000000003894)

    2009-10-16 09:49:31.74 spid77 0000000077D6B71A Module(kernel32+000000000002B71A)

    2009-10-16 09:49:31.82 spid77 Stack Signature for the dump is 0x000000016A19D0EF

    I restarted the SQL Server service and the query ran through fine. This has not happend before but I'm a little worried there may be an underlying issue and may rear its ugly head again.

    Any ideas?

    Cheers

    Chris

  • Are you able to run a memcheck on this server? Could be a memory issue?

    Also who many CPU's do you have on this SQL server? What is your MAXDOP set too?

  • Do you have PAGE_VERIFICATION on the database? Seems to me a page was corrupt and with the restart repaired.

    Looking at the query though, I would rewrite it to this. Doing the join conditions in the WHERE clause isn't the best solution, and can lead to cartesian products more easily. SELECT DBU.BusinessUnitCD + AccountNo + ContactID 'ContactUnique'

    , MAX(DD.Fulldate) LatestOrderDate

    , SUM(CASE WHEN OrderChannelCD = 'P' THEN 1

    ELSE 0

    END) EPROC

    , SUM(CASE WHEN OrderChannelCD = 'E' THEN 1

    ELSE 0

    END) EDI

    , SUM(CASE WHEN OrderChannelCD = 'W' THEN 1

    ELSE 0

    END) WEB

    FROM FACT_Shipment_Invoice_Line SIL

    , DIM_Account DA

    INNER JOIN DIM_Business_Unit DBU ON SIL.BusinessUnitKey = DBU.BusinessUnitKey

    AND SIL.AccountKey = DBU.AccountKey

    INNER JOIN DIM_Contact DC ON SIL.ContactKey = DC.ContactKey

    INNER JOIN DIM_Invoice_Info DI ON SIL.InvoiceInfoKey = DI.InvoiceInfoKey

    INNER JOIN DIM_Date DD ON SIL.PostedDTKey = DD.DateKey

    WHERE [PF-Company] = 'Farnell Europe'

    AND DD.DateKey > 20070620

    AND BillingTransactionType = 'INVOICE'

    AND ContactID <> '0'

    AND AccountManager <> 'PRODADMIN'

    GROUP BY DBU.BusinessUnitCD + AccountNo + ContactID

    Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2

  • Thanks for the replies.

    Ronald - I have already rewritten the query for him but posted the query that generated the error.

    If the error re-occurs I will some diagnostics on the database.

    Cheers

    Chris

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

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