Re: Replication Minor Error 29510

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks for the reply Darren.

We do not have any compacting in our application, so we will go ahead and
test compacting then replicating again.

Darren just for our knowledge. Will compacting the database fix any issues
with it? We are getting this error when we replicate, and also an error of
null reference when inserting into one of the tables, but this does not
happen on any other handheld. We could open the DB in SQL CE Query analyzer,
is the DB still possibly corrupt somehow and compacting will fix it?

Thanks and take care.

"Darren Shaffer" wrote:

> have you tried to compact this database? it may be damaged.
> --
> Darren Shaffer
> ..NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
> "Synced" <Synced@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:D64064C5-B9AB-44EB-92F6-BA7ABFD5AE82@xxxxxxxxxxxxxxxx
> > Hey guys,
> >
> > Seems I'm getting this error:
> > Major: 80004005
> > Minor: 29510
> >
> > MSDN describes it as: The ISequentialStream interface detects that the
> > BLOB
> > data stream is not empty.
> >
> > What does this mean? Here is the situation...
> >
> > Handheld has added possibly 100 or 200 new records, not replicated yet for
> > a
> > few days. The main SQL 2000 server, 3 new columns were added. Now we try
> > to
> > merge replicate, and we get that error.
> >
> > Any ideas how I can resolve this and make the replication work? I need to
> > get the data onto the main server. I have no idea what could cause this,
> > we
> > have added columns in the past before.
> >
> > The 3 columns we added to the article are an int, datetime, datetime. Not
> > sure why the error mentions a BLOB?
> >
> > Any help would be supremely appreciated.
> >
> > Thanks and take care.
>
>
>
.

Relevant Pages

  • Re: Replication Minor Error 29510
    ... Compacting does a couple of things. ... Will compacting the database fix any issues ... We could open the DB in SQL CE Query ... >>> merge replicate, ...
    (microsoft.public.sqlserver.ce)
  • Replication Minor Error 29510
    ... The ISequentialStream interface detects that the BLOB ... data stream is not empty. ... merge replicate, ... The 3 columns we added to the article are an int, datetime, datetime. ...
    (microsoft.public.sqlserver.ce)