Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Services are stopped automatically Expand / Collapse
Author
Message
Posted Wednesday, August 28, 2013 4:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402
Hi All,

we have one server which is have windows 2008r2 and sql server2008r2. here we have three instances but in that 2 named instances for named instances services are stopped automatically.

we checked in error log the message is:

2013-08-28 01:47:51 - ? [100] Microsoft SQLServerAgent version 10.50.1600.1 ((Unknown) unicode retail build) : Process ID 2156
2013-08-28 01:47:51 - ? [101] SQL Server ARSAMANT-WS05\ION_INST_ETL_02 version 10.50.1600 (0 connection limit)
2013-08-28 01:47:51 - ? [102] SQL Server ODBC driver version 10.50.1720
2013-08-28 01:47:51 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is ARSAMANT-WS05\ION_INST_ETL_02
2013-08-28 01:47:51 - ? [310] 24 processor(s) and 98243 MB RAM detected
2013-08-28 01:47:51 - ? [339] Local computer is ARSAMANT-WS05 running Windows NT 6.1 (7600)
2013-08-28 01:47:51 - ? [432] There are 12 subsystems in the subsystems cache
2013-08-28 01:47:52 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2013-08-28 01:47:52 - ? [129] SQLAgent$ION_INST_ETL_02 starting under Windows NT service control
2013-08-28 01:47:52 - + [260] Unable to start mail session (reason: No mail profile defined)
2013-08-28 01:47:52 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2013-08-28 02:16:21 - ! [012] The MSSQL$ION_INST_ETL_02 service terminated unexpectedly
2013-08-28 02:16:21 - + [139] AutoRestart: Attempting to restart the MSSQL$ION_INST_ETL_02 service (attempt #1)...
2013-08-28 02:16:31 - ! [368] AutoRestart: Unable to restart the MSSQL$ION_INST_ETL_02 service (reason: Access is denied)
2013-08-28 02:16:36 - ! [359] The local host server is not running
2013-08-28 02:16:36 - + [139] AutoRestart: Attempting to restart the MSSQL$ION_INST_ETL_02 service (attempt #2)...
2013-08-28 02:16:36 - ! [368] AutoRestart: Unable to restart the MSSQL$ION_INST_ETL_02 service (reason: Access is denied)
2013-08-28 02:16:41 - + [139] AutoRestart: Attempting to restart the MSSQL$ION_INST_ETL_02 service (attempt #3)...
2013-08-28 02:16:41 - ! [368] AutoRestart: Unable to restart the MSSQL$ION_INST_ETL_02 service (reason: Access is denied)
2013-08-28 02:16:41 - ! [140] AutoRestart: The MSSQL$ION_INST_ETL_02 service could not be restarted after 3 attempts
2013-08-28 02:16:41 - + [360] SQLServerAgent initiating shutdown following MSSQL$ION_INST_ETL_02 shutdown
2013-08-28 02:16:43 - ! [359] The local host server is not running
2013-08-28 02:16:43 - ! [359] The local host server is not running
2013-08-28 02:16:43 - ? [098] SQLServerAgent terminated (normally)
here default instance is running successfully

what may be the problem
Post #1489098
Posted Wednesday, August 28, 2013 4:14 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:50 AM
Points: 5,329, Visits: 9,773
That's telling you that SQL Server Agent stopped because SQL Server stopped unexpectedly. To find out why SQL Server stopped, try the SQL Server errorlog or the Windows event log.

John
Post #1489102
Posted Wednesday, August 28, 2013 4:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402
in previous post i have mentioned the event viewer log file.

here ia m sending the sql error log as well.

2013-08-28 01:47:51 - ? [100] Microsoft SQLServerAgent version 10.50.1600.1 ((Unknown) unicode retail build) : Process ID 2156
2013-08-28 01:47:51 - ? [101] SQL Server ARSAMANT-WS05\ION_INST_ETL_02 version 10.50.1600 (0 connection limit)
2013-08-28 01:47:51 - ? [102] SQL Server ODBC driver version 10.50.1720
2013-08-28 01:47:51 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is ARSAMANT-WS05\ION_INST_ETL_02
2013-08-28 01:47:51 - ? [310] 24 processor(s) and 98243 MB RAM detected
2013-08-28 01:47:51 - ? [339] Local computer is ARSAMANT-WS05 running Windows NT 6.1 (7600)
2013-08-28 01:47:51 - ? [432] There are 12 subsystems in the subsystems cache
2013-08-28 01:47:52 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2013-08-28 01:47:52 - ? [129] SQLAgent$ION_INST_ETL_02 starting under Windows NT service control
2013-08-28 01:47:52 - + [260] Unable to start mail session (reason: No mail profile defined)
2013-08-28 01:47:52 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2013-08-28 02:16:21 - ! [012] The MSSQL$ION_INST_ETL_02 service terminated unexpectedly
2013-08-28 02:16:21 - + [139] AutoRestart: Attempting to restart the MSSQL$ION_INST_ETL_02 service (attempt #1)...
2013-08-28 02:16:31 - ! [368] AutoRestart: Unable to restart the MSSQL$ION_INST_ETL_02 service (reason: Access is denied)
2013-08-28 02:16:36 - ! [359] The local host server is not running
2013-08-28 02:16:36 - + [139] AutoRestart: Attempting to restart the MSSQL$ION_INST_ETL_02 service (attempt #2)...
2013-08-28 02:16:36 - ! [368] AutoRestart: Unable to restart the MSSQL$ION_INST_ETL_02 service (reason: Access is denied)
2013-08-28 02:16:41 - + [139] AutoRestart: Attempting to restart the MSSQL$ION_INST_ETL_02 service (attempt #3)...
2013-08-28 02:16:41 - ! [368] AutoRestart: Unable to restart the MSSQL$ION_INST_ETL_02 service (reason: Access is denied)
2013-08-28 02:16:41 - ! [140] AutoRestart: The MSSQL$ION_INST_ETL_02 service could not be restarted after 3 attempts
2013-08-28 02:16:41 - + [360] SQLServerAgent initiating shutdown following MSSQL$ION_INST_ETL_02 shutdown
2013-08-28 02:16:43 - ! [359] The local host server is not running
2013-08-28 02:16:43 - ! [359] The local host server is not running
2013-08-28 02:16:43 - ? [098] SQLServerAgent terminated (normally)


here if we start manually it is working but after 10 mins it is went to stop mode. default instance is working fine
Post #1489106
Posted Wednesday, August 28, 2013 4:46 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:50 AM
Points: 5,329, Visits: 9,773
Posting exactly the same thing again doesn't alter the fact that it's from SQLAGENT.OUT, not from the SQL Server errorlog. From the Access Denied error, I'd say you've got an issue with permissions. Have you recently changed the account under which SQL Server runs?

John
Post #1489119
Posted Wednesday, August 28, 2013 5:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402
no we have not changed any accounts here all are running under same account (network service account).

for sql error log we have restarted the service now it is showing that information only.
Post #1489141
Posted Wednesday, August 28, 2013 11:15 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402
here in event viewer we are getting message like " server 'server name' is terminated unexpectedly"

we are getting this message only
Post #1489520
Posted Wednesday, August 28, 2013 11:29 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, August 28, 2014 3:25 AM
Points: 519, Visits: 165
try changing it to a domain account and seeing if that makes a difference the inference from the log is that its a permissions issue.

Other than that supply the windows event log and the SQL logs
Post #1489533
Posted Thursday, August 29, 2013 8:59 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402
here i am sending the sql log

2013-08-28 12:56:50.17 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

2013-08-28 12:56:50.17 Server (c) Microsoft Corporation.
2013-08-28 12:56:50.17 Server All rights reserved.
2013-08-28 12:56:50.17 Server Server process ID is 41780.
2013-08-28 12:56:50.17 Server System Manufacturer: 'Intel Corporation', System Model: 'S5520HC'.
2013-08-28 12:56:50.17 Server Authentication mode is MIXED.
2013-08-28 12:56:50.18 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.ION_INST_ETL_02\MSSQL\Log\ERRORLOG'.
2013-08-28 12:56:50.18 Server This instance of SQL Server last reported using a process ID of 22852 at 8/28/2013 12:38:36 PM (local) 8/28/2013 7:38:36 PM (UTC). This is an informational message only; no user action is required.
2013-08-28 12:56:50.18 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL10_50.ION_INST_ETL_02\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL10_50.ION_INST_ETL_02\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL10_50.ION_INST_ETL_02\MSSQL\DATA\mastlog.ldf
2013-08-28 12:56:50.18 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2013-08-28 12:56:50.18 Server Detected 24 CPUs. This is an informational message; no user action is required.
2013-08-28 12:56:50.18 Server Cannot use Large Page Extensions: lock memory privilege was not granted.
2013-08-28 12:56:50.64 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2013-08-28 12:56:50.64 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
2013-08-28 12:56:50.69 Server Node configuration: node 0: CPU mask: 0x0000000000fff000:0 Active CPU mask: 0x0000000000fff000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2013-08-28 12:56:50.69 Server Node configuration: node 1: CPU mask: 0x0000000000000fff:0 Active CPU mask: 0x0000000000000fff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2013-08-28 12:56:50.73 spid8s Starting up database 'master'.
2013-08-28 12:56:50.75 spid8s 3 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2013-08-28 12:56:50.75 spid8s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2013-08-28 12:56:50.75 spid8s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2013-08-28 12:56:50.78 spid8s Resource governor reconfiguration succeeded.
2013-08-28 12:56:50.78 spid8s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2013-08-28 12:56:50.78 spid8s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2013-08-28 12:56:50.78 spid8s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'ION_INST_ETL_02'.
2013-08-28 12:56:50.81 spid8s SQL Trace ID 1 was started by login "sa".
2013-08-28 12:56:50.81 spid8s Starting up database 'mssqlsystemresource'.
2013-08-28 12:56:50.82 spid8s The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
2013-08-28 12:56:50.85 spid13s Starting up database 'model'.
2013-08-28 12:56:50.85 spid8s Server name is 'ARSAMANT-WS05\ION_INST_ETL_02'. This is an informational message only. No user action is required.
2013-08-28 12:56:50.88 spid13s Clearing tempdb database.
2013-08-28 12:56:51.02 spid15s A new instance of the full-text filter daemon host process has been successfully started.
2013-08-28 12:56:51.03 spid13s Starting up database 'tempdb'.
2013-08-28 12:56:51.06 spid15s Starting up database 'msdb'.
2013-08-28 12:56:51.06 spid17s Starting up database 'ION_DB_ETL_03'.
2013-08-28 12:56:51.06 spid16s Starting up database 'distribution'.
2013-08-28 12:56:51.07 spid18s The Service Broker protocol transport is disabled or not configured.
2013-08-28 12:56:51.07 spid18s The Database Mirroring protocol transport is disabled or not configured.
2013-08-28 12:56:51.07 Server A self-generated certificate was successfully loaded for encryption.
2013-08-28 12:56:51.08 Server Server is listening on [ 'any' <ipv6> 4234].
2013-08-28 12:56:51.08 spid18s Service Broker manager has started.
2013-08-28 12:56:51.08 Server Server is listening on [ 'any' <ipv4> 4234].
2013-08-28 12:56:51.08 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\ION_INST_ETL_02 ].
2013-08-28 12:56:51.08 Server Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$ION_INST_ETL_02\sql\query ].
2013-08-28 12:56:51.08 Server Server is listening on [ ::1 <ipv6> 22279].
2013-08-28 12:56:51.08 Server Server is listening on [ 127.0.0.1 <ipv4> 22279].
2013-08-28 12:56:51.08 Server Dedicated admin connection support was established for listening locally on port 22279.
2013-08-28 12:56:51.09 spid15s 19 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2013-08-28 12:56:51.11 spid15s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2013-08-28 12:56:51.11 spid15s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2013-08-28 12:56:51.26 spid16s 1110 transactions rolled forward in database 'distribution' (5). This is an informational message only. No user action is required.
2013-08-28 12:56:51.32 spid16s 0 transactions rolled back in database 'distribution' (5). This is an informational message only. No user action is required.
2013-08-28 12:56:51.32 spid16s Recovery is writing a checkpoint in database 'distribution' (5). This is an informational message only. No user action is required.
2013-08-28 12:56:52.78 Server The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/ARSAMANT-WS05.cisco.com:ION_INST_ETL_02 ] for the SQL Server service.
2013-08-28 12:56:52.78 Server The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/ARSAMANT-WS05.cisco.com:4234 ] for the SQL Server service.
2013-08-28 12:56:52.94 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2013-08-28 12:57:01.36 spid17s Recovery of database 'ION_DB_ETL_03' (7) is 0% complete (approximately 165 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
2013-08-28 12:57:01.83 spid17s Recovery of database 'ION_DB_ETL_03' (7) is 0% complete (approximately 165 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
2013-08-28 12:57:01.86 spid17s Recovery of database 'ION_DB_ETL_03' (7) is 0% complete (approximately 167 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2013-08-28 12:57:02.01 spid17s Recovery of database 'ION_DB_ETL_03' (7) is 2% complete (approximately 26 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2013-08-28 12:57:04.35 spid17s Recovery of database 'ION_DB_ETL_03' (7) is 10% complete (approximately 24 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2013-08-28 12:57:06.23 spid17s Recovery of database 'ION_DB_ETL_03' (7) is 17% complete (approximately 22 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2013-08-28 12:57:08.24 spid17s Recovery of database 'ION_DB_ETL_03' (7) is 24% complete (approximately 20 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2013-08-28 12:57:11.33 spid17s Recovery of database 'ION_DB_ETL_03' (7) is 32% complete (approximately 20 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2013-08-28 12:57:11.33 spid17s 3022 transactions rolled forward in database 'ION_DB_ETL_03' (7). This is an informational message only. No user action is required.
2013-08-28 12:57:11.82 spid17s Recovery of database 'ION_DB_ETL_03' (7) is 32% complete (approximately 20 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
2013-08-28 12:57:11.86 spid8s 0 transactions rolled back in database 'ION_DB_ETL_03' (7). This is an informational message only. No user action is required.
2013-08-28 12:57:11.86 spid8s Recovery is writing a checkpoint in database 'ION_DB_ETL_03' (7). This is an informational message only. No user action is required.
2013-08-28 12:57:11.86 spid8s Recovery completed for database ION_DB_ETL_03 (database ID 7) in 10 second(s) (analysis 492 ms, redo 9476 ms, undo 42 ms.) This is an informational message only. No user action is required.
2013-08-28 12:57:11.91 spid17s CHECKDB for database 'ION_DB_ETL_03' finished without errors on 2013-04-05 09:37:06.607 (local time). This is an informational message only; no user action is required.
2013-08-28 12:57:11.97 spid8s Recovery is complete. This is an informational message only. No user action is required.
2013-08-28 12:57:11.97 spid8s Launched startup procedure 'sp_MSrepl_startup'.
2013-08-28 12:57:11.97 spid8s Launched startup procedure 'sp_MScleanupmergepublisher'.
2013-08-28 12:57:12.12 spid51 Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
2013-08-28 12:57:12.13 spid51 Using 'xpsqlbot.dll' version '2009.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2013-08-28 12:57:12.17 spid51 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2013-08-28 12:57:12.18 spid51 Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2013-08-28 12:57:12.19 spid51 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2013-08-28 12:57:12.19 spid51 Using 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2013-08-28 13:08:18.95 Logon Error: 18456, Severity: 14, State: 38.
2013-08-28 13:08:18.95 Logon Login failed for user 'CISCO\psathe'. Reason: Failed to open the explicitly specified database. [CLIENT: 10.21.151.76]
2013-08-28 14:25:11.42 spid58 Process ID 57 was killed by hostname HAILINLI-WS, host process ID 9312.
2013-08-28 22:33:08.35 spid54 Using 'dbghelp.dll' version '4.0.5'
2013-08-28 22:33:08.36 spid54 ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL10_50.ION_INST_ETL_02\MSSQL\LOG\SQLDump0005.txt
2013-08-28 22:33:08.36 spid54 SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2013-08-28 22:33:08.36 spid54 * *******************************************************************************
2013-08-28 22:33:08.36 spid54 *
2013-08-28 22:33:08.36 spid54 * BEGIN STACK DUMP:
2013-08-28 22:33:08.36 spid54 * 08/28/13 22:33:08 spid 54
2013-08-28 22:33:08.36 spid54 *
2013-08-28 22:33:08.36 spid54 *
2013-08-28 22:33:08.36 spid54 * Exception Address = 0000000076E120E0 Module(ntdll+00000000000520E0)
2013-08-28 22:33:08.36 spid54 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2013-08-28 22:33:08.36 spid54 * Access Violation occurred reading address 0000000000000000
2013-08-28 22:33:08.36 spid54 * Input Buffer 510 bytes -
2013-08-28 22:33:08.36 spid54 * select top 1 * from OPENQUERY(CG1PRD,'SELECT B.order_number
2013-08-28 22:33:08.36 spid54 * ,A.line_number ,nvl(A.option_number,0) as option_numb
2013-08-28 22:33:08.36 spid54 * er --,D.set_name as ship_set_number --,C.organization_
2013-08-28 22:33:08.36 spid54 * code ,A.ordered_item as item_number ,A.item_type_code
2013-08-28 22:33:08.36 spid54 * -- ,H.product_family -- ,I.business_unit -- ,J.l
2013-08-28 22:33:08.36 spid54 * ine_of_business -- ,B.context as order_type_name -- ,B.s
2013-08-28 22:33:08.36 spid54 * ales_channel_code -- --,XOHE.attribute3 AS PromiseDateAlignCode
2013-08-28 22:33:08.36 spid54 * -- ,XOHE.ALIGN_FLAG AS PromiseDateAlignCode -- ,B.order
2013-08-28 22:33:08.36 spid54 * ed_date -- ,B.booked_date -- ,null as dispatch_date
2013-08-28 22:33:08.36 spid54 * -- ,null as production_date -- ,null as pick_release_date
2013-08-28 22:33:08.36 spid54 * -- ,null as fcd_date -- ,A.schedule_ship_date -- ,
2013-08-28 22:33:08.36 spid54 * A.promise_date -- ,A.actual_shipment_date as shipped_date
2013-08-28 22:33:08.36 spid54 * -- ,A.request_date -- ,A.ordered_quantity -- ,A.shippe
2013-08-28 22:33:08.36 spid54 * d_quantity -- ,A.UNIT_SELLING_PRICE -- ,L.party_name as
2013-08-28 22:33:08.36 spid54 * sold_to_customer_name -- ,L.country as sold_to_country --
2013-08-28 22:33:08.36 spid54 * ,P.party_name as ship_to_customer_name -- ,RR.CITY AS SHIP_TO_
2013-08-28 22:33:08.36 spid54 * CITY -- ,RR.STATE AS SHIP_TO_STATE -- ,RR.country as sh
2013-08-28 22:33:08.36 spid54 * ip_to_country -- ,T.party_name as bill_to_customer_name -
2013-08-28 22:33:08.36 spid54 * - ,T.country as bill_to_country -- ,(SELECT PP.party_name
2013-08-28 22:33:08.36 spid54 * --from OE_ORDER_HEADERS_ALL BB -- --LEFT JOIN CCA_SO_END_CUSTOM
2013-08-28 22:33:08.36 spid54 * ERS AA -- --ON BB.HEADER_ID = AA.HEADER_ID -- , hz_cust_a
2013-08-28 22:33:08.36 spid54 * ccounts KK -- --ON AA.END_CUSTOMER_ID = KK.CUST_ACCOUNT_ID
2013-08-28 22:33:08.36 spid54 * -- , hz_parties PP -- WHERE KK.PARTY_ID = PP.PARTY_ID -
2013-08-28 22:33:08.36 spid54 * - AND PP.party_name IS NOT NULL -- AND BB.BOOKED_DATE > ADD_MONT
2013-08-28 22:33:08.36 spid54 * HS(CURRENT_DATE, -72) -- AND BB.HEADER_ID = A.HEADER_ID --
2013-08-28 22:33:08.36 spid54 * AND ROWNUM = 1) AS End_Customer_Name -- ,(select RR.country
2013-08-28 22:33:08.36 spid54 * --from OE_ORDER_HEADERS_ALL BB, -- --CCA_SO_END_CUSTOMERS AA
2013-08-28 22:33:08.36 spid54 * , -- APPS.hz_cust_site_uses_all MM, -- hz_cust_acct_sites
2013-08-28 22:33:08.36 spid54 * _all NN, -- AR.HZ_PA
2013-08-28 22:33:08.36 spid54 *
2013-08-28 22:33:08.36 spid54 *
2013-08-28 22:33:08.36 spid54 * MODULE BASE END SIZE
2013-08-28 22:33:08.36 spid54 * sqlservr 0000000000520000 00000000040CDFFF 03bae000
2013-08-28 22:33:08.36 spid54 * ntdll 0000000076DC0000 0000000076F6AFFF 001ab000
2013-08-28 22:33:08.36 spid54 * kernel32 0000000076BA0000 0000000076CBEFFF 0011f000
2013-08-28 22:33:08.36 spid54 * KERNELBASE 000007FEFD020000 000007FEFD08AFFF 0006b000
2013-08-28 22:33:08.36 spid54 * ADVAPI32 000007FEFE990000 000007FEFEA6AFFF 000db000
2013-08-28 22:33:08.36 spid54 * msvcrt 000007FEFE7A0000 000007FEFE83EFFF 0009f000
2013-08-28 22:33:08.36 spid54 * sechost 000007FEFE400000 000007FEFE41EFFF 0001f000
2013-08-28 22:33:08.36 spid54 * RPCRT4 000007FEFE2D0000 000007FEFE3FDFFF 0012e000
2013-08-28 22:33:08.36 spid54 * MSVCR80 0000000074460000 0000000074528FFF 000c9000
2013-08-28 22:33:08.36 spid54 * MSVCP80 0000000073DF0000 0000000073EF8FFF 00109000
2013-08-28 22:33:08.36 spid54 * sqlos 00000000735D0000 00000000735D6FFF 00007000
2013-08-28 22:33:08.36 spid54 * Secur32 000007FEFC8F0000 000007FEFC8FAFFF 0000b000
2013-08-28 22:33:08.36 spid54 * SSPICLI 000007FEFCB80000 000007FEFCBA4FFF 00025000
2013-08-28 22:33:08.36 spid54 * pdh 000007FEF9FF0000 000007FEFA03DFFF 0004e000
2013-08-28 22:33:08.36 spid54 * SHLWAPI 000007FEFE420000 000007FEFE490FFF 00071000
2013-08-28 22:33:08.36 spid54 * GDI32 000007FEFE6B0000 000007FEFE716FFF 00067000
2013-08-28 22:33:08.36 spid54 * USER32 0000000076CC0000 0000000076DB9FFF 000fa000
2013-08-28 22:33:08.36 spid54 * LPK 000007FEFE980000 000007FEFE98DFFF 0000e000
2013-08-28 22:33:08.36 spid54 * USP10 000007FEFEA70000 000007FEFEB39FFF 000ca000
2013-08-28 22:33:08.36 spid54 * USERENV 000007FEFC040000 000007FEFC05DFFF 0001e000
2013-08-28 22:33:08.36 spid54 * profapi 000007FEFCD20000 000007FEFCD2EFFF 0000f000
2013-08-28 22:33:08.36 spid54 * WINMM 000007FEF9FB0000 000007FEF9FEAFFF 0003b000
2013-08-28 22:33:08.36 spid54 * IPHLPAPI 000007FEFAE00000 000007FEFAE26FFF 00027000
2013-08-28 22:33:08.36 spid54 * NSI 000007FEFE2C0000 000007FEFE2C7FFF 00008000
2013-08-28 22:33:08.36 spid54 * WINNSI 000007FEFADF0000 000007FEFADFAFFF 0000b000
2013-08-28 22:33:08.36 spid54 * opends60 00000000734F0000 00000000734F7FFF 00008000
2013-08-28 22:33:08.36 spid54 * NETAPI32 000007FEFAB20000 000007FEFAB35FFF 00016000
2013-08-28 22:33:08.36 spid54 * netutils 000007FEFC500000 000007FEFC50BFFF 0000c000
2013-08-28 22:33:08.36 spid54 * srvcli 000007FEFC7C0000 000007FEFC7E2FFF 00023000
2013-08-28 22:33:08.36 spid54 * wkscli 000007FEFAB00000 000007FEFAB14FFF 00015000
2013-08-28 22:33:08.36 spid54 * LOGONCLI 000007FEFC510000 000007FEFC53FFFF 00030000
2013-08-28 22:33:08.36 spid54 * SAMCLI 000007FEFA760000 000007FEFA773FFF 00014000
2013-08-28 22:33:08.36 spid54 * BatchParser 0000000071A20000 0000000071A4CFFF 0002d000
2013-08-28 22:33:08.36 spid54 * IMM32 000007FEFF0A0000 000007FEFF0CDFFF 0002e000
2013-08-28 22:33:08.36 spid54 * MSCTF 000007FEFECC0000 000007FEFEDC8FFF 00109000
2013-08-28 22:33:08.36 spid54 * psapi 0000000076F90000 0000000076F96FFF 00007000
2013-08-28 22:33:08.36 spid54 * instapi10 0000000074410000 000000007441CFFF 0000d000
2013-08-28 22:33:08.36 spid54 * cscapi 000007FEF9F80000 000007FEF9F8EFFF 0000f000
2013-08-28 22:33:08.36 spid54 * sqlevn70 00000000601B0000 00000000603B0FFF 00201000
2013-08-28 22:33:08.36 spid54 * CRYPTSP 000007FEFC6D0000 000007FEFC6E6FFF 00017000
2013-08-28 22:33:08.36 spid54 * rsaenh 000007FEFC290000 000007FEFC2D6FFF 00047000
2013-08-28 22:33:08.36 spid54 * CRYPTBASE 000007FEFCC10000 000007FEFCC1EFFF 0000f000
2013-08-28 22:33:08.36 spid54 * BROWCLI 000007FEF9F60000 000007FEF9F71FFF 00012000
2013-08-28 22:33:08.36 spid54 * AUTHZ 000007FEFC770000 000007FEFC79EFFF 0002f000
2013-08-28 22:33:08.36 spid54 * MSCOREE 000007FEFA370000 000007FEFA3DEFFF 0006f000
2013-08-28 22:33:08.36 spid54 * mscoreei 000007FEFA260000 000007FEFA2EFFFF 00090000
2013-08-28 22:33:08.36 spid54 * ole32 000007FEFD320000 000007FEFD521FFF 00202000
2013-08-28 22:33:08.36 spid54 * credssp 000007FEFC130000 000007FEFC138FFF 00009000
2013-08-28 22:33:08.36 spid54 * msv1_0 000007FEFC490000 000007FEFC4E0FFF 00051000
2013-08-28 22:33:08.36 spid54 * cryptdll 000007FEFC8D0000 000007FEFC8E3FFF 00014000
2013-08-28 22:33:08.36 spid54 * kerberos 000007FEFC5A0000 000007FEFC652FFF 000b3000
2013-08-28 22:33:08.36 spid54 * MSASN1 000007FEFCDC0000 000007FEFCDCEFFF 0000f000
2013-08-28 22:33:08.36 spid54 * schannel 000007FEFC320000 000007FEFC376FFF 00057000
2013-08-28 22:33:08.36 spid54 * CRYPT32 000007FEFCEB0000 000007FEFD015FFF 00166000
2013-08-28 22:33:08.36 spid54 * security 0000000073490000 0000000073492FFF 00003000
2013-08-28 22:33:08.36 spid54 * WS2_32 000007FEFD2D0000 000007FEFD31CFFF 0004d000
2013-08-28 22:33:08.36 spid54 * SHELL32 000007FEFD530000 000007FEFE2B5FFF 00d86000
2013-08-28 22:33:08.36 spid54 * OLEAUT32 000007FEFE5D0000 000007FEFE6A6FFF 000d7000
2013-08-28 22:33:08.36 spid54 * ftimport 0000000060000000 0000000060024FFF 00025000
2013-08-28 22:33:08.36 spid54 * MSFTE 0000000049980000 0000000049D2DFFF 003ae000
2013-08-28 22:33:08.36 spid54 * VERSION 000007FEFBE70000 000007FEFBE7BFFF 0000c000
2013-08-28 22:33:08.36 spid54 * dbghelp 000000005FCD0000 000000005FE2DFFF 0015e000
2013-08-28 22:33:08.36 spid54 * WINTRUST 000007FEFCE70000 000007FEFCEA9FFF 0003a000
2013-08-28 22:33:08.36 spid54 * ntmarta 000007FEFBE20000 000007FEFBE4CFFF 0002d000
2013-08-28 22:33:08.36 spid54 * WLDAP32 000007FEFF030000 000007FEFF07FFFF 00050000
2013-08-28 22:33:08.36 spid54 * ncrypt 000007FEFC720000 000007FEFC76DFFF 0004e000
2013-08-28 22:33:08.36 spid54 * bcrypt 000007FEFC6F0000 000007FEFC711FFF 00022000
2013-08-28 22:33:08.36 spid54 * mswsock 000007FEFC540000 000007FEFC593FFF 00054000
2013-08-28 22:33:08.36 spid54 * wship6 000007FEFC7A0000 000007FEFC7A6FFF 00007000
2013-08-28 22:33:08.36 spid54 * wshtcpip 000007FEFBF40000 000007FEFBF46FFF 00007000
2013-08-28 22:33:08.36 spid54 * ntdsapi 000007FEFA580000 000007FEFA5A6FFF 00027000
2013-08-28 22:33:08.36 spid54 * DNSAPI 000007FEFC380000 000007FEFC3DAFFF 0005b000
2013-08-28 22:33:08.36 spid54 * rasadhlp 000007FEF6090000 000007FEF6097FFF 00008000
2013-08-28 22:33:08.36 spid54 * fwpuclnt 000007FEFACE0000 000007FEFAD32FFF 00053000
2013-08-28 22:33:08.36 spid54 * bcryptprimitives 000007FEFC1D0000 000007FEFC21BFFF 0004c000
2013-08-28 22:33:08.36 spid54 * CLBCatQ 000007FEFE8E0000 000007FEFE978FFF 00099000
2013-08-28 22:33:08.36 spid54 * sqlncli10 0000000072770000 0000000072A27FFF 002b8000
2013-08-28 22:33:08.36 spid54 * COMCTL32 000007FEF5E80000 000007FEF5F1FFFF 000a0000
2013-08-28 22:33:08.36 spid54 * COMDLG32 000007FEFE840000 000007FEFE8D7FFF 00098000
2013-08-28 22:33:08.36 spid54 * SQLNCLIR10 0000000073710000 0000000073746FFF 00037000
2013-08-28 22:33:08.36 spid54 * netbios 000007FEFA1A0000 000007FEFA1A9FFF 0000a000
2013-08-28 22:33:08.36 spid54 * xpsqlbot 00000000719E0000 00000000719E7FFF 00008000
2013-08-28 22:33:08.36 spid54 * xpstar 000000006E470000 000000006E4F7FFF 00088000
2013-08-28 22:33:08.36 spid54 * SQLSCM 0000000073330000 000000007333DFFF 0000e000
2013-08-28 22:33:08.36 spid54 * ODBC32 000007FEF5F20000 000007FEF5FCEFFF 000af000
2013-08-28 22:33:08.36 spid54 * ATL80 0000000074420000 000000007443FFFF 00020000
2013-08-28 22:33:08.36 spid54 * odbcint 0000000072730000 0000000072767FFF 00038000
2013-08-28 22:33:08.36 spid54 * clusapi 000007FEF6310000 000007FEF635FFFF 00050000
2013-08-28 22:33:08.36 spid54 * resutils 000007FEF62F0000 000007FEF6308FFF 00019000
2013-08-28 22:33:08.36 spid54 * xpstar 00000000719B0000 00000000719D4FFF 00025000
2013-08-28 22:33:08.36 spid54 * xplog70 0000000071940000 000000007194FFFF 00010000
2013-08-28 22:33:08.36 spid54 * xplog70 0000000071930000 0000000071931FFF 00002000
2013-08-28 22:33:08.36 spid54 * oledb32 000007FEF9730000 000007FEF983DFFF 0010e000
2013-08-28 22:33:08.36 spid54 * MSDART 000007FEF98D0000 000007FEF98F7FFF 00028000
2013-08-28 22:33:08.36 spid54 * Comctl32 000007FEFB930000 000007FEFBB23FFF 001f4000
2013-08-28 22:33:08.36 spid54 * OLEDB32R 00000000732A0000 00000000732B3FFF 00014000
2013-08-28 22:33:08.36 spid54 * comsvcs 000007FEF0540000 000007FEF06EFFFF 001b0000
2013-08-28 22:33:08.36 spid54 * OraOLEDB11 000000001B460000 000000001B4EEFFF 0008f000
2013-08-28 22:33:08.36 spid54 * OraOLEDBgmr11 0000000044100000 0000000044126FFF 00027000
2013-08-28 22:33:08.36 spid54 * OCI 000000001B900000 000000001B9AAFFF 000ab000
2013-08-28 22:33:08.36 spid54 * OraOLEDBrst11 0000000044400000 0000000044434FFF 00035000
2013-08-28 22:33:08.36 spid54 * OraOLEDButl11 0000000044700000 0000000044708FFF 00009000
2013-08-28 22:33:08.36 spid54 * OraClient11 000000002E950000 000000002EDEDFFF 0049e000
2013-08-28 22:33:08.36 spid54 * oracore11 000000001D7E0000 000000001D93FFFF 00160000
2013-08-28 22:33:08.36 spid54 * oranls11 000000001DB90000 000000001DC8EFFF 000ff000
2013-08-28 22:33:08.36 spid54 * oraunls11 000000001A480000 000000001A49FFFF 00020000
2013-08-28 22:33:08.36 spid54 * orauts 000000001A4B0000 000000001A4B6FFF 00007000
2013-08-28 22:33:08.36 spid54 * oracommon11 000000002EDF0000 000000002F0A6FFF 002b7000
2013-08-28 22:33:08.36 spid54 * orasnls11 000000001ACF0000 000000001AD2CFFF 0003d000
2013-08-28 22:33:08.36 spid54 * orageneric11 000000002F0B0000 000000002FFB0FFF 00f01000
2013-08-28 22:33:08.36 spid54 * oraxml11 000000002FFC0000 000000003049EFFF 004df000
2013-08-28 22:33:08.36 spid54 * oran11 00000000304A0000 00000000308F3FFF 00454000
2013-08-28 22:33:08.36 spid54 * oranl11 000000001BBB0000 000000001BC1EFFF 0006f000
2013-08-28 22:33:08.36 spid54 * orantcp11 000000001AF40000 000000001AF74FFF 00035000
2013-08-28 22:33:08.36 spid54 * oranldap11 000000001B210000 000000001B25AFFF 0004b000
2013-08-28 22:33:08.36 spid54 * orannzsbb11 0000000026100000 0000000026283FFF 00184000
2013-08-28 22:33:08.36 spid54 * WSOCK32 000007FEF4D50000 000007FEF4D58FFF 00009000
2013-08-28 22:33:08.36 spid54 * oraldapclnt11 0000000030900000 0000000030AF1FFF 001f2000
2013-08-28 22:33:08.36 spid54 * orancrypt11 000000001BC40000 000000001BC63FFF 00024000
2013-08-28 22:33:08.36 spid54 * orazt11 000000002CEE0000 000000002D0CFFFF 001f0000
2013-08-28 22:33:08.36 spid54 * oranro11 000000001CA50000 000000001CAAAFFF 0005b000
2013-08-28 22:33:08.36 spid54 * oranhost11 000000001BFC0000 000000001BFC9FFF 0000a000
2013-08-28 22:33:08.36 spid54 * orancds11 000000001C310000 000000001C316FFF 00007000
2013-08-28 22:33:08.36 spid54 * orantns11 000000001CAB0000 000000001CAC0FFF 00011000
2013-08-28 22:33:08.36 spid54 * oraztkg11 00000000264D0000 0000000026582FFF 000b3000
2013-08-28 22:33:08.36 spid54 * orapls11 0000000030B00000 0000000031020FFF 00521000
2013-08-28 22:33:08.36 spid54 * oraslax11 000000001CB00000 000000001CB0EFFF 0000f000
2013-08-28 22:33:08.36 spid54 * oravsn11 000000001CBA0000 000000001CBA6FFF 00007000
2013-08-28 22:33:08.36 spid54 * oraplp11 0000000031030000 0000000031424FFF 003f5000
2013-08-28 22:33:08.36 spid54 * orahasgen11 0000000031430000 0000000031705FFF 002d6000
2013-08-28 22:33:08.36 spid54 * oraocr11 0000000026790000 0000000026857FFF 000c8000
2013-08-28 22:33:08.36 spid54 * oraocrb11 0000000026C50000 0000000026D43FFF 000f4000
2013-08-28 22:33:08.36 spid54 * oraocrutl11 000000001D560000 000000001D570FFF 00011000
2013-08-28 22:33:08.36 spid54 * imagehlp 000007FEFF080000 000007FEFF096FFF 00017000
2013-08-28 22:33:08.36 spid54 * oracell11 000000001D590000 000000001D5DAFFF 0004b000
2013-08-28 22:33:08.36 spid54 * orasql11 0000000026860000 00000000268BDFFF 0005e000
2013-08-28 22:33:08.36 spid54 * OraPlc11 000000001D960000 000000001D97FFFF 00020000
2013-08-28 22:33:08.36 spid54 * OraOLEDB11us 0000000044300000 0000000044305FFF 00006000
2013-08-28 22:33:08.36 spid54 * OraOLEDBpus11 0000000044200000 0000000044207FFF 00008000
2013-08-28 22:33:08.36 spid54 * RpcRtRemote 000007FEFCD00000 000007FEFCD13FFF 00014000
2013-08-28 22:33:08.36 spid54 * NLAapi 000007FEFB320000 000007FEFB334FFF 00015000
2013-08-28 22:33:08.36 spid54 * winrnr 000007FEF9D60000 000007FEF9D6AFFF 0000b000
2013-08-28 22:33:08.36 spid54 * napinsp 000007FEF9D40000 000007FEF9D54FFF 00015000
2013-08-28 22:33:08.36 spid54 * dsrole 000007FEFB210000 000007FEFB21BFFF 0000c000
2013-08-28 22:33:08.36 spid54 * SAMLIB 000007FEFA500000 000007FEFA51CFFF 0001d000
2013-08-28 22:33:08.36 spid54 * dbghelp 00000018C50F0000 00000018C524DFFF 0015e000
2013-08-28 22:33:08.36 spid54 *
2013-08-28 22:33:08.36 spid54 * P1Home: 000000002B7CA090: 00000000C0000005 0000000000000000 0000000076E120E0 FFFFF6FB00000002 0000000000000000 0000000000000000
2013-08-28 22:33:08.36 spid54 * P2Home: 000000002B7C9BA0: 000000002B7CA090 000000002B7C9BA0 0000000000000000 0000000000000000 0000000032B55658 0000000000000000
2013-08-28 22:33:08.36 spid54 * P3Home: 0000000000000000:
2013-08-28 22:33:08.36 spid54 * P4Home: 0000000000000000:
2013-08-28 22:33:08.36 spid54 * P5Home: 0000000032B55658: 0000000032B59580 0000000032B5E358 0000000032B5E7F8 0000000000000000 0000000000000000 00000000321F44E0
2013-08-28 22:33:08.36 spid54 * P6Home: 0000000000000000:
2013-08-28 22:33:08.36 spid54 * ContextFlags: 000000000010001F: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2013-08-28 22:33:08.36 spid54 * MxCsr: 0000000000001F80:
2013-08-28 22:33:08.36 spid54 * SegCs: 0000000000000033:
2013-08-28 22:33:08.36 spid54 * SegDs: 000000000000002B:
2013-08-28 22:33:08.36 spid54 * SegEs: 000000000000002B:
2013-08-28 22:33:08.36 spid54 * SegFs: 0000000000000053:
2013-08-28 22:33:08.36 spid54 * SegGs: 000000000000002B:
2013-08-28 22:33:08.36 spid54 * SegSs: 000000000000002B:
2013-08-28 22:33:08.37 spid54 * EFlags: 0000000000010246: 0000000000000000 0000000101580000 0000000102680000 0000000102780000 0000000000000000 0000001000000000
2013-08-28 22:33:08.37 spid54 * Rax: 000000000000000E:
2013-08-28 22:33:08.37 spid54 * Rcx: 0000000000000000:
2013-08-28 22:33:08.37 spid54 * Rdx: 0000000000100000: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2013-08-28 22:33:08.37 spid54 * Rbx: 00000000000F0000: 0000000000000000 0100430F9179C1AC 00000000FFEEFFEE 0000000019010018 00000000000F0128 00000000000F0000
2013-08-28 22:33:08.37 spid54 * Rsp: 000000002B7CA160: 0000000000000004 0000000000000000 00000000319F77E0 0000000031A14D20 00000000319EABF0 000007FE3D00003D
2013-08-28 22:33:08.37 spid54 * Rbp: 0000000000000002:
2013-08-28 22:33:08.37 spid54 * Rsi: 000000003AC1A340: 0000000000000000 101F434F25010024 0000000000000000 0000001600020000 0000000100008100 0000000000000000
2013-08-28 22:33:08.37 spid54 * Rdi: 000000003AC1A580: 0000006B00630061 001F432B0E00000E 000000011910FEF0 0000000000000000 00000000319E9830 00000000319EAC00
2013-08-28 22:33:08.37 spid54 * R8: 0000000000000024:
2013-08-28 22:33:08.37 spid54 * R9: 000000003AC1A350: 0000000000000000 0000001600020000 0000000100008100 0000000000000000 0000000000000000 0000000000000000
2013-08-28 22:33:08.37 spid54 * R10: 000000003AC1A590: 000000011910FEF0 0000000000000000 00000000319E9830 00000000319EAC00 006E006700690053 0046005F00640065
2013-08-28 22:33:08.37 spid54 * R11: 00000000319EAB80: 0000000000000043 8C0000B314451486 0000000000000044 800000B314451487 0000000000000009 800000B314451484
2013-08-28 22:33:08.37 spid54 * R12: 000000011910FEF0: 0072006500680074 0064006E0061006C 325137304B570073 5973655931313032 0073006500527365 00000065006C0061
2013-08-28 22:33:08.37 spid54 * R13: 0000000000000000:
2013-08-28 22:33:08.37 spid54 * R14: 0000000000000000:
2013-08-28 22:33:08.37 spid54 * R15: 0000000000000000:
2013-08-28 22:33:08.37 spid54 * Rip: 0000000076E120E0: 244C8B4D00458B49 E2CC850FC13B4908 C3850FC23B490000 480847B70F0000E2 8B4C000000C88329 C0854D0000014083
2013-08-28 22:33:08.37 spid54 * *******************************************************************************
2013-08-28 22:33:08.37 spid54 * -------------------------------------------------------------------------------
2013-08-28 22:33:08.37 spid54 * Short Stack Dump
2013-08-28 22:33:08.41 spid54 0000000076E120E0 Module(ntdll+00000000000520E0)
2013-08-28 22:33:08.41 spid54 0000000076E11F05 Module(ntdll+0000000000051F05)
2013-08-28 22:33:08.41 spid54 000007FEFD359F76 Module(ole32+0000000000039F76)
2013-08-28 22:33:08.42 spid54 0000000044701A5F Module(OraOLEDButl11+0000000000001A5F)
2013-08-28 22:33:08.42 spid54 0000000044423371 Module(OraOLEDBrst11+0000000000023371)
2013-08-28 22:33:08.42 spid54 000000004442446D Module(OraOLEDBrst11+000000000002446D)
2013-08-28 22:33:08.42 spid54 000000001B461DB1 Module(OraOLEDB11+0000000000001DB1)
2013-08-28 22:33:08.42 spid54 0000000001050ACF Module(sqlservr+0000000000B30ACF)
2013-08-28 22:33:08.42 spid54 0000000000FF9B47 Module(sqlservr+0000000000AD9B47)
2013-08-28 22:33:08.42 spid54 0000000000FEA102 Module(sqlservr+0000000000ACA102)
2013-08-28 22:33:08.42 spid54 0000000000F63C9F Module(sqlservr+0000000000A43C9F)
2013-08-28 22:33:08.42 spid54 0000000001081A62 Module(sqlservr+0000000000B61A62)
2013-08-28 22:33:08.42 spid54 00000000010805AD Module(sqlservr+0000000000B605AD)
2013-08-28 22:33:08.42 spid54 000000000108002C Module(sqlservr+0000000000B6002C)
2013-08-28 22:33:08.42 spid54 000000000107C90C Module(sqlservr+0000000000B5C90C)
2013-08-28 22:33:08.42 spid54 0000000000B5BB6F Module(sqlservr+000000000063BB6F)
2013-08-28 22:33:08.42 spid54 00000000008008A6 Module(sqlservr+00000000002E08A6)
2013-08-28 22:33:08.42 spid54 0000000000800623 Module(sqlservr+00000000002E0623)
2013-08-28 22:33:08.42 spid54 0000000000799CC7 Module(sqlservr+0000000000279CC7)
2013-08-28 22:33:08.42 spid54 00000000007FA81F Module(sqlservr+00000000002DA81F)
2013-08-28 22:33:08.42 spid54 0000000000799CC7 Module(sqlservr+0000000000279CC7)
2013-08-28 22:33:08.42 spid54 00000000007F4958 Module(sqlservr+00000000002D4958)
2013-08-28 22:33:08.42 spid54 0000000000799CC7 Module(sqlservr+0000000000279CC7)
2013-08-28 22:33:08.42 spid54 000000000079A585 Module(sqlservr+000000000027A585)
2013-08-28 22:33:08.42 spid54 0000000000799CC7 Module(sqlservr+0000000000279CC7)
2013-08-28 22:33:08.42 spid54 0000000000799B91 Module(sqlservr+0000000000279B91)
2013-08-28 22:33:08.42 spid54 00000000007A2C46 Module(sqlservr+0000000000282C46)
2013-08-28 22:33:08.42 spid54 00000000007001E5 Module(sqlservr+00000000001E01E5)
2013-08-28 22:33:08.42 spid54 00000000006FF74E Module(sqlservr+00000000001DF74E)
2013-08-28 22:33:08.42 spid54 00000000006FFE19 Module(sqlservr+00000000001DFE19)
2013-08-28 22:33:08.42 spid54 00000000006FFCBF Module(sqlservr+00000000001DFCBF)
2013-08-28 22:33:08.42 spid54 000000000057B203 Module(sqlservr+000000000005B203)
2013-08-28 22:33:08.43 spid54 000000000057C1A6 Module(sqlservr+000000000005C1A6)
2013-08-28 22:33:08.43 spid54 00000000005C5342 Module(sqlservr+00000000000A5342)
2013-08-28 22:33:08.43 spid54 000000000052BBD8 Module(sqlservr+000000000000BBD8)
2013-08-28 22:33:08.43 spid54 000000000052B8BA Module(sqlservr+000000000000B8BA)
2013-08-28 22:33:08.43 spid54 000000000052B6FF Module(sqlservr+000000000000B6FF)
2013-08-28 22:33:08.43 spid54 0000000000A48FB6 Module(sqlservr+0000000000528FB6)
2013-08-28 22:33:08.43 spid54 0000000000A49175 Module(sqlservr+0000000000529175)
2013-08-28 22:33:08.43 spid54 0000000000A49839 Module(sqlservr+0000000000529839)
2013-08-28 22:33:08.43 spid54 0000000000A49502 Module(sqlservr+0000000000529502)
2013-08-28 22:33:08.43 spid54 00000000744637D7 Module(MSVCR80+00000000000037D7)
2013-08-28 22:33:08.43 spid54 0000000074463894 Module(MSVCR80+0000000000003894)
2013-08-28 22:33:08.44 spid54 0000000076BBF56D Module(kernel32+000000000001F56D)
2013-08-28 22:33:08.44 spid54 0000000076DF3021 Module(ntdll+0000000000033021)
2013-08-28 22:33:08.45 spid54 Stack Signature for the dump is 0x000000015D21641C
2013-08-28 22:33:10.46 spid54 External dump process return code 0x20000001.
External dump process returned no errors.

2013-08-28 22:34:52.14 spid54 Using 'dbghelp.dll' version '4.0.5'
2013-08-28 22:34:52.14 spid54 ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL10_50.ION_INST_ETL_02\MSSQL\LOG\SQLDump0006.txt
2013-08-28 22:34:52.14 spid54 SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2013-08-28 22:34:52.14 spid54 * *******************************************************************************
2013-08-28 22:34:52.14 spid54 *
2013-08-28 22:34:52.14 spid54 * BEGIN STACK DUMP:
2013-08-28 22:34:52.14 spid54 * 08/28/13 22:34:52 spid 54
2013-08-28 22:34:52.14 spid54 *
2013-08-28 22:34:52.14 spid54 *
2013-08-28 22:34:52.14 spid54 * Exception Address = 000000004441316E Module(OraOLEDBrst11+000000000001316E)
2013-08-28 22:34:52.14 spid54 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2013-08-28 22:34:52.14 spid54 * Access Violation occurred writing address 0000000019110000
2013-08-28 22:34:52.14 spid54 * Input Buffer 510 bytes -
2013-08-28 22:34:52.14 spid54 * select top 1 * from OPENQUERY(CG1PRD,'SELECT B.order_number
2013-08-28 22:34:52.14 spid54 * ,A.line_number ,nvl(A.option_number,0) as option_numb
2013-08-28 22:34:52.14 spid54 * er --,D.set_name as ship_set_number --,C.organization_
2013-08-28 22:34:52.14 spid54 * code ,A.ordered_item as item_number ,A.item_type_code
2013-08-28 22:34:52.14 spid54 * -- ,H.product_family -- ,I.business_unit -- ,J.l
2013-08-28 22:34:52.14 spid54 * ine_of_business -- ,B.context as order_type_name -- ,B.s
2013-08-28 22:34:52.14 spid54 * ales_channel_code -- --,XOHE.attribute3 AS PromiseDateAlignCode
2013-08-28 22:34:52.14 spid54 * -- ,XOHE.ALIGN_FLAG AS PromiseDateAlignCode -- ,B.order
2013-08-28 22:34:52.14 spid54 * ed_date -- ,B.booked_date -- ,null as dispatch_date
2013-08-28 22:34:52.14 spid54 * -- ,null as production_date -- ,null as pick_release_date
2013-08-28 22:34:52.14 spid54 * -- ,null as fcd_date -- ,A.schedule_ship_date -- ,
2013-08-28 22:34:52.14 spid54 * A.promise_date -- ,A.actual_shipment_date as shipped_date
2013-08-28 22:34:52.14 spid54 * -- ,A.request_date -- ,A.ordered_quantity -- ,A.shippe
2013-08-28 22:34:52.14 spid54 * d_quantity -- ,A.UNIT_SELLING_PRICE -- ,L.party_name as
2013-08-28 22:34:52.14 spid54 * sold_to_customer_name -- ,L.country as sold_to_country --
2013-08-28 22:34:52.14 spid54 * ,P.party_name as ship_to_customer_name -- ,RR.CITY AS SHIP_TO_
2013-08-28 22:34:52.14 spid54 * CITY -- ,RR.STATE AS SHIP_TO_STATE -- ,RR.country as sh
2013-08-28 22:34:52.14 spid54 * ip_to_country -- ,T.party_name as bill_to_customer_name -
2013-08-28 22:34:52.14 spid54 * - ,T.country as bill_to_country -- ,(SELECT PP.party_name
2013-08-28 22:34:52.14 spid54 * --from OE_ORDER_HEADERS_ALL BB -- --LEFT JOIN CCA_SO_END_CUSTOM
2013-08-28 22:34:52.14 spid54 * ERS AA -- --ON BB.HEADER_ID = AA.HEADER_ID -- , hz_cust_a
2013-08-28 22:34:52.14 spid54 * ccounts KK -- --ON AA.END_CUSTOMER_ID = KK.CUST_ACCOUNT_ID
2013-08-28 22:34:52.14 spid54 * -- , hz_parties PP -- WHERE KK.PARTY_ID = PP.PARTY_ID -
2013-08-28 22:34:52.14 spid54 * - AND PP.party_name IS NOT NULL -- AND BB.BOOKED_DATE > ADD_MONT
2013-08-28 22:34:52.14 spid54 * HS(CURRENT_DATE, -72) -- AND BB.HEADER_ID = A.HEADER_ID --
2013-08-28 22:34:52.14 spid54 * AND ROWNUM = 1) AS End_Customer_Name -- ,(select RR.country
2013-08-28 22:34:52.14 spid54 * --from OE_ORDER_HEADERS_ALL BB, -- --CCA_SO_END_CUSTOMERS AA
2013-08-28 22:34:52.14 spid54 * , -- APPS.hz_cust_site_uses_all MM, -- hz_cust_acct_sites
2013-08-28 22:34:52.14 spid54 * _all NN, -- AR.HZ_PA
2013-08-28 22:34:52.14 spid54 *
2013-08-28 22:34:52.14 spid54 *
2013-08-28 22:34:52.14 spid54 * MODULE BASE END SIZE
2013-08-28 22:34:52.14 spid54 * sqlservr 0000000000520000 00000000040CDFFF 03bae000
2013-08-28 22:34:52.14 spid54 * ntdll 0000000076DC0000 0000000076F6AFFF 001ab000
2013-08-28 22:34:52.14 spid54 * kernel32 0000000076BA0000 0000000076CBEFFF 0011f000
2013-08-28 22:34:52.14 spid54 * KERNELBASE 000007FEFD020000 000007FEFD08AFFF 0006b000
2013-08-28 22:34:52.14 spid54 * ADVAPI32 000007FEFE990000 000007FEFEA6AFFF 000db000
2013-08-28 22:34:52.14 spid54 * msvcrt 000007FEFE7A0000 000007FEFE83EFFF 0009f000
2013-08-28 22:34:52.14 spid54 * sechost 000007FEFE400000 000007FEFE41EFFF 0001f000
2013-08-28 22:34:52.14 spid54 * RPCRT4 000007FEFE2D0000 000007FEFE3FDFFF 0012e000
2013-08-28 22:34:52.14 spid54 * MSVCR80 0000000074460000 0000000074528FFF 000c9000
2013-08-28 22:34:52.14 spid54 * MSVCP80 0000000073DF0000 0000000073EF8FFF 00109000
2013-08-28 22:34:52.14 spid54 * sqlos 00000000735D0000 00000000735D6FFF 00007000
2013-08-28 22:34:52.14 spid54 * Secur32 000007FEFC8F0000 000007FEFC8FAFFF 0000b000
2013-08-28 22:34:52.14 spid54 * SSPICLI 000007FEFCB80000 000007FEFCBA4FFF 00025000
2013-08-28 22:34:52.14 spid54 * pdh 000007FEF9FF0000 000007FEFA03DFFF 0004e000
2013-08-28 22:34:52.14 spid54 * SHLWAPI 000007FEFE420000 000007FEFE490FFF 00071000
2013-08-28 22:34:52.14 spid54 * GDI32 000007FEFE6B0000 000007FEFE716FFF 00067000
2013-08-28 22:34:52.14 spid54 * USER32 0000000076CC0000 0000000076DB9FFF 000fa000
2013-08-28 22:34:52.14 spid54 * LPK 000007FEFE980000 000007FEFE98DFFF 0000e000
2013-08-28 22:34:52.14 spid54 * USP10 000007FEFEA70000 000007FEFEB39FFF 000ca000
2013-08-28 22:34:52.14 spid54 * USERENV 000007FEFC040000 000007FEFC05DFFF 0001e000
2013-08-28 22:34:52.14 spid54 * profapi 000007FEFCD20000 000007FEFCD2EFFF 0000f000
2013-08-28 22:34:52.14 spid54 * WINMM 000007FEF9FB0000 000007FEF9FEAFFF 0003b000
2013-08-28 22:34:52.14 spid54 * IPHLPAPI 000007FEFAE00000 000007FEFAE26FFF 00027000
2013-08-28 22:34:52.14 spid54 * NSI 000007FEFE2C0000 000007FEFE2C7FFF 00008000
2013-08-28 22:34:52.14 spid54 * WINNSI 000007FEFADF0000 000007FEFADFAFFF 0000b000
2013-08-28 22:34:52.14 spid54 * opends60 00000000734F0000 00000000734F7FFF 00008000
2013-08-28 22:34:52.14 spid54 * NETAPI32 000007FEFAB20000 000007FEFAB35FFF 00016000
2013-08-28 22:34:52.14 spid54 * netutils 000007FEFC500000 000007FEFC50BFFF 0000c000
2013-08-28 22:34:52.14 spid54 * srvcli 000007FEFC7C0000 000007FEFC7E2FFF 00023000
2013-08-28 22:34:52.14 spid54 * wkscli 000007FEFAB00000 000007FEFAB14FFF 00015000
2013-08-28 22:34:52.14 spid54 * LOGONCLI 000007FEFC510000 000007FEFC53FFFF 00030000
2013-08-28 22:34:52.14 spid54 * SAMCLI 000007FEFA760000 000007FEFA773FFF 00014000
2013-08-28 22:34:52.14 spid54 * BatchParser 0000000071A20000 0000000071A4CFFF 0002d000
2013-08-28 22:34:52.14 spid54 * IMM32 000007FEFF0A0000 000007FEFF0CDFFF 0002e000
2013-08-28 22:34:52.14 spid54 * MSCTF 000007FEFECC0000 000007FEFEDC8FFF 00109000
2013-08-28 22:34:52.14 spid54 * psapi 0000000076F90000 0000000076F96FFF 00007000
2013-08-28 22:34:52.14 spid54 * instapi10 0000000074410000 000000007441CFFF 0000d000
2013-08-28 22:34:52.14 spid54 * cscapi 000007FEF9F80000 000007FEF9F8EFFF 0000f000
2013-08-28 22:34:52.14 spid54 * sqlevn70 00000000601B0000 00000000603B0FFF 00201000
2013-08-28 22:34:52.14 spid54 * CRYPTSP 000007FEFC6D0000 000007FEFC6E6FFF 00017000
2013-08-28 22:34:52.14 spid54 * rsaenh 000007FEFC290000 000007FEFC2D6FFF 00047000
2013-08-28 22:34:52.14 spid54 * CRYPTBASE 000007FEFCC10000 000007FEFCC1EFFF 0000f000
2013-08-28 22:34:52.14 spid54 * BROWCLI 000007FEF9F60000 000007FEF9F71FFF 00012000
2013-08-28 22:34:52.14 spid54 * AUTHZ 000007FEFC770000 000007FEFC79EFFF 0002f000
2013-08-28 22:34:52.14 spid54 * MSCOREE 000007FEFA370000 000007FEFA3DEFFF 0006f000
2013-08-28 22:34:52.14 spid54 * mscoreei 000007FEFA260000 000007FEFA2EFFFF 00090000
2013-08-28 22:34:52.14 spid54 * ole32 000007FEFD320000 000007FEFD521FFF 00202000
2013-08-28 22:34:52.14 spid54 * credssp 000007FEFC130000 000007FEFC138FFF 00009000
2013-08-28 22:34:52.14 spid54 * msv1_0 000007FEFC490000 000007FEFC4E0FFF 00051000
2013-08-28 22:34:52.14 spid54 * cryptdll 000007FEFC8D0000 000007FEFC8E3FFF 00014000
2013-08-28 22:34:52.14 spid54 * kerberos 000007FEFC5A0000 000007FEFC652FFF 000b3000
2013-08-28 22:34:52.14 spid54 * MSASN1 000007FEFCDC0000 000007FEFCDCEFFF 0000f000
2013-08-28 22:34:52.14 spid54 * schannel 000007FEFC320000 000007FEFC376FFF 00057000
2013-08-28 22:34:52.14 spid54 * CRYPT32 000007FEFCEB0000 000007FEFD015FFF 00166000
2013-08-28 22:34:52.14 spid54 * security 0000000073490000 0000000073492FFF 00003000
2013-08-28 22:34:52.14 spid54 * WS2_32 000007FEFD2D0000 000007FEFD31CFFF 0004d000
2013-08-28 22:34:52.14 spid54 * SHELL32 000007FEFD530000 000007FEFE2B5FFF 00d86000
2013-08-28 22:34:52.14 spid54 * OLEAUT32 000007FEFE5D0000 000007FEFE6A6FFF 000d7000
2013-08-28 22:34:52.14 spid54 * ftimport 0000000060000000 0000000060024FFF 00025000
2013-08-28 22:34:52.14 spid54 * MSFTE 0000000049980000 0000000049D2DFFF 003ae000
2013-08-28 22:34:52.14 spid54 * VERSION 000007FEFBE70000 000007FEFBE7BFFF 0000c000
2013-08-28 22:34:52.14 spid54 * dbghelp 000000005FCD0000 000000005FE2DFFF 0015e000
2013-08-28 22:34:52.14 spid54 * WINTRUST 000007FEFCE70000 000007FEFCEA9FFF 0003a000
2013-08-28 22:34:52.14 spid54 * ntmarta 000007FEFBE20000 000007FEFBE4CFFF 0002d000
2013-08-28 22:34:52.14 spid54 * WLDAP32 000007FEFF030000 000007FEFF07FFFF 00050000
2013-08-28 22:34:52.14 spid54 * ncrypt 000007FEFC720000 000007FEFC76DFFF 0004e000
2013-08-28 22:34:52.14 spid54 * bcrypt 000007FEFC6F0000 000007FEFC711FFF 00022000
2013-08-28 22:34:52.14 spid54 * mswsock 000007FEFC540000 000007FEFC593FFF 00054000
2013-08-28 22:34:52.14 spid54 * wship6 000007FEFC7A0000 000007FEFC7A6FFF 00007000
2013-08-28 22:34:52.14 spid54 * wshtcpip 000007FEFBF40000 000007FEFBF46FFF 00007000
2013-08-28 22:34:52.14 spid54 * ntdsapi 000007FEFA580000 000007FEFA5A6FFF 00027000
2013-08-28 22:34:52.14 spid54 * DNSAPI 000007FEFC380000 000007FEFC3DAFFF 0005b000
2013-08-28 22:34:52.14 spid54 * rasadhlp 000007FEF6090000 000007FEF6097FFF 00008000
2013-08-28 22:34:52.14 spid54 * fwpuclnt 000007FEFACE0000 000007FEFAD32FFF 00053000
2013-08-28 22:34:52.14 spid54 * bcryptprimitives 000007FEFC1D0000 000007FEFC21BFFF 0004c000
2013-08-28 22:34:52.14 spid54 * CLBCatQ 000007FEFE8E0000 000007FEFE978FFF 00099000
2013-08-28 22:34:52.14 spid54 * sqlncli10 0000000072770000 0000000072A27FFF 002b8000
2013-08-28 22:34:52.14 spid54 * COMCTL32 000007FEF5E80000 000007FEF5F1FFFF 000a0000
2013-08-28 22:34:52.14 spid54 * COMDLG32 000007FEFE840000 000007FEFE8D7FFF 00098000
2013-08-28 22:34:52.14 spid54 * SQLNCLIR10 0000000073710000 0000000073746FFF 00037000
2013-08-28 22:34:52.14 spid54 * netbios 000007FEFA1A0000 000007FEFA1A9FFF 0000a000
2013-08-28 22:34:52.14 spid54 * xpsqlbot 00000000719E0000 00000000719E7FFF 00008000
2013-08-28 22:34:52.14 spid54 * xpstar 000000006E470000 000000006E4F7FFF 00088000
2013-08-28 22:34:52.14 spid54 * SQLSCM 0000000073330000 000000007333DFFF 0000e000
2013-08-28 22:34:52.14 spid54 * ODBC32 000007FEF5F20000 000007FEF5FCEFFF 000af000
2013-08-28 22:34:52.14 spid54 * ATL80 0000000074420000 000000007443FFFF 00020000
2013-08-28 22:34:52.14 spid54 * odbcint 0000000072730000 0000000072767FFF 00038000
2013-08-28 22:34:52.14 spid54 * clusapi 000007FEF6310000 000007FEF635FFFF 00050000
2013-08-28 22:34:52.14 spid54 * resutils 000007FEF62F0000 000007FEF6308FFF 00019000
2013-08-28 22:34:52.14 spid54 * xpstar 00000000719B0000 00000000719D4FFF 00025000
2013-08-28 22:34:52.14 spid54 * xplog70 0000000071940000 000000007194FFFF 00010000
2013-08-28 22:34:52.14 spid54 * xplog70 0000000071930000 0000000071931FFF 00002000
2013-08-28 22:34:52.14 spid54 * oledb32 000007FEF9730000 000007FEF983DFFF 0010e000
2013-08-28 22:34:52.14 spid54 * MSDART 000007FEF98D0000 000007FEF98F7FFF 00028000
2013-08-28 22:34:52.14 spid54 * Comctl32 000007FEFB930000 000007FEFBB23FFF 001f4000
2013-08-28 22:34:52.14 spid54 * OLEDB32R 00000000732A0000 00000000732B3FFF 00014000
2013-08-28 22:34:52.14 spid54 * comsvcs 000007FEF0540000 000007FEF06EFFFF 001b0000
2013-08-28 22:34:52.14 spid54 * OraOLEDB11 000000001B460000 000000001B4EEFFF 0008f000
2013-08-28 22:34:52.14 spid54 * OraOLEDBgmr11 0000000044100000 0000000044126FFF 00027000
2013-08-28 22:34:52.14 spid54 * OCI 000000001B900000 000000001B9AAFFF 000ab000
2013-08-28 22:34:52.14 spid54 * OraOLEDBrst11 0000000044400000 0000000044434FFF 00035000
2013-08-28 22:34:52.14 spid54 * OraOLEDButl11 0000000044700000 0000000044708FFF 00009000
2013-08-28 22:34:52.14 spid54 * OraClient11 000000002E950000 000000002EDEDFFF 0049e000
2013-08-28 22:34:52.14 spid54 * oracore11 000000001D7E0000 000000001D93FFFF 00160000
2013-08-28 22:34:52.14 spid54 * oranls11 000000001DB90000 000000001DC8EFFF 000ff000
2013-08-28 22:34:52.14 spid54 * oraunls11 000000001A480000 000000001A49FFFF 00020000
2013-08-28 22:34:52.14 spid54 * orauts 000000001A4B0000 000000001A4B6FFF 00007000
2013-08-28 22:34:52.14 spid54 * oracommon11 000000002EDF0000 000000002F0A6FFF 002b7000
2013-08-28 22:34:52.14 spid54 * orasnls11 000000001ACF0000 000000001AD2CFFF 0003d000
2013-08-28 22:34:52.14 spid54 * orageneric11 000000002F0B0000 000000002FFB0FFF 00f01000
2013-08-28 22:34:52.14 spid54 * oraxml11 000000002FFC0000 000000003049EFFF 004df000
2013-08-28 22:34:52.14 spid54 * oran11 00000000304A0000 00000000308F3FFF 00454000
2013-08-28 22:34:52.14 spid54 * oranl11 000000001BBB0000 000000001BC1EFFF 0006f000
2013-08-28 22:34:52.14 spid54 * orantcp11 000000001AF40000 000000001AF74FFF 00035000
2013-08-28 22:34:52.14 spid54 * oranldap11 000000001B210000 000000001B25AFFF 0004b000
2013-08-28 22:34:52.14 spid54 * orannzsbb11 0000000026100000 0000000026283FFF 00184000
2013-08-28 22:34:52.14 spid54 * WSOCK32 000007FEF4D50000 000007FEF4D58FFF 00009000
2013-08-28 22:34:52.14 spid54 * oraldapclnt11 0000000030900000 0000000030AF1FFF 001f2000
2013-08-28 22:34:52.14 spid54 * orancrypt11 000000001BC40000 000000001BC63FFF 00024000
2013-08-28 22:34:52.14 spid54 * orazt11 000000002CEE0000 000000002D0CFFFF 001f0000
2013-08-28 22:34:52.14 spid54 * oranro11 000000001CA50000 000000001CAAAFFF 0005b000
2013-08-28 22:34:52.14 spid54 * oranhost11 000000001BFC0000 000000001BFC9FFF 0000a000
2013-08-28 22:34:52.14 spid54 * orancds11 000000001C310000 000000001C316FFF 00007000
2013-08-28 22:34:52.14 spid54 * orantns11 000000001CAB0000 000000001CAC0FFF 00011000
2013-08-28 22:34:52.14 spid54 * oraztkg11 00000000264D0000 0000000026582FFF 000b3000
2013-08-28 22:34:52.14 spid54 * orapls11 0000000030B00000 0000000031020FFF 00521000
2013-08-28 22:34:52.14 spid54 * oraslax11 000000001CB00000 000000001CB0EFFF 0000f000
2013-08-28 22:34:52.14 spid54 * oravsn11 000000001CBA0000 000000001CBA6FFF 00007000
2013-08-28 22:34:52.14 spid54 * oraplp11 0000000031030000 0000000031424FFF 003f5000
2013-08-28 22:34:52.14 spid54 * orahasgen11 0000000031430000 0000000031705FFF 002d6000
2013-08-28 22:34:52.14 spid54 * oraocr11 0000000026790000 0000000026857FFF 000c8000
2013-08-28 22:34:52.14 spid54 * oraocrb11 0000000026C50000 0000000026D43FFF 000f4000
2013-08-28 22:34:52.14 spid54 * oraocrutl11 000000001D560000 000000001D570FFF 00011000
2013-08-28 22:34:52.14 spid54 * imagehlp 000007FEFF080000 000007FEFF096FFF 00017000
2013-08-28 22:34:52.14 spid54 * oracell11 000000001D590000 000000001D5DAFFF 0004b000
2013-08-28 22:34:52.14 spid54 * orasql11 0000000026860000 00000000268BDFFF 0005e000
2013-08-28 22:34:52.14 spid54 * OraPlc11 000000001D960000 000000001D97FFFF 00020000
2013-08-28 22:34:52.14 spid54 * OraOLEDB11us 0000000044300000 0000000044305FFF 00006000
2013-08-28 22:34:52.14 spid54 * OraOLEDBpus11 0000000044200000 0000000044207FFF 00008000
2013-08-28 22:34:52.14 spid54 * RpcRtRemote 000007FEFCD00000 000007FEFCD13FFF 00014000
2013-08-28 22:34:52.14 spid54 * NLAapi 000007FEFB320000 000007FEFB334FFF 00015000
2013-08-28 22:34:52.14 spid54 * winrnr 000007FEF9D60000 000007FEF9D6AFFF 0000b000
2013-08-28 22:34:52.14 spid54 * napinsp 000007FEF9D40000 000007FEF9D54FFF 00015000
2013-08-28 22:34:52.14 spid54 * dsrole 000007FEFB210000 000007FEFB21BFFF 0000c000
2013-08-28 22:34:52.14 spid54 * SAMLIB 000007FEFA500000 000007FEFA51CFFF 0001d000
2013-08-28 22:34:52.14 spid54 * apphelp 000007FEFCBB0000 000007FEFCC06FFF 00057000
2013-08-28 22:34:52.14 spid54 * dbghelp 00000018C43B0000 00000018C450DFFF 0015e000
2013-08-28 22:34:52.14 spid54 *
2013-08-28 22:34:52.14 spid54 * P1Home: 000000002B7CA0E0: 00000000C0000005 0000000000000000 000000004441316E FFFFF6FB00000002 0000000000000001 0000000019110000
2013-08-28 22:34:52.14 spid54 * P2Home: 000000002B7C9BF0: 000000002B7CA0E0 000000002B7C9BF0 0000000000000000 0000000000000000 000000009B00049F 0000000000000000
2013-08-28 22:34:52.14 spid54 * P3Home: 0000000000000000:
2013-08-28 22:34:52.14 spid54 * P4Home: 0000000000000000:
2013-08-28 22:34:52.14 spid54 * P5Home: 000000009B00049F: 59031D030302F702 373039323501AB01 2020203931303438 4631202020202020 335132314B57434F 31304B5733313032
2013-08-28 22:34:52.14 spid54 * P6Home: 0000000000000000:
2013-08-28 22:34:52.14 spid54 * ContextFlags: 000000000010001F: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000 0000000000000000
2013-08-28 22:34:52.14 spid54 * MxCsr: 0000000000001F80:
2013-08-28 22:34:52.14 spid54 * SegCs: 0000000000000033:
2013-08-28 22:34:52.14 spid54 * SegDs: 000000000000002B:
2013-08-28 22:34:52.14 spid54 * SegEs: 000000000000002B:
2013-08-28 22:34:52.14 spid54 * SegFs: 0000000000000053:
2013-08-28 22:34:52.14 spid54 * SegGs: 000000000000002B:
2013-08-28 22:34:52.14 spid54 * SegSs: 000000000000002B:
2013-08-28 22:34:52.14 spid54 * EFlags: 0000000000010206: 000076EFB1900000 0000FFFFFFFF0000 0000000000000000 0000000000000000 000000000FA00000 0000000000000000
2013-08-28 22:34:52.14 spid54 * Rax: 000000002B7CA248: 00000000444143CA 000000003AC77D20 000000004441252D 0000000032B7D8D8 0000000032B7D8D8 0000000019110000
2013-08-28 22:34:52.14 spid54 * Rcx: 0000000031A14E90: 0000000032B99EC0 00000000321CCCA8 0000000032B7FC30 00000000319E8790 0000000000000000 0000000000000000
2013-08-28 22:34:52.14 spid54 * Rdx: 00000000319F78D0: 0000000032B803C8 0000000000000000 005F000000000000 0022000000220000 00220000002E0000 0032003100300000
2013-08-28 22:34:52.14 spid54 * Rbx: 00000000319E8850: 000000003AC77D80 000000003AC77E80 0000005200000008 900000B31443365B 0000000000000016 800000B314430000
2013-08-28 22:34:52.14 spid54 * Rsp: 000000002B7CA1B0: 000000002B7C0004 00000000319F78D0 00000000000F0298 0000000076E11AE8 0000000000000000 0000000000000000
2013-08-28 22:34:52.14 spid54 * Rbp: 0000000000000002:
2013-08-28 22:34:52.14 spid54 * Rsi: 0000000019110000:
2013-08-28 22:34:52.14 spid54 * Rdi: 000000003AB3D9D0: 000000003ACB89B0 0000000000000006 000000003AB3D9F0 880000B314F7C38E 000000003AA43A20 000000000000000D
2013-08-28 22:34:52.14 spid54 * R8: 000000003ACB89B0: 0072006F002E0042 0065007200650064 00610064005F0064 8000000000650074 0045004E0049FFFF 900000B314F6664C
2013-08-28 22:34:52.14 spid54 * R9: 0000000000000002:
2013-08-28 22:34:52.14 spid54 * R10: 000000002B7CA1F0: 0000000000000003 000000003AC7571A 000000003AC75710 0000000000000000 0000000000000000 00000000319F78D0
2013-08-28 22:34:52.14 spid54 * R11: 000000003AC75A40: 00470049004C0041 004C0046005F004E 0044000000470041 880000B314F09C2D 00000000190F6D28 00000000190F6D28
2013-08-28 22:34:52.14 spid54 * R12: 00000000319F78D0: 0000000032B803C8 0000000000000000 005F000000000000 0022000000220000 00220000002E0000 0032003100300000
2013-08-28 22:34:52.14 spid54 * R13: 0000000031A14E90: 0000000032B99EC0 00000000321CCCA8 0000000032B7FC30 00000000319E8790 0000000000000000 0000000000000000
2013-08-28 22:34:52.14 spid54 * R14: 0000000000000000:
2013-08-28 22:34:52.14 spid54 * R15: 0000000000000000:
2013-08-28 22:34:52.14 spid54 * Rip: 000000004441316E: 78247C894836894C 000000C824BC8B48 37894C0374FF8548 00000090249C8948 000000D0249C8B48 33894C0374DB8548
2013-08-28 22:34:52.14 spid54 * *******************************************************************************
2013-08-28 22:34:52.14 spid54 * -------------------------------------------------------------------------------
2013-08-28 22:34:52.14 spid54 * Short Stack Dump
2013-08-28 22:34:52.14 spid54 000000004441316E Module(OraOLEDBrst11+000000000001316E)
2013-08-28 22:34:52.14 spid54 00000000444143CA Module(OraOLEDBrst11+00000000000143CA)
2013-08-28 22:34:52.15 spid54 000000004441616B Module(OraOLEDBrst11+000000000001616B)
2013-08-28 22:34:52.15 spid54 000000004441C8AB Module(OraOLEDBrst11+000000000001C8AB)
2013-08-28 22:34:52.15 spid54 00000000444248BA Module(OraOLEDBrst11+00000000000248BA)
2013-08-28 22:34:52.15 spid54 000000001B461AF9 Module(OraOLEDB11+0000000000001AF9)
2013-08-28 22:34:52.15 spid54 0000000001050ACF Module(sqlservr+0000000000B30ACF)
2013-08-28 22:34:52.15 spid54 0000000000FF9B47 Module(sqlservr+0000000000AD9B47)
2013-08-28 22:34:52.15 spid54 0000000000FEA102 Module(sqlservr+0000000000ACA102)
2013-08-28 22:34:52.15 spid54 0000000000F63C9F Module(sqlservr+0000000000A43C9F)
2013-08-28 22:34:52.15 spid54 0000000001081A62 Module(sqlservr+0000000000B61A62)
2013-08-28 22:34:52.15 spid54 00000000010805AD Module(sqlservr+0000000000B605AD)
2013-08-28 22:34:52.15 spid54 000000000108002C Module(sqlservr+0000000000B6002C)
2013-08-28 22:34:52.15 spid54 000000000107C90C Module(sqlservr+0000000000B5C90C)
2013-08-28 22:34:52.15 spid54 0000000000B5BB6F Module(sqlservr+000000000063BB6F)
2013-08-28 22:34:52.15 spid54 00000000008008A6 Module(sqlservr+00000000002E08A6)
2013-08-28 22:34:52.15 spid54 0000000000800623 Module(sqlservr+00000000002E0623)
2013-08-28 22:34:52.15 spid54 0000000000799CC7 Module(sqlservr+0000000000279CC7)
2013-08-28 22:34:52.15 spid54 00000000007FA81F Module(sqlservr+00000000002DA81F)
2013-08-28 22:34:52.15 spid54 0000000000799CC7 Module(sqlservr+0000000000279CC7)
2013-08-28 22:34:52.15 spid54 00000000007F4958 Module(sqlservr+00000000002D4958)
2013-08-28 22:34:52.15 spid54 0000000000799CC7 Module(sqlservr+0000000000279CC7)
2013-08-28 22:34:52.15 spid54 000000000079A585 Module(sqlservr+000000000027A585)
2013-08-28 22:34:52.15 spid54 0000000000799CC7 Module(sqlservr+0000000000279CC7)
2013-08-28 22:34:52.15 spid54 0000000000799B91 Module(sqlservr+0000000000279B91)
2013-08-28 22:34:52.15 spid54 00000000007A2C46 Module(sqlservr+0000000000282C46)
2013-08-28 22:34:52.15 spid54 00000000007001E5 Module(sqlservr+00000000001E01E5)
2013-08-28 22:34:52.15 spid54 00000000006FF74E Module(sqlservr+00000000001DF74E)
2013-08-28 22:34:52.15 spid54 00000000006FFE19 Module(sqlservr+00000000001DFE19)
2013-08-28 22:34:52.15 spid54 00000000006FFCBF Module(sqlservr+00000000001DFCBF)
2013-08-28 22:34:52.15 spid54 000000000057B203 Module(sqlservr+000000000005B203)
2013-08-28 22:34:52.15 spid54 000000000057C1A6 Module(sqlservr+000000000005C1A6)
2013-08-28 22:34:52.15 spid54 00000000005C5342 Module(sqlservr+00000000000A5342)
2013-08-28 22:34:52.15 spid54 000000000052BBD8 Module(sqlservr+000000000000BBD8)
2013-08-28 22:34:52.15 spid54 000000000052B8BA Module(sqlservr+000000000000B8BA)
2013-08-28 22:34:52.15 spid54 000000000052B6FF Module(sqlservr+000000000000B6FF)
2013-08-28 22:34:52.15 spid54 0000000000A48FB6 Module(sqlservr+0000000000528FB6)
2013-08-28 22:34:52.15 spid54 0000000000A49175 Module(sqlservr+0000000000529175)
2013-08-28 22:34:52.16 spid54 0000000000A49839 Module(sqlservr+0000000000529839)
2013-08-28 22:34:52.16 spid54 0000000000A49502 Module(sqlservr+0000000000529502)
2013-08-28 22:34:52.16 spid54 00000000744637D7 Module(MSVCR80+00000000000037D7)
2013-08-28 22:34:52.16 spid54 0000000074463894 Module(MSVCR80+0000000000003894)
2013-08-28 22:34:52.17 spid54 0000000076BBF56D Module(kernel32+000000000001F56D)
2013-08-28 22:34:52.17 spid54 0000000076DF3021 Module(ntdll+0000000000033021)
2013-08-28 22:34:52.17 spid54 Stack Signature for the dump is 0x00000000122EAFE5
2013-08-28 22:34:53.07 spid54 External dump process return code 0x20000001.
External dump process returned no errors.

2013-08-28 22:36:21.27 spid54 Using 'dbghelp.dll' version '4.0.5'
2013-08-28 22:36:21.28 spid54 Problem creating symptom dump file due to internal exception
Post #1489764
Posted Thursday, August 29, 2013 9:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:50 AM
Points: 5,329, Visits: 9,773
Looks serious. Use your favourite search engine to investigate this error: SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. You may have to call Microsoft support for this.

John

Edit: strange that this error occurred at a completely different time from the one in SQLAGENT.OUT.
Post #1489767
Posted Thursday, August 29, 2013 10:12 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:31 AM
Points: 3,900, Visits: 7,138
Have you checked to verify the linked server referenced in the stack dump? Could be an issue there (security/external to the linked server) and whenever this query gets run, it causes a fatal error, generating the dump?

While there are many errors in your prior log posts, this appears to show up in the stack dump frequently
Process ID 57 was killed by hostname HAILINLI-WS, host process ID 9312.
2013-08-28 22:33:08.35 spid54 Using 'dbghelp.dll' version '4.0.5'
2013-08-28 22:33:08.36 spid54 ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL10_50.ION_INST_ETL_02\MSSQL\LOG\SQLDump0005.txt
2013-08-28 22:33:08.36 spid54 SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2013-08-28 22:33:08.36 spid54 * *******************************************************************************
2013-08-28 22:33:08.36 spid54 *
2013-08-28 22:33:08.36 spid54 * BEGIN STACK DUMP:
2013-08-28 22:33:08.36 spid54 * 08/28/13 22:33:08 spid 54
2013-08-28 22:33:08.36 spid54 *
2013-08-28 22:33:08.36 spid54 *
2013-08-28 22:33:08.36 spid54 * Exception Address = 0000000076E120E0 Module(ntdll+00000000000520E0)
2013-08-28 22:33:08.36 spid54 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2013-08-28 22:33:08.36 spid54 * Access Violation occurred reading address 0000000000000000
2013-08-28 22:33:08.36 spid54 * Input Buffer 510 bytes -
2013-08-28 22:33:08.36 spid54 * select top 1 * from OPENQUERY(CG1PRD,'SELECT B.order_number
2013-08-28 22:33:08.36 spid54 * ,A.line_number ,nvl(A.option_number,0) as option_numb
2013-08-28 22:33:08.36 spid54 * er --,D.set_name as ship_set_number --,C.organization_
2013-08-28 22:33:08.36 spid54 * code ,A.ordered_item as item_number ,A.item_type_code
...


______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1489789
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse