The Data Update Job (DUJ) may fail with the following error message:
Error #2627 in procedure inv.UpdateQuarantinetblComputer line 191.
[Violation of PRIMARY KEY constraint 'PK__#Quarant__9B933F9C15AEC75B'.
Cannot insert duplicate key in object 'dbo.#QuarantineComputerData'.
The duplicate key value is (1, 128759).]
This error indicates a duplicate entry is being inserted into the temporary quarantine table during the DUJ process.
CID = 1ComputerID = 128759
When querying the following tables:
SELECT * FROM snowlicensemanager.dbo.tblQuarantineComputer;
SELECT * FROM snowlicensemanager.dbo.tblComputer;
You will find that the duplicate ComputerID does not appear in either table.
Additionally, in the Snow License Manager web UI, searching for the hostname associated with the ComputerID will return multiple entries. Clicking any of the duplicates leads to the same ComputerID in the URL, confirming a duplication issue tied to a single device.
This issue was caused by a defect in earlier versions of Snow Inventory, where certain connectors could duplicate devices while linking them to the same hostname.
To resolve the problem:
- Update to Snow Inventory 6.9.4 or later, where the issue has been addressed.
- In the Snow License Manager web UI, remove both duplicated computer records associated with the hostname.
- Allow the devices to report in again through normal scanning.
- Rerun the DUJ, which should now complete successfully.
This issue was caused by a known defect in earlier versions of Snow Inventory. Upgrading to 6.9.4 and removing the duplicated entries will prevent the error from recurring.
N/A
Related Articles
Send data update job (DUJ) logs to technical support 545Number of Views Data Update Job fails due to insufficient transaction log space 83Number of Views Snow Data Update Job fails with the error "Could not complete cursor operation because the table schema changed after the … 78Number of Views How to troubleshoot Data Update Job in SLM 9.x 114Number of Views Data Update Job fails logging error #16943 84Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Revenera Assistant
Case id: 00001065
Activity: Status change: 2 hours ago