Summary
On FlexNet Manager Suite systems where a large volume of unique filenames have been imported, the “WriteFileEvidence - Insert unmatched evidence” inventory writer step may fail due to the FileEvidenceFileID identity column in the FileEvidenceFile table in the compliance database growing too large and running out of available values.
Details
When this issue occurs, inventory imports are likely to fail with an error similar to the following:
2019-11-15 06:57:00,735 [INFO ] WriteFileEvidence - Insert unmatched evidence
2019-11-15 07:00:24,730 [INFO ] Failed to execute Writer 'WriteFileEvidence - Insert unmatched evidence' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\\Writer\FileEvidence.xml, at step line 108
Error: Arithmetic overflow error converting IDENTITY to data type int.
Arithmetic overflow occurred.
The following SQL query can be executed against the compliance database to identify the current identity value in the FileEvidenceFile table:
SELECT IDENT_CURRENT('dbo.FileEvidenceFile') AS CurrentIdentity
This issue is likely to occur if the value returned by this query is at or near 2,147,483,647 (being the maximum value that can be stored in a SQL Server INT value).
Mitigation
This issue may be mitigated by executing the following SQL query against the compliance database to reseed the FileEvidenceFile table to use negative identity values:
DBCC CHECKIDENT('dbo.FileEvidenceFile', RESEED, -2147483647)
Note that this mitigation can only be done once. If this mitigation has been previously applied and the database has continued to grow such that all negative identity values have been subsequently used then imports are likely to start to fail again.
Related issue
Also see the following issue, which can result in the same symptoms as this issue, but with a different root cause: "WriteFileEvidence - Insert unmatched evidence" import writer step may fail with error due to NewFileEvidence_MT.FileEvidenceID identity column value reaching limit of 2^31: "Arithmetic overflow error converting IDENTITY to data type int" (IOJ-2082391).
Fix status
This issue is still open but not currently scheduled to be addressed.
Other information
Affected components: Database, Inventory import (read/write/export)
Master issue ID: IOJ-1898355
Also known as: ITAM-1660
Related Articles
Known Issue: “WriteFileEvidence - Insert unmatched evidence” import writer step may fail with error due to NewFileEvidence… 65Number of Views "WriteFileEvidence - Insert unmatched evidence" import writer step may fail with error due to NewFileEvidence_MT.FileEvide… 4Number of Views "WriteFileEvidence - Insert unmatched evidence" import writer step may fail with error due to FileEvidenceFile.FileEvidenc… 4Number of Views Known Issue: EvidenceAlerts import writer step may fail with error when using SQL Server 2016: INSERT EXEC failed because … 12Number of Views WriteInstalledInstallerEvidence writer step may fail with error: "Cannot insert the value NULL into column 'ComplianceComp… 4Number 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