Sync object status does not reset

Document ID : KB000089237
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Sync object status does not reset
Resolution:
Detailed Description and Symptoms
Occasionally, an issue occurs where the status of Sync objects do not reset. 

This problem has been associated with the following:

There is a known bug in the MS SQL SERVER that if 'Mars_Connection=Yes' is used, DEADLOCK's are not returned to the application. We highly recommend that this feature is turned off. We believe that once MARS is turned off that this behavior will no longer be occur.

following should be completed:

1) update the ms sql native client and update your DB to the latest service pack

The current client version is:
20110428/150850.350 - 20110423/104029.477 - U0003535 DB INFO: 'DRIVER-VER = 10.00.1600'
The current DB version is:
20110428/150850.350 - 20110423/104029.477 - U0003535 DB INFO: 'DBMS-VER = 10.00.2531'

2) turn off Mars_Connection (i.e.: "Mars_Connection=No")