Skip navigation
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
799 Views 3 Replies Latest reply: Dec 17, 2012 7:23 AM by elwellj RSS
elwellj Newcomer 4 posts since
Apr 18, 2012
Currently Being Moderated

Dec 11, 2012 7:41 AM

Violation of PRIMARY KEY constraint 'PK_AssetServices'. Cannot insert duplicate key in object 'dbo.AssetServices'

The following error still exists after applying HotFix 7_5_1_05003_FS_DB.

 

2012-12-05 00:18:05-05:00 |  | 1 | FSScanCtrl | 0x0868 | Data Service Exception ERROR (0x80040e14; IDispatch error #3092) :  @ErrorNumber=2627, Level 14, State 1, Procedure ReconUpdateAssetProperties_Service_Vuln, Line 135, Message: Violation of PRIMARY KEY constraint 'PK_AssetServices'. Cannot insert duplicate key in object 'dbo.AssetServices'. The duplicate key value is (10437585, 231, 135).

2012-12-05 00:18:05-05:00 |  | 1 | FSScanCtrl | 0x0868 | DataServiceException 1018:.\FSJobDBWriter.cpp - CFSScanCtrlDatabase::Request_PostProcess --- Data Service Exception ERROR (0x80040e14; IDispatch error #3092) :  @ErrorNumber=2627, Level 14, State 1, Procedure ReconUpdateAssetProperties_Service_Vuln, Line 135, Message: Violation of PRIMARY KEY constraint 'PK_AssetServices'. Cannot insert duplicate key in object 'dbo.AssetServices'. The duplicate key value is (10437585, 231, 135).

2012-12-05 00:18:05-05:00 | U3_C166_J373 | 4 | FSScanCtrl | 0x0868 | (reqID 773)Post Processing Finished - FAILED (code:0) : Updated vuln BOP data(J373)

 

This error started witn the update from 7.5 to 7.5.1. There is a KB article (KB76836)  that says to open a ticket and request to be escalated to teir 3 and request the above mentioned hotfix. However this hotfix has not fixed the above issue. At this point our MVM envonrment is useless. Anyone have any ideas? I am currently waiting on a response from teir 3 and the devs, but figured I would reach out to the community as well. Any help would be greatly appreciated.

 

Thanks,

Josh

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 5 points
  • Helpful Answers - 3 points