Error in SQL Server database synchronization using SyncServices and WCF -


The database I have server - Microsoft SQL Server 2008 R2 (RTM) - L0k50kl600kl (x 64). . ADO.NET is configured to synchronize with a SQL Server Compact database client through using Microsoft Synchronization Services WCF

Sometimes this error began to emerge:

< P> Microsoft.Synchronization.Data .yncException:. Unable to calculate change in DBServerSyncProvider for table 'table name' in synchronization group 'group name'

--- & gt; SystemkDatakSqlClientkSqlException: When went to a transport-level error to get results from the server (: TCP Provider, error: Provider. 0 - Semaphore time has expired expiration period)

System.Data .SqlClient.SqlConnection.OnError (SqlException Exception, Boolean Break Connection)
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning (TdsParserStateObject stateObj)
System.Data.SqlClient.TdsParserStateObject.ReadSniError (TdsParserStateObject stateObj , UInt32 error) System.Data.SqlClient.TdsParserStateObject.ReadSni on (SystemAdsyncResult asyncResult, TdsParserStateObject stateObj)
on System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket ()
S ystem.Data.SqlClient.TdsParserStateObject.ReadBuffer ()
on System.Data.SqlClient.TdsParserStateObject.ReadByte ()
Sistmkdeta. SQLLient.TdsParser.Run (RunBehavior Run Behavior, SqlCommand cmdHandler, SqlDataReader Data Stream, BulkPCPML Resettate BulkHandler, TdsParserStateObject stateObj)
System.Data.SqlClient.SqlDataReader.ConsumeMetaData ()
System.Data.SqlClient.SqlDataReader GetMetaData () on System.Data.SqlClient.SqlCommand.FinishExecuteReader (SqlDataReader DS, RunVivier RunBrevier, String ResetOostings String) on ​​System.Data.SqlClient.SqlCommand.RunExecuteReaderTds (CommandBehavior cmdBehavior, RunBehavior Run Behavior, Boolean Returnstream, Boolean async ) On the system. Data SQLLient.SqlCommand.RunExecuteReader (CommandWheel cmdBehavior, RunBehavior Run Behavior, Boolean ReturnStream, String Method, DbAsyncResult Results)
System.Data.SqlClient.SqlCommand.RunExecuteReader (CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, string method)
System.Data.SqlClient.SqlCommand.ExecuteReader (CommandBehavior behavior, string method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader (CommandBehavior behavior
)
System.Data.Common.DbCommand.System.Data. IDbCommand.ExecuteReader (low)
on.Data.Server.DbServerSyncProvider.EnumerateChanges on Microsoft.Synchronizati (SyncGroupMetadata groupMetadata, SyncSession syncSession, IDbTransaction transaction, EnumerateChangeType changeType, SyncSchema traceSchema)

The table names are different each time.

Let me know how to solve this problem please.

Thank you.

I believe that you will get this error if you specify a database during the retention period Successful sync is not done. See

We occasionally receive this even when the sync process is unable to obtain data due to an open transaction or is locking with another process. : ( 

 GO ON  ALTER DATABASE SET yourdatabasenamehere READ_COMMITTED_SNAPSHOT I believe that is right for the  set  To have)

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more