I have a big problem when using Merge Replication to download data from SQL Server 2000 to PDA.

  • Thread starter Thread starter Pikctsach
  • Start date Start date
P

Pikctsach

Hi all,

I have a big problem when using Merge Replication to download data
from SQL Server 2000 to PDA.

My program have to download about 200000 rows from database server.
(approximately 67MB).

I have test my program , where I can download 197419 rows.

But when I deploy my program for customer. I met the two following
errors:

28557

28566

I have met those error in the development stage, but if I increase the
memory size, everything will be OK.

The problem is the above solution does not work when deploy for
customer, I'm stuck. I can not figure out the reason. :-(

Further more, The second time I synchronize data between PDA and
Database server, I met the following message "Fail to exchange
data..". So the data can not be merge between PDA and Database server,
I don't know why?

PS:
I have create the publication on SQL server,all of the public columns
of tables are not null

Any suggest would be greate appreciated.
 
The exact error that I have met is

Failed to enumerate changes in the filtered articles.
Category: NULL Source:
Merge Replication Provider
Number: -2147200925
Message: Failed to enumerate changes in the filtered articles.
Category: COMMAND
Source: Failed Command
Number: 0
Message: create table #belong_agent_-2147483646 (tablenick int NOT
NULL, rowguid uniqueidentifier NOT NULL,generation int NULL, lineage
varbinary(255) NULL, col v varbinary(2048) NULL)
Category: SQLSERVER
Source: ServerName
Number: 170
Message: Line 1: Incorrect syntax near '-'.

I have try the link http://support.microsoft.com/default.aspx?scid=kb;en-us;814916#appliesto
but I really don't know how to obtain the fix.

Help me pls, it's really urgent!
 
Back
Top