SQL Server Performance

EXCEPTION_ACCESS_VIOLATION on DTS text data load

Discussion in 'SQL Server DTS-Related Questions' started by tandangp, Jul 21, 2005.

  1. tandangp New Member

    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
  2. Luis Martin Moderator

    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.



Share This Page