exectuing a .bat from cmdexec

All,
sql 2000 sp3
I have a .bat file at d:\wip\queries.bat, the step succeeds, but there is no
data in the files that I am creating. Below is the contents of the .bat. I
have 'd:\queries.bat' in the cmdexec step. I have verified the odbc
connection, any other ideas would be a great help.
db2cmd /c /w /i db2 +o -tf ds1_query.sql -r d:\wip\ds1_query.txt
db2cmd /c /w /i db2 +o -tf ds2_wrs_ind_employee_db2_query.sql -r
d:\wip\ds2_wrs_ind_employee_db2.txt
db2cmd /c /w /i db2 +o -tf ds3_wrs_clr_employee_db2_query.sql -r
d:\wip\ds3_wrs_clr_employee_db2.txt
db2cmd /c /w /i db2 +o -tf ds4_wrs_client_db2_query.sql -r
d:\wip\ds4_wrs_client_db2.txt
db2cmd /c /w /i db2 +o -tf ds5_wrs_diary_db2_query.sql -r
d:\wip\ds5_wrs_diary_db2.txt
db2cmd /c /w /i db2 +o -tf ds6_wrs_dry_history_db2_query.sql -r
d:\wip\ds6_wrs_dry_history_db2.txt
db2cmd /c /w /i db2 +o -tf ds7_wrs_folder_control_db2_query.sql -r
d:\wip\ds7_wrs_folder_control_db2.txt
--
Thanks,
SnyperSorry, the step does fail. I see it in the appliction log as a failure. I do
not know how to get the .bat to execute properly. Any ideas?
--
Thanks,
Snyper
"snyper" wrote:
> All,
> sql 2000 sp3
> I have a .bat file at d:\wip\queries.bat, the step succeeds, but there is no
> data in the files that I am creating. Below is the contents of the .bat. I
> have 'd:\queries.bat' in the cmdexec step. I have verified the odbc
> connection, any other ideas would be a great help.
> db2cmd /c /w /i db2 +o -tf ds1_query.sql -r d:\wip\ds1_query.txt
> db2cmd /c /w /i db2 +o -tf ds2_wrs_ind_employee_db2_query.sql -r
> d:\wip\ds2_wrs_ind_employee_db2.txt
> db2cmd /c /w /i db2 +o -tf ds3_wrs_clr_employee_db2_query.sql -r
> d:\wip\ds3_wrs_clr_employee_db2.txt
> db2cmd /c /w /i db2 +o -tf ds4_wrs_client_db2_query.sql -r
> d:\wip\ds4_wrs_client_db2.txt
> db2cmd /c /w /i db2 +o -tf ds5_wrs_diary_db2_query.sql -r
> d:\wip\ds5_wrs_diary_db2.txt
> db2cmd /c /w /i db2 +o -tf ds6_wrs_dry_history_db2_query.sql -r
> d:\wip\ds6_wrs_dry_history_db2.txt
> db2cmd /c /w /i db2 +o -tf ds7_wrs_folder_control_db2_query.sql -r
> d:\wip\ds7_wrs_folder_control_db2.txt
> --
> Thanks,
> Snyper|||Snyper
Although i know nothing of the detail of what you are trying to do here ...
If running the indiviual commands are being created but not populted then
perhaps it might be worth looking at it being a permissions error in creating
the information or permisiions on population the file.
when you run one of these commands what permissions context is it running
under
under, your id, under the os id or under the applicaion you are running the
commands from.
Are the drive letters in the contect of the user and location you are
running them from ie if runnind this on a remote serverits D: will not be the
same as you d:
perhap you need to qualify the files such \\<severname>\<sharename>
Can you break these commands down
a simpler command to say display a directory listing work via this method ie
the cmdexec works but not he commnd you are running...
"snyper" wrote:
> Sorry, the step does fail. I see it in the appliction log as a failure. I do
> not know how to get the .bat to execute properly. Any ideas?
> --
> Thanks,
> Snyper
>
> "snyper" wrote:
> > All,
> >
> > sql 2000 sp3
> >
> > I have a .bat file at d:\wip\queries.bat, the step succeeds, but there is no
> > data in the files that I am creating. Below is the contents of the .bat. I
> > have 'd:\queries.bat' in the cmdexec step. I have verified the odbc
> > connection, any other ideas would be a great help.
> >
> > db2cmd /c /w /i db2 +o -tf ds1_query.sql -r d:\wip\ds1_query.txt
> > db2cmd /c /w /i db2 +o -tf ds2_wrs_ind_employee_db2_query.sql -r
> > d:\wip\ds2_wrs_ind_employee_db2.txt
> > db2cmd /c /w /i db2 +o -tf ds3_wrs_clr_employee_db2_query.sql -r
> > d:\wip\ds3_wrs_clr_employee_db2.txt
> > db2cmd /c /w /i db2 +o -tf ds4_wrs_client_db2_query.sql -r
> > d:\wip\ds4_wrs_client_db2.txt
> > db2cmd /c /w /i db2 +o -tf ds5_wrs_diary_db2_query.sql -r
> > d:\wip\ds5_wrs_diary_db2.txt
> > db2cmd /c /w /i db2 +o -tf ds6_wrs_dry_history_db2_query.sql -r
> > d:\wip\ds6_wrs_dry_history_db2.txt
> > db2cmd /c /w /i db2 +o -tf ds7_wrs_folder_control_db2_query.sql -r
> > d:\wip\ds7_wrs_folder_control_db2.txt
> > --
> >
> > Thanks,
> >
> > Snyper

Excessive Logon Audit Events

I have a stand alone Windows 2000 server sp4 running SQL 2000 sp3. I need t
o be able to audit successful and failed Logon events and I have the group p
olicy set to do this. The box is in an offsite facility connected by at T1
over a VPN connection. My
SQL developers have the remote server registered in their Enterprise Manager
along with the local SQL servers. When they have Enterprise Manager open,
the following event is logged on the remote SQL server every 10 seconds. It
is filling my log and maki
ng it difficult to read. Why is this happening and can I make it stop?
Event Type: Success Audit
Event Source: Security
Event Category: Account Logon
Event ID: 680
Date: 6/28/2004
Time: 9:01:29 AM
User: NT AUTHORITY\SYSTEM
Computer: CONDOR
Description:
Account Used for Logon by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0
Account Name:
SomeUser
Workstation:
UserWorkstationIn Enterprise Manager (the devs need to do this on their PC's) goto
Tools>Options and uncheck the Poll Server checkbox. As you will see the
default interval for this polling is 10 seconds.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Chris Wilkins" <Chris Wilkins@.discussions.microsoft.com> wrote in message
news:2D79110F-901D-43F2-9DA6-1AD0A97CC90F@.microsoft.com...
> I have a stand alone Windows 2000 server sp4 running SQL 2000 sp3. I need
to be able to audit successful and failed Logon events and I have the group
policy set to do this. The box is in an offsite facility connected by at T1
over a VPN connection. My SQL developers have the remote server registered
in their Enterprise Manager along with the local SQL servers. When they
have Enterprise Manager open, the following event is logged on the remote
SQL server every 10 seconds. It is filling my log and making it difficult
to read. Why is this happening and can I make it stop?
> Event Type: Success Audit
> Event Source: Security
> Event Category: Account Logon
> Event ID: 680
> Date: 6/28/2004
> Time: 9:01:29 AM
> User: NT AUTHORITY\SYSTEM
> Computer: CONDOR
> Description:
> Account Used for Logon by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0
> Account Name:
> SomeUser
> Workstation:
> UserWorkstation
>

EXCEPTION_ACCESS_VIOLATION in RangeGenerator::GetNextRange

Hi,
I'm getting errors from SQL Server 2000 SP3 running under Windows Server
2003. Rebooting the server doesn't help and running DBCC CHECKDB doesn't
give any errors. I've looked in the Knowledge Base for articles dealing
with EXCEPTION_ACCESS_VIOLATION errors, but none of them seen to apply to
me.
Here is part of what is showing up in the log:
SqlDumpExceptionHandler: Process 1780 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. *
************************************************** *****************************
*
* BEGIN STACK DUMP:
* 06/25/04 14:49:33 spid 55
*
* Exception Address = 007F8A40 (RangeGenerator::GetNextRange + 000003D0
Line 0+00000000) * Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION * Access Violation occurred reading address
E89C400A * Input Buffer 2342 bytes -
* select distinct rb.brand_cd,rb.report_item_cd into #temp4rb from
REPORT_ * LIST rl,REPORT_BRANDS rb where service_cd=1 and report_cd=35
and report_ * table_cd=4 and rl.report_item_cd=rb.report_item_cd select
market_cd,sto * re_cd,ad_dt_yyyymm,report_item_cd,ad_quality_cd,su m(
ad_cnt) ad_cnt into * #temp4ac from FEAT_SUM_QUAL_REBATE f,#temp4rb rb
where f.brand_cd=rb.br * and_cd and market_cd in
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17 *
,18,19,20,21,22,23,24,25,27,28,29,31,32,34,35,36,3 7,38,40,44,46,49,50,52 *
,53,57,77,78,85,86,87) and ad_dt_yyyymm in ( 200405,200404,200403,
* 200402,200401,200312,200311,200310,200309,200308,2 00307,200306) group
by * market_cd,store_cd,ad_dt_yyyymm,report_item_cd,ad_ quality_cd *
* MODULE BASE END SIZE * sqlservr
00400000 00B2CFFF 0072d000 * ntdll
77F40000 77FF9FFF 000ba000 * kernel32
77E40000 77F33FFF 000f4000 * ADVAPI32 77DA0000
77E2FFFF 00090000 * RPCRT4 77C50000 77CF3FFF
000a4000 * USER32 77D00000 77D8EFFF 0008f000 *
GDI32 77C00000 77C43FFF 00044000 * OPENDS60
41060000 41065FFF 00006000 * MSVCRT
77BA0000 77BF3FFF 00054000 * UMS
41070000 4107CFFF 0000d000 * SQLSORT 42AE0000
42B6FFFF 00090000 * MSVCIRT 60020000 6002FFFF
00010000 * sqlevn70 41080000 41086FFF 00007000 *
NETAPI32 02C60000 02CB2FFF 00053000 * ole32
030D0000 031F3FFF 00124000 * XOLEHLP
03200000 03205FFF 00006000 * MSDTCPRX
03210000 03280FFF 00071000 * OLEAUT32 03290000
0330CFFF 0007d000 * MSVCP60 03310000 03370FFF
00061000 * MTXCLU 03380000 03397FFF 00018000 *
VERSION 033A0000 033A7FFF 00008000 * WSOCK32
033B0000 033B8FFF 00009000 * WS2_32
033C0000 033D7FFF 00018000 * WS2HELP
033E0000 033E7FFF 00008000 * CLUSAPI 03430000
03440FFF 00011000 * RESUTILS 03450000 03461FFF
00012000 * USERENV 03470000 03529FFF 000ba000 *
MFC42u 03530000 03623FFF 000f4000 * secur32
036B0000 036C2FFF 00013000 * mswsock
036E0000 03722FFF 00043000 * DNSAPI
03730000 03756FFF 00027000 * winrnr 037A0000
037A6FFF 00007000 * WLDAP32 037B0000 037DEFFF
0002f000 * rasadhlp 03800000 03804FFF 00005000 *
SSNMPN70 00C70000 00C75FFF 00006000 * SSNETLIB
00C80000 00C94FFF 00015000 * security
044B0000 044B3FFF 00004000 * wshtcpip
04500000 04507FFF 00008000 * SSmsLPCn 04510000
04516FFF 00007000 * ntdsapi 04530000 04545FFF
00016000 * SQLFTQRY 04420000 04451FFF 00032000 *
CLBCatQ 04A60000 04ADDFFF 0007e000 * COMRes
04AE0000 04BA5FFF 000c6000 * sqloledb
04BB0000 04C35FFF 00086000 * MSDART
04480000 044A8FFF 00029000 * COMCTL32 04C40000
04CCFFFF 00090000 * comdlg32 04CD0000 04D16FFF
00047000 * SHLWAPI 04D20000 04D68FFF 00049000 *
SHELL32 04D70000 0554CFFF 007dd000 * MSDATL3
045B0000 045C7FFF 00018000 * comctl32
05550000 05635FFF 000e6000 * oledb32
059E0000 05A5CFFF 0007d000 * OLEDB32R 05A60000
05A70FFF 00011000 * rsaenh 0FFD0000 0FFFCFFF
0002d000 * PSAPI 05B00000 05B0AFFF 0000b000 *
xpstar 03050000 03096FFF 00047000 * SQLRESLD
030A0000 030A6FFF 00007000 * SQLSVC
030B0000 030C6FFF 00017000 * ODBC32
05C10000 05C49FFF 0003a000 * odbcbcp 05C50000
05C55FFF 00006000 * W95SCM 05C60000 05C6BFFF
0000c000 * SQLUNIRL 05C70000 05C9CFFF 0002d000 *
WINSPOOL 05CA0000 05CC5FFF 00026000 * SHFOLDER
05CD0000 05CD8FFF 00009000 * odbcint
05EB0000 05EC6FFF 00017000 * NDDEAPI
05FE0000 05FE6FFF 00007000 * SQLSVC 05FF0000
05FF5FFF 00006000 * xpstar 06000000 06008FFF
00009000 * dbghelp 06840000 068F4FFF 000b5000 *
* Edi: 067BFCD8: 3AE52EB8 067BFD10 A7FFFFFA 389C2000 067BFDB4
0097C46F * Esi: 389C2000: 01000201 00018000 00000000 00150000
00000000 00330000 * Eax: 58001005: 00000000 03000000 00000B00
8C000000 88000002 88000002 * Ebx: 389E8708: 3868DCE4 000004F7
00000004 000004F4 00000004 00000000 * Ecx: 00000033:
* Edx: 00000002:
* Eip: 007F8A40: 4604B70F 8D4C4303 8BFA3074 8BA50C45 A5663448
C150418B * Ebp: 067BFCF4: 067BFD10 00801CB1 3AE52D68 3AE225E8
00000000 3AE52998 * SegCs: 0000001B:
* EFlags: 00010207: 43003B00 5C003A00 49005700 44004E00 57004F00
3B005300 * Esp: 067BFC6C: 00000001 3AE52B44 00000000 00000000
00000000 00C567A0 * SegSs: 00000023:
*
************************************************** *****************************
*
* Short Stack Dump
* 007F8A40 Module(sqlservr+003F8A40)
(RangeGenerator::GetNextRange+000003D0) * 00801CB1
Module(sqlservr+00401CB1) (RowsetSS::FetchNextRow+00000153) * 0042A4F6
Module(sqlservr+0002A4F6) (CQScanRowset::GetRowWithPrefetch+00000040) *
0042C21B Module(sqlservr+0002C21B) (CQScanRange::GetRow+000000EF) *
004314C9 Module(sqlservr+000314C9) (CQScanHashMatch::Iterate+00000BAF) *
00431B41 Module(sqlservr+00031B41) (CQScanHashMatch::GetRow+0000009F) *
006FCBF7 Module(sqlservr+002FCBF7) (CQScanXProducer::Open+0000039B) *
006FC656 Module(sqlservr+002FC656) (FnProducerThread+0000020E) * 0051274C
Module(sqlservr+0011274C) (subproc_main+000000C2) * 41075002
Module(UMS+00005002) (ProcessWorkRequests+00000272) * 41074698
Module(UMS+00004698) (ThreadStartRoutine+00000098) * 77BC90A2
Module(MSVCRT+000290A2) (endthread+000000A6) * 77E4A990
Module(kernel32+0000A990) (FlsSetValue+00000779)
If you don't find anything on KB, are up on sp and CHECKDB comes out clean, it is time for a case
with MS Support...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Glen K" <blah@.blah.com> wrote in message news:pan.2004.06.25.19.18.22.966869@.blah.com...
> Hi,
> I'm getting errors from SQL Server 2000 SP3 running under Windows Server
> 2003. Rebooting the server doesn't help and running DBCC CHECKDB doesn't
> give any errors. I've looked in the Knowledge Base for articles dealing
> with EXCEPTION_ACCESS_VIOLATION errors, but none of them seen to apply to
> me.
> Here is part of what is showing up in the log:
>
> SqlDumpExceptionHandler: Process 1780 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. *
> ************************************************** *****************************
> *
> * BEGIN STACK DUMP:
> * 06/25/04 14:49:33 spid 55
> *
> * Exception Address = 007F8A40 (RangeGenerator::GetNextRange + 000003D0
> Line 0+00000000) * Exception Code = c0000005
> EXCEPTION_ACCESS_VIOLATION * Access Violation occurred reading address
> E89C400A * Input Buffer 2342 bytes -
> * select distinct rb.brand_cd,rb.report_item_cd into #temp4rb from
> REPORT_ * LIST rl,REPORT_BRANDS rb where service_cd=1 and report_cd=35
> and report_ * table_cd=4 and rl.report_item_cd=rb.report_item_cd select
> market_cd,sto * re_cd,ad_dt_yyyymm,report_item_cd,ad_quality_cd,su m(
> ad_cnt) ad_cnt into * #temp4ac from FEAT_SUM_QUAL_REBATE f,#temp4rb rb
> where f.brand_cd=rb.br * and_cd and market_cd in
> (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17 *
> ,18,19,20,21,22,23,24,25,27,28,29,31,32,34,35,36,3 7,38,40,44,46,49,50,52 *
> ,53,57,77,78,85,86,87) and ad_dt_yyyymm in ( 200405,200404,200403,
> * 200402,200401,200312,200311,200310,200309,200308,2 00307,200306) group
> by * market_cd,store_cd,ad_dt_yyyymm,report_item_cd,ad_ quality_cd *
> * MODULE BASE END SIZE * sqlservr
> 00400000 00B2CFFF 0072d000 * ntdll
> 77F40000 77FF9FFF 000ba000 * kernel32
> 77E40000 77F33FFF 000f4000 * ADVAPI32 77DA0000
> 77E2FFFF 00090000 * RPCRT4 77C50000 77CF3FFF
> 000a4000 * USER32 77D00000 77D8EFFF 0008f000 *
> GDI32 77C00000 77C43FFF 00044000 * OPENDS60
> 41060000 41065FFF 00006000 * MSVCRT
> 77BA0000 77BF3FFF 00054000 * UMS
> 41070000 4107CFFF 0000d000 * SQLSORT 42AE0000
> 42B6FFFF 00090000 * MSVCIRT 60020000 6002FFFF
> 00010000 * sqlevn70 41080000 41086FFF 00007000 *
> NETAPI32 02C60000 02CB2FFF 00053000 * ole32
> 030D0000 031F3FFF 00124000 * XOLEHLP
> 03200000 03205FFF 00006000 * MSDTCPRX
> 03210000 03280FFF 00071000 * OLEAUT32 03290000
> 0330CFFF 0007d000 * MSVCP60 03310000 03370FFF
> 00061000 * MTXCLU 03380000 03397FFF 00018000 *
> VERSION 033A0000 033A7FFF 00008000 * WSOCK32
> 033B0000 033B8FFF 00009000 * WS2_32
> 033C0000 033D7FFF 00018000 * WS2HELP
> 033E0000 033E7FFF 00008000 * CLUSAPI 03430000
> 03440FFF 00011000 * RESUTILS 03450000 03461FFF
> 00012000 * USERENV 03470000 03529FFF 000ba000 *
> MFC42u 03530000 03623FFF 000f4000 * secur32
> 036B0000 036C2FFF 00013000 * mswsock
> 036E0000 03722FFF 00043000 * DNSAPI
> 03730000 03756FFF 00027000 * winrnr 037A0000
> 037A6FFF 00007000 * WLDAP32 037B0000 037DEFFF
> 0002f000 * rasadhlp 03800000 03804FFF 00005000 *
> SSNMPN70 00C70000 00C75FFF 00006000 * SSNETLIB
> 00C80000 00C94FFF 00015000 * security
> 044B0000 044B3FFF 00004000 * wshtcpip
> 04500000 04507FFF 00008000 * SSmsLPCn 04510000
> 04516FFF 00007000 * ntdsapi 04530000 04545FFF
> 00016000 * SQLFTQRY 04420000 04451FFF 00032000 *
> CLBCatQ 04A60000 04ADDFFF 0007e000 * COMRes
> 04AE0000 04BA5FFF 000c6000 * sqloledb
> 04BB0000 04C35FFF 00086000 * MSDART
> 04480000 044A8FFF 00029000 * COMCTL32 04C40000
> 04CCFFFF 00090000 * comdlg32 04CD0000 04D16FFF
> 00047000 * SHLWAPI 04D20000 04D68FFF 00049000 *
> SHELL32 04D70000 0554CFFF 007dd000 * MSDATL3
> 045B0000 045C7FFF 00018000 * comctl32
> 05550000 05635FFF 000e6000 * oledb32
> 059E0000 05A5CFFF 0007d000 * OLEDB32R 05A60000
> 05A70FFF 00011000 * rsaenh 0FFD0000 0FFFCFFF
> 0002d000 * PSAPI 05B00000 05B0AFFF 0000b000 *
> xpstar 03050000 03096FFF 00047000 * SQLRESLD
> 030A0000 030A6FFF 00007000 * SQLSVC
> 030B0000 030C6FFF 00017000 * ODBC32
> 05C10000 05C49FFF 0003a000 * odbcbcp 05C50000
> 05C55FFF 00006000 * W95SCM 05C60000 05C6BFFF
> 0000c000 * SQLUNIRL 05C70000 05C9CFFF 0002d000 *
> WINSPOOL 05CA0000 05CC5FFF 00026000 * SHFOLDER
> 05CD0000 05CD8FFF 00009000 * odbcint
> 05EB0000 05EC6FFF 00017000 * NDDEAPI
> 05FE0000 05FE6FFF 00007000 * SQLSVC 05FF0000
> 05FF5FFF 00006000 * xpstar 06000000 06008FFF
> 00009000 * dbghelp 06840000 068F4FFF 000b5000 *
> * Edi: 067BFCD8: 3AE52EB8 067BFD10 A7FFFFFA 389C2000 067BFDB4
> 0097C46F * Esi: 389C2000: 01000201 00018000 00000000 00150000
> 00000000 00330000 * Eax: 58001005: 00000000 03000000 00000B00
> 8C000000 88000002 88000002 * Ebx: 389E8708: 3868DCE4 000004F7
> 00000004 000004F4 00000004 00000000 * Ecx: 00000033:
> * Edx: 00000002:
> * Eip: 007F8A40: 4604B70F 8D4C4303 8BFA3074 8BA50C45 A5663448
> C150418B * Ebp: 067BFCF4: 067BFD10 00801CB1 3AE52D68 3AE225E8
> 00000000 3AE52998 * SegCs: 0000001B:
> * EFlags: 00010207: 43003B00 5C003A00 49005700 44004E00 57004F00
> 3B005300 * Esp: 067BFC6C: 00000001 3AE52B44 00000000 00000000
> 00000000 00C567A0 * SegSs: 00000023:
> *
> ************************************************** *****************************
> *
> ----
> * Short Stack Dump
> * 007F8A40 Module(sqlservr+003F8A40)
> (RangeGenerator::GetNextRange+000003D0) * 00801CB1
> Module(sqlservr+00401CB1) (RowsetSS::FetchNextRow+00000153) * 0042A4F6
> Module(sqlservr+0002A4F6) (CQScanRowset::GetRowWithPrefetch+00000040) *
> 0042C21B Module(sqlservr+0002C21B) (CQScanRange::GetRow+000000EF) *
> 004314C9 Module(sqlservr+000314C9) (CQScanHashMatch::Iterate+00000BAF) *
> 00431B41 Module(sqlservr+00031B41) (CQScanHashMatch::GetRow+0000009F) *
> 006FCBF7 Module(sqlservr+002FCBF7) (CQScanXProducer::Open+0000039B) *
> 006FC656 Module(sqlservr+002FC656) (FnProducerThread+0000020E) * 0051274C
> Module(sqlservr+0011274C) (subproc_main+000000C2) * 41075002
> Module(UMS+00005002) (ProcessWorkRequests+00000272) * 41074698
> Module(UMS+00004698) (ThreadStartRoutine+00000098) * 77BC90A2
> Module(MSVCRT+000290A2) (endthread+000000A6) * 77E4A990
> Module(kernel32+0000A990) (FlsSetValue+00000779)
|||Hi Glen,
Thanks for Tibor's suggestion. Looking at the nature of this issue, it
would require intensive troubleshooting which would be done quickly and
effectively with direct assistance from a Microsoft Support Professional
through Microsoft Product Support Services. You can contact Microsoft
Product Support directly by choosing one of the options listed at
http://support.microsoft.com/default...=sz;en-us;top.
If this is not an urgent issue and you would like us to create an incident
for you and have Microsoft Customer Service Representative contact you
directly, please send email to (remove "online." from this no Spam email
address) mailto:dscommhf@.online.microsoft.com with the following
information,
*Include "Followup: <Tomcat IssueID>" in the email Subject.
*Location of the post
*First Name, Last Name
*MSDN Subscriber ID
*Company name (if any)
*Phone number
*e-mail address
Sincerely yours,
Bill Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
| From: Glen K <blah@.blah.com>
| Subject: EXCEPTION_ACCESS_VIOLATION in RangeGenerator::GetNextRange
| User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing
moment of clarity.)
| Message-ID: <pan.2004.06.25.19.18.22.966869@.blah.com>
| Newsgroups: microsoft.public.sqlserver.server
| MIME-Version: 1.0
| Content-Type: text/plain; charset=ISO-2022-jp
| Content-Transfer-Encoding: 8bit
| Lines: 124
| Date: Fri, 25 Jun 2004 19:18:22 GMT
| NNTP-Posting-Host: 67.86.129.2
| X-Complaints-To: abuse@.cv.net
| X-Trace: news4.srv.hcvlny.cv.net 1088191102 67.86.129.2 (Fri, 25 Jun 2004
15:18:22 EDT)
| NNTP-Posting-Date: Fri, 25 Jun 2004 15:18:22 EDT
| Organization: Optimum Online
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.gigan ews.com!f
eed5.newsreader.com!newsreader.com!news3.optonline .net!news4.srv.hcvlny.cv.n
et.POSTED!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:347783
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi,
| I'm getting errors from SQL Server 2000 SP3 running under Windows Server
| 2003. Rebooting the server doesn't help and running DBCC CHECKDB doesn't
| give any errors. I've looked in the Knowledge Base for articles dealing
| with EXCEPTION_ACCESS_VIOLATION errors, but none of them seen to apply to
| me.
|
| Here is part of what is showing up in the log:
|
|
|
| SqlDumpExceptionHandler: Process 1780 generated fatal exception c0000005
| EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. *
|
************************************************** **************************
***
| *
| * BEGIN STACK DUMP:
| * 06/25/04 14:49:33 spid 55
| *
| * Exception Address = 007F8A40 (RangeGenerator::GetNextRange + 000003D0
| Line 0+00000000) * Exception Code = c0000005
| EXCEPTION_ACCESS_VIOLATION * Access Violation occurred reading address
| E89C400A * Input Buffer 2342 bytes -
| * select distinct rb.brand_cd,rb.report_item_cd into #temp4rb from
| REPORT_ * LIST rl,REPORT_BRANDS rb where service_cd=1 and report_cd=35
| and report_ * table_cd=4 and rl.report_item_cd=rb.report_item_cd select
| market_cd,sto * re_cd,ad_dt_yyyymm,report_item_cd,ad_quality_cd,su m(
| ad_cnt) ad_cnt into * #temp4ac from FEAT_SUM_QUAL_REBATE f,#temp4rb rb
| where f.brand_cd=rb.br * and_cd and market_cd in
| (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17 *
| ,18,19,20,21,22,23,24,25,27,28,29,31,32,34,35,36,3 7,38,40,44,46,49,50,52 *
| ,53,57,77,78,85,86,87) and ad_dt_yyyymm in ( 200405,200404,200403,
| * 200402,200401,200312,200311,200310,200309,200308,2 00307,200306) group
| by * market_cd,store_cd,ad_dt_yyyymm,report_item_cd,ad_ quality_cd *
| * MODULE BASE END SIZE * sqlservr
| 00400000 00B2CFFF 0072d000 * ntdll
| 77F40000 77FF9FFF 000ba000 * kernel32
| 77E40000 77F33FFF 000f4000 * ADVAPI32 77DA0000
| 77E2FFFF 00090000 * RPCRT4 77C50000 77CF3FFF
| 000a4000 * USER32 77D00000 77D8EFFF 0008f000 *
| GDI32 77C00000 77C43FFF 00044000 * OPENDS60
| 41060000 41065FFF 00006000 * MSVCRT
| 77BA0000 77BF3FFF 00054000 * UMS
| 41070000 4107CFFF 0000d000 * SQLSORT 42AE0000
| 42B6FFFF 00090000 * MSVCIRT 60020000 6002FFFF
| 00010000 * sqlevn70 41080000 41086FFF 00007000 *
| NETAPI32 02C60000 02CB2FFF 00053000 * ole32
| 030D0000 031F3FFF 00124000 * XOLEHLP
| 03200000 03205FFF 00006000 * MSDTCPRX
| 03210000 03280FFF 00071000 * OLEAUT32 03290000
| 0330CFFF 0007d000 * MSVCP60 03310000 03370FFF
| 00061000 * MTXCLU 03380000 03397FFF 00018000 *
| VERSION 033A0000 033A7FFF 00008000 * WSOCK32
| 033B0000 033B8FFF 00009000 * WS2_32
| 033C0000 033D7FFF 00018000 * WS2HELP
| 033E0000 033E7FFF 00008000 * CLUSAPI 03430000
| 03440FFF 00011000 * RESUTILS 03450000 03461FFF
| 00012000 * USERENV 03470000 03529FFF 000ba000 *
| MFC42u 03530000 03623FFF 000f4000 * secur32
| 036B0000 036C2FFF 00013000 * mswsock
| 036E0000 03722FFF 00043000 * DNSAPI
| 03730000 03756FFF 00027000 * winrnr 037A0000
| 037A6FFF 00007000 * WLDAP32 037B0000 037DEFFF
| 0002f000 * rasadhlp 03800000 03804FFF 00005000 *
| SSNMPN70 00C70000 00C75FFF 00006000 * SSNETLIB
| 00C80000 00C94FFF 00015000 * security
| 044B0000 044B3FFF 00004000 * wshtcpip
| 04500000 04507FFF 00008000 * SSmsLPCn 04510000
| 04516FFF 00007000 * ntdsapi 04530000 04545FFF
| 00016000 * SQLFTQRY 04420000 04451FFF 00032000 *
| CLBCatQ 04A60000 04ADDFFF 0007e000 * COMRes
| 04AE0000 04BA5FFF 000c6000 * sqloledb
| 04BB0000 04C35FFF 00086000 * MSDART
| 04480000 044A8FFF 00029000 * COMCTL32 04C40000
| 04CCFFFF 00090000 * comdlg32 04CD0000 04D16FFF
| 00047000 * SHLWAPI 04D20000 04D68FFF 00049000 *
| SHELL32 04D70000 0554CFFF 007dd000 * MSDATL3
| 045B0000 045C7FFF 00018000 * comctl32
| 05550000 05635FFF 000e6000 * oledb32
| 059E0000 05A5CFFF 0007d000 * OLEDB32R 05A60000
| 05A70FFF 00011000 * rsaenh 0FFD0000 0FFFCFFF
| 0002d000 * PSAPI 05B00000 05B0AFFF 0000b000 *
| xpstar 03050000 03096FFF 00047000 * SQLRESLD
| 030A0000 030A6FFF 00007000 * SQLSVC
| 030B0000 030C6FFF 00017000 * ODBC32
| 05C10000 05C49FFF 0003a000 * odbcbcp 05C50000
| 05C55FFF 00006000 * W95SCM 05C60000 05C6BFFF
| 0000c000 * SQLUNIRL 05C70000 05C9CFFF 0002d000 *
| WINSPOOL 05CA0000 05CC5FFF 00026000 * SHFOLDER
| 05CD0000 05CD8FFF 00009000 * odbcint
| 05EB0000 05EC6FFF 00017000 * NDDEAPI
| 05FE0000 05FE6FFF 00007000 * SQLSVC 05FF0000
| 05FF5FFF 00006000 * xpstar 06000000 06008FFF
| 00009000 * dbghelp 06840000 068F4FFF 000b5000 *
| * Edi: 067BFCD8: 3AE52EB8 067BFD10 A7FFFFFA 389C2000 067BFDB4
| 0097C46F * Esi: 389C2000: 01000201 00018000 00000000 00150000
| 00000000 00330000 * Eax: 58001005: 00000000 03000000 00000B00
| 8C000000 88000002 88000002 * Ebx: 389E8708: 3868DCE4 000004F7
| 00000004 000004F4 00000004 00000000 * Ecx: 00000033:
| * Edx: 00000002:
| * Eip: 007F8A40: 4604B70F 8D4C4303 8BFA3074 8BA50C45 A5663448
| C150418B * Ebp: 067BFCF4: 067BFD10 00801CB1 3AE52D68 3AE225E8
| 00000000 3AE52998 * SegCs: 0000001B:
| * EFlags: 00010207: 43003B00 5C003A00 49005700 44004E00 57004F00
| 3B005300 * Esp: 067BFC6C: 00000001 3AE52B44 00000000 00000000
| 00000000 00C567A0 * SegSs: 00000023:
| *
|
************************************************** **************************
***
| *
|
| * Short Stack Dump
| * 007F8A40 Module(sqlservr+003F8A40)
| (RangeGenerator::GetNextRange+000003D0) * 00801CB1
| Module(sqlservr+00401CB1) (RowsetSS::FetchNextRow+00000153) * 0042A4F6
| Module(sqlservr+0002A4F6) (CQScanRowset::GetRowWithPrefetch+00000040) *
| 0042C21B Module(sqlservr+0002C21B) (CQScanRange::GetRow+000000EF) *
| 004314C9 Module(sqlservr+000314C9) (CQScanHashMatch::Iterate+00000BAF) *
| 00431B41 Module(sqlservr+00031B41) (CQScanHashMatch::GetRow+0000009F) *
| 006FCBF7 Module(sqlservr+002FCBF7) (CQScanXProducer::Open+0000039B) *
| 006FC656 Module(sqlservr+002FC656) (FnProducerThread+0000020E) * 0051274C
| Module(sqlservr+0011274C) (subproc_main+000000C2) * 41075002
| Module(UMS+00005002) (ProcessWorkRequests+00000272) * 41074698
| Module(UMS+00004698) (ThreadStartRoutine+00000098) * 77BC90A2
| Module(MSVCRT+000290A2) (endthread+000000A6) * 77E4A990
| Module(kernel32+0000A990) (FlsSetValue+00000779)
|
|||Hi Glen,
Thanks for Tibor's suggestion. Looking at the nature of this issue, it
would require intensive troubleshooting which would be done quickly and
effectively with direct assistance from a Microsoft Support Professional
through Microsoft Product Support Services. You can contact Microsoft
Product Support directly by choosing one of the options listed at
http://support.microsoft.com/default...=sz;en-us;top.
If this is not an urgent issue and you would like us to create an incident
for you and have Microsoft Customer Service Representative contact you
directly, please send email to (remove "online." from this no Spam email
address) mailto:dscommhf@.online.microsoft.com with the following
information,
*Include "Followup: <Tomcat IssueID>" in the email Subject.
*Location of the post
*First Name, Last Name
*MSDN Subscriber ID
*Company name (if any)
*Phone number
*e-mail address
Sincerely yours,
Bill Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
| From: Glen K <blah@.blah.com>
| Subject: EXCEPTION_ACCESS_VIOLATION in RangeGenerator::GetNextRange
| User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing
moment of clarity.)
| Message-ID: <pan.2004.06.25.19.18.22.966869@.blah.com>
| Newsgroups: microsoft.public.sqlserver.server
| MIME-Version: 1.0
| Content-Type: text/plain; charset=ISO-2022-jp
| Content-Transfer-Encoding: 8bit
| Lines: 124
| Date: Fri, 25 Jun 2004 19:18:22 GMT
| NNTP-Posting-Host: 67.86.129.2
| X-Complaints-To: abuse@.cv.net
| X-Trace: news4.srv.hcvlny.cv.net 1088191102 67.86.129.2 (Fri, 25 Jun 2004
15:18:22 EDT)
| NNTP-Posting-Date: Fri, 25 Jun 2004 15:18:22 EDT
| Organization: Optimum Online
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.gigan ews.com!f
eed5.newsreader.com!newsreader.com!news3.optonline .net!news4.srv.hcvlny.cv.n
et.POSTED!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:347783
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi,
| I'm getting errors from SQL Server 2000 SP3 running under Windows Server
| 2003. Rebooting the server doesn't help and running DBCC CHECKDB doesn't
| give any errors. I've looked in the Knowledge Base for articles dealing
| with EXCEPTION_ACCESS_VIOLATION errors, but none of them seen to apply to
| me.
|
| Here is part of what is showing up in the log:
|
|
|
| SqlDumpExceptionHandler: Process 1780 generated fatal exception c0000005
| EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. *
|
************************************************** **************************
***
| *
| * BEGIN STACK DUMP:
| * 06/25/04 14:49:33 spid 55
| *
| * Exception Address = 007F8A40 (RangeGenerator::GetNextRange + 000003D0
| Line 0+00000000) * Exception Code = c0000005
| EXCEPTION_ACCESS_VIOLATION * Access Violation occurred reading address
| E89C400A * Input Buffer 2342 bytes -
| * select distinct rb.brand_cd,rb.report_item_cd into #temp4rb from
| REPORT_ * LIST rl,REPORT_BRANDS rb where service_cd=1 and report_cd=35
| and report_ * table_cd=4 and rl.report_item_cd=rb.report_item_cd select
| market_cd,sto * re_cd,ad_dt_yyyymm,report_item_cd,ad_quality_cd,su m(
| ad_cnt) ad_cnt into * #temp4ac from FEAT_SUM_QUAL_REBATE f,#temp4rb rb
| where f.brand_cd=rb.br * and_cd and market_cd in
| (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17 *
| ,18,19,20,21,22,23,24,25,27,28,29,31,32,34,35,36,3 7,38,40,44,46,49,50,52 *
| ,53,57,77,78,85,86,87) and ad_dt_yyyymm in ( 200405,200404,200403,
| * 200402,200401,200312,200311,200310,200309,200308,2 00307,200306) group
| by * market_cd,store_cd,ad_dt_yyyymm,report_item_cd,ad_ quality_cd *
| * MODULE BASE END SIZE * sqlservr
| 00400000 00B2CFFF 0072d000 * ntdll
| 77F40000 77FF9FFF 000ba000 * kernel32
| 77E40000 77F33FFF 000f4000 * ADVAPI32 77DA0000
| 77E2FFFF 00090000 * RPCRT4 77C50000 77CF3FFF
| 000a4000 * USER32 77D00000 77D8EFFF 0008f000 *
| GDI32 77C00000 77C43FFF 00044000 * OPENDS60
| 41060000 41065FFF 00006000 * MSVCRT
| 77BA0000 77BF3FFF 00054000 * UMS
| 41070000 4107CFFF 0000d000 * SQLSORT 42AE0000
| 42B6FFFF 00090000 * MSVCIRT 60020000 6002FFFF
| 00010000 * sqlevn70 41080000 41086FFF 00007000 *
| NETAPI32 02C60000 02CB2FFF 00053000 * ole32
| 030D0000 031F3FFF 00124000 * XOLEHLP
| 03200000 03205FFF 00006000 * MSDTCPRX
| 03210000 03280FFF 00071000 * OLEAUT32 03290000
| 0330CFFF 0007d000 * MSVCP60 03310000 03370FFF
| 00061000 * MTXCLU 03380000 03397FFF 00018000 *
| VERSION 033A0000 033A7FFF 00008000 * WSOCK32
| 033B0000 033B8FFF 00009000 * WS2_32
| 033C0000 033D7FFF 00018000 * WS2HELP
| 033E0000 033E7FFF 00008000 * CLUSAPI 03430000
| 03440FFF 00011000 * RESUTILS 03450000 03461FFF
| 00012000 * USERENV 03470000 03529FFF 000ba000 *
| MFC42u 03530000 03623FFF 000f4000 * secur32
| 036B0000 036C2FFF 00013000 * mswsock
| 036E0000 03722FFF 00043000 * DNSAPI
| 03730000 03756FFF 00027000 * winrnr 037A0000
| 037A6FFF 00007000 * WLDAP32 037B0000 037DEFFF
| 0002f000 * rasadhlp 03800000 03804FFF 00005000 *
| SSNMPN70 00C70000 00C75FFF 00006000 * SSNETLIB
| 00C80000 00C94FFF 00015000 * security
| 044B0000 044B3FFF 00004000 * wshtcpip
| 04500000 04507FFF 00008000 * SSmsLPCn 04510000
| 04516FFF 00007000 * ntdsapi 04530000 04545FFF
| 00016000 * SQLFTQRY 04420000 04451FFF 00032000 *
| CLBCatQ 04A60000 04ADDFFF 0007e000 * COMRes
| 04AE0000 04BA5FFF 000c6000 * sqloledb
| 04BB0000 04C35FFF 00086000 * MSDART
| 04480000 044A8FFF 00029000 * COMCTL32 04C40000
| 04CCFFFF 00090000 * comdlg32 04CD0000 04D16FFF
| 00047000 * SHLWAPI 04D20000 04D68FFF 00049000 *
| SHELL32 04D70000 0554CFFF 007dd000 * MSDATL3
| 045B0000 045C7FFF 00018000 * comctl32
| 05550000 05635FFF 000e6000 * oledb32
| 059E0000 05A5CFFF 0007d000 * OLEDB32R 05A60000
| 05A70FFF 00011000 * rsaenh 0FFD0000 0FFFCFFF
| 0002d000 * PSAPI 05B00000 05B0AFFF 0000b000 *
| xpstar 03050000 03096FFF 00047000 * SQLRESLD
| 030A0000 030A6FFF 00007000 * SQLSVC
| 030B0000 030C6FFF 00017000 * ODBC32
| 05C10000 05C49FFF 0003a000 * odbcbcp 05C50000
| 05C55FFF 00006000 * W95SCM 05C60000 05C6BFFF
| 0000c000 * SQLUNIRL 05C70000 05C9CFFF 0002d000 *
| WINSPOOL 05CA0000 05CC5FFF 00026000 * SHFOLDER
| 05CD0000 05CD8FFF 00009000 * odbcint
| 05EB0000 05EC6FFF 00017000 * NDDEAPI
| 05FE0000 05FE6FFF 00007000 * SQLSVC 05FF0000
| 05FF5FFF 00006000 * xpstar 06000000 06008FFF
| 00009000 * dbghelp 06840000 068F4FFF 000b5000 *
| * Edi: 067BFCD8: 3AE52EB8 067BFD10 A7FFFFFA 389C2000 067BFDB4
| 0097C46F * Esi: 389C2000: 01000201 00018000 00000000 00150000
| 00000000 00330000 * Eax: 58001005: 00000000 03000000 00000B00
| 8C000000 88000002 88000002 * Ebx: 389E8708: 3868DCE4 000004F7
| 00000004 000004F4 00000004 00000000 * Ecx: 00000033:
| * Edx: 00000002:
| * Eip: 007F8A40: 4604B70F 8D4C4303 8BFA3074 8BA50C45 A5663448
| C150418B * Ebp: 067BFCF4: 067BFD10 00801CB1 3AE52D68 3AE225E8
| 00000000 3AE52998 * SegCs: 0000001B:
| * EFlags: 00010207: 43003B00 5C003A00 49005700 44004E00 57004F00
| 3B005300 * Esp: 067BFC6C: 00000001 3AE52B44 00000000 00000000
| 00000000 00C567A0 * SegSs: 00000023:
| *
|
************************************************** **************************
***
| *
|
| * Short Stack Dump
| * 007F8A40 Module(sqlservr+003F8A40)
| (RangeGenerator::GetNextRange+000003D0) * 00801CB1
| Module(sqlservr+00401CB1) (RowsetSS::FetchNextRow+00000153) * 0042A4F6
| Module(sqlservr+0002A4F6) (CQScanRowset::GetRowWithPrefetch+00000040) *
| 0042C21B Module(sqlservr+0002C21B) (CQScanRange::GetRow+000000EF) *
| 004314C9 Module(sqlservr+000314C9) (CQScanHashMatch::Iterate+00000BAF) *
| 00431B41 Module(sqlservr+00031B41) (CQScanHashMatch::GetRow+0000009F) *
| 006FCBF7 Module(sqlservr+002FCBF7) (CQScanXProducer::Open+0000039B) *
| 006FC656 Module(sqlservr+002FC656) (FnProducerThread+0000020E) * 0051274C
| Module(sqlservr+0011274C) (subproc_main+000000C2) * 41075002
| Module(UMS+00005002) (ProcessWorkRequests+00000272) * 41074698
| Module(UMS+00004698) (ThreadStartRoutine+00000098) * 77BC90A2
| Module(MSVCRT+000290A2) (endthread+000000A6) * 77E4A990
| Module(kernel32+0000A990) (FlsSetValue+00000779)
|

EXCEPTION_ACCESS_VIOLATION in RangeGenerator::GetNextRange

Hi,
I'm getting errors from SQL Server 2000 SP3 running under Windows Server
2003. Rebooting the server doesn't help and running DBCC CHECKDB doesn't
give any errors. I've looked in the Knowledge Base for articles dealing
with EXCEPTION_ACCESS_VIOLATION errors, but none of them seen to apply to
me.
Here is part of what is showing up in the log:
SqlDumpExceptionHandler: Process 1780 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. *
****************************************
************************************
***
*
* BEGIN STACK DUMP:
* 06/25/04 14:49:33 spid 55
*
* Exception Address = 007F8A40 (RangeGenerator::GetNextRange + 000003D0
Line 0+00000000) * Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION * Access Violation occurred reading address
E89C400A * Input Buffer 2342 bytes -
* select distinct rb.brand_cd,rb.report_item_cd into #temp4rb from
REPORT_ * LIST rl,REPORT_BRANDS rb where service_cd=1 and report_cd=35
and report_ * table_cd=4 and rl.report_item_cd=rb.report_item_cd select
market_cd,sto * re_cd,ad_dt_yyyymm,report_item_cd,ad_qua
lity_cd,sum(
ad_cnt) ad_cnt into * #temp4ac from FEAT_SUM_QUAL_REBATE f,#temp4rb rb
where f.brand_cd=rb.br * and_cd and market_cd in
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,
17 *
,18,19,20,21,22,23,24,25,27,28,29,31,32,
34,35,36,37,38,40,44,46,49,50,52 *
,53,57,77,78,85,86,87) and ad_dt_yyyymm in ( 200405,200404,200403,
* 200402,200401,200312,200311,200310,20030
9,200308,200307,200306) group
by * market_cd,store_cd,ad_dt_yyyymm,report_i
tem_cd,ad_quality_cd *
* MODULE BASE END SIZE * sqlservr
00400000 00B2CFFF 0072d000 * ntdll
77F40000 77FF9FFF 000ba000 * kernel32
77E40000 77F33FFF 000f4000 * ADVAPI32 77DA0000
77E2FFFF 00090000 * RPCRT4 77C50000 77CF3FFF
000a4000 * USER32 77D00000 77D8EFFF 0008f000 *
GDI32 77C00000 77C43FFF 00044000 * OPENDS60
41060000 41065FFF 00006000 * MSVCRT
77BA0000 77BF3FFF 00054000 * UMS
41070000 4107CFFF 0000d000 * SQLSORT 42AE0000
42B6FFFF 00090000 * MSVCIRT 60020000 6002FFFF
00010000 * sqlevn70 41080000 41086FFF 00007000 *
NETAPI32 02C60000 02CB2FFF 00053000 * ole32
030D0000 031F3FFF 00124000 * XOLEHLP
03200000 03205FFF 00006000 * MSDTCPRX
03210000 03280FFF 00071000 * OLEAUT32 03290000
0330CFFF 0007d000 * MSVCP60 03310000 03370FFF
00061000 * MTXCLU 03380000 03397FFF 00018000 *
VERSION 033A0000 033A7FFF 00008000 * WSOCK32
033B0000 033B8FFF 00009000 * WS2_32
033C0000 033D7FFF 00018000 * WS2HELP
033E0000 033E7FFF 00008000 * CLUSAPI 03430000
03440FFF 00011000 * RESUTILS 03450000 03461FFF
00012000 * USERENV 03470000 03529FFF 000ba000 *
MFC42u 03530000 03623FFF 000f4000 * secur32
036B0000 036C2FFF 00013000 * mswsock
036E0000 03722FFF 00043000 * DNSAPI
03730000 03756FFF 00027000 * winrnr 037A0000
037A6FFF 00007000 * WLDAP32 037B0000 037DEFFF
0002f000 * rasadhlp 03800000 03804FFF 00005000 *
SSNMPN70 00C70000 00C75FFF 00006000 * SSNETLIB
00C80000 00C94FFF 00015000 * security
044B0000 044B3FFF 00004000 * wshtcpip
04500000 04507FFF 00008000 * SSmsLPCn 04510000
04516FFF 00007000 * ntdsapi 04530000 04545FFF
00016000 * SQLFTQRY 04420000 04451FFF 00032000 *
CLBCatQ 04A60000 04ADDFFF 0007e000 * COMRes
04AE0000 04BA5FFF 000c6000 * sqloledb
04BB0000 04C35FFF 00086000 * MSDART
04480000 044A8FFF 00029000 * COMCTL32 04C40000
04CCFFFF 00090000 * comdlg32 04CD0000 04D16FFF
00047000 * SHLWAPI 04D20000 04D68FFF 00049000 *
SHELL32 04D70000 0554CFFF 007dd000 * MSDATL3
045B0000 045C7FFF 00018000 * comctl32
05550000 05635FFF 000e6000 * oledb32
059E0000 05A5CFFF 0007d000 * OLEDB32R 05A60000
05A70FFF 00011000 * rsaenh 0FFD0000 0FFFCFFF
0002d000 * PSAPI 05B00000 05B0AFFF 0000b000 *
xpstar 03050000 03096FFF 00047000 * SQLRESLD
030A0000 030A6FFF 00007000 * SQLSVC
030B0000 030C6FFF 00017000 * ODBC32
05C10000 05C49FFF 0003a000 * odbcbcp 05C50000
05C55FFF 00006000 * W95SCM 05C60000 05C6BFFF
0000c000 * SQLUNIRL 05C70000 05C9CFFF 0002d000 *
WINSPOOL 05CA0000 05CC5FFF 00026000 * SHFOLDER
05CD0000 05CD8FFF 00009000 * odbcint
05EB0000 05EC6FFF 00017000 * NDDEAPI
05FE0000 05FE6FFF 00007000 * SQLSVC 05FF0000
05FF5FFF 00006000 * xpstar 06000000 06008FFF
00009000 * dbghelp 06840000 068F4FFF 000b5000 *
* Edi: 067BFCD8: 3AE52EB8 067BFD10 A7FFFFFA 389C2000 067BFDB4
0097C46F * Esi: 389C2000: 01000201 00018000 00000000 00150000
00000000 00330000 * Eax: 58001005: 00000000 03000000 00000B00
8C000000 88000002 88000002 * Ebx: 389E8708: 3868DCE4 000004F7
00000004 000004F4 00000004 00000000 * Ecx: 00000033:
* Edx: 00000002:
* Eip: 007F8A40: 4604B70F 8D4C4303 8BFA3074 8BA50C45 A5663448
C150418B * Ebp: 067BFCF4: 067BFD10 00801CB1 3AE52D68 3AE225E8
00000000 3AE52998 * SegCs: 0000001B:
* EFlags: 00010207: 43003B00 5C003A00 49005700 44004E00 57004F00
3B005300 * Esp: 067BFC6C: 00000001 3AE52B44 00000000 00000000
00000000 00C567A0 * SegSs: 00000023:
*
****************************************
************************************
***
*
----
--
* Short Stack Dump
* 007F8A40 Module(sqlservr+003F8A40)
(RangeGenerator::GetNextRange+000003D0) * 00801CB1
Module(sqlservr+00401CB1) (RowsetSS::FetchNextRow+00000153) * 0042A4F6
Module(sqlservr+0002A4F6) (CQScanRowset::GetRowWithPrefetch+000000
40) *
0042C21B Module(sqlservr+0002C21B) (CQScanRange::GetRow+000000EF) *
004314C9 Module(sqlservr+000314C9) (CQScanHashMatch::Iterate+00000BAF) *
00431B41 Module(sqlservr+00031B41) (CQScanHashMatch::GetRow+0000009F) *
006FCBF7 Module(sqlservr+002FCBF7) (CQScanXProducer::Open+0000039B) *
006FC656 Module(sqlservr+002FC656) (FnProducerThread+0000020E) * 0051274C
Module(sqlservr+0011274C) (subproc_main+000000C2) * 41075002
Module(UMS+00005002) (ProcessWorkRequests+00000272) * 41074698
Module(UMS+00004698) (ThreadStartRoutine+00000098) * 77BC90A2
Module(MSVCRT+000290A2) (endthread+000000A6) * 77E4A990
Module(kernel32+0000A990) (FlsSetValue+00000779)If you don't find anything on KB, are up on sp and CHECKDB comes out clean,
it is time for a case
with MS Support...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Glen K" <blah@.blah.com> wrote in message news:pan.2004.06.25.19.18.22.966869@.blah.com...[vb
col=seagreen]
> Hi,
> I'm getting errors from SQL Server 2000 SP3 running under Windows Server
> 2003. Rebooting the server doesn't help and running DBCC CHECKDB doesn't
> give any errors. I've looked in the Knowledge Base for articles dealing
> with EXCEPTION_ACCESS_VIOLATION errors, but none of them seen to apply to
> me.
> Here is part of what is showing up in the log:
>
> SqlDumpExceptionHandler: Process 1780 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. *
> ****************************************
**********************************
*****
> *
> * BEGIN STACK DUMP:
> * 06/25/04 14:49:33 spid 55
> *
> * Exception Address = 007F8A40 (RangeGenerator::GetNextRange + 000003D0
> Line 0+00000000) * Exception Code = c0000005
> EXCEPTION_ACCESS_VIOLATION * Access Violation occurred reading address
> E89C400A * Input Buffer 2342 bytes -
> * select distinct rb.brand_cd,rb.report_item_cd into #temp4rb from
> REPORT_ * LIST rl,REPORT_BRANDS rb where service_cd=1 and report_cd=35
> and report_ * table_cd=4 and rl.report_item_cd=rb.report_item_cd select
> market_cd,sto * re_cd,ad_dt_yyyymm,report_item_cd,ad_qua
lity_cd,sum(
> ad_cnt) ad_cnt into * #temp4ac from FEAT_SUM_QUAL_REBATE f,#temp4rb rb
> where f.brand_cd=rb.br * and_cd and market_cd in
> (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,
17 *
> ,18,19,20,21,22,23,24,25,27,28,29,31,32,
34,35,36,37,38,40,44,46,49,50,52 *
> ,53,57,77,78,85,86,87) and ad_dt_yyyymm in ( 200405,200404,200403,
> * 200402,200401,200312,200311,200310,20030
9,200308,200307,200306) group
> by * market_cd,store_cd,ad_dt_yyyymm,report_i
tem_cd,ad_quality_cd *
> * MODULE BASE END SIZE * sqlservr
> 00400000 00B2CFFF 0072d000 * ntdll
> 77F40000 77FF9FFF 000ba000 * kernel32
> 77E40000 77F33FFF 000f4000 * ADVAPI32 77DA0000
> 77E2FFFF 00090000 * RPCRT4 77C50000 77CF3FFF
> 000a4000 * USER32 77D00000 77D8EFFF 0008f000 *
> GDI32 77C00000 77C43FFF 00044000 * OPENDS60
> 41060000 41065FFF 00006000 * MSVCRT
> 77BA0000 77BF3FFF 00054000 * UMS
> 41070000 4107CFFF 0000d000 * SQLSORT 42AE0000
> 42B6FFFF 00090000 * MSVCIRT 60020000 6002FFFF
> 00010000 * sqlevn70 41080000 41086FFF 00007000 *
> NETAPI32 02C60000 02CB2FFF 00053000 * ole32
> 030D0000 031F3FFF 00124000 * XOLEHLP
> 03200000 03205FFF 00006000 * MSDTCPRX
> 03210000 03280FFF 00071000 * OLEAUT32 03290000
> 0330CFFF 0007d000 * MSVCP60 03310000 03370FFF
> 00061000 * MTXCLU 03380000 03397FFF 00018000 *
> VERSION 033A0000 033A7FFF 00008000 * WSOCK32
> 033B0000 033B8FFF 00009000 * WS2_32
> 033C0000 033D7FFF 00018000 * WS2HELP
> 033E0000 033E7FFF 00008000 * CLUSAPI 03430000
> 03440FFF 00011000 * RESUTILS 03450000 03461FFF
> 00012000 * USERENV 03470000 03529FFF 000ba000 *
> MFC42u 03530000 03623FFF 000f4000 * secur32
> 036B0000 036C2FFF 00013000 * mswsock
> 036E0000 03722FFF 00043000 * DNSAPI
> 03730000 03756FFF 00027000 * winrnr 037A0000
> 037A6FFF 00007000 * WLDAP32 037B0000 037DEFFF
> 0002f000 * rasadhlp 03800000 03804FFF 00005000 *
> SSNMPN70 00C70000 00C75FFF 00006000 * SSNETLIB
> 00C80000 00C94FFF 00015000 * security
> 044B0000 044B3FFF 00004000 * wshtcpip
> 04500000 04507FFF 00008000 * SSmsLPCn 04510000
> 04516FFF 00007000 * ntdsapi 04530000 04545FFF
> 00016000 * SQLFTQRY 04420000 04451FFF 00032000 *
> CLBCatQ 04A60000 04ADDFFF 0007e000 * COMRes
> 04AE0000 04BA5FFF 000c6000 * sqloledb
> 04BB0000 04C35FFF 00086000 * MSDART
> 04480000 044A8FFF 00029000 * COMCTL32 04C40000
> 04CCFFFF 00090000 * comdlg32 04CD0000 04D16FFF
> 00047000 * SHLWAPI 04D20000 04D68FFF 00049000 *
> SHELL32 04D70000 0554CFFF 007dd000 * MSDATL3
> 045B0000 045C7FFF 00018000 * comctl32
> 05550000 05635FFF 000e6000 * oledb32
> 059E0000 05A5CFFF 0007d000 * OLEDB32R 05A60000
> 05A70FFF 00011000 * rsaenh 0FFD0000 0FFFCFFF
> 0002d000 * PSAPI 05B00000 05B0AFFF 0000b000 *
> xpstar 03050000 03096FFF 00047000 * SQLRESLD
> 030A0000 030A6FFF 00007000 * SQLSVC
> 030B0000 030C6FFF 00017000 * ODBC32
> 05C10000 05C49FFF 0003a000 * odbcbcp 05C50000
> 05C55FFF 00006000 * W95SCM 05C60000 05C6BFFF
> 0000c000 * SQLUNIRL 05C70000 05C9CFFF 0002d000 *
> WINSPOOL 05CA0000 05CC5FFF 00026000 * SHFOLDER
> 05CD0000 05CD8FFF 00009000 * odbcint
> 05EB0000 05EC6FFF 00017000 * NDDEAPI
> 05FE0000 05FE6FFF 00007000 * SQLSVC 05FF0000
> 05FF5FFF 00006000 * xpstar 06000000 06008FFF
> 00009000 * dbghelp 06840000 068F4FFF 000b5000 *
> * Edi: 067BFCD8: 3AE52EB8 067BFD10 A7FFFFFA 389C2000 067BFDB4
> 0097C46F * Esi: 389C2000: 01000201 00018000 00000000 00150000
> 00000000 00330000 * Eax: 58001005: 00000000 03000000 00000B00
> 8C000000 88000002 88000002 * Ebx: 389E8708: 3868DCE4 000004F7
> 00000004 000004F4 00000004 00000000 * Ecx: 00000033:
> * Edx: 00000002:
> * Eip: 007F8A40: 4604B70F 8D4C4303 8BFA3074 8BA50C45 A5663448
> C150418B * Ebp: 067BFCF4: 067BFD10 00801CB1 3AE52D68 3AE225E8
> 00000000 3AE52998 * SegCs: 0000001B:
> * EFlags: 00010207: 43003B00 5C003A00 49005700 44004E00 57004F00
> 3B005300 * Esp: 067BFC6C: 00000001 3AE52B44 00000000 00000000
> 00000000 00C567A0 * SegSs: 00000023:
> *
> ****************************************
**********************************
*****
> *
> ----
--
> * Short Stack Dump
> * 007F8A40 Module(sqlservr+003F8A40)
> (RangeGenerator::GetNextRange+000003D0) * 00801CB1
> Module(sqlservr+00401CB1) (RowsetSS::FetchNextRow+00000153) * 0042A4F6
> Module(sqlservr+0002A4F6) (CQScanRowset::GetRowWithPrefetch+000000
40) *
> 0042C21B Module(sqlservr+0002C21B) (CQScanRange::GetRow+000000EF) *
> 004314C9 Module(sqlservr+000314C9) (CQScanHashMatch::Iterate+00000BAF) *
> 00431B41 Module(sqlservr+00031B41) (CQScanHashMatch::GetRow+0000009F) *
> 006FCBF7 Module(sqlservr+002FCBF7) (CQScanXProducer::Open+0000039B) *
> 006FC656 Module(sqlservr+002FC656) (FnProducerThread+0000020E) * 0051274C
> Module(sqlservr+0011274C) (subproc_main+000000C2) * 41075002
> Module(UMS+00005002) (ProcessWorkRequests+00000272) * 41074698
> Module(UMS+00004698) (ThreadStartRoutine+00000098) * 77BC90A2
> Module(MSVCRT+000290A2) (endthread+000000A6) * 77E4A990
> Module(kernel32+0000A990) (FlsSetValue+00000779)[/vbcol]|||Hi Glen,
Thanks for Tibor's suggestion. Looking at the nature of this issue, it
would require intensive troubleshooting which would be done quickly and
effectively with direct assistance from a Microsoft Support Professional
through Microsoft Product Support Services. You can contact Microsoft
Product Support directly by choosing one of the options listed at
http://support.microsoft.com/defaul...d=sz;en-us;top.
If this is not an urgent issue and you would like us to create an incident
for you and have Microsoft Customer Service Representative contact you
directly, please send email to (remove "online." from this no Spam email
address) mailto:dscommhf@.online.microsoft.com with the following
information,
*Include "Followup: <Tomcat IssueID>" in the email Subject.
*Location of the post
*First Name, Last Name
*MSDN Subscriber ID
*Company name (if any)
*Phone number
*e-mail address
Sincerely yours,
Bill Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
--
| From: Glen K <blah@.blah.com>
| Subject: EXCEPTION_ACCESS_VIOLATION in RangeGenerator::GetNextRange
| User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing
moment of clarity.)
| Message-ID: <pan.2004.06.25.19.18.22.966869@.blah.com>
| Newsgroups: microsoft.public.sqlserver.server
| MIME-Version: 1.0
| Content-Type: text/plain; charset=ISO-2022-jp
| Content-Transfer-Encoding: 8bit
| Lines: 124
| Date: Fri, 25 Jun 2004 19:18:22 GMT
| NNTP-Posting-Host: 67.86.129.2
| X-Complaints-To: abuse@.cv.net
| X-Trace: news4.srv.hcvlny.cv.net 1088191102 67.86.129.2 (Fri, 25 Jun 2004
15:18:22 EDT)
| NNTP-Posting-Date: Fri, 25 Jun 2004 15:18:22 EDT
| Organization: Optimum Online
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!f
eed5.newsreader.com!newsreader.com!news3.optonline.net!news4.srv.hcvlny.cv.n
et.POSTED!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:347783
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi,
| I'm getting errors from SQL Server 2000 SP3 running under Windows Server
| 2003. Rebooting the server doesn't help and running DBCC CHECKDB doesn't
| give any errors. I've looked in the Knowledge Base for articles dealing
| with EXCEPTION_ACCESS_VIOLATION errors, but none of them seen to apply to
| me.
|
| Here is part of what is showing up in the log:
|
|
|
| SqlDumpExceptionHandler: Process 1780 generated fatal exception c0000005
| EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. *
|
****************************************
************************************
***
| *
| * BEGIN STACK DUMP:
| * 06/25/04 14:49:33 spid 55
| *
| * Exception Address = 007F8A40 (RangeGenerator::GetNextRange + 000003D0
| Line 0+00000000) * Exception Code = c0000005
| EXCEPTION_ACCESS_VIOLATION * Access Violation occurred reading address
| E89C400A * Input Buffer 2342 bytes -
| * select distinct rb.brand_cd,rb.report_item_cd into #temp4rb from
| REPORT_ * LIST rl,REPORT_BRANDS rb where service_cd=1 and report_cd=35
| and report_ * table_cd=4 and rl.report_item_cd=rb.report_item_cd select
| market_cd,sto * re_cd,ad_dt_yyyymm,report_item_cd,ad_qua
lity_cd,sum(
| ad_cnt) ad_cnt into * #temp4ac from FEAT_SUM_QUAL_REBATE f,#temp4rb rb
| where f.brand_cd=rb.br * and_cd and market_cd in
| (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,
17 *
| ,18,19,20,21,22,23,24,25,27,28,29,31,32,
34,35,36,37,38,40,44,46,49,50,52 *
| ,53,57,77,78,85,86,87) and ad_dt_yyyymm in ( 200405,200404,200403,
| * 200402,200401,200312,200311,200310,20030
9,200308,200307,200306) group
| by * market_cd,store_cd,ad_dt_yyyymm,report_i
tem_cd,ad_quality_cd *
| * MODULE BASE END SIZE * sqlservr
| 00400000 00B2CFFF 0072d000 * ntdll
| 77F40000 77FF9FFF 000ba000 * kernel32
| 77E40000 77F33FFF 000f4000 * ADVAPI32 77DA0000
| 77E2FFFF 00090000 * RPCRT4 77C50000 77CF3FFF
| 000a4000 * USER32 77D00000 77D8EFFF 0008f000 *
| GDI32 77C00000 77C43FFF 00044000 * OPENDS60
| 41060000 41065FFF 00006000 * MSVCRT
| 77BA0000 77BF3FFF 00054000 * UMS
| 41070000 4107CFFF 0000d000 * SQLSORT 42AE0000
| 42B6FFFF 00090000 * MSVCIRT 60020000 6002FFFF
| 00010000 * sqlevn70 41080000 41086FFF 00007000 *
| NETAPI32 02C60000 02CB2FFF 00053000 * ole32
| 030D0000 031F3FFF 00124000 * XOLEHLP
| 03200000 03205FFF 00006000 * MSDTCPRX
| 03210000 03280FFF 00071000 * OLEAUT32 03290000
| 0330CFFF 0007d000 * MSVCP60 03310000 03370FFF
| 00061000 * MTXCLU 03380000 03397FFF 00018000 *
| VERSION 033A0000 033A7FFF 00008000 * WSOCK32
| 033B0000 033B8FFF 00009000 * WS2_32
| 033C0000 033D7FFF 00018000 * WS2HELP
| 033E0000 033E7FFF 00008000 * CLUSAPI 03430000
| 03440FFF 00011000 * RESUTILS 03450000 03461FFF
| 00012000 * USERENV 03470000 03529FFF 000ba000 *
| MFC42u 03530000 03623FFF 000f4000 * secur32
| 036B0000 036C2FFF 00013000 * mswsock
| 036E0000 03722FFF 00043000 * DNSAPI
| 03730000 03756FFF 00027000 * winrnr 037A0000
| 037A6FFF 00007000 * WLDAP32 037B0000 037DEFFF
| 0002f000 * rasadhlp 03800000 03804FFF 00005000 *
| SSNMPN70 00C70000 00C75FFF 00006000 * SSNETLIB
| 00C80000 00C94FFF 00015000 * security
| 044B0000 044B3FFF 00004000 * wshtcpip
| 04500000 04507FFF 00008000 * SSmsLPCn 04510000
| 04516FFF 00007000 * ntdsapi 04530000 04545FFF
| 00016000 * SQLFTQRY 04420000 04451FFF 00032000 *
| CLBCatQ 04A60000 04ADDFFF 0007e000 * COMRes
| 04AE0000 04BA5FFF 000c6000 * sqloledb
| 04BB0000 04C35FFF 00086000 * MSDART
| 04480000 044A8FFF 00029000 * COMCTL32 04C40000
| 04CCFFFF 00090000 * comdlg32 04CD0000 04D16FFF
| 00047000 * SHLWAPI 04D20000 04D68FFF 00049000 *
| SHELL32 04D70000 0554CFFF 007dd000 * MSDATL3
| 045B0000 045C7FFF 00018000 * comctl32
| 05550000 05635FFF 000e6000 * oledb32
| 059E0000 05A5CFFF 0007d000 * OLEDB32R 05A60000
| 05A70FFF 00011000 * rsaenh 0FFD0000 0FFFCFFF
| 0002d000 * PSAPI 05B00000 05B0AFFF 0000b000 *
| xpstar 03050000 03096FFF 00047000 * SQLRESLD
| 030A0000 030A6FFF 00007000 * SQLSVC
| 030B0000 030C6FFF 00017000 * ODBC32
| 05C10000 05C49FFF 0003a000 * odbcbcp 05C50000
| 05C55FFF 00006000 * W95SCM 05C60000 05C6BFFF
| 0000c000 * SQLUNIRL 05C70000 05C9CFFF 0002d000 *
| WINSPOOL 05CA0000 05CC5FFF 00026000 * SHFOLDER
| 05CD0000 05CD8FFF 00009000 * odbcint
| 05EB0000 05EC6FFF 00017000 * NDDEAPI
| 05FE0000 05FE6FFF 00007000 * SQLSVC 05FF0000
| 05FF5FFF 00006000 * xpstar 06000000 06008FFF
| 00009000 * dbghelp 06840000 068F4FFF 000b5000 *
| * Edi: 067BFCD8: 3AE52EB8 067BFD10 A7FFFFFA 389C2000 067BFDB4
| 0097C46F * Esi: 389C2000: 01000201 00018000 00000000 00150000
| 00000000 00330000 * Eax: 58001005: 00000000 03000000 00000B00
| 8C000000 88000002 88000002 * Ebx: 389E8708: 3868DCE4 000004F7
| 00000004 000004F4 00000004 00000000 * Ecx: 00000033:
| * Edx: 00000002:
| * Eip: 007F8A40: 4604B70F 8D4C4303 8BFA3074 8BA50C45 A5663448
| C150418B * Ebp: 067BFCF4: 067BFD10 00801CB1 3AE52D68 3AE225E8
| 00000000 3AE52998 * SegCs: 0000001B:
| * EFlags: 00010207: 43003B00 5C003A00 49005700 44004E00 57004F00
| 3B005300 * Esp: 067BFC6C: 00000001 3AE52B44 00000000 00000000
| 00000000 00C567A0 * SegSs: 00000023:
| *
|
****************************************
************************************
***
| *
|
----
--
| * Short Stack Dump
| * 007F8A40 Module(sqlservr+003F8A40)
| (RangeGenerator::GetNextRange+000003D0) * 00801CB1
| Module(sqlservr+00401CB1) (RowsetSS::FetchNextRow+00000153) * 0042A4F6
| Module(sqlservr+0002A4F6) (CQScanRowset::GetRowWithPrefetch+000000
40) *
| 0042C21B Module(sqlservr+0002C21B) (CQScanRange::GetRow+000000EF) *
| 004314C9 Module(sqlservr+000314C9) (CQScanHashMatch::Iterate+00000BAF) *
| 00431B41 Module(sqlservr+00031B41) (CQScanHashMatch::GetRow+0000009F) *
| 006FCBF7 Module(sqlservr+002FCBF7) (CQScanXProducer::Open+0000039B) *
| 006FC656 Module(sqlservr+002FC656) (FnProducerThread+0000020E) * 0051274C
| Module(sqlservr+0011274C) (subproc_main+000000C2) * 41075002
| Module(UMS+00005002) (ProcessWorkRequests+00000272) * 41074698
| Module(UMS+00004698) (ThreadStartRoutine+00000098) * 77BC90A2
| Module(MSVCRT+000290A2) (endthread+000000A6) * 77E4A990
| Module(kernel32+0000A990) (FlsSetValue+00000779)
|

EXCEPTION_ACCESS_VIOLATION and sp3

Hi.
I installed SQL Server 2000 (it's a DC running Win2K Server SP4,
Exchange 2000 built 6249:4 SP3, Etrust Inoculate it 7.0, Zetafax
7.5) but the service didn't start and in the event
viewer the following error occured:
Event ID: 17055
Source: MSSQLSERVER
DESC: 17310:
FRunCm: Process 4008 gen fatal except c0000005
EXCEPTION_ACCESS_VIOLATION.
SQL Server is terminating the process.
As per Microsoft I ran SP3a ( http://support.microsoft.com/?kbid=814572 ) :
the setup stops and I obtained an error in the script
"sp3_serv_uni.sql" .
I checked sp3_serv_uni.out : "..General network error..".
I tried using Named Pipes only in Network Utility and the same for Client
Network Utility on the Server : it doesn't work !!
From where i had to start to solve the problem?
Please Help ( no deep experience in SQL2k...) .Thanks
P.S.Analysis Services is not installed.have u installed the latest MDAC as well?
Try change the Port number or use TCP/IP
Regards
Z
"Corrado N." <coradon_987@.libero.it> wrote in message
news:bk7997$ppe7h$1@.ID-107005.news.uni-berlin.de...
> Hi.
> I installed SQL Server 2000 (it's a DC running Win2K Server SP4,
> Exchange 2000 built 6249:4 SP3, Etrust Inoculate it 7.0, Zetafax
> 7.5) but the service didn't start and in the event
> viewer the following error occured:
> Event ID: 17055
> Source: MSSQLSERVER
> DESC: 17310:
> FRunCm: Process 4008 gen fatal except c0000005
> EXCEPTION_ACCESS_VIOLATION.
> SQL Server is terminating the process.
>
> As per Microsoft I ran SP3a ( http://support.microsoft.com/?kbid=814572 )
:
> the setup stops and I obtained an error in the script
> "sp3_serv_uni.sql" .
> I checked sp3_serv_uni.out : "..General network error..".
> I tried using Named Pipes only in Network Utility and the same for
Client
> Network Utility on the Server : it doesn't work !!
> From where i had to start to solve the problem?
> Please Help ( no deep experience in SQL2k...) .Thanks
> P.S.Analysis Services is not installed.
>

Excel Pivot Table

When I use Excel 2002 Sp3 to connect to the AS2000. I can select multiple value in the Page field. But when I install the OLAP AS 9.0 provider to connect to the AS2005. The multiple value selection is disapper. How can I fix this?There is a 'select multiple items' checkbox in the bottom area of the dropdown box.

If this is not visible - I'd almost think that your Excel platform at that specific time is Excel 2000.
Try recreating your pivot table from the as2005 cube|||I am using Excel 2002. It is funny sometime the muti value check box appear, sometime it disappear. I also try to reinstall the Excel, but it doesn't help|||

Did you upgrade MSXML to 6.0 as well as upgrading the AS Provider ?

Must say I don't get this behaviour in 2003 having added both the upgrades

|||Yes MSXML 6.0 Parser and MS OLAP Provide For AS 9.0 have been installed in my computer. Now I find the tempoary solution. If I run another application such as IE6 to overlap the Excel, then I can see the multi value check box. It is really @.$%...?|||

It's good that you're getting somewhere!

I remember that in some cases, I've had to have MDAC 2.8 installed if it wasn't already present. You shouldn't be getting that far in excel w/o it, but it's worth a try.

http://www.microsoft.com/downloads/details.aspx?DisplayLang=en&FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c