Re: Distribution Agent fails with Access Violation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Janet, i write from Italy, i have the same problem.
Have you resolved the problem.

I don' t know more what to make.

Thanks

"Janet" wrote:

> Log file is not in the system32 we have searched the entire machine for it.
> I have checked the data and that looks fine, and the DTS should be ok too
> because the Snapshot uses it and works. I have also restarted the SQL Agent
>
> This article has been working now for a couple of months and started to fail
> the moment SQL came back up after the SP4 install.
>
> The other thing to note is that now whenever a distrubtion agent fails (for
> other publications not just this one) the SPID doesn't seem to clear properly
> and when the agent runs again it fails saying that the agent is already
> running.
>
> "Hilary Cotter" wrote:
>
> > I think that this log should be in %windir%\system32
> >
> > I have seen these events as well.Sometimes it is that the data is not in the
> > correct form and the distrib agent will fault, but on the next run will work
> > fine. Query your data to determine if this could account for the problem.
> >
> > What happens if you restart your agent? Does the error clear?
> >
> > --
> > Hilary Cotter
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> > Looking for a FAQ on Indexing Services/SQL FTS
> > http://www.indexserverfaq.com
> > "Janet" <Janet@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:BC4CCE66-3860-4558-B8BD-1AD6A6D99BD2@xxxxxxxxxxxxxxxx
> > > I have a SQL Server 2000 installation on Windows 2000 Server, last night I
> > > updated this server with SQL SP4. The install was successful but after
> > the
> > > installation one of my Publications failed with Data Transformation (DTS)
> > > Failed.
> > > In the Event log I have the following error.
> > >
> > > Microsoft SQL Server Replication: The DISTRIB.EXE executable is
> > terminating
> > > abnormally because it hit an exception. Exception Code c0000005.
> > > Check file ReplExceptDist.log for details
> > >
> > > This log file does not exist on the Server.
> > >
> > > I have traced the problem to a particular article in the publication. If I
> > > Reinitilize this one application with a snapshot it is successful.
> > >
> > > Any suggestions would be helpful at this point
> > >
> > > Thanks
> > > Janet
> >
> >
> >
.

Relevant Pages

  • Re: Why did Dave delete his ex-wife Lindas posts using hipcrime? www.geocities.com/kdkdabbm/mine
    ... International's Chemical Report on C.S. Agent #6.] ... Governor Ann Richards allow the use of helicopters from the Texas ... The following descriptions are entirely from Janet Reno's own testimony, ...
    (sci.engr.joining.welding)
  • Re: Distribution Agent fails with Access Violation
    ... Log file is not in the system32 we have searched the entire machine for it. ... I have checked the data and that looks fine, and the DTS should be ok too ... I have also restarted the SQL Agent ... > Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL Agent Failure - monitoring
    ... > unexpectedly or fails to start. ... >> I want to log to the Windows Event Log whenever the SQL Server Agent is ... >> I have set the agent to AutoStart when the OpSys restarts, ...
    (microsoft.public.sqlserver.server)
  • using perl grep to read a log file - need some sort of loop
    ... I read this log file twice a day using cron. ... the script if not send an email to myself and then exit. ... Fri Jul 23 13:54:54 2004: Agent is now disconnected. ... print"starting the log search for connected\n\n"; ...
    (perl.beginners)
  • SQL Agent Failure - monitoring
    ... I want to log to the Windows Event Log whenever the SQL Server Agent is ... or it just fails unexpectedly. ... I have set the agent to AutoStart when the OpSys restarts, ...
    (microsoft.public.sqlserver.server)