all groups > sql server replication > march 2004 >
You're in the

sql server replication

group:

SQL Profiler causes excpetions


SQL Profiler causes excpetions chandy NO[at]SPAM totalise.co.uk
3/30/2004 8:34:48 AM
sql server replication:
We have the following scanario.

Publisher is SQL 2k SP2, Subscribers are SQL CE 1.1, using merge
replication.

Everything is fine, until we start SQL Profiler on the Publisher
Database. If the Profiler is running then replication takes 2-3
attempts, failing between times with server errors. SQL records the
following in the log:

SqlDumpExceptionHandler: Process 64 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..

and points to:

sp_upd_F280ADE09C6947139B37078469804F9B

(or similar depending on the subscriber who initialised the merge at
the time)

Server is a dual-processor PIII 500 with 4GB RAM and plenty of disk.

Subscribers are iPAQs.

Any ideas???

Re: SQL Profiler causes excpetions Hilary Cotter
3/30/2004 1:12:56 PM
do these procedures exist on the SQL CE database?

Can you check the conflicts table for errors about missing replication
procs?

[quoted text, click to view]

Re: SQL Profiler causes excpetions chandy NO[at]SPAM totalise.co.uk
3/31/2004 1:21:29 AM
Hi Hilary,

They exist in the Publisher db, they just start throwing exceptions
when profiler is active.

Chandy

[quoted text, click to view]
Re: SQL Profiler causes excpetions Hilary Cotter
3/31/2004 8:07:29 AM
but do they exist on the CE?

It sounds like a bug you should call PSS on.
[quoted text, click to view]

AddThis Social Bookmark Button