Sync Framework - In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.

Question

I trying to do a snapshot between SQLCE 3.5 SP1 and SQL Server 2008 by using the sync framework.

I received a inner exception stated that "{"Unable to enumerate changes at the DbServerSyncProvider for table 'ArInvoice' in synchronization group 'ArInvoiceSyncTableSyncGroup'."}".

The inner text for the inner exception stated that "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.".

And the item for the inner exception indicated that "In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.".

What is going wrong? Any setting i miss out?

Answer 1

I found the above error message only occurred while the data in my SQL Server 2008 is large.

I try to remove the data from 800000++ records to 7000++ records then i can snapshot it without issue.

Is there anyway to overcome this? While the application go online, it have to deal with table with 800000++ records.

I did do a filtering during synchronization so the number of records that need to be snapshot to the mobile device is 7000++. Somehow seem like the sync framework need to process the whole chunk of data which is 800000++ records?

Anyone facing the similar issue? Please help. Thanks.