Hi Forum,
We are having issue with reconciliation with the error.
Failed to import inventory devices with error message
The MERGE statement conflicted with the FOREIGN KEY constraint "FK_FileEvidenceMatchCount_FileEvidence_MT". The conflict occurred in database "FNMSCompliance", table "dbo.NewFileEvidence_MT", column 'FileEvidenceID'. Warning: Null value is eliminated by an aggregate or other SET operation. The statement has been terminated.
Please suggest how this issue can be fixed.
Regards,
winvarma
Jan 24, 2023 11:41 PM
Jan 25, 2023 01:39 AM
Hi @ChrisG ,
thanks for the quick revert on this thread. Actually till yesterday we are facing reconciliation issues with the below error.
'Failed to import inventory devices with error message 'Arithmetic overflow error converting IDENTITY to data type int. Arithmetic overflow occurred.'
As a part of troubleshooting steps we have executed the NewFileEvidence_MT reseed.sql query as per the below instructions from the support last August on the same issue.
"It appears that you are using an outdated reseed script. I've seen a reported issue where the error you've encountered can be seen with the outdated reseed script. Please run the new reseed script in order to resolve this:
1) Back up the Compliance DB.
2) Disable the batch scheduler with the following query:
UPDATE
ComplianceSetting
SET
SettingValue = 0
WHERE
SettingName = 'BatchSchedulerProcessDispatch'
;
3) Run the attached query NewFileEvidence_MT reseed v5.sql
4) Re-enable reconciles:
UPDATE
ComplianceSetting
SET
SettingValue = 1
WHERE
SettingName = 'BatchSchedulerProcessDispatch'
;
Later after following the above instructions we are getting the new error which is posted in the initial thread. Attached the SQL query we executed for solving the above issue.
Write file evidence is being executed before this error attached the snapshot.
Have raised a case on this and as there is no update and as this is a production environment in which we are facing the issue we have followed the above steps.
Please review and suggest
Jan 25, 2023 03:37 AM - edited Jan 25, 2023 04:06 AM
I understand that you have worked further Flexera Support to get this addressed with an updated import procedures configuration file.
For reference, this is now being tracked as the following Known Issue: WriteRemoteFileEvidenceMatchCounts import writer step may fail with error: Failed to import inventory devices with error message 'The MERGE statement conflicted with the FOREIGN KEY constraint "FK_FileEvidenceMatchCount_FileEvidence_MT". (IOK-1012974)
Feb 09, 2023 12:32 AM
we are having the same issue please suggest the workaround provided by Flexera
Jan 11, 2024 09:46 AM
If this error is consistently reoccurring for you, I would suggest raising a case with Flexera Support with details of your environment, and a log file showing the failure details. They will be able to help work through mitigation options that may be applicable to your specific situation.
Jan 11, 2024 04:48 PM