SQL SERVER 2005 REPLICATION (SNAPSHOT GENERATION FAILING)

i'm getting error when try generate snapshot "merge" replication.  have added articles one-by-one try , narrow problem down.  error on specific articles.  appreciated.

 

2006-03-23 18:23:14.35 server: myserver

2006-03-23 18:23:14.35 database: mydb
2006-03-23 18:23:14.35 command text: sys.sp_releaseapplock
2006-03-23 18:23:14.35 parameters:
2006-03-23 18:23:14.35  @resource = myserver-dbmerge
2006-03-23 18:23:14.35  @lockowner = session
2006-03-23 18:23:14.35  @dbprincipal = db_owner
2006-03-23 18:23:14.35 [99%] replication agent had encountered exception.
2006-03-23 18:23:14.35 source: replication
2006-03-23 18:23:14.35 exception type: microsoft.sqlserver.replication.replicationagentsqlexception
2006-03-23 18:23:14.35 exception message: startindex cannot less zero.
2006-03-23 18:23:14.35 parameter name: startindex
2006-03-23 18:23:14.35 message code: 52006
2006-03-23 18:23:14.35 
2006-03-23 18:23:14.35 call stack:
2006-03-23 18:23:14.35 microsoft.sqlserver.replication.replicationagentsqlexception: startindex cannot less zero.
2006-03-23 18:23:14.35 parameter name: startindex  ---> system.argumentoutofrangeexception: startindex cannot less zero.
2006-03-23 18:23:14.35 parameter name: startindex
2006-03-23 18:23:14.35    @ system.text.stringbuilder.remove(int32 startindex, int32 length)
2006-03-23 18:23:14.35    @ microsoft.sqlserver.replication.snapshot.smoscriptingmanager.textmodeonobjectscripter.processgetobjectscriptresult(sqldatareader datareader)
2006-03-23 18:23:14.35    @ microsoft.sqlserver.replication.agentcore.executewithoptionalresults(commandsetupdelegate commandsetupdelegate, processresultsdelegate processresultsdelegate, int32 querytimeout, commandbehavior commandbehavior)
2006-03-23 18:23:14.35    --- end of inner exception stack trace ---
2006-03-23 18:23:14.35    @ microsoft.sqlserver.replication.agentcore.executewithoptionalresults(commandsetupdelegate commandsetupdelegate, processresultsdelegate processresultsdelegate, int32 querytimeout, commandbehavior commandbehavior)
2006-03-23 18:23:14.35    @ microsoft.sqlserver.replication.agentcore.executewithoptionalresults(commandsetupdelegate commandsetupdelegate, processresultsdelegate processresultsdelegate, commandbehavior commandbehavior)
2006-03-23 18:23:14.35    @ microsoft.sqlserver.replication.snapshot.smoscriptingmanager.textmodeonobjectscripter.script()
2006-03-23 18:23:14.35    @ microsoft.sqlserver.replication.snapshot.smoscriptingmanager.generatetablearticletrgscript(scripter scripter, basearticlewrapper articlewrapper, table smotable)
2006-03-23 18:23:14.35    @ microsoft.sqlserver.replication.snapshot.mergesmoscriptingmanager.generatetablearticlescripts(articlescriptingbundle articlescriptingbundle)
2006-03-23 18:23:14.35    @ microsoft.sqlserver.replication.snapshot.mergesmoscriptingmanager.generatearticlescripts(articlescriptingbundle articlescriptingbundle)
2006-03-23 18:23:14.35    @ microsoft.sqlserver.replication.snapshot.smoscriptingmanager.generateobjectscripts(articlescriptingbundle articlescriptingbundle)
2006-03-23 18:23:14.35    @ microsoft.sqlserver.replication.snapshot.smoscriptingmanager.doscripting()
2006-03-23 18:23:14.35    @ microsoft.sqlserver.replication.snapshot.sqlserversnapshotprovider.doscripting()
2006-03-23 18:23:14.35    @ microsoft.sqlserver.replication.snapshot.mergesnapshotprovider.doscripting()
2006-03-23 18:23:14.35    @ microsoft.sqlserver.replication.snapshot.sqlserversnapshotprovider.generatesnapshot()
2006-03-23 18:23:14.35    @ microsoft.sqlserver.replication.snapshotgenerationagent.internalrun()
2006-03-23 18:23:14.35    @ microsoft.sqlserver.replication.agentcore.run()
2006-03-23 18:23:14.81 [99%] ********************************************************************************
2006-03-23 18:23:14.81 replication agent had encountered unexpected exception, memory dump
2006-03-23 18:23:14.81 containing information exception has been generated @ following
2006-03-23 18:23:14.81 location:
2006-03-23 18:23:14.81
2006-03-23 18:23:14.81     c:\program files\microsoft sql server\90\shared\errordumps\replagent_20060323132343.mdmp

i applied sp1 ctp , snapshot generating without failing.

thanks quick reply.

SQL Server  >  SQL Server Replication