Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007
    Posts
    1

    Unanswered: SQL Error in Event Log - help!

    Background:

    We have a data import t-sql job which runs every morning to extract data from a large Unix database. This has worked fine on an old server which ran the same SQL version and service pack.

    The t-sql uses a linked server and simply truncates the local tables and reimports the whole lot. Appreciate there are other ways to do this but it works fine for a medium sized business and is not mission critical.

    However, when we have moved this onto the new server its throwing an error message in the event log when the job finishes. It actually completes the job and reports it as successful but at the exact same time it throws the following error message into the event log:

    Error: 0, Severity: 19, State: 0
    SqlDumpExceptionHandler: Process 14 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


    I have attached the dump txt file.

    T-SQL:

    Code:
    Begin Transaction
    
    truncate table arista_caclient
    truncate table arista_camatgrp
    truncate table arista_camatter
    truncate table arista_cabilhis
    truncate table arista_cablaloc
    truncate table arista_cafintrn
    truncate table arista_cadescrp
    truncate table arista_catimtrn
    truncate table arista_cafeextn
    truncate table arista_fmsaddr
    truncate table arista_cabilloi
    truncate table arista_caferate
    
    INSERT INTO arista_caclient SELECT * FROM OPENQUERY(arista_ODBClink,'SELECT * FROM caclient WHERE cl_datopn>=''01/01/1900'' OR cl_datopn is null')
    INSERT INTO arista_camatgrp SELECT * FROM OPENQUERY(arista_ODBClink,'SELECT * FROM camatgrp WHERE (mg_datcls>=''01/01/1900'' OR mg_datcls is null) AND (mg_datopn>=''01/01/1900'' OR mg_datopn is null)')
    INSERT INTO arista_camatter SELECT * FROM OPENQUERY(arista_ODBClink,'SELECT * FROM camatter WHERE (mt_estcmp>=''01/01/1900'' OR mt_estcmp is null)')
    INSERT INTO arista_cabilhis SELECT * FROM OPENQUERY(arista_ODBClink,'SELECT * FROM cabilhis WHERE (bh_bildat>=''01/01/1900'' OR bh_bildat is null) AND (bh_laspay>=''01/01/1900'' OR bh_laspay is null) AND (bh_rundat>=''01/01/1900'' OR bh_rundat is null) AND (bh_remdat>=''01/01/1900'' OR bh_remdat is null)')
    INSERT INTO arista_cablaloc SELECT * FROM OPENQUERY(arista_ODBClink,'SELECT * FROM cablaloc')
    INSERT INTO arista_cafintrn SELECT * FROM OPENQUERY(arista_ODBClink,'SELECT * FROM cafintrn WHERE (tr_trdate>=''01/01/1900'' OR tr_trdate is null)')
    INSERT INTO arista_cadescrp SELECT * FROM OPENQUERY(arista_ODBClink,'SELECT * FROM cadescrp')
    INSERT INTO arista_catimtrn SELECT * FROM OPENQUERY(arista_ODBClink,'SELECT * FROM catimtrn WHERE (tt_trndat>=''01/01/1900'' OR tt_trndat is null)')
    INSERT INTO arista_cafeextn SELECT * FROM OPENQUERY(arista_ODBClink,'SELECT * FROM cafeextn')
    INSERT INTO arista_fmsaddr SELECT * FROM OPENQUERY(arista_ODBClink,'SELECT * FROM fmsaddr')
    INSERT INTO arista_cabilloi SELECT * FROM OPENQUERY(arista_ODBClink,'SELECT * FROM cabilloi')
    INSERT INTO arista_caferate SELECT * FROM OPENQUERY(arista_ODBClink,'SELECT * FROM caferate')
    
    DBCC DBreindex (arista_caclient)
    DBCC DBreindex (arista_camatgrp)
    DBCC DBreindex (arista_camatter)
    DBCC DBreindex (arista_cablaloc)
    DBCC DBreindex (arista_catimtrn)
    DBCC DBreindex (arista_cafintrn)
    DBCC DBreindex (arista_cadescrp)
    DBCC DBreindex (arista_cafeextn)
    DBCC DBreindex (arista_fmsaddr)
    DBCC DBreindex (arista_cabilloi)
    DBCC DBreindex (arista_caferate)
    
    If @@error <> 0
    	Rollback Transaction
    Commit Transaction
    Environment:

    Server 2003 SP2
    SQL2000 SP3

    Appreciate any advice at all as its a bit of an odd one.

    Tim
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    http://support.microsoft.com/kb/824227

    I would upgrade to service pack 4 before doing anything else

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •