LarsReifegerste

Data Update Job Crash after updating the Snow License Manager to version 9.3.3

Discussion created by LarsReifegerste Advocate on Sep 18, 2019
Latest reply on Oct 9, 2019 by alessandro.badin

If you see this after error message after the Data Update Job:

 

Error #2627 in procedure dbo.JobVMHostAssociation line 418. [Violation of PRIMARY KEY constraint
'PK_tblComputerHostHistory'. Cannot insert duplicate key in object 'dbo.tblComputerHostHistory'. The duplicate key value is (6, 77537, 43372, Aug 20 2019 12:00AM).]

 

 

Open a support ticket and make a downgrad from the dbo.JobVMHostAssociation procedure.

You get the procedure from the Snow Support.

 

After that the data update job works again.

Outcomes