3 Replies Latest reply: Dec 17, 2012 7:23 AM by elwellj RSS

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

    elwellj

      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