hi all,
I have this message error (subject) when snapshot finish and subscriber try to download for the first time all updates delete and insert .... my subscriber have populate all the table with data of snapshot, but when start download updates from publisher, give this error. I have only this message and no others ... and the problem is that it show me "succesfull" but with this message.

Any suggestion?

thanks in advance....


From http://www.developmentnow.com/g/114_0_0_0_0_0/sql-server-replication.htm

Posted via DevelopmentNow.com Groups

In particular i notice that warning come in the store sp_msenumgenerations when subscriber do this select :
select generation, guidsrc, art_nick, guidlocal, pubid, nicknames, okaytoskip from @generation_range
ORDER BY generation ASC

From http://www.developmentnow.com/g/114_2007_7_0_0_996336/The-merge-process-could-not-retrieve-generation-information-at-the-Subscriber.htm

Posted via DevelopmentNow.com Groups

There's a good chance this is a timeout issue. Try increasing the timeout of
the merge agent and resynchronize. If this doesn't fix it, please enable
logging and post up the details of the log file
(http://support.microsoft.com/?id=312292).
Cheers,
Paul Ibison

I have already set timeout agent to zero .... i have put snapshot on local drive of subscriber ..... and dont work .....

i reindex ms_genhistory and contents .... but nothing .....

im thinking im going rewrite the store sp_MSenumgenerations .....

i notice is pretty wirte bad ...

Any suggestion?


From http://www.developmentnow.com/g/114_2007_7_0_0_996336/The-merge-process-could-not-retrieve-generation-information-at-the-Subscriber.htm

Posted via DevelopmentNow.com Groups

Please can you do the logging I mentioned in my previous post - I'm hoping it
might provide a bit more info...
Cheers,
Paul Ibison

Thanks paul ...

now i modiify store to let it do 100.000 records at time and it seems it works...

but if something go wrong i will post the log as you say ...

thanks again ....



From http://www.developmentnow.com/g/114_2007_7_0_0_996336/The-merge-process-could-not-retrieve-generation-information-at-the-Subscriber.htm

Posted via DevelopmentNow.com Groups

Paul, we modify the store procedure with top 100.000 and all works fine ...
now subscriber is downloading updates inserts and deletes records from Publisher ...

why microsoft dont think to give at the store a new parameter that is n° of records to fetch in a step ....

mergehistory is always a big table now we have 7.000.0000 of records in this table ... and we are a bit concerned to to metadata clean .... we noticed that is a bit rescue do it ... but thats another story ....

hi and thanks for your time again

good work man

From http://www.developmentnow.com/g/114_2007_7_0_0_996336/The-merge-process-could-not-retrieve-generation-information-at.htm

Posted via DevelopmentNow.com Groups