December 11, 2008 at 5:42 pm
hi,
I got this below error, when large document are dumped in sharepoint. Sharepoint databases are stored in Sql server 2005. I found this hotfix http://support.microsoft.com/kb/916086. But when some data is dumped in share point is it ctreate temporary tables? and work around is Disable the Auto Create Statistics option and the Auto Update Statistics option in the tempdb database.
So can I install hotfix or the workaround is fine?
2008-12-09 17:54:07.97 spid204 ex_raise2: Exception raised, major=52, minor=43, state=1, severity=22, attempting to create symptom dump
2008-12-09 17:54:07.97 spid204 Using 'dbghelp.dll' version '4.0.5'
2008-12-09 17:54:08.04 spid204 **Dump thread - spid = 204, PSS = 0x0000000166579BB0, EC = 0x0000000166579BC0
2008-12-09 17:54:08.04 spid204 *
2008-12-09 17:54:08.04 spid204 * User initiated stack dump. This is not a server exception dump.
2008-12-09 17:54:08.04 spid204 *
2008-12-09 17:54:08.05 spid204 ***Stack Dump being sent to D:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0002.txt
2008-12-09 17:54:08.05 spid204 * *******************************************************************************
2008-12-09 17:54:08.05 spid204 *
2008-12-09 17:54:08.05 spid204 * BEGIN STACK DUMP:
2008-12-09 17:54:08.05 spid204 * 12/09/08 17:54:08 spid 204
2008-12-09 17:54:08.05 spid204 *
2008-12-09 17:54:08.05 spid204 * ex_raise2: Exception raised, major=52, minor=43, state=1, severity=22
2008-12-09 17:54:08.05 spid204 *
2008-12-09 17:54:08.05 spid204 * Input Buffer 26 bytes -
2008-12-09 17:54:08.05 spid204 * & D o c I 81 01 00 00 00 08 00 26 04 05 44 00 6f 00 63 00 49 00
2008-12-09 17:54:08.05 spid204 * d Ñ J 64 00 d1 04 01 4a 00 00
2008-12-09 17:54:08.05 spid204 *
2008-12-09 17:54:08.05 spid204 *
2008-12-09 17:54:08.05 spid204 * MODULE BASE END SIZE
2008-12-09 17:54:08.07 spid204 * sqlservr 0000000001000000 0000000003501FFF 02502000
2008-12-09 17:54:08.07 spid204 * ntdll 0000000077EC0000 0000000077FF8FFF 00139000
2008-12-09 17:54:08.07 spid204 * kernel32 0000000077D40000 0000000077EB2FFF 00173000
2008-12-09 17:54:08.07 spid204 * MSVCR80 0000000078130000 00000000781F8FFF 000c9000
2008-12-09 17:54:08.07 spid204 * msvcrt 000007FF7FC00000 000007FF7FC85FFF 00086000
2008-12-09 17:54:08.07 spid204 * MSVCP80 000000007C420000 000000007C528FFF 00109000
2008-12-09 17:54:08.07 spid204 * ADVAPI32 000007FF7FEE0000 000007FF7FFE4FFF 00105000
2008-12-09 17:54:08.07 spid204 * RPCRT4 000007FF7FD30000 000007FF7FEC8FFF 00199000
2008-12-09 17:54:08.07 spid204 * Secur32 000007FF7E9C0000 000007FF7E9E1FFF 00022000
2008-12-09 17:54:08.07 spid204 * USER32 0000000077C20000 0000000077D2BFFF 0010c000
2008-12-09 17:54:08.07 spid204 * GDI32 000007FF7FC90000 000007FF7FD2BFFF 0009c000
2008-12-09 17:54:08.07 spid204 * CRYPT32 000007FF7D370000 000007FF7D4CEFFF 0015f000
2008-12-09 17:54:08.07 spid204 * MSASN1 000007FF7D340000 000007FF7D369FFF 0002a000
2008-12-09 17:54:08.07 spid204 * MSWSOCK 000007FF771B0000 000007FF7722CFFF 0007d000
2008-12-09 17:54:08.07 spid204 * WS2_32 000007FF77310000 000007FF7733FFFF 00030000
2008-12-09 17:54:08.07 spid204 * WS2HELP 000007FF77140000 000007FF7714BFFF 0000c000
2008-12-09 17:54:08.07 spid204 * USERENV 000007FF7C680000 000007FF7C789FFF 0010a000
2008-12-09 17:54:08.07 spid204 * opends60 00000000333E0000 00000000333E7FFF 00008000
2008-12-09 17:54:08.07 spid204 * NETAPI32 000007FF77370000 000007FF77407FFF 00098000
2008-12-09 17:54:08.07 spid204 * SHELL32 000007FF7F190000 000007FF7FB9AFFF 00a0b000
2008-12-09 17:54:08.07 spid204 * SHLWAPI 000007FF7EF60000 000007FF7EFFAFFF 0009b000
2008-12-09 17:54:08.07 spid204 * IMM32 000007FF7D500000 000007FF7D538FFF 00039000
2008-12-09 17:54:08.07 spid204 * comctl32 000007FF7F000000 000007FF7F186FFF 00187000
2008-12-09 17:54:08.07 spid204 * psapi 000007FF7E380000 000007FF7E38FFFF 00010000
2008-12-09 17:54:08.07 spid204 * instapi 0000000048060000 000000004806CFFF 0000d000
2008-12-09 17:54:08.07 spid204 * CLUSAPI 000007FF7B3A0000 000007FF7B3C3FFF 00024000
2008-12-09 17:54:08.07 spid204 * ole32 000007FF57140000 000007FF573C4FFF 00285000
2008-12-09 17:54:08.07 spid204 * OLEAUT32 000007FF7EBC0000 000007FF7ECD5FFF 00116000
2008-12-09 17:54:08.07 spid204 * RESUTILS 000007FF7B310000 000007FF7B32BFFF 0001c000
2008-12-09 17:54:08.07 spid204 * sqlevn70 000000004F610000 000000004F7B8FFF 001a9000
2008-12-09 17:54:08.07 spid204 * SQLOS 00000000344D0000 00000000344D5FFF 00006000
2008-12-09 17:54:08.07 spid204 * rsaenh 0000000068000000 000000006804BFFF 0004c000
2008-12-09 17:54:08.07 spid204 * AUTHZ 000007FF7E490000 000007FF7E4BDFFF 0002e000
2008-12-09 17:54:08.07 spid204 * MSCOREE 000006427EE60000 000006427EED3FFF 00074000
2008-12-09 17:54:08.07 spid204 * msv1_0 000007FF7E500000 000007FF7E543FFF 00044000
2008-12-09 17:54:08.07 spid204 * iphlpapi 000007FF57040000 000007FF57070FFF 00031000
2008-12-09 17:54:08.07 spid204 * kerberos 000007FF77410000 000007FF774C3FFF 000b4000
2008-12-09 17:54:08.07 spid204 * cryptdll 000007FF7DC90000 000007FF7DC9EFFF 0000f000
2008-12-09 17:54:08.07 spid204 * schannel 000007FF7DD50000 000007FF7DD90FFF 00041000
2008-12-09 17:54:08.07 spid204 * COMRES 000007FF7EAF0000 000007FF7EBB5FFF 000c6000
2008-12-09 17:54:08.07 spid204 * XOLEHLP 000007FF5C5B0000 000007FF5C5B6FFF 00007000
2008-12-09 17:54:08.07 spid204 * MSDTCPRX 000007FF67140000 000007FF67213FFF 000d4000
2008-12-09 17:54:08.07 spid204 * msvcp60 000000000D860000 000000000D949FFF 000ea000
2008-12-09 17:54:08.07 spid204 * MTXCLU 000007FF7B540000 000007FF7B569FFF 0002a000
2008-12-09 17:54:08.07 spid204 * VERSION 000007FF7FBF0000 000007FF7FBFAFFF 0000b000
2008-12-09 17:54:08.07 spid204 * WSOCK32 000007FF770F0000 000007FF770F9FFF 0000a000
2008-12-09 17:54:08.07 spid204 * DNSAPI 000007FF7E8F0000 000007FF7E93DFFF 0004e000
2008-12-09 17:54:08.07 spid204 * winrnr 000007FF7E9F0000 000007FF7E9FAFFF 0000b000
2008-12-09 17:54:08.07 spid204 * WLDAP32 000007FF7E950000 000007FF7E9B5FFF 00066000
2008-12-09 17:54:08.07 spid204 * rasadhlp 000007FF7EA00000 000007FF7EA06FFF 00007000
2008-12-09 17:54:08.07 spid204 * hnetcfg 000007FF6D200000 000007FF6D292FFF 00093000
2008-12-09 17:54:08.07 spid204 * wshtcpip 000007FF77170000 000007FF7717AFFF 0000b000
2008-12-09 17:54:08.07 spid204 * security 000007FF77530000 000007FF77534FFF 00005000
2008-12-09 17:54:08.07 spid204 * msfte 0000000049980000 0000000049D2DFFF 003ae000
2008-12-09 17:54:08.07 spid204 * dbghelp 0000000010100000 000000001025CFFF 0015d000
2008-12-09 17:54:08.07 spid204 * WINTRUST 000007FF7E3E0000 000007FF7E42DFFF 0004e000
2008-12-09 17:54:08.07 spid204 * imagehlp 000007FF7E470000 000007FF7E482FFF 00013000
2008-12-09 17:54:08.07 spid204 * dssenh 0000000068100000 000000006813EFFF 0003f000
2008-12-09 17:54:08.07 spid204 * NTMARTA 000007FF7E4C0000 000007FF7E4FBFFF 0003c000
2008-12-09 17:54:08.07 spid204 * SAMLIB 000007FF77150000 000007FF77165FFF 00016000
2008-12-09 17:54:08.07 spid204 * ntdsapi 000007FF7DCB0000 000007FF7DCD3FFF 00024000
2008-12-09 17:54:08.07 spid204 * xpsp2res 0000000010880000 0000000010B46FFF 002c7000
2008-12-09 17:54:08.07 spid204 * CLBCatQ 000007FF7EA10000 000007FF7EAEDFFF 000de000
2008-12-09 17:54:08.07 spid204 * sqlncli 00000000337A0000 0000000033A5FFFF 002c0000
2008-12-09 17:54:08.07 spid204 * COMCTL32 000007FF76200000 000007FF762EEFFF 000ef000
2008-12-09 17:54:08.07 spid204 * comdlg32 000007FF7D540000 000007FF7D5B6FFF 00077000
2008-12-09 17:54:08.07 spid204 * SQLNCLIR 0000000035000000 0000000035032FFF 00033000
2008-12-09 17:54:08.07 spid204 * msftepxy 0000000003850000 0000000003870FFF 00021000
2008-12-09 17:54:08.07 spid204 * xpsqlbot 000000004A7C0000 000000004A7C7FFF 00008000
2008-12-09 17:54:08.07 spid204 * xpstar90 0000000053C30000 0000000053CB5FFF 00086000
2008-12-09 17:54:08.07 spid204 * SQLSCM90 0000000053AD0000 0000000053ADBFFF 0000c000
2008-12-09 17:54:08.07 spid204 * ODBC32 000007FF63F00000 000007FF63F66FFF 00067000
2008-12-09 17:54:08.07 spid204 * BatchParser90 00000000520C0000 00000000520ECFFF 0002d000
2008-12-09 17:54:08.07 spid204 * ATL80 000000007C630000 000000007C64DFFF 0001e000
2008-12-09 17:54:08.07 spid204 * odbcint 000007FF63DC0000 000007FF63DD7FFF 00018000
2008-12-09 17:54:08.07 spid204 * xpstar90 0000000014C10000 0000000014C35FFF 00026000
2008-12-09 17:54:08.07 spid204 * xplog70 0000000034730000 000000003473FFFF 00010000
2008-12-09 17:54:08.07 spid204 * xplog70 0000000014C60000 0000000014C62FFF 00003000
2008-12-09 17:54:08.07 spid204 * msxmlsql 0000000078800000 0000000078967FFF 00168000
2008-12-09 17:54:08.07 spid204 * msxml3 000007FF56D40000 000007FF56F53FFF 00214000
2008-12-09 17:54:08.07 spid204 *
2008-12-09 17:54:08.07 spid204 * P1Home: 0000000000000001:
2008-12-09 17:54:08.07 spid204 * P2Home: 00000000136DA370: 0043004200390037 00000000000A0030 0000000000000000 0000000000000000 0000000000000030 0000000000000000
2008-12-09 17:54:08.07 spid204 * P3Home: 0000000000000000:
2008-12-09 17:54:08.07 spid204 * P4Home: 0000000077EF40C2: 00000320249C8B48 0000031824B48B48 0000031024BC8B48 0000030824A48B4C 0000030024AC8B4C 000002F824B48B4C
2008-12-09 17:54:08.07 spid204 * P5Home: 0000000000000000:
2008-12-09 17:54:08.07 spid204 * P6Home: 0000000000000000:
2008-12-09 17:54:08.07 spid204 * ContextFlags: 000000000010000F:
2008-12-09 17:54:08.07 spid204 * MxCsr: 0000000000001FA0:
2008-12-09 17:54:08.07 spid204 * SegCs: 0000000000000033:
2008-12-09 17:54:08.07 spid204 * SegDs: 000000000000002B:
2008-12-09 17:54:08.07 spid204 * SegEs: 000000000000002B:
2008-12-09 17:54:08.07 spid204 * SegFs: 0000000000000053:
2008-12-09 17:54:08.07 spid204 * SegGs: 000000000000002B:
2008-12-09 17:54:08.07 spid204 * SegSs: 000000000000002B:
2008-12-09 17:54:08.07 spid204 * EFlags: 0000000000000206:
2008-12-09 17:54:08.07 spid204 * Rax: 00000000136DA3F8: 0000000077D67D8D 0000000012725E80 0000000000000000 00000000136DA6B0 0000000166579BB0 00000000000042AC
2008-12-09 17:54:08.07 spid204 * Rcx: 00000000136D9F20: 0000000000000001 00000000136DA370 0000000000000000 0000000077EF40C2 0000000000000000 0000000000000000
2008-12-09 17:54:08.07 spid204 * Rdx: 0000000000000000:
2008-12-09 17:54:08.07 spid204 * Rbx: 0000000000000000:
2008-12-09 17:54:08.07 spid204 * Rsp: 00000000136DA400: 0000000012725E80 0000000000000000 00000000136DA6B0 0000000166579BB0 00000000000042AC 0000000000000000
2008-12-09 17:54:08.07 spid204 * Rbp: 00000000FFFFFFFF: 0082000000030100 0000000000000001 0100000000000000 D600280000006900 000001000335E51F 00182C000014A900
2008-12-09 17:54:08.07 spid204 * Rsi: 00000000136DA6B0: 0000000012725E80 00000000010A9080 00000000FFFFFFFE 000000000124E6BB 000000023E2FB160 00000000136DA870
2008-12-09 17:54:08.07 spid204 * Rdi: 0000000166579BB0: 0000000166578B00 0000000000000000 0000000166579BB0 0000000000000000 0000000000000004 0000000166579BD8
2008-12-09 17:54:08.07 spid204 * R8: 0000000000000000:
2008-12-09 17:54:08.07 spid204 * R9: 0000000000000000:
2008-12-09 17:54:08.07 spid204 * R10: 0000000000000000:
2008-12-09 17:54:08.07 spid204 * R11: 00000000136DABF0: 0000000000000001 00000000136DA370 0000000000000000 0000000077EF40C2 0000000000000000 0000000000000000
2008-12-09 17:54:08.07 spid204 * R12: 00000000FFFFFFFF: 0082000000030100 0000000000000001 0100000000000000 D600280000006900 000001000335E51F 00182C000014A900
2008-12-09 17:54:08.07 spid204 * R13: 0000000166579BC0: 0000000166579BB0 0000000000000000 0000000000000004 0000000166579BD8 0000000166579BD8 0000000166579BE8
2008-12-09 17:54:08.07 spid204 * R14: 00000000136DBBC0: 0072005F00780065 0065007300690061 00450020003A0032 0070006500630078 006E006F00690074 0069006100720020
2008-12-09 17:54:08.07 spid204 * R15: 0000000000000001:
2008-12-09 17:54:08.07 spid204 * Rip: 0000000077D67D8D: C3000000C8C48148 15FF984B8D49D233 8699E990FFFD96DF 9090909090900000 834853C08B909090 0C0CEA158B4830EC
2008-12-09 17:54:08.07 spid204 * *******************************************************************************
2008-12-09 17:54:08.07 spid204 * -------------------------------------------------------------------------------
2008-12-09 17:54:08.07 spid204 * Short Stack Dump
2008-12-09 17:54:08.13 spid204 0000000077D67D8D Module(kernel32+0000000000027D8D)
2008-12-09 17:54:08.13 spid204 0000000001D345DE Module(sqlservr+0000000000D345DE)
2008-12-09 17:54:08.13 spid204 0000000001D3F3A9 Module(sqlservr+0000000000D3F3A9)
2008-12-09 17:54:08.13 spid204 0000000001D3FB1B Module(sqlservr+0000000000D3FB1B)
2008-12-09 17:54:08.13 spid204 000000000186689B Module(sqlservr+000000000086689B)
2008-12-09 17:54:08.13 spid204 00000000010E07E2 Module(sqlservr+00000000000E07E2)
2008-12-09 17:54:08.13 spid204 000000000206380C Module(sqlservr+000000000106380C)
2008-12-09 17:54:08.15 spid204 000000000177E28C Module(sqlservr+000000000077E28C)
2008-12-09 17:54:08.15 spid204 0000000001473E66 Module(sqlservr+0000000000473E66)
2008-12-09 17:54:08.16 spid204 00000000020E6C99 Module(sqlservr+00000000010E6C99)
2008-12-09 17:54:08.16 spid204 0000000002665A45 Module(sqlservr+0000000001665A45)
2008-12-09 17:54:08.16 spid204 0000000002666290 Module(sqlservr+0000000001666290)
2008-12-09 17:54:08.16 spid204 00000000027816EF Module(sqlservr+00000000017816EF)
2008-12-09 17:54:08.16 spid204 00000000010A5BEA Module(sqlservr+00000000000A5BEA)
2008-12-09 17:54:08.16 spid204 0000000001070FBE Module(sqlservr+0000000000070FBE)
2008-12-09 17:54:08.16 spid204 0000000001028709 Module(sqlservr+0000000000028709)
2008-12-09 17:54:08.16 spid204 0000000001023EA1 Module(sqlservr+0000000000023EA1)
2008-12-09 17:54:08.16 spid204 0000000001079636 Module(sqlservr+0000000000079636)
2008-12-09 17:54:08.16 spid204 000000000245961F Module(sqlservr+000000000145961F)
2008-12-09 17:54:08.16 spid204 0000000001020C4E Module(sqlservr+0000000000020C4E)
2008-12-09 17:54:08.16 spid204 000000000102F94A Module(sqlservr+000000000002F94A)
2008-12-09 17:54:08.16 spid204 000000000102F375 Module(sqlservr+000000000002F375)
2008-12-09 17:54:08.16 spid204 0000000001030872 Module(sqlservr+0000000000030872)
2008-12-09 17:54:08.16 spid204 0000000001270CE7 Module(sqlservr+0000000000270CE7)
2008-12-09 17:54:08.16 spid204 000000000100685E Module(sqlservr+000000000000685E)
2008-12-09 17:54:08.18 spid204 0000000001006F11 Module(sqlservr+0000000000006F11)
2008-12-09 17:54:08.18 spid204 0000000001006A01 Module(sqlservr+0000000000006A01)
2008-12-09 17:54:08.18 spid204 00000000010EF7A7 Module(sqlservr+00000000000EF7A7)
2008-12-09 17:54:08.18 spid204 00000000010F051A Module(sqlservr+00000000000F051A)
2008-12-09 17:54:08.18 spid204 00000000010F03F1 Module(sqlservr+00000000000F03F1)
2008-12-09 17:54:08.18 spid204 00000000010F0289 Module(sqlservr+00000000000F0289)
2008-12-09 17:54:08.18 spid204 00000000781337D7 Module(MSVCR80+00000000000037D7)
2008-12-09 17:54:08.18 spid204 0000000078133894 Module(MSVCR80+0000000000003894)
2008-12-09 17:54:08.18 spid204 0000000077D6B6DA Module(kernel32+000000000002B6DA)
2008-12-09 17:54:08.22 spid204 * -------------------------------------------------------------------------------
2008-12-09 17:54:08.22 spid204 Stack Signature for the dump is 0x00000001A1B0D2B5
2008-12-09 17:54:14.71 spid204 External dump process return code 0x20000001.
External dump process returned no errors.
2008-12-09 17:54:14.72 spid204 Error: 5243, Severity: 22, State: 1.
2008-12-09 17:54:14.72 spid204 An inconsistency was detected during an internal operation. Please contact technical support. Reference number 8.
plz advice me
December 12, 2008 at 1:06 am
madhu.arda (12/11/2008)
2008-12-09 17:54:14.72 spid204 Error: 5243, Severity: 22, State: 1.2008-12-09 17:54:14.72 spid204 An inconsistency was detected during an internal operation. Please contact technical support. Reference number 8.
I'd suggest you follow the advice in that error and contact Technical Support (Microsoft Customer Support). They're the best people for this kind of problems and they will be able to advise you on hotfixes, etc.
It will cost, but it's probably worth it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply