EXCEPTION_ACCESS_VIOLATION on DTS text data load | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

EXCEPTION_ACCESS_VIOLATION on DTS text data load

Hi everyone, The DTS load that we have in our environment were running fine for more than 1.5 years, until a few months ago it starts to fail with this message:
—–Original Message—–
From: sqluser
Sent: Thursday, July 21, 2005 2:10 AM
To: Garrett, Bradley (AHL); Tandang, Paulus (AHL)
Subject: SQL Server Alert System: ‘Demo: Sev. 19 Errors’ occurred on
\AHLSQL2AHL2
DATE/TIME:7/21/2005 2:09:08 AM DESCRIPTION:Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 55 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. COMMENT:(None) JOB RUN:(None) and then our DTS package message that we built give the message that the format file for BCP bulk load is wrong, which is incorrect, because within 1-3 hours later we run the package without problem. Here is the message:
—–Original Message—–
From: sqluser
Sent: Thursday, July 21, 2005 2:10 AM
To: Garrett, Bradley (AHL)
Cc: Tandang, Paulus (AHL)
Subject: AHLSQL2AHL2 DatarrayCF xyCard R05.04.000 Daily (CVO) Stage –
Bulk Adjustments Error
The package failed in the Bulk Insert Task Function(Bulk Adjustments). The DTS package has encountered an error that is related to the Bulk Insert function. A possible cause might be that the data contain column headers and/or text delimiters. Or that the structure of the table may have changed and no longer match what is expected by the Bulk Load utility. The most common cause is that the source file name does not match the name of the source file Specified in the INI file. Please review the error and determine the nature of the problem before re-executing this package.
When we run it again the package a few hours later, the package run fine without any of the errors message above.
The text files come from Mainframe download. My manager and I talked to mainframe people in our office and they confirmed that the files has been transferred completed, hours before the DTS load take place. Microsoft has SQL 2000 SP4 that address this access violation problem, but this SP4 hasn’t ready yet for public because Microsoft still working on the bug of this SP4. This can be a microsoft problem and can be our environment problem. My manager already approved the cost to open call to Microsoft, but before I talk to them, I would like to know if our great and friendly forum here have suggestion. Has anyone experience this or have ideas on what the problem and solution could be? Any response will be greatly appreciated. Thanks!
Paulus
According:http://support.microsoft.com/default.aspx?scid=kb;en-us;830773
SP4 is the solution. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
]]>