Forums Neueste Beiträge
 

Fehler bei sp_refreshsqlmodule

12/03/2009 - 11:30 von Lutz Uhlmann | Report spam
Hallo NG!

Beim Nutzen von sp_refreshsqlmodule für eine meiner Prozeduren kommt
folgender Fehler:

EXEC sp_refreshsqlmodule 'schTrans.procCheckTransferDigiPen'

Meldung 0, Ebene 11, Status 0, Zeile 0
Für den aktuellen Befehl ist ein schwerwiegender Fehler aufgetreten. Löschen
Sie eventuelle Ergebnisse.
Meldung 0, Ebene 20, Status 0, Zeile 0
Für den aktuellen Befehl ist ein schwerwiegender Fehler aufgetreten. Löschen
Sie eventuelle Ergebnisse.

Keine Ahnung warum ausgerechnet bei der ...

Das einzige was ich mir vielleicht vorstellen könnte, wàre daß in dieser
eine temp. Tabelle angelegt wird ...

Lutz
 

Lesen sie die antworten

#1 Lutz Uhlmann
12/03/2009 - 11:47 | Warnen spam
Meldung 0, Ebene 11, Status 0, Zeile 0
Für den aktuellen Befehl ist ein schwerwiegender Fehler aufgetreten.
Löschen Sie eventuelle Ergebnisse.
Meldung 0, Ebene 20, Status 0, Zeile 0
Für den aktuellen Befehl ist ein schwerwiegender Fehler aufgetreten.
Löschen Sie eventuelle Ergebnisse.



Hier noch ein Auszug aus dem Server-Log

2009-03-12 11:41:44.25 spid64 Using 'dbghelp.dll' version '4.0.5'
2009-03-12 11:41:44.25 spid64 ***Stack Dump being sent to C:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0015.txt
2009-03-12 11:41:44.25 spid64 SqlDumpExceptionHandler: Process 64
generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.
2009-03-12 11:41:44.25 spid64 *
*******************************************************************************
2009-03-12 11:41:44.25 spid64 *
2009-03-12 11:41:44.25 spid64 * BEGIN STACK DUMP:
2009-03-12 11:41:44.25 spid64 * 03/12/09 11:41:44 spid 64
2009-03-12 11:41:44.25 spid64 *
2009-03-12 11:41:44.25 spid64 *
2009-03-12 11:41:44.25 spid64 * Exception Address = 00000000023F3194
Module(sqlservr+00000000013F3194)
2009-03-12 11:41:44.25 spid64 * Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION
2009-03-12 11:41:44.25 spid64 * Access Violation occurred reading
address 000000010000000F
2009-03-12 11:41:44.25 spid64 * Input Buffer 150 bytes -
2009-03-12 11:41:44.25 spid64 * EXEC sp_refreshsqlmodule
'schTrans.procTransferCheckDigiPen
2009-03-12 11:41:44.25 spid64 * '
2009-03-12 11:41:44.25 spid64 *
2009-03-12 11:41:44.25 spid64 *
2009-03-12 11:41:44.25 spid64 * MODULE BASE
END SIZE
2009-03-12 11:41:44.25 spid64 * sqlservr
0000000001000000 0000000003651FFF 02652000
2009-03-12 11:41:44.25 spid64 * ntdll
0000000076DA0000 0000000076F1FFFF 00180000
2009-03-12 11:41:44.25 spid64 * kernel32
0000000076BA0000 0000000076CCAFFF 0012b000
2009-03-12 11:41:44.25 spid64 * MSVCR80
0000000074DA0000 0000000074E68FFF 000c9000
2009-03-12 11:41:44.25 spid64 * msvcrt
000007FEFD6F0000 000007FEFD78BFFF 0009c000
2009-03-12 11:41:44.25 spid64 * MSVCP80
0000000074100000 0000000074208FFF 00109000
2009-03-12 11:41:44.25 spid64 * ADVAPI32
000007FEFEDC0000 000007FEFEEC7FFF 00108000
2009-03-12 11:41:44.25 spid64 * RPCRT4
000007FEFEF60000 000007FEFF09EFFF 0013f000
2009-03-12 11:41:44.25 spid64 * sqlos
00000000344D0000 00000000344D6FFF 00007000
2009-03-12 11:41:44.25 spid64 * Secur32
000007FEFD340000 000007FEFD35BFFF 0001c000
2009-03-12 11:41:44.25 spid64 * USERENV
000007FEFD360000 000007FEFD385FFF 00026000
2009-03-12 11:41:44.25 spid64 * USER32
0000000076CD0000 0000000076D9CFFF 000cd000
2009-03-12 11:41:44.25 spid64 * GDI32
000007FEFD7F0000 000007FEFD852FFF 00063000
2009-03-12 11:41:44.25 spid64 * WINMM
000007FEFB300000 000007FEFB338FFF 00039000
2009-03-12 11:41:44.25 spid64 * ole32
000007FEFEBB0000 000007FEFED87FFF 001d8000
2009-03-12 11:41:44.25 spid64 * OLEAUT32
000007FEFDAE0000 000007FEFDBB2FFF 000d3000
2009-03-12 11:41:44.25 spid64 * OLEACC
000007FEFB350000 000007FEFB39EFFF 0004f000
2009-03-12 11:41:44.25 spid64 * opends60
00000000333E0000 00000000333E7FFF 00008000
2009-03-12 11:41:44.25 spid64 * NETAPI32
000007FEFCF00000 000007FEFCFA2FFF 000a3000
2009-03-12 11:41:44.25 spid64 * PSAPI
0000000076F20000 0000000076F28FFF 00009000
2009-03-12 11:41:44.25 spid64 * IMM32
000007FEFED90000 000007FEFEDBCFFF 0002d000
2009-03-12 11:41:44.25 spid64 * MSCTF
000007FEFEAA0000 000007FEFEBA0FFF 00101000
2009-03-12 11:41:44.25 spid64 * LPK
000007FEFD860000 000007FEFD86CFFF 0000d000
2009-03-12 11:41:44.25 spid64 * USP10
000007FEFE820000 000007FEFE8B9FFF 0009a000
2009-03-12 11:41:44.25 spid64 * instapi
0000000048060000 000000004806CFFF 0000d000
2009-03-12 11:41:44.25 spid64 * cscapi
000007FEF9C10000 000007FEF9C1DFFF 0000e000
2009-03-12 11:41:44.25 spid64 * sqlevn70
000000004F610000 000000004F814FFF 00205000
2009-03-12 11:41:44.25 spid64 * sqlevn70
0000000003EB0000 0000000004058FFF 001a9000
2009-03-12 11:41:44.25 spid64 * NTMARTA
000007FEFC890000 000007FEFC8BBFFF 0002c000
2009-03-12 11:41:44.25 spid64 * WLDAP32
000007FEFE8C0000 000007FEFE914FFF 00055000
2009-03-12 11:41:44.25 spid64 * WS2_32
000007FEFD870000 000007FEFD8B3FFF 00044000
2009-03-12 11:41:44.25 spid64 * NSI
000007FEFE920000 000007FEFE926FFF 00007000
2009-03-12 11:41:44.25 spid64 * SAMLIB
000007FEFCDB0000 000007FEFCDCBFFF 0001c000
2009-03-12 11:41:44.25 spid64 * rsaenh
000007FEFC5A0000 000007FEFC5E6FFF 00047000
2009-03-12 11:41:44.25 spid64 * AUTHZ
000007FEFD2D0000 000007FEFD2F5FFF 00026000
2009-03-12 11:41:44.25 spid64 * MSCOREE
000006427EE50000 000006427EEBFFFF 00070000
2009-03-12 11:41:44.25 spid64 * credssp
000007FEFC9F0000 000007FEFC9F8FFF 00009000
2009-03-12 11:41:44.25 spid64 * CRYPT32
000007FEFCBD0000 000007FEFCD05FFF 00136000
2009-03-12 11:41:44.25 spid64 * MSASN1
000007FEFCD80000 000007FEFCD98FFF 00019000
2009-03-12 11:41:44.25 spid64 * schannel
000007FEFC6D0000 000007FEFC723FFF 00054000
2009-03-12 11:41:44.25 spid64 * msv1_0
000007FEFC990000 000007FEFC9D4FFF 00045000
2009-03-12 11:41:44.25 spid64 * cryptdll
000007FEFCE10000 000007FEFCE23FFF 00014000
2009-03-12 11:41:44.25 spid64 * kerberos
000007FEFC8C0000 000007FEFC965FFF 000a6000
2009-03-12 11:41:44.25 spid64 * COMRES
0000000073F70000 00000000740ACFFF 0013d000
2009-03-12 11:41:44.25 spid64 * security
00000000740B0000 00000000740B3FFF 00004000
2009-03-12 11:41:44.25 spid64 * SHELL32
000007FEFDBC0000 000007FEFE811FFF 00c52000
2009-03-12 11:41:44.25 spid64 * SHLWAPI
000007FEFD8C0000 000007FEFD932FFF 00073000
2009-03-12 11:41:44.25 spid64 * comctl32
000007FEFBD90000 000007FEFBF88FFF 001f9000
2009-03-12 11:41:44.25 spid64 * msfte
0000000049980000 0000000049D2DFFF 003ae000
2009-03-12 11:41:44.25 spid64 * VERSION
000007FEFCB60000 000007FEFCB6AFFF 0000b000
2009-03-12 11:41:44.25 spid64 * dbghelp
00000000721E0000 000000007233CFFF 0015d000
2009-03-12 11:41:44.25 spid64 * WINTRUST
000007FEFC2C0000 000007FEFC2F8FFF 00039000
2009-03-12 11:41:44.25 spid64 * imagehlp
000007FEFD6D0000 000007FEFD6E6FFF 00017000
2009-03-12 11:41:44.25 spid64 * ncrypt
000007FEFCA50000 000007FEFCA91FFF 00042000
2009-03-12 11:41:44.25 spid64 * dssenh
000007FEF98E0000 000007FEF9913FFF 00034000
2009-03-12 11:41:44.25 spid64 * mswsock
000007FEFC810000 000007FEFC85EFFF 0004f000
2009-03-12 11:41:44.25 spid64 * wship6
000007FEFC9E0000 000007FEFC9E6FFF 00007000
2009-03-12 11:41:44.25 spid64 * wshtcpip
000007FEFC4D0000 000007FEFC4D6FFF 00007000
2009-03-12 11:41:44.25 spid64 * ntdsapi
000007FEFCD50000 000007FEFCD75FFF 00026000
2009-03-12 11:41:44.25 spid64 * DNSAPI
000007FEFCDD0000 000007FEFCE08FFF 00039000
2009-03-12 11:41:44.25 spid64 * NLAapi
000007FEFBCD0000 000007FEFBCE2FFF 00013000
2009-03-12 11:41:44.25 spid64 * IPHLPAPI
000007FEFCB70000 000007FEFCB92FFF 00023000
2009-03-12 11:41:44.25 spid64 * dhcpcsvc
000007FEFCAA0000 000007FEFCAE4FFF 00045000
2009-03-12 11:41:44.25 spid64 * WINNSI
000007FEFD1F0000 000007FEFD1F9FFF 0000a000
2009-03-12 11:41:44.25 spid64 * dhcpcsvc6
000007FEFC860000 000007FEFC88AFFF 0002b000
2009-03-12 11:41:44.25 spid64 * napinsp
000007FEFA590000 000007FEFA5A2FFF 00013000
2009-03-12 11:41:44.25 spid64 * pnrpnsp
000007FEFA570000 000007FEFA586FFF 00017000
2009-03-12 11:41:44.25 spid64 * winrnr
000007FEFA690000 000007FEFA69AFFF 0000b000
2009-03-12 11:41:44.25 spid64 * rasadhlp
000007FEFA8A0000 000007FEFA8A7FFF 00008000
2009-03-12 11:41:44.25 spid64 * bcrypt
000007FEFCA00000 000007FEFCA4EFFF 0004f000
2009-03-12 11:41:44.25 spid64 * CLBCatQ
000007FEFDA40000 000007FEFDAD8FFF 00099000
2009-03-12 11:41:44.25 spid64 * sqlncli
00000000337A0000 0000000033A63FFF 002c4000
2009-03-12 11:41:44.25 spid64 * COMCTL32
000007FEFAEE0000 000007FEFAF7FFFF 000a0000
2009-03-12 11:41:44.25 spid64 * comdlg32
000007FEFEED0000 000007FEFEF5BFFF 0008c000
2009-03-12 11:41:44.25 spid64 * SQLNCLIR
0000000035000000 0000000035036FFF 00037000
2009-03-12 11:41:44.25 spid64 * xpsqlbot
000000004A7C0000 000000004A7C7FFF 00008000
2009-03-12 11:41:44.25 spid64 * xpstar90
0000000053C30000 0000000053CB7FFF 00088000
2009-03-12 11:41:44.25 spid64 * SQLSCM90
0000000053AD0000 0000000053ADBFFF 0000c000
2009-03-12 11:41:44.25 spid64 * ODBC32
000007FEF6430000 000007FEF649FFFF 00070000
2009-03-12 11:41:44.25 spid64 * BatchParser90
00000000520C0000 00000000520ECFFF 0002d000
2009-03-12 11:41:44.25 spid64 * ATL80
000000007C630000 000000007C64DFFF 0001e000
2009-03-12 11:41:44.25 spid64 * odbcint
0000000074850000 0000000074887FFF 00038000
2009-03-12 11:41:44.25 spid64 * xpstar90
000000000CF10000 000000000CF36FFF 00027000
2009-03-12 11:41:44.25 spid64 * xplog70
0000000034730000 000000003473FFFF 00010000
2009-03-12 11:41:44.25 spid64 * xplog70
000000000CF50000 000000000CF53FFF 00004000
2009-03-12 11:41:44.25 spid64 * ssdebugps
00000000346C0000 00000000346D2FFF 00013000
2009-03-12 11:41:44.25 spid64 * apphelp
000007FEFD280000 000007FEFD2B4FFF 00035000
2009-03-12 11:41:44.25 spid64 *
2009-03-12 11:41:44.25 spid64 * P1Home: 000000000B72CE00:
00000000C0000005 0000000000000000 00000000023F3194 0000001800000002
0000000000000000 000000010000000F
2009-03-12 11:41:44.25 spid64 * P2Home: 00000000C5562560:
00000000C1F44740 00000000C55626B0 00000000C1F44280 00000000C1F44370
0000000000000000 0000000300000000
2009-03-12 11:41:44.25 spid64 * P3Home: 0000000000000000:
2009-03-12 11:41:44.25 spid64 * P4Home: 0000000001000000:
0000000300905A4D 0000FFFF00000004 00000000000000B8 0000000000000040
0000000000000000 0000000000000000
2009-03-12 11:41:44.25 spid64 * P5Home: FFFFFA8008A61140:
2009-03-12 11:41:44.25 spid64 * P6Home: FFFFFA80095AD860:
2009-03-12 11:41:44.25 spid64 * ContextFlags: 000000000010001F:
2009-03-12 11:41:44.25 spid64 * MxCsr: 0000000000001FA0:
2009-03-12 11:41:44.25 spid64 * SegCs: 0000000000000033:
2009-03-12 11:41:44.25 spid64 * SegDs: 000000000000002B:
2009-03-12 11:41:44.25 spid64 * SegEs: 000000000000002B:
2009-03-12 11:41:44.25 spid64 * SegFs: 0000000000000053:
2009-03-12 11:41:44.25 spid64 * SegGs: 000000000000002B:
2009-03-12 11:41:44.25 spid64 * SegSs: 000000000000002B:
2009-03-12 11:41:44.25 spid64 * EFlags: 0000000000010246:
0000000102580000 0000000102680000 0000000000000000 0000000000000000
0000000000008000 0000000000000000
2009-03-12 11:41:44.25 spid64 * Rax: 00000000C6FAE410:
000000010000000E 0000000B00000001 0000000000000001 0000000100000000
0000000000000000 00000000C6FAE080
2009-03-12 11:41:44.25 spid64 * Rcx: 00000000C1F44370:
0000000001192AF0 0000000000000000 0000000000000000 0000000000000001
0000000000000000 0000000000000000
2009-03-12 11:41:44.25 spid64 * Rdx: 00000000C6FAF3D0:
00000000C6FAEFD0 00000000C6FAE410 00000000C6FAEEC0 00000000C6FAF418
00000000C6FAF638 0010000200000001
2009-03-12 11:41:44.25 spid64 * Rbx: 00000000C5562560:
00000000C1F44740 00000000C55626B0 00000000C1F44280 00000000C1F44370
0000000000000000 0000000300000000
2009-03-12 11:41:44.25 spid64 * Rsp: 000000000B72CED0:
0000000000000000 0000000000000000 0000000000000000 0000000000000000
0000000000000000 0000000000000000
2009-03-12 11:41:44.25 spid64 * Rbp: 00000000C5562560:
00000000C1F44740 00000000C55626B0 00000000C1F44280 00000000C1F44370
0000000000000000 0000000300000000
2009-03-12 11:41:44.25 spid64 * Rsi: 00000000C6FAF3D0:
00000000C6FAEFD0 00000000C6FAE410 00000000C6FAEEC0 00000000C6FAF418
00000000C6FAF638 0010000200000001
2009-03-12 11:41:44.25 spid64 * Rdi: 00000000C1F44370:
0000000001192AF0 0000000000000000 0000000000000000 0000000000000001
0000000000000000 0000000000000000
2009-03-12 11:41:44.25 spid64 * R8: 00000000C6860050:
00000000013A8240 0000000000002000 000A000D0000007A 00000000C68600D0
00000000C0A86880 0000000100000008
2009-03-12 11:41:44.25 spid64 * R9: 00000000FFFFFFFF:
2009-03-12 11:41:44.25 spid64 * R10: 00000000013A7FE0:
0000000001B072C0 0000000001691610 000000000169E130 000000000283A3D0
0000000001B06630 000000000178D560
2009-03-12 11:41:44.25 spid64 * R11: 00000000C4BBC400:
00000000012E5F70 0000000000000001 00000000C4BBC4B0 0000000000000000
0000000000000000 0000000000000000
2009-03-12 11:41:44.25 spid64 * R12: 00000000C6860170:
0000000001247C90 0020002000000000 FFFFFFFE20916D0C 0000000000005141
0000000000000000 0000000000000008
2009-03-12 11:41:44.25 spid64 * R13: 00000000C5562560:
00000000C1F44740 00000000C55626B0 00000000C1F44280 00000000C1F44370
0000000000000000 0000000300000000
2009-03-12 11:41:44.25 spid64 * R14: 00000000C6FAF3D0:
00000000C6FAEFD0 00000000C6FAE410 00000000C6FAEEC0 00000000C6FAF418
00000000C6FAF638 0010000200000001
2009-03-12 11:41:44.25 spid64 * R15: 0000000000000001:
2009-03-12 11:41:44.25 spid64 * Rip: 00000000023F3194:
08888B4810518B41 FFAA267CE8000001 034087C748E88B48 40EB000000000000
4C00000360898B44 8B4800000340818B
2009-03-12 11:41:44.25 spid64 *
*******************************************************************************
2009-03-12 11:41:44.25 spid64
* -
2009-03-12 11:41:44.25 spid64 * Short Stack Dump
2009-03-12 11:41:44.25 spid64 00000000023F3194
Module(sqlservr+00000000013F3194)
2009-03-12 11:41:44.25 spid64 0000000001AD470C
Module(sqlservr+0000000000AD470C)
2009-03-12 11:41:44.25 spid64 00000000017C3A6D
Module(sqlservr+00000000007C3A6D)
2009-03-12 11:41:44.25 spid64 00000000014F6E2D
Module(sqlservr+00000000004F6E2D)
2009-03-12 11:41:44.25 spid64 0000000001576ED5
Module(sqlservr+0000000000576ED5)
2009-03-12 11:41:44.25 spid64 000000000171EBD1
Module(sqlservr+000000000071EBD1)
2009-03-12 11:41:44.25 spid64 000000000170B8EA
Module(sqlservr+000000000070B8EA)
2009-03-12 11:41:44.25 spid64 00000000014CA5DA
Module(sqlservr+00000000004CA5DA)
2009-03-12 11:41:44.25 spid64 00000000029B7B99
Module(sqlservr+00000000019B7B99)
2009-03-12 11:41:44.25 spid64 0000000001836019
Module(sqlservr+0000000000836019)
2009-03-12 11:41:44.25 spid64 00000000017073CE
Module(sqlservr+00000000007073CE)
2009-03-12 11:41:44.25 spid64 0000000001708F59
Module(sqlservr+0000000000708F59)
2009-03-12 11:41:44.25 spid64 000000000170B9C5
Module(sqlservr+000000000070B9C5)
2009-03-12 11:41:44.25 spid64 0000000001839DF5
Module(sqlservr+0000000000839DF5)
2009-03-12 11:41:44.25 spid64 0000000001839FE2
Module(sqlservr+0000000000839FE2)
2009-03-12 11:41:44.25 spid64 00000000018583A0
Module(sqlservr+00000000008583A0)
2009-03-12 11:41:44.25 spid64 00000000017073CE
Module(sqlservr+00000000007073CE)
2009-03-12 11:41:44.25 spid64 0000000001708F59
Module(sqlservr+0000000000708F59)
2009-03-12 11:41:44.25 spid64 000000000170B9C5
Module(sqlservr+000000000070B9C5)
2009-03-12 11:41:44.26 spid64 00000000017053E2
Module(sqlservr+00000000007053E2)
2009-03-12 11:41:44.26 spid64 000000000170A59D
Module(sqlservr+000000000070A59D)
2009-03-12 11:41:44.26 spid64 00000000016BC32E
Module(sqlservr+00000000006BC32E)
2009-03-12 11:41:44.26 spid64 00000000016BC5C9
Module(sqlservr+00000000006BC5C9)
2009-03-12 11:41:44.26 spid64 00000000016B5CC4
Module(sqlservr+00000000006B5CC4)
2009-03-12 11:41:44.26 spid64 000000000155E837
Module(sqlservr+000000000055E837)
2009-03-12 11:41:44.26 spid64 0000000001522F59
Module(sqlservr+0000000000522F59)
2009-03-12 11:41:44.26 spid64 00000000015372B0
Module(sqlservr+00000000005372B0)
2009-03-12 11:41:44.26 spid64 00000000014F72F8
Module(sqlservr+00000000004F72F8)
2009-03-12 11:41:44.26 spid64 0000000074DA37D7
Module(MSVCR80+00000000000037D7)
2009-03-12 11:41:44.27 spid64 0000000074DA3894
Module(MSVCR80+0000000000003894)
2009-03-12 11:41:44.27 spid64 0000000076BC495D
Module(kernel32+000000000002495D)
2009-03-12 11:41:44.27 spid64 0000000076DC8791
Module(ntdll+0000000000028791)
2009-03-12 11:41:44.27 spid64 Stack Signature for the dump is
0x000000000A200327
2009-03-12 11:41:44.74 spid64 External dump process return code
0x20000001.
External dump process returned no errors.

Ähnliche fragen