Sync object status does not reset

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Sync object status does not reset

Environment

Release: AOATAM99000-8.0-Automic-One Automation Tools-Application Manager
Component:

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")