Showing posts with label exception. Show all posts
Showing posts with label exception. Show all posts

Thursday, March 8, 2012

[PRB SQL 2k SP4] SqlMail: fatal exception c0000005

Hello,
on one server that I build to test the SP4, I've got constantly a fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION, which is due to SqlMail (when
it notifies after a job, linked to a maintenance plan).
I did install this server following the rpocedure for our production server,
which does not experiment this error at all.
I've been unable to locate relevant information even after extensive search.
Any thought about it? Any similar experience somebody?
Thanks,
Emmanuel
PS: the beginning of the crash dump text file is as follows (edited):
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server 8.00.2039
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Bios Version is Phoenix ROM BIOS PLUS Version 1.10 A11
Current time is 00:52:46 08/12/05.
1 Intel x86 level 6, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 70%
Total Physical = 1023 MB
Available Physical = 304 MB
Total Page File = 2463 MB
Available Page File = 1424 MB
Total Virtual = 2047 MB
Available Virtual = 931 MB
*Stack Dump being sent to e:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0014.txt
*
*****************************************************************************
**
*
* BEGIN STACK DUMP:
* 08/12/05 00:52:46 spid 59
*
* Exception Address = 77F8206B (RtlEnterCriticalSection + 0000000B Line
0+000
00000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 0864FF90
* Input Buffer 1178 bytes -
* DECLARE @.msg varchar(255) SELECT @.msg = 'The attached report is a summ
* ary of the automated maintenance carried out for plan ' + datename(dw
* , getdate()) + ' ' + convert(varchar, datepart(dd, getdate())) + ' '
* + datename(mm, getdate()) + ' ' + convert(varchar, datepart(yy, ge
* tdate())) + ':' + CHAR(13) EXEC xp_sendmail @.recipients = 'emmanue
* l@.mycompany.com', @.subject = 'SQL Server DB Maintenance Report
* - SQL-SP4\User Databases (Success)', @.message = @.msg, @.attachments
* = 'E:\Program Files\Microsoft SQL Server\MSSQL\LOG\User Databases4_2005
* 08120045.txt'
*AV normally means a bug in sqlserver. You might want to contact PSS. This
call should not be charged.
http://support.microsoft.com/oas/default.aspx?ln=en-us&x=11&y=13&prid=2392&gprid=36498
--
-oj
"Emmanuel" <Emmanuel@.discussions.microsoft.com> wrote in message
news:291AF677-3E24-49C7-8354-D3675363A55E@.microsoft.com...
> Hello,
> on one server that I build to test the SP4, I've got constantly a fatal
> exception c0000005 EXCEPTION_ACCESS_VIOLATION, which is due to SqlMail
> (when
> it notifies after a job, linked to a maintenance plan).
> I did install this server following the rpocedure for our production
> server,
> which does not experiment this error at all.
> I've been unable to locate relevant information even after extensive
> search.
> Any thought about it? Any similar experience somebody?
> Thanks,
> Emmanuel
> PS: the beginning of the crash dump text file is as follows (edited):
> =====================================================================> BugCheck Dump
> =====================================================================>
> This file is generated by Microsoft SQL Server 8.00.2039
> upon detection of fatal unexpected error. Please return this file,
> the query or program that produced the bugcheck, the database and
> the error log, and any other pertinent information with a Service Request.
>
> Computer type is AT/AT COMPATIBLE.
> Bios Version is Phoenix ROM BIOS PLUS Version 1.10 A11
> Current time is 00:52:46 08/12/05.
> 1 Intel x86 level 6, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 70%
> Total Physical = 1023 MB
> Available Physical = 304 MB
> Total Page File = 2463 MB
> Available Page File = 1424 MB
> Total Virtual = 2047 MB
> Available Virtual = 931 MB
> *Stack Dump being sent to e:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0014.txt
> *
> *****************************************************************************
> **
> *
> * BEGIN STACK DUMP:
> * 08/12/05 00:52:46 spid 59
> *
> * Exception Address = 77F8206B (RtlEnterCriticalSection + 0000000B Line
> 0+000
> 00000)
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 0864FF90
> * Input Buffer 1178 bytes -
> * DECLARE @.msg varchar(255) SELECT @.msg = 'The attached report is a
> summ
> * ary of the automated maintenance carried out for plan ' +
> datename(dw
> * , getdate()) + ' ' + convert(varchar, datepart(dd, getdate())) + ' '
> * + datename(mm, getdate()) + ' ' + convert(varchar, datepart(yy,
> ge
> * tdate())) + ':' + CHAR(13) EXEC xp_sendmail @.recipients => 'emmanue
> * l@.mycompany.com', @.subject = 'SQL Server DB Maintenance Report
> * - SQL-SP4\User Databases (Success)', @.message = @.msg,
> @.attachments
> * = 'E:\Program Files\Microsoft SQL Server\MSSQL\LOG\User
> Databases4_2005
> * 08120045.txt'
> *
>

[PRB SQL 2k SP4] SqlMail: fatal exception c0000005

Hello,
on one server that I build to test the SP4, I've got constantly a fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION, which is due to SqlMail (when
it notifies after a job, linked to a maintenance plan).
I did install this server following the rpocedure for our production server,
which does not experiment this error at all.
I've been unable to locate relevant information even after extensive search.
Any thought about it? Any similar experience somebody?
Thanks,
Emmanuel
PS: the beginning of the crash dump text file is as follows (edited):
========================================
=============================
BugCheck Dump
========================================
=============================
This file is generated by Microsoft SQL Server 8.00.2039
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Bios Version is Phoenix ROM BIOS PLUS Version 1.10 A11
Current time is 00:52:46 08/12/05.
1 Intel x86 level 6, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 70%
Total Physical = 1023 MB
Available Physical = 304 MB
Total Page File = 2463 MB
Available Page File = 1424 MB
Total Virtual = 2047 MB
Available Virtual = 931 MB
*Stack Dump being sent to e:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0014.txt
*
****************************************
************************************
*
**
*
* BEGIN STACK DUMP:
* 08/12/05 00:52:46 spid 59
*
* Exception Address = 77F8206B (RtlEnterCriticalSection + 0000000B Line
0+000
00000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 0864FF90
* Input Buffer 1178 bytes -
* DECLARE @.msg varchar(255) SELECT @.msg = 'The attached report is a summ
* ary of the automated maintenance carried out for plan ' + datename(dw
* , getdate()) + ' ' + convert(varchar, datepart(dd, getdate())) + ' '
* + datename(mm, getdate()) + ' ' + convert(varchar, datepart(yy, ge
* tdate())) + ':' + CHAR(13) EXEC xp_sendmail @.recipients = 'emmanue
* l@.mycompany.com', @.subject = 'SQL Server DB Maintenance Report
* - SQL-SP4\User Databases (Success)', @.message = @.msg, @.attachments
* = 'E:\Program Files\Microsoft SQL Server\MSSQL\LOG\User Databases4_2005
* 08120045.txt'
*AV normally means a bug in sqlserver. You might want to contact PSS. This
call should not be charged.
http://support.microsoft.com/oas/de...d=3
6498
-oj
"Emmanuel" <Emmanuel@.discussions.microsoft.com> wrote in message
news:291AF677-3E24-49C7-8354-D3675363A55E@.microsoft.com...
> Hello,
> on one server that I build to test the SP4, I've got constantly a fatal
> exception c0000005 EXCEPTION_ACCESS_VIOLATION, which is due to SqlMail
> (when
> it notifies after a job, linked to a maintenance plan).
> I did install this server following the rpocedure for our production
> server,
> which does not experiment this error at all.
> I've been unable to locate relevant information even after extensive
> search.
> Any thought about it? Any similar experience somebody?
> Thanks,
> Emmanuel
> PS: the beginning of the crash dump text file is as follows (edited):
> ========================================
=============================
> BugCheck Dump
> ========================================
=============================
>
> This file is generated by Microsoft SQL Server 8.00.2039
> upon detection of fatal unexpected error. Please return this file,
> the query or program that produced the bugcheck, the database and
> the error log, and any other pertinent information with a Service Request.
>
> Computer type is AT/AT COMPATIBLE.
> Bios Version is Phoenix ROM BIOS PLUS Version 1.10 A11
> Current time is 00:52:46 08/12/05.
> 1 Intel x86 level 6, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 70%
> Total Physical = 1023 MB
> Available Physical = 304 MB
> Total Page File = 2463 MB
> Available Page File = 1424 MB
> Total Virtual = 2047 MB
> Available Virtual = 931 MB
> *Stack Dump being sent to e:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0014.txt
> *
> ****************************************
**********************************
***
> **
> *
> * BEGIN STACK DUMP:
> * 08/12/05 00:52:46 spid 59
> *
> * Exception Address = 77F8206B (RtlEnterCriticalSection + 0000000B Line
> 0+000
> 00000)
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 0864FF90
> * Input Buffer 1178 bytes -
> * DECLARE @.msg varchar(255) SELECT @.msg = 'The attached report is a
> summ
> * ary of the automated maintenance carried out for plan ' +
> datename(dw
> * , getdate()) + ' ' + convert(varchar, datepart(dd, getdate())) + ' '
> * + datename(mm, getdate()) + ' ' + convert(varchar, datepart(yy,
> ge
> * tdate())) + ':' + CHAR(13) EXEC xp_sendmail @.recipients =
> 'emmanue
> * l@.mycompany.com', @.subject = 'SQL Server DB Maintenance Report
> * - SQL-SP4\User Databases (Success)', @.message = @.msg,
> @.attachments
> * = 'E:\Program Files\Microsoft SQL Server\MSSQL\LOG\User
> Databases4_2005
> * 08120045.txt'
> *
>

[PRB SQL 2k SP4] SqlMail: fatal exception c0000005

Hello,
on one server that I build to test the SP4, I've got constantly a fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION, which is due to SqlMail (when
it notifies after a job, linked to a maintenance plan).
I did install this server following the rpocedure for our production server,
which does not experiment this error at all.
I've been unable to locate relevant information even after extensive search.
Any thought about it? Any similar experience somebody?
Thanks,
Emmanuel
PS: the beginning of the crash dump text file is as follows (edited):
================================================== ===================
BugCheck Dump
================================================== ===================
This file is generated by Microsoft SQL Server 8.00.2039
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Bios Version is Phoenix ROM BIOS PLUS Version 1.10 A11
Current time is 00:52:46 08/12/05.
1 Intel x86 level 6, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 70%
Total Physical = 1023 MB
Available Physical = 304 MB
Total Page File = 2463 MB
Available Page File = 1424 MB
Total Virtual = 2047 MB
Available Virtual = 931 MB
*Stack Dump being sent to e:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0014.txt
*
************************************************** ***************************
**
*
* BEGIN STACK DUMP:
* 08/12/05 00:52:46 spid 59
*
* Exception Address = 77F8206B (RtlEnterCriticalSection + 0000000B Line
0+000
00000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 0864FF90
* Input Buffer 1178 bytes -
* DECLARE @.msg varchar(255) SELECT @.msg = 'The attached report is a summ
* ary of the automated maintenance carried out for plan ' + datename(dw
* , getdate()) + ' ' + convert(varchar, datepart(dd, getdate())) + ' '
* + datename(mm, getdate()) + ' ' + convert(varchar, datepart(yy, ge
* tdate())) + ':' + CHAR(13) EXEC xp_sendmail @.recipients = 'emmanue
* l@.mycompany.com', @.subject = 'SQL Server DB Maintenance Report
* - SQL-SP4\User Databases (Success)', @.message = @.msg, @.attachments
* = 'E:\Program Files\Microsoft SQL Server\MSSQL\LOG\User Databases4_2005
* 08120045.txt'
*
AV normally means a bug in sqlserver. You might want to contact PSS. This
call should not be charged.
http://support.microsoft.com/oas/def...92&gprid=36498
-oj
"Emmanuel" <Emmanuel@.discussions.microsoft.com> wrote in message
news:291AF677-3E24-49C7-8354-D3675363A55E@.microsoft.com...
> Hello,
> on one server that I build to test the SP4, I've got constantly a fatal
> exception c0000005 EXCEPTION_ACCESS_VIOLATION, which is due to SqlMail
> (when
> it notifies after a job, linked to a maintenance plan).
> I did install this server following the rpocedure for our production
> server,
> which does not experiment this error at all.
> I've been unable to locate relevant information even after extensive
> search.
> Any thought about it? Any similar experience somebody?
> Thanks,
> Emmanuel
> PS: the beginning of the crash dump text file is as follows (edited):
> ================================================== ===================
> BugCheck Dump
> ================================================== ===================
>
> This file is generated by Microsoft SQL Server 8.00.2039
> upon detection of fatal unexpected error. Please return this file,
> the query or program that produced the bugcheck, the database and
> the error log, and any other pertinent information with a Service Request.
>
> Computer type is AT/AT COMPATIBLE.
> Bios Version is Phoenix ROM BIOS PLUS Version 1.10 A11
> Current time is 00:52:46 08/12/05.
> 1 Intel x86 level 6, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 70%
> Total Physical = 1023 MB
> Available Physical = 304 MB
> Total Page File = 2463 MB
> Available Page File = 1424 MB
> Total Virtual = 2047 MB
> Available Virtual = 931 MB
> *Stack Dump being sent to e:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0014.txt
> *
> ************************************************** ***************************
> **
> *
> * BEGIN STACK DUMP:
> * 08/12/05 00:52:46 spid 59
> *
> * Exception Address = 77F8206B (RtlEnterCriticalSection + 0000000B Line
> 0+000
> 00000)
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 0864FF90
> * Input Buffer 1178 bytes -
> * DECLARE @.msg varchar(255) SELECT @.msg = 'The attached report is a
> summ
> * ary of the automated maintenance carried out for plan ' +
> datename(dw
> * , getdate()) + ' ' + convert(varchar, datepart(dd, getdate())) + ' '
> * + datename(mm, getdate()) + ' ' + convert(varchar, datepart(yy,
> ge
> * tdate())) + ':' + CHAR(13) EXEC xp_sendmail @.recipients =
> 'emmanue
> * l@.mycompany.com', @.subject = 'SQL Server DB Maintenance Report
> * - SQL-SP4\User Databases (Success)', @.message = @.msg,
> @.attachments
> * = 'E:\Program Files\Microsoft SQL Server\MSSQL\LOG\User
> Databases4_2005
> * 08120045.txt'
> *
>

Saturday, February 11, 2012

@@SourceRow: Logging Failed

I defined exception file in the DTS package options. I didn't use SQL7.0 format file.

A file with the following contents was created. But a source error file was not. Can someone have the similar experience?

DATA TRANSFORMATION SERVICES: Data Pump Exception Log

@.@.ErrorRow: 496702
Error during Transformation 'DTSTransformation__94' for Row number 496702. Errors encountered so far in this task: 8.

Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Error Description:ActiveX Scripting Transform 'DTSTransformation__94' encountered an invalid data value for 'ANNUITY_BEGIN_DT' destination column.
Error Help File:sqldts80.hlp
Error Help Context ID:30632
@.@.SourceRow: Logging Failed

Error code: 80004005

@.@.ExecutionCompleted

Execution Completed: 3/24/2004 1:57:32 PM

************************************************** **************************************************Enable DTS package logging for further information.

Also try to delete the transform between those to columns and map them to the right columns...