sql server replication:
How large is your database? IIRC if the database is too large you will not
be able to compress it if the compressed size is over 2 G.
--
RelevantNoise.com - dedicated to mining blogs for business intelligence.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com [quoted text, click to view] "Manish" <jainmanishs@gmail.com> wrote in message
news:1191849470.581020.89270@g4g2000hsf.googlegroups.com...
> when i run SnapshotGenerationAgent.GenerateSnapshot(), it fails.
>
> the log file generated is as follows
>
> ............................
>
> ............................
>
> Flushing cabinet folder
>
> The replication agent had encountered an exception.
>
> Source: Replication
>
> Exception Type: Microsoft.SqlServer.Replication.FciException
>
> Exception Message: The replication agent had encountered a file
> compression (cabinet) library error while calling 'FCIDestroy()'.
>
> Message Code: 4
>
> what this error indicates .. i am not able to track what is mistake
>
> pls let me konw asap
>
> FOLLOWING IS THE CODE THAT I AM USING TO RUN SNAPSHOT AGENT
>
> private static EReturnValue generateSnapshot()
>
> {
>
> if (!publisherConn.IsOpen)
>
> {
>
> return EReturnValue.Failure;
>
> }
>
> EReturnValue retVal = EReturnValue.Success;
>
> SnapshotGenerationAgent agent=new SnapshotGenerationAgent();;
>
> try
>
> {
>
> //SET THE STATUS EVENT
>
> mPublicationStatusInfo = new StringBuilder(1024);//CAPACITY IS 1024
>
> agent.Status += new AgentCore.StatusEventHandler(snapshotAgentStatus);
>
> agent.Distributor = DistributorName;
>
> agent.DistributorLogin = DBLogin;
>
> agent.DistributorPassword = DBPassword;
>
> agent.Publisher = PublisherName;
>
> agent.PublisherLogin = DBLogin;
>
> agent.PublisherPassword = DBPassword;
>
> agent.PublisherDatabase = PublicationDatabaseName;
>
> agent.ReplicationType = ReplicationType.Merge;
>
> agent.Publication = PublicationName;
>
> agent.GenerateSnapshot();
>
> retVal = EReturnValue.Success;
>
> }
>
> catch (Exception ex)
>
> {
>
> #if debug
>
> MessageBox.Show(ex.Message);
>
> #endif
>
> retVal = EReturnValue.Failure;
>
> }
>
> finally
>
> {
>
> writeStatusInfoInLogFile();
>
> }
>
> return retVal;
>
> }
> Please tell me what is reason
> thanking u
> Manish
>