Compliance calculation errors with errors as seen below:
09:04:54,344 104 ERROR ErrorHandlingTaskBlockRunner; Error occured in task block SnowSoftware.LicenseManager.Licensing.Service.Taskflow.Blocks.PersistCostsTaskBlock.System.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint PK_tblUnusedApplicationBreakdown. Cannot insert duplicate key in object dbo.tblUnusedApplicationBreakdown. The duplicate key value is (1, 4ea7e34d-5095-4cdc-bbe5-8caa78224530, 1006058079, 9).
and/or
15:34:25,380 13 INFO LicenseResultWriter; Saved 7 rows to tblInvalidLicensesPerConsumer for batch 3, duration: 00:00:00.0915044.15:34:25,380 4 ERROR ErrorHandlingTaskBlockRunner; Error occured in task block SnowSoftware.LicenseManager.Licensing.Service.Taskflow.Blocks.PersistCostsTaskBlock.System.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException:Violation of PRIMARY KEY constraint PK_tblCostsPerApplicationSummary. Cannot insert duplicate key in object dbo.tblCostsPerApplicationSummary. The duplicate key value is (1, 4ea7e34d-5095-4cdc-bbe5-8caa78224530, 9).
Application: Snow License Manager
Component: License Manager
Application area: Compliance
Seen in versions:
9.6+
9.7.0
9.7.2
We can find this by query the database with the below statement.
We can then view this application in SLM and edit it to verify duplicate metrics exist:
Related Articles
Library Refresh Fails With Duplicate Entry Errors 28Number of Views Code Insight MIT License Data Cleanup Project 6Number of Views MongoDB service fails to start after upgrading to Snow License Manager 9.39 200Number of Views Send data update job (DUJ) logs to technical support 511Number of Views Offline activation failed with error 51306, 51309 (FLX_ACT_TRAN_ERR_RSP_SIGNATURE_*) 45Number 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. | |
Case id: 00001065
Activity: Status change: 2 hours ago