Thursday, March 22, 2012

Error: 3624, Severity: 20, State: 1.

Dear Sir/Madam,
Hello,
We have a SQL Server 2000 on a remote server in Texas, we send our data over TCP/IP every 3 minutes to SQL Server but from 1 one week ago we found an error on SQL Server so we cannot send data to SQL Server.
Errors are as below:
++++++++++
++++++++++
++++++++++
Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid =3D 52, PSS =3D 0x43b551d8, EC =3D 0x43b55508
*Stack Dump being sent to d:\sql2000
\data\MSSQL\log\SQLDump0459.txt
* ************************************************
*
* BEGIN STACK DUMP:
* 06/06/04 16:58:48 spid 52
*
* *
* s p _ e x e c u 0a 00 73 00 70 00 5f 00 65 00 78 00 65 00 63 00 75 00
* t e & & 74 00 65 00 00 00 00 00 26 04 04 09 00 00 00 00 00 26
* "ي #=AD 04 04 93 ed 05 00 00 00 23 ad 05 00 00 00 00 00 00 00
* =AD بي ي ي ad 05 00 00 d3 d1 e3 d1 = c8 ed 20 ca ed e3 20 e3 e1 ed
* ب با با وي چ 20 = c8 d3 df ca c8 c7 e1 20 c8 c7 20 e6 ed e1 8d d1 20
* با بيا اي ه = و c8 c7 20 c8 ed c7 e4 20 c7 ed e4 20 df e5 20 ca e6 d1
* چها ا به ي e4 e3 e4 = ca 20 8d e5 c7 d1 20 cc c7 e4 c8 e5 9d ed 20
* اي ا يا وبي = ب c7 ed ca c7 e1 ed c7 20 e3 cd df 20 ce e6 c8 ed 20 c8
* اي ا ايي ف ا d1 = c7 ed 20 d4 e4 c7 d3 c7 ed ed 20 e4 dd d1 c7 ca 20
* ا ا ي به پا ا = پي c7 da d2 c7 e3 ed 20 c8 e5 20 81 c7 d1 c7 e1 e3 81 ed
* آ بو ، ف : آ df 20 c2 ca e4 = 20 c8 e6 cf a1 20 90 dd ca 3a 20 c2 90
* اهي وبي ا و = و c7 e5 ed 20 ce e6 c8 ed 20 c7 d2 20 e4 e6 da 20 e6 20
* يوه با ي يفا = d4 ed e6 e5 20 c8 c7 d2 ed 20 cd d1 ed dd c7 e4 20 ce
* و ا پي پي ا e6 cf 20 = cf d1 20 c7 e1 e3 81 ed df 20 81 ed cf c7 20
* ي . غفو ا df d1 cf ed e3 2e 20 = 0d 0a db dd e6 d1 20 df c7 e3 d1
* وا پ ا با ي e6 c7 20 = 81 d3 20 c7 d2 20 c8 c7 d2 90 d4 ca 20 ca ed
* ي ا ابقا چ e3 20 e3 = e1 ed 20 c7 d2 20 e3 d3 c7 c8 de c7 ca 20 8d
* ها ا به ي اي = ا ي e5 c7 d1 20 cc c7 e4 c8 e5 9d ed 20 c7 ed ca c7 e1 ed
* ا به ب ا ي ا c7 20 c8 = e5 20 ce c8 d1 90 d2 c7 d1 ed 20 cf c7 e4 d4
* ويا اي ا (اي = ا cc e6 ed c7 e4 20 c7 ed d1 c7 e4 20 28 c7 ed d3 e4 c7
* )، ف : اي و 29 a1 20 90 dd ca 3a = 20 cf d1 20 c7 ed e4 20 ca e6 d1
* ي هايي چو e4 e3 e4 = ca 20 ca ed e3 9d e5 c7 ed ed 20 8d e6 e4 20
* اي ا يا، قه ا = ا c7 ed ca c7 e1 ed c7 a1 20 de e5 d1 e3 c7 e4 20 c7 d1
* وپا و ف ا ه و = ا پ e6 81 c7 20 e6 20 dd d1 c7 e4 d3 e5 20 e6 20 c7 d3 81
* ا يا ي هاي و = و c7 e4 ed c7 20 ca ed e3 e5 c7 ed 20 d3 e6 e3 20 e6 20
* چها ا وپا 8d e5 c7 = d1 e3 20 c7 d1 e6 81 c7 20 d4 d1 df ca 20 df
* ه بو ه و d1 cf e5 20 c8 e6 cf = e4 cf 20 df e5 20 e6 d1 d2 d4 df
* ا ا اي ي ها ا c7 = d1 c7 e4 20 c7 ed e4 20 ca ed e3 9d e5 c7 20 c7 d2
* اظ ي ي و ا 20 e1 cd c7 d9 = 20 ca df e4 ed df ed 20 e6 20 ca c7 df
* ي ي ب به ي ca ed df ed 20 = e4 d3 c8 ca 20 c8 e5 20 ca ed e3 20 e3
* ا ي ي ب بو . c7 20 ce ed e1 = ed 20 c8 d1 ca d1 20 c8 e6 cf e4 cf 2e
* به و ي ه ب ا 20 c8 e5 = 20 d8 e6 d1 ed 20 df e5 20 cf d1 20 c8 d1 c7
* ب ف ا ه با ا ا c8 = d1 20 dd d1 c7 e4 d3 e5 20 c8 c7 20 c7 ce ca e1 c7
* ف 20 ا يا ، قاب dd = 20 32 30 20 c7 e3 ca ed c7 d2 a1 20 e3 de c7 c8 e1
* ا پا يا با ا = اف 20 c7 d3 81 c7 e4 ed c7 20 c8 c7 20 c7 ce ca e1 c7 dd
* 12 ا يا و 20 31 32 20 c7 e3 ca ed c7 = d2 20 e6 20 cf d1 20 e3 d5
* اف با اي ا يا = با ا c7 dd 20 c8 c7 20 c7 ed ca c7 e1 ed c7 20 c8 c7 20 c7
* اف يا ي با ي = ه ce ca e1 c7 dd 20 d2 ed c7 cf ed 20 c8 c7 d2 ed 9d e5
* ا ا وا ا ي . c7 20 d1 c7 20 = e6 c7 90 d0 c7 d1 20 df d1 cf ed e3 2e
* وي ي : 0d 0a e6 ed 20 ca d5 d1 ed cd 20 = df d1 cf 3a 20 cf d1
* اي و ب اي 20 c7 ed e4 20 = ca e6 d1 e4 e3 e4 ca 20 c8 d1 c7 ed 20
* ي با بو ه e4 ce d3 ca ed = e4 20 c8 c7 d1 20 c8 e6 cf 20 df e5 20
* ب اب يفا ا = وپا c8 d1 c7 c8 d1 20 cd d1 ed dd c7 e4 20 c7 d1 e6 81 c7
* يي ق ا ي ف ي ed ed 20 = de d1 c7 d1 20 e3 ed 9d 90 d1 dd ca ed e3 20
* و به با ي ه e6 20 c8 = e5 20 cf e4 c8 c7 e1 20 e4 ca ed cc e5 20 e4
* بو ي ، ا با ا = ي c8 e6 cf ed e3 a1 20 e1 d0 c7 20 c8 c7 20 c7 d1 d2 ed
* ابي ب با ي = ها c7 c8 ed 20 c8 d3 df ca c8 c7 e1 ed d3 ca 9d e5 c7 20
* ا اظ ا ب ي c7 d2 20 e1 cd = c7 d9 20 df e1 c7 d3 9d c8 e4 cf ed 20
* پ ي، ي ي و ا 81 d2 d4 = df ed a1 20 ca df e4 ed df ed 20 e6 20 ca c7
* ي ي ق ا ي df ca ed df ed 20 de = d5 cf 20 cf c7 d4 ca ed e3 20 ca
* يب ا ي ي ا ب d1 df ed = c8 20 c7 d5 e1 ed 20 ca ed e3 20 d1 c7 20 c8
* اي پا ا پي آ d1 = c7 ed 20 81 c7 d1 c7 e1 e3 81 ed df 20 c2 ca e4 20
* ا ايي ي . ا d4 e4 c7 d3 c7 = ed ed 20 df e4 ed e3 2e 0d 0a df c7 e3
* وا ا ا ه به d1 e6 c7 = 20 cf d1 20 c7 cf c7 e3 e5 20 c8 e5 20 df e3
* بو وي چ هاي = ا ب c8 e6 cf 20 e6 ed e1 8d d1 e5 c7 ed 20 e3 e4 c7 d3 c8
* ا ا ه و اف و 20 c7 d4 = c7 d1 e5 20 df d1 cf 20 e6 20 c7 dd d2 e6 cf
* : ا ا قب ا ا 3a 20 c7 90 d1 = 20 ca c7 20 de c8 e1 20 c7 d2 20 c7 da
* ا به آ وي چ = ها d2 c7 e3 20 c8 e5 20 c2 ca e4 20 e6 ed e1 8d d1 e5 c7
* ي ي ا يا ed 20 e3 cf d1 e4 ed = 20 cf d1 20 c7 ce ca ed c7 d1 20
* ي ق ا ب ي ، ب ca ed e3 = 20 de d1 c7 d1 20 c8 90 ed d1 cf a1 20 c8 d3
* يا ي ا ا و ed c7 d1 ed 20 = c7 d2 20 e3 d4 df e1 c7 ca 20 e6 d1 d2
* ا ا واه d4 df c7 d1 c7 e4 20 = cd e1 20 ce e6 c7 e5 cf 20 d4 cf
* . وي ا ا ه ف 2e 0d 0a e6 ed = 20 cf d1 20 c7 cf c7 e3 e5 20 90 dd ca
* و و و با اي = ا، 9d e6 90 e6 20 ce e6 cf 20 c8 c7 20 c7 ed d3 e4 c7 a1
* ا ي 3 ه 20 c7 d2 20 ca d4 df ed e1 20 33 = 20 e3 d1 cd e1 e5 20
* ا وي آ ا ي ا c7 d1 cf = e6 ed 20 c2 e3 c7 cf 90 ed 20 ca c7 20 d4 d1
* و ابقا پا ا = پ e6 da 20 e3 d3 c7 c8 de c7 ca 20 81 c7 d1 c7 e1 e3 81
* ي آ ب ا و ed df 20 c2 ca e4 20 = ce c8 d1 20 cf c7 cf 20 e6 20 90
* ف : اف اي ق ب dd ca 3a = 20 c7 dd d2 c7 ed d4 20 de cf d1 ca 20 c8 cf
* ي با ي ا ، ا = ها e4 ed 20 c8 c7 d2 ed df e4 c7 e4 a1 20 df c7 d1 e5 c7
* ي ي ي و ف قا ed 20 ca = df e4 ed df ed 20 e6 20 d1 dd da 20 e4 de c7
* ف اه ب ا ه ه d8 20 d6 = da dd 20 c7 e5 e3 20 c8 d1 e4 c7 e3 e5 20 e5
* اي اي ه ا و . c7 ed 20 = c7 ed e4 20 d3 e5 20 c7 d1 cf e6 d3 ca 2e 0d
* ا وا پايا 0a df c7 = e3 d1 e6 c7 20 cf d1 20 81 c7 ed c7 e4 20 ca
* ا ي : ي ا c7 df ed cf 20 df d1 cf 3a = 20 d8 ed 20 e3 d0 c7 df d1
* ا ي ه اي ا يا c7 = ca ed 20 df e5 20 cf d1 20 c7 ed ca c7 e1 ed c7 20
* با وو ا ا پا = يا c8 c7 20 e3 d3 e6 e6 e1 c7 e4 20 c7 d3 81 c7 e4 ed c7
* ا ي ، و 20 cf c7 d4 ca ed e3 a1 20 = cf d1 20 d5 e6 d1 ca 20 e3
* وافق ف ا يو = ا e6 c7 dd de ca 20 dd cf d1 c7 d3 ed e6 e4 20 cc c7 e4
* با ا و و ي ، ق c8 = c7 d2 c7 e4 20 e6 20 e3 da e1 e6 e1 ed e4 a1 20 de
* ب ا با يهاي ا = پ c8 e1 20 c7 d2 20 c8 c7 d2 ed e5 c7 ed 20 c7 e1 e3 81
* ي آ ، و ed df 20 c2 ca e4 a1 20 cf = d1 20 ca e6 d1 e4 e3 e4 ca
* ا پا يا ي 20 c7 d3 81 c7 = e4 ed c7 20 d4 d1 df ca 20 e3 ed 9d df
* ي . ا هاي پيا e4 = ed e3 2e 0d 0a c7 e4 ca e5 c7 ed 20 81 ed c7 e3 00
* # # 00 23 00 00 00 00 00 00 00 00 00 ff ff ff ff 00 00 23
* # 00 00 00 00 00 00 00 00 00 ff ff ff ff 00 00 23 00 00
* o " 00 00 00 00 00 00 00 ff ff ff ff 00 00 6f 08 08 f8 94
* =B1 00 00 d8 1b b1 00
* *
* MODULE BASE END SIZE
* sqlservr 00400000 00B32FFF 00733000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C627FFF 000b8000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7DFFF 0003e000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107BFFF 0000c000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* LPK 6CA60000 6CA67FFF 00008000
* USP10 66650000 666A3FFF 00054000
* sqlevn70 10000000 10006FFF 00007000
* NETAPI32 7A7C0000 7A80EFFF 0004f000
* SECUR32 7C340000 7C34EFFF 0000f000
* NETRAP 7A810000 7A815FFF 00006000
* SAMLIB 7A820000 7A82EFFF 0000f000
* WS2_32 7A830000 7A843FFF 00014000
* WS2HELP 7A850000 7A857FFF 00008000
* WLDAP32 7A860000 7A889FFF 0002a000
* DNSAPI 7A890000 7A8B3FFF 00024000
* WSOCK32 7A8C0000 7A8C7FFF 00008000
* ole32 7AB70000 7AC5EFFF 000ef000
* XOLEHLP 7AC60000 7AC67FFF 00008000
* MSDTCPRX 7AC70000 7AD26FFF 000b7000
* MTXCLU 7AD30000 7AD3FFFF 00010000
* VERSION 7AD40000 7AD46FFF 00007000
* LZ32 7AD50000 7AD55FFF 00006000
* CLUSAPI 7AD60000 7AD6FFFF 00010000
* RESUTILS 7AD70000 7AD7CFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* rnr20 7AD80000 7AD8BFFF 0000c000
* iphlpapi 7AD90000 7ADA2FFF 00013000
* ICMP 7ADB0000 7ADB4FFF 00005000
* MPRAPI 7ADC0000 7ADD6FFF 00017000
* OLEAUT32 7ADE0000 7AE7AFFF 0009b000
* ACTIVEDS 7AE80000 7AEAEFFF 0002f000
* ADSLDPC 7AEB0000 7AED2FFF 00023000
* RTUTILS 7AEE0000 7AEEDFFF 0000e000
* SETUPAPI 7AEF0000 7AF7DFFF 0008e000
* RASAPI32 7AF80000 7AFB2FFF 00033000
* RASMAN 7AFC0000 7AFD0FFF 00011000
* TAPI32 7AFE0000 7B001FFF 00022000
* COMCTL32 7B010000 7B093FFF 00084000
* SHLWAPI 7B0A0000 7B104FFF 00065000
* DHCPCSVC 7B110000 7B128FFF 00019000
* winrnr 7B5D0000 7B5D7FFF 00008000
* rasadhlp 7B5E0000 7B5E4FFF 00005000
* SSNETLIB 7BDA0000 7BDB4FFF 00015000
* NTMARTA 7BE00000 7BE1CFFF 0001d000
* WINSPOOL 7BE20000 7BE3DFFF 0001e000
* MPR 7BE40000 7BE4FFFF 00010000
* NTDSAPI 7BE50000 7BE60FFF 00011000
* security 003F0000 003F3FFF 00004000
* msafd 10450000 1046DFFF 0001e000
* wshtcpip 10470000 10476FFF 00007000
* SSmsLPCn 10500000 10507FFF 00008000
* SSnmPN70 410D0000 410D5FFF 00006000
* rsabase 7CA00000 7CA22FFF 00023000
* CRYPT32 7C740000 7C7C6FFF 00087000
* MSASN1 109A0000 109AFFFF 00010000
* SQLFTQRY 10BD0000 10C01FFF 00032000
* CLBCATQ 10C10000 10C9FFFF 00090000
* sqloledb 10CC0000 10D32FFF 00073000
* MSDART 10D40000 10D5EFFF 0001f000
* comdlg32 10D60000 10D9DFFF 0003e000
* SHELL32 10DA0000 10FE7FFF 00248000
* MSDATL3 10FF0000 11004FFF 00015000
* oledb32 1F8A0000 1F905FFF 00066000
* OLEDB32R 1F910000 1F91FFFF 00010000
* msv1_0 11340000 11360FFF 00021000
* xpstar 410F0000 41136FFF 00047000
* SQLRESLD 42AC0000 42AC6FFF 00007000
* SQLSVC 11370000 11386FFF 00017000
* ODBC32 11390000 113C1FFF 00032000
* odbcbcp 113D0000 113D5FFF 00006000
* W95SCM 41140000 4114BFFF 0000c000
* SQLUNIRL 41090000 410BCFFF 0002d000
* SHFOLDER 113E0000 113E7FFF 00008000
* odbcint 1F850000 1F865FFF 00016000
* NDDEAPI 114F0000 114F6FFF 00007000
* SQLSVC 11500000 11505FFF 00006000
* xpstar 11510000 11518FFF 00009000
* dbghelp 167A0000 16854FFF 000b5000
*
* Edi: 43B55508: 43B551D8 43F7D418 43F7D418 43B19918 43B190C0 43F7C030 * Esi: 00000000: * Eax: 00000000: * Ebx: 43B551D8: 00000034 00000000 01178E38 000094FE 00000000 00000000 * Ecx: 10A2ACDC: 00000000 0001003F 3CFBD11E 00000000 00000000 00000000 * Edx: FFFFFFFF: * Eip: 0087FE8E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B * Ebp: 10A2ACC0: 10A2B4E0 0088199F 43B551D8 10A2B644 10A2B8E7 780238AE * SegCs: 0000001B: * EFlags: 00010246: 00720067 006D0061 00460020 006C0069 00730065 004D005C * Esp: 10A2AC94: 43B55508 00000000 43B551D8 10A2ACDC 43B55000 10A2AC94 * SegSs: 00000023: * ***********************************************************
********************
* ----
--
* Short Stack Dump
* 0087FE8E Module(sqlservr+0047FE8E) (CStackDump::GetContextAndDump+0000002E)
* 0088199F Module(sqlservr+0048199F) (stackTrace+00000223)
* 00935D29 Module(sqlservr+00535D29) (utassert_fail+000002E3)
* 005B483E Module(sqlservr+001B483E) (RecBase::Resize+00000091)
* 004035D7 Module(sqlservr+000035D7) (RecBase::Size+0000000E)
* 0040DD57 Module(sqlservr+0000DD57) (Page::GetRowSize+0000002A)
* 0050C787 Module(sqlservr+0010C787) (DataSplitMgr::MoveRecord+0000002E)
* 0050D18F Module(sqlservr+0010D18F) (DataSplitMgr::RegularSplitPoint+00000099)
* 0043F481 Module(sqlservr+0003F481) (DataSplitMgr::FindSplitPoint+00000046)
* 0043F337 Module(sqlservr+0003F337) (DataSplitMgr::SplitPage+00000022)
* 0043FDD8 Module(sqlservr+0003FDD8) (datasplit+0000002A)
* 004366A7 Module(sqlservr+000366A7) (InsertRowIntoNCIndex+0000027C)
* 004363DD Module(sqlservr+000363DD) (ncupdate+000001FA)
* 00411BBC Module(sqlservr+00011BBC) (rowinsert+0000012E)
* 00412085 Module(sqlservr+00012085) (insert+00000013)
* 00413375 Module(sqlservr+00013375) (RowsetSS::InsertRow+000001F2)
* 00411229 Module(sqlservr+00011229) (CValRow::SetDataX+00000035)
* 00411149 Module(sqlservr+00011149) (SetDataWithPop+0000001C)
* 00411400 Module(sqlservr+00011400) (CEs::GeneralEval+00000088)
* 0042AF91 Module(sqlservr+0002AF91) (CQScanScalarInsert::GetRow+00000035)
* 0043E6F6 Module(sqlservr+0003E6F6) (CQScanNLJoin::GetRow+0000010B)
* 004B341E Module(sqlservr+000B341E) (CQScanAssert::GetRow+0000001B)
* 004110B3 Module(sqlservr+000110B3) (CQueryScan::GetRow+00000014)
* 0041D3EF Module(sqlservr+0001D3EF) (CStmtQuery::ErsqExecuteQuery+00000357)
* 0041E02C Module(sqlservr+0001E02C) (CStmtDML::XretExecuteNormal+000002AE)
* 0041DE5A Module(sqlservr+0001DE5A) (CStmtDML::XretExecute+0000001C)
* 0041C3CB Module(sqlservr+0001C3CB) (CMsqlExecContext::ExecuteStmts+000003B9)
* 0041BA11 Module(sqlservr+0001BA11) (CMsqlExecContext::Execute+000001B6)
* 0041B02D Module(sqlservr+0001B02D) (CSQLSource::Execute+00000357)
* 005F257E Module(sqlservr+001F257E) (SpExecute+00000227)
* 005F4262 Module(sqlservr+001F4262) (CSpecProc::ExecuteSpecial+00000264)
* 005F3D37 Module(sqlservr+001F3D37) (CXProc::Execute+000000A3)
* 005F5F29 Module(sqlservr+001F5F29) (CSQLSource::Execute+000003C0)
* 00437EC6 Module(sqlservr+00037EC6) (execrpc+00000507)
* 00437128 Module(sqlservr+00037128) (execute_rpc+00000019)
* 0042921A Module(sqlservr+0002921A) (process_commands+00000232)
* 41072838 Module(UMS+00002838) (ProcessWorkRequests+00000272)
* 410725B3 Module(UMS+000025B3) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57438B Module(KERNEL32+0000438B) (TlsSetValue+000000F0)
* ----
--
++++++++++
++++++++++
++++++++++
Stack Signature for the dump is 0x8FCB01BD
++++++++++
++++++++++
++++++++++
SQL Server Assertion: File: <R:\sql\ntdbms\storeng\drs\include\record.inl>, line=3D1447 Failed Assertion =3D 'm_SizeRec > 0 && m_SizeRec <=3D MAXDATAROW'.
++++++++++
++++++++++
++++++++++
Error: 3624, Severity: 20, State: 1.
++++++++++
++++++++++
++++++++++
Would you please help me to solve the problem.
Yours Sincerely,
Ahmad RezaYour database is corrputed.
Run DBCC CheckDB
Bojidar Alexandrov
"Ahmad Reza" <anonymous@.discussions.microsoft.com> wrote in message
news:18d8301c44bcc$b70b5000$a101280a@.phx.gbl...
Dear Sir/Madam,
Hello,
We have a SQL Server 2000 on a remote server in Texas, we
send our data over TCP/IP every 3 minutes to SQL Server
but from 1 one week ago we found an error on SQL Server so
we cannot send data to SQL Server.
Errors are as below:

No comments:

Post a Comment