Jan 25, 2023
03:37 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
... View more
Jan 24, 2023
11:41 PM
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
... View more
Dec 29, 2022
06:50 AM
Hi , Roles required are as below.
Cloud Application Administrator and Report reader roles in Azure for gathering inventory from O365 tenant and if there are multiple tenants above role should be assigned from each tenant to gather O365 inventory from all the tenants.
Regards
... View more
Latest posts by winvarma_MCI
Subject | Views | Posted |
---|---|---|
108 | Jan 25, 2023 03:37 AM | |
130 | Jan 24, 2023 11:41 PM | |
173 | Dec 29, 2022 06:50 AM |
Activity Feed
- Posted Re: Reconciliation failing with error 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'. on FlexNet Manager Forum. Jan 25, 2023 03:37 AM
- Posted Reconciliation failing with error 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. on FlexNet Manager Forum. Jan 24, 2023 11:41 PM
- Kudoed Re: How to determine device type Server or Desktop? for mag00_75. Jan 02, 2023 10:48 AM
- Posted Re: What access is needed to configure inventory collection for Office 365? on FlexNet Manager Knowledge Base. Dec 29, 2022 06:50 AM