Subscription problems

Question

 

Hi

 

I need to test a database solution (many tables) all indexes, ref. keys, because i get this error when I trying to create a new subscription. tru internet.

 

"No key matching the described characteristics could be found within the current range ".

 

I need somekind of program that checks data integrity. or what is this?

 

HELP!!! this issue is starting to bee very IMPORTANT to get some solution. clients is waiting to update database!

 

Is this the couse:

 

added new tables

added new columns

added new foreign keys

 

when replication was online??

 

Or have the DBMail something to do with this? I have seen in log files that mail is somehow connected.

Answer 1

Hi

 

No need of help started from scratch.

 

Thanks for looking

Answer 2

hi,

 

did you ever figured out the problem?

I am having the same error Message = "No key matching the described characteristics could be found within the current range." and do not know where to start looking for the cause.

 

regards

mark

 

 

Answer 3

Can you tell us exactly what you were doing?  Was this via TSQL or the UI?  And could you post the complete error message with error number and txt?

Answer 4

ok, I have a simple app which synchronize mobile sql with sql 2005 server. Simulator works great - tables are synchronized, but when deployed to a device - Motorolla Q phone than I get an exception during the call to repl.Synchronize(). T

 

try

{

_repl.Synchronize();

}

catch (SqlCeException exp)

{

MessageBox.Show(exp.ToString());

}

 

he exception has no message:

 

 

-  exp {""} System.Data.SqlServerCe.SqlCeException
+  base {""} System.SystemException {System.Data.SqlServerCe.SqlCeException}
+  Errors {System.Data.SqlServerCe.SqlCeErrorCollection} System.Data.SqlServerCe.SqlCeErrorCollection
+  errors {System.Data.SqlServerCe.SqlCeErrorCollection} System.Data.SqlServerCe.SqlCeErrorCollection
  HResult -2147217895 int
  Message "" string
  NativeError 0 int
  Source "Microsoft SQL Server 2005 Mobile Edition" string

 

I can navigate from the browser to my server http://..../sqlcesa30.dll?diag and getting back all good results.

I manually installed on a device the following cabs:

Microsoft SQL Server 2005 Mobile Edition\Device\Mobile\v3.0\wce500\armv4i\sqlce30.phone.wce5.armv4i.CAB

Microsoft SQL Server 2005 Mobile Edition\Device\Mobile\v3.0\wce500\armv4i\sqlce30.repl.phone.wce5.armv4i.CAB

 

and

Microsoft SQL Server 2005 Mobile Edition\Device\Client\v2.0\wce500\armv4i\sql.phone.wce5.armv4i.CAB

 

Please help!!

 

Thanks

Mark

 

 

 

 

 

 

 

 

Answer 5

 

forgot to mention that during the call to repl.Synchronize() i get the following 2 exception in output window of VS.NET 2005:

 

A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll

A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll

 

 

 

Answer 6

Hi,

I'm having the same error message --"No key matching the described characteristics could be found within the current range." I tried to create a new publication and subscription, but the error still exists in the last step of the New Subscription wizard.

 

Thanks