Crazy SQL error in multi site WSUS environment

W2k3
SQL 2005
SQL DE (child


Hi,

Currently have 5 WSUS servers:- One central repositry server and 4 "child"
collector servers. All of the downstream servers have suddenly started
getting a crazy SQL error. The catalog syncs from the Primary server to the
child servers once a day. The primary server is using SQL2005, but the
childern are using SQL Desktop Edition.

Since the 11th, the child servers are all reporting the following errors:

SqlException: Cannot insert duplicate key row in object 'dbo.tbDeployment'
with unique index 'nc_RevisionID_TargetGroupID_ActionID'.

Failed to create implicit deployment

Failed to create scan deployment for latest revision

Failed to Undecline the update using spUndeclineUpdate

Cannot roll back deployUpdate. No transaction or savepoint of that name was
found.

Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK
TRANSACTION statement is missing. Previous count = 1, current count = 0.

The statement has been terminated.

at
Microsoft.UpdateServices.DatabaseAccess.DBConnecti on.DrainObsoleteConnections(SqlException e)

at Microsoft.UpdateServices.DatabaseAccess.DBConnecti on.ExecuteReader()

at
Microsoft.UpdateServices.Internal.SingleResultSetS PHandler.ExecuteStoredProcedure(DBConnection connection)

at Microsoft.UpdateServices.Internal.GenericDataAcces s.ExecuteSP(String
spName, DBParameterCollection args, IExecuteSPHandler handler, Int32
queryTimeoutInSeconds)

at Microsoft.UpdateServices.Internal.GenericDataAcces s.ExecuteSP(String
spName, DBParameterCollection args, IExecuteSPHandler handler)

at
Microsoft.UpdateServices.Internal.DatabaseAccess.C ommonDataAccess.ExecuteSPSingleResultSet(String
spName, DBParameterCollection args, Type resultType, Int32
queryTimeoutInSeconds)

at
Microsoft.UpdateServices.Internal.DatabaseAccess.C ommonDataAccess.ExecuteSPSingleResultSet(String spName, DBParameterCollection args, Type resultType)

at Microsoft.UpdateServices.Internal.DatabaseAccess.A dmin


Obviously the child servers are not receiving updates. Any ideas?