Null value eliminated from aggregate. -- sql server replication

Sean Paik
11/13/2003 4:27:13 PM

We are using replication in L.A & Mexico.
Right now, the replication doesn't work.
Someone tried to save the data in Mexico.
The below data is not normal.
I don't want to stop replication.
I just want to delete 1 row on table.
But, I cannot find the data on the database.
Where is the below data?
Can I delete replication data on database?
Pls help me.

Distribution Agent Error Details.

Last action : Warning: Null value eliminated from
aggregate.

Last Command : {CALL sp_MSins_ship_det1 (307002, 215,
430000046, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, B5C4F5BD-B077-4C7E-A933-
EB8528C2786D)}

Error Information

Category Source Number
--------------------------------------------
Data source SRVBAKX 8153
Data source SRVBAKX 8153

Hilary Cotter
11/14/2003 12:09:32 PM

try the skiperror command. In the error details message
note the error number. Then expand your replication
monitor folder, expand replication agents, expand the
particular folder for you problem agent (trans, merge or
snapshot), right click on your agent, select agnet
properites, steps, run agent, edit and then at the end of
the command type (space) -SkipErrors and then place your
error number.

Restart your job.

You can also right click on your agent, select agent
profiles, select continue on data consistency errors.

Then restat your job.
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Null value eliminated from aggregate.