A new Flexera Community experience is coming on November 25th. Click here for more information.
it seems that NewFileEvidence_MT is affected by this error- Arithmetic overflow error converting expression to data type int.
For dbo.ComplianceHistory flexera solved the issue but for NewFileEvidence_MT table only RESEED option is available as a temp fix.
I am running version 2022 R1
Aug 17, 2022 05:56 AM
To log a bug, you can raise a case with Flexera Support.
With that said, if you're encountering this problem in relation to the NewFileEvidence_MT database table then your scenario is likely covered by the following known issue: NewFileEvidence_MT.FileEvidenceID 32 bit INT identity column in compliance database may run out of values, causing "WriteFileEvidence - Insert unmatched evidence" import writer to fail (IOJ-2082391)
Aug 17, 2022 06:18 AM - edited Aug 17, 2022 09:54 AM
To log a bug, you can raise a case with Flexera Support.
With that said, if you're encountering this problem in relation to the NewFileEvidence_MT database table then your scenario is likely covered by the following known issue: NewFileEvidence_MT.FileEvidenceID 32 bit INT identity column in compliance database may run out of values, causing "WriteFileEvidence - Insert unmatched evidence" import writer to fail (IOJ-2082391)
Aug 17, 2022 06:18 AM - edited Aug 17, 2022 09:54 AM
Correct but if you reseed it would solve the issue, you just get some time until it gets full again.
When it will get full you will have no workaround... the best way is to change to bigint like it was done for dbo.ComplianceHistory_MT.
Aug 17, 2022 06:24 AM
To submit a bug try this...Open new case - Community (flexera.com)
Robert
Aug 18, 2022 08:57 AM