Merge error

Hi,
the Merge-Agent stops with this error:
Columname 'rowguidcol' is invalid executing this command
{call sp_MSmakearticleprocs (?, ?)}
What is the reason for the error ?
How can I solve the problem ?
Regards
Leandro
do any of the articles you are replicating contain a column called
rowguidcol?
"Leandro Etchezar" <paralea@.ciudad.com.ar> wrote in message
news:%237lRvi3PFHA.3668@.TK2MSFTNGP14.phx.gbl...
> Hi,
> the Merge-Agent stops with this error:
> Columname 'rowguidcol' is invalid executing this command
> {call sp_MSmakearticleprocs (?, ?)}
> What is the reason for the error ?
> How can I solve the problem ?
> Regards
> Leandro
>

Merge Agent fails - "Invalid character value for cast specificatio

Hi
From http://support.microsoft.com/kb/867880 it seems to have been fixed in
release 952. If you call PSS they should be able to give you the approriate
patch.
John
"Luke Ward" wrote:

> Hi Guys
> This above error is suppose to be fixed in SP4 for SQL Server 2000, howeve
r,
> SP4 is not available yet!
> Does anyone know of a HOT FIX or work around?
> Many Thanks
> Luke
>
>Thanks, I will give them a call
btw - both my servers are on SP3a
Cheers
Luke
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:EDF66E5C-3BEE-4F80-A24B-49868D66D251@.microsoft.com...
> Hi
> From http://support.microsoft.com/kb/867880 it seems to have been fixed in
> release 952. If you call PSS they should be able to give you the
> approriate
> patch.
> John
>
> "Luke Ward" wrote:
>|||Hi Guys
MS Tech gave me a fix, which did not fix it, I have now applied SP4, and
still get the same error :-(
I am going to see if I can attach logging to the publication.
What else can I do? any advise appreciated.
Luke
"Luke Ward" <lukeward@.campbelluk.com> wrote in message
news:OkrgViKUFHA.2940@.TK2MSFTNGP10.phx.gbl...
> Thanks, I will give them a call
> btw - both my servers are on SP3a
> Cheers
> Luke
> "John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
> news:EDF66E5C-3BEE-4F80-A24B-49868D66D251@.microsoft.com...
>

Merge Agent Error: invalid column 'rowguid'

I get this error when I Push New subscription and indicate NO, to initialize
schema and data.
the wizard dialog is: Initial Subscription, and I am choosing: No,
subscriber already has schema and data
Does the subscriber have an identical table ther already (including the guid
column)?
Regards,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||No. I just have four tables in my publication and checked for that first.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23W53vgb%23EHA.2608@.TK2MSFTNGP10.phx.gbl...
> Does the subscriber have an identical table ther already (including the
> guid
> column)?
> Regards,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Robert,
the table must already be there in a nosync initialization, in identical
format to the publisher one.
If you are saying it isn't there, then you'll need to use backup/restore or
DTS or some other means to transfer it.
Rgds,
Paul Ibison
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:OoAgSmb%23EHA.2032@.tk2msftngp13.phx.gbl...
> No. I just have four tables in my publication and checked for that first.
>
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:%23W53vgb%23EHA.2608@.TK2MSFTNGP10.phx.gbl...
>
|||Thank you Paul. I feel special today with all your attention.
I meant the column rowguid; I checked that it was not present as I assume
the PushNewSubscription process will create the column in the table at the
subscriber.
What I really am trying to accomplish, and forgive me, is how do I "turn on
replication" at the publisher-machine when my subscriber machine is already
in a working-production environment?
My thinking is that I start with a blank database at the publisher, schema
matching the subscriber, and enable publishing and push a new subscription
but NOT intializing schema and data. Because I'm guessing the blank
database at the publisher will destroy all records at the live subscriber,
making it blank also. Am I correct and what is the solution?
Thank you very, very much.
Bob
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23dAW%23ub%23EHA.2804@.TK2MSFTNGP15.phx.gbl.. .
> Robert,
> the table must already be there in a nosync initialization, in identical
> format to the publisher one.
> If you are saying it isn't there, then you'll need to use backup/restore
> or
> DTS or some other means to transfer it.
> Rgds,
> Paul Ibison
> "Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
> news:OoAgSmb%23EHA.2032@.tk2msftngp13.phx.gbl...
>
|||Robert,
please keep the questions coming - this is my great
hobby
The initialization process can do one of two things:
(a) if you choose a synch initialization, then the
complete table will be BCPd out into the repldata share.
In that share there'll be several textfiles - for
creating the schema, the indexes, one containing data,
but the initial text file contains simply a 'drop table'
statement. That means that it really doesn't matter what
is on the subscriber - there can be a table of the same
name or not. if there is, it'll be deleted anyway.
(b) you select to do a nosync initialization. In this
case, the exact ssame table (inc guid) must exist on the
subscriber. The initialization process will create
metadata tables on the subscriber, but it won't touch the
replicated table at all.
There are further variations if we consider other options
for @.pre_creation_cmd, where you can select to leave the
table there if it already exists and such like, but these
are for specialist scenarios.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)