SMS_DISTRIBUTION_MANAGER - SQL warnings
Hi,I have 11059 SQL warnings in SMS_DISTRIBUTION_MANAGER yet. I received all of them today.Message ID: 619The Description is:Microsoft SQL Server reported SQL message 2627, severity 14: [23000][2627][Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PeerDPResMap_PK'. Cannot insert duplicate key in object 'dbo.PeerDPResMap'. : sp_MapDistributionPointsWhat can be the problem?Thank you in advance! Please refer to your SMS documentation, SQL documentation, or the Microsoft Knowledge Base for further troubleshooting information.
February 11th, 2010 6:28pm

Hi,this Pb can be a duplicate package IDs I think ... for this, try to : Stop the SMS_STATUS_MANAGER using the Systems Management Server Service Manager Stop the SMS_Executive service Delete the oldest SQL file in the \SMS\Inboxes\statmgr.box\retry directory Restart SMS_Executive service Restart the SMS_STATUS_MANAGER using the Systems Management Server Service Manager Repeat steps 1-3 until the Statmgr.log file no longer reports the SQL errors. Thank's.Bechir Gharbi. MCP, MCSA, MCSE M+S, MCITP Server/Enterprise Administrator, MCT, MCTS Configuration Manager/Forefront
Free Windows Admin Tool Kit Click here and download it now
February 11th, 2010 11:27pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics