i come across this error few months ago while doing client push on bulk number
of computers and it fail at one computer because of duplicate key and then it
stops continuing.
The below error basically tells you that,there is already an entry exist in
database (dbo.ClientPushMachine_G) with resoureID (33555616) with different
computer name and cannot update or do anything with new computer.more info,can
get from smsprov.log on the site server.
If you try select * from dbo.ClientPushMachine_G where machineID='33555616'
from SQL management studio,you will get a computer name which is different than
what you are trying to push.
you cannot do client push until you correct the MachineID/ResourceID for the
existing machine .
What i did was,delete the record from Database with this machineID and try
client push,it worked.--only for client push installation.
if you try with other client installation methods,you will not have problems.
RegardsEswar Koneti
www.eskonr.com
From: chilv...@scj.com
To: mssms@lists.myitforum.com
Subject: [mssms] sql error
Date: Wed, 19 Nov 2014 01:38:52 +0000
Hello ,
Anyone has a solution or encountered the same problem as below? The automatic
client push is failing.
Microsoft SQL Server reported SQL message 2627, severity 14:
[23000][2627][Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of
UNIQUE KEY constraint 'ClientPushMachine_G_AK'. Cannot insert duplicate key in
object 'dbo.ClientPushMachine_G'.
The duplicate key value is (33555616). : sp_CP_CheckNewAssign
Please refer to your Configuration Manager documentation, SQL Server
documentation, or the Microsoft Knowledge Base for further troubleshooting
information.
