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 FileEvidenceID identity column in the NewFileEvidence_MT table in the compliance database growing too large and running out of available values.
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 NewFileEvidence_MT table:
SELECT IDENT_CURRENT('dbo.NewFileEvidence_MT') 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).
A SQL script that can be used to reseed and reclaim identity values in the NewFileEvidence_MT table can be found attached to the solution marked in the following Flexera Community forum discussion: Failed to execute writer 'WriteFileEvidence - Insert unmatched evidence'.
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 FileEvidenceFile.FileEvidenceFileID identity column value reaching limit of 2^31: "Arithmetic overflow error converting IDENTITY to data type int" (IOJ-1898355).
This issue is still open but not currently scheduled to be addressed.
Affected components: Database, Inventory import (read/write/export)
Master issue ID: IOJ-2082391
Also known as: ITAM-647
Jul 27, 2022 02:33 AM - edited Dec 27, 2023 01:27 PM